How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Moving Datafiles Between ASM Disk Groups → You may want to move an active datafile in an ARCHIVELOG mode database from one ASM disk group to … you use ASM disk groups ASMDSK2 and ASMDSK1. You want to move datafile +ASMDSK2/rdbms/datafile … /tbs_5.256.565313879 to disk group ASMDSK1. To move a datafile from one ASM disk group to another ASM disk … ; Back
26 Performing ASM Data Migration → This chapter describes how to migrate data into and out of Automatic Storage Management (ASM … ) storage with RMAN. This chapter includes the following topics: Overview of ASM Data Migration Preparing … to Migrate the Database to ASM Migrating the Database to ASM Migrating a Database from ASM to Alternative
Preparing to Migrate the Database to ASM → assumptions: You want to migrate the database to two ASM disk groups: +DATA for the database and +FRA … for the flash recovery area. The database to be migrated to ASM storage is named mydb. Note: If you … do not want to migrate the flash recovery area, then skip step 10. To prepare the database for ASM … to a recovery catalog.
Basics Steps of Data Migration to ASM → ASM are as follows: Back up the database and server parameter file, and disable Oracle Flashback … Database. This step is described in \"Preparing to Migrate the Database to ASM\". Restore files to ASM … , recover the database, and optionally migrate the flash recovery area to ASM. This step is … described in
Migrating a Database from ASM to Alternative Storage → Migrating a database from ASM to an alternative storage system is essentially the reverse of the … migration to ASM. Modify the steps in \"Preparing to Migrate the Database to ASM\" and \"Migrating the … Database to ASM\" as follows: If the procedure specifies Oracle Managed Files locations, then alter … specifies
Migrating the Database to ASM → same assumptions described in \"Preparing to Migrate the Database to ASM\". If you are not migrating … the recovery area to ASM, then you need to modify some of the steps, which are noted. Note: The … . To migrate the database to ASM: Follow the steps in \"Preparing to Migrate the Database to ASM … \". Restore
Purpose of ASM Data Migration → Alternatives to ASM storage include file systems, raw disks, and SAN configurations. ASM includes a … because ASM manages disks for you. Oracle Real Application Clusters (Oracle RAC) databases benefit from … ASM because it provides ready-made shared storage. If a database currently uses a storage system … other
Basic Concepts of ASM Data Migration → You can migrate data to ASM with RMAN even if you are not using RMAN as your primary backup tool … database both in ASM and alternative storage systems, then you can move a database directly into … ASM. If you do not have sufficient storage, then you can back the database up to tape, create an ASM … disk group
Overview of ASM Data Migration → This section explains the basic concepts and tasks involved in migrating data to and from ASM.
Upgrade ASM → following steps to upgrade ASM: Shut down the instance: SQL> SHUTDOWN IMMEDIATE If your operating … the ASM instance you are upgrading, where SID is the instance name. For example, if your SID is … +ASM, then enter the following at a command prompt: C:\\> NET STOP OracleASMService+ASM Delete the … Oracle service
Cluster ASM Upgrade → For cluster ASM upgrade, execute the following steps: As orauser, upgrade ASM to release 11.1 using … OUI and DBUA. The new ASM release 11.1 should be running in a new Oracle Home 2 ( OH2 ). ASM should … still be running as orauser. Bring down the ASM and Listener resources from CRS home. As a new user
Troubleshoot the ASM Upgrade → This section explains what to do if something goes wrong with your ASM upgrade. If you run out of … resources during the ASM upgrade, then increase the resource allocation. After increasing the … manual ASM upgrade or restarting DBUA. A new Oracle Database release might require larger shared memory
ASM Disk Group Compatibility → ASM disk group compatibility settings across software versions. Using the new compatibility attributes … the disk group for the database and the disk group for ASM, respectively. This feature enables … Database Storage Administrator's Guide for more information on ASM disk group compatibility
Cancel the ASM Upgrade → To cancel an ASM upgrade, start the ASM instance from the old Oracle home.
Single-Instance ASM Upgrade → If ASM version 10.2 is installed in Oracle Home 1 ( OH1 ) and the operating system user is orauser … , execute the following steps: As orauser, upgrade ASM to release 11.1 using OUI and DBUA. The new … ASM release 11.1 should be running in a new Oracle Home 2 ( OH2 ). ASM should still be running as … orauser.
Recommended Tasks After ASM Upgrades → Performing the following tasks is recommended, but not required, after you have upgraded ASM: Reset … ASM Passwords to Enforce Case-Sensitivity Advance the ASM and Oracle Database Disk Group … Compatibility Set Up ASM Preferred Read Failure Groups You should also consider performing the following tasks
Database Upgrade After ASM Upgrade → database after upgrading ASM. The database user must be a member of OSDBA for ASM. There are three … Also: Oracle Database Storage Administrator's Guide for information on making an ASM disk group … 10.2 to 11.1 in a new Oracle Home ( OH4 ) which is separate from the ASM Oracle Home ( OH3 … that all occurrences
Required Tasks After ASM Upgrades → The following tasks are required after an ASM Upgrade: Set Environment Variables Single-Instance ASM Upgrade Cluster ASM Upgrade
Optional Tasks After ASM Upgrades → If you separate the operating system ownership of Oracle homes belonging to ASM and to one or more … databases, then you must migrate the operating system user of an upgraded ASM or database home by … executing the steps in the following section: Database Upgrade After ASM Upgrade