Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
来源:互联网 发布:bim设计方案优化 编辑:程序博客网 时间:2024/05/01 02:25
This article describes the steps to migrate a database from Non-ASM to ASM and vice-versa.
To setup ASM, please follow
Note 452924.1 - How to Prepare Storage for ASM
Note 265633.1 - ASM Technical Best Practices
Note 249992.1 - New Feature on ASM (Automatic Storage Manager).
Scope and Application
A scheduled downtime is needed.
Steps To Migrate/Move a Database From Non-ASM to ASM And Vice-Versa
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'
control_files='+DATA/<dbid>/control01.ctl'
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.
Note 468458.1 - How To Move Controlfile To ASM
If you later want to duplicate an extra copy of control file, please see
Note 345180.1 - How to duplicate a controlfile when ASM is involved
Step 2: Startup the database in nomount state
SQL> Startup nomount
Step 3: From RMAN session, copy the control file from old location to new location
RMAN> CONNECT TARGET
RMAN> RESTORE CONTROLFILE FROM '/u01/TST/control01.ctl';
Here /u01/TST/control01.ctl is the old location of control file.
Step 4: From SQL session, mount the database
SQL> ALTER DATABASE MOUNT;
Step 5: Using RMAN, copy the datafile from NON-ASM to ASM
RMAN>BACKUP AS COPY DATABASE FORMAT '+DATA';
Step 6: Using RMAN, rename the datafile , using the following command
RMAN> SWITCH DATABASE TO COPY;
Step 7: Switch tempfile and open database.
RMAN> run {
set newname for tempfile 1 to '+DATA';
set newname for tempfile 2 to '+DATA';
...
switch tempfile all;
}
RMAN> ALTER DATABASE OPEN;
Step 8: Do the following maintenance
SQL> SELECT a.group#, b.member, a.status FROM v$log a, v$logfile b WHERE a.group#=b.group#;
SQL> ALTER DATABASE ADD LOGFILE MEMBER '+ASM_Disk_group' TO GROUP 1;
SQL> ALTER DATABASE ADD LOGFILE MEMBER '+ASM_Disk_group' TO GROUP 2;
SQL> ALTER DATABASE DROP LOGFILE MEMBER '';
SQL> ALTER SYSTEM SWITCH LOGFILE;
SQL> ALTER DATABASE DROP LOGFILE MEMBER '';
SQL> ALTER SYSTEM SWITCH LOGFILE;
... 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.
SQL> Startup nomount
5. Use RMAN to copy the control file from ASM to NON-ASM.
RMAN> RESTORE CONTROLFILE FROM '';
6. Mount the DB.
SQL> alter database mount;
7. Use RMAN to copy the database from ASM to NON-ASM.
RMAN> BACKUP AS COPY DATABASE format '/u01/oradata/nonasmdb/datafile/%U';
8. From RMAN.
RMAN> SWITCH DATABASE TO COPY;
9. Recreate the tempfile and redo logs as before. See step 7 and 8 above.
From Oracle
-------------------------------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
Email: dvd.dba@gmail.com
DBA1 群:62697716(满); DBA2 群:62697977(满) DBA3 群:62697850(满)
DBA 超级群:63306533(满); DBA4 群: 83829929 DBA5群: 142216823
聊天 群:40132017 聊天2群:69087192
--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请
- Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
- Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
- How to Copy Archivelog Files From ASM to Filesystem and vice versa
- Migrating a Database from ASM to Non-ASM Storage
- Oracle RMAN Migrate DB from RAC ASM to Single non-ASM
- Oracle RMAN Migrate from Single none-ASM to Single ASM
- wstring to string and vice versa
- c# - string to byte[] and vice versa
- How to move ASM database files from one diskgroup to another
- How to move ASM database files from one diskgroup to another
- Converting 11gR2 "Administrator" managed database to "Policy" managed and vice versa (文档 ID 1486772.
- How to move a datafile from a file system to ASM
- How to move a datafile from a file system to ASM (Doc ID 390274.1)
- How to move a datafile from a file system to ASM (Doc ID 390274.1)
- How to move a datafile from a file system to ASM
- How to move a datafile from ASM to the file system
- How can I convert a QString to char* and vice versa ?
- How can I convert a QString to char* and vice versa?
- 怎样自定义数据文件格式
- 网页上禁止右键功能
- struts2 命名空间---action的寻找规则
- ubuntu删除错误的ATI驱动
- oracle 构造与已知表结构相同的表问题
- Steps To Migrate-Move a Database From Non-ASM to ASM And Vice-Versa
- FLEX日期格式化处理和字符串转换
- C++ 和Objective-C 混合编码 注意事项
- oracle11g更改字符集AL32UTF8为ZHS16GBK
- js 返回值 并刷新父界面
- 使用Entity Framework时,如何构建动态排序条件
- 支持IE和FF的ASP.NET弹出层
- 内核配置与编译
- oracle中自增列!