活着,寻找生存。
分类: Oracle
2016-07-25 10:56:26
This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa.
To setup ASM, please follow
A scheduled downtime is needed.
Step 1: Edit the pfile/spfile of DB to point the new control_file location on ASM
E.g. : if your disk group name is '+DATA'
The setting here is actually an alias for the controlfile.
For 10gR1 or you don't want to use an alias for controlfile, please set control_files='+DATA' and use the following note to update the parameter again in the pfile/spfile after the controlfile is created at step #3.
If you later want to duplicate an extra copy of control file, please see
Step 2: Startup the database in nomount state
Step 3: From RMAN session, copy the control file from old location to new location
Here /u01/TST/control01.ctl is the old location of control file.
Step 4: From SQL session, mount the database
Step 5: Using RMAN, copy the datafile from NON-ASM to ASM
Step 6: Using RMAN, rename the datafile , using the following command
Step 7: Switch tempfile and open database.
Step 8: Do the following maintenance
... repeat for *all* online redo log members.
A redo log member can only be dropped after being archived and being in INACTIVE mode. If needed, switch logfile multiple times until the logfile is ready for dropping.
STEP of MIGRATION from ASM to NON-ASM
1. Start your database with ASM.
2. Create pfile from spfile.
3. Edit pfile/spfile to reflect controlfile name in file system location.
4. Startup nomount the DB.
5. Use RMAN to copy the control file from ASM to NON-ASM.
6. Mount the DB.
7. Use RMAN to copy the database from ASM to NON-ASM.
8. From RMAN.
9. Recreate the tempfile and redo logs as before. See step 7 and 8 above.
For Windows use the next document
How to Move from Non-ASM to ASM on Windows? Note 1914862.1
Reference
Additional Resources
Community Discussions:
Still have questions? Use the above community to search for similar discussions or start a new discussion on this subject.