RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1]
RMAN Duplicate Database From RAC ASM To RAC ASM [ID 461479.1] | |||||
| |||||
修改時間 22-JUN-2011 型別 HOWTO 狀態 MODERATED |
This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review. |
Applies to:
Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.4 - Release: 10.1 to 10.2Information in this document applies to any platform.
Goal
RMAN Duplicate Database From RAC ASM to RAC ASMSolution
Assumptions
This note assumes the following:
You are using recovery catalog database catdb
The target database trgt is on host1 and contains ASM datafiles and online logs in diskgroup +DISK1
You want to duplicate the target to database dupdb on remote host host2.
host2 has diskgroup +DISK2
You want to store the datafiles for dupdb to +DISK2
You want to store two controlfiles in +DISK2
The backups and archivelogs created by host1 are accessible by host2
Procedure
1) Create an initialization parameter for auxiliary instance by copying the target database initialization parameter file. Change the parameters as follows:
Set DB_NAME to the new database name dupdb
Set CONTROL_FILES to store two copies of the control file in +DISK2
Set DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT to convert the datafile and online log file names from +DISK1 to +DISK2
Set any other initialization parameters that end in _DEST, such as DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_DEST_n, to reference +DISK2
Comment all the RAC related parameters in the dupdb parameter file. We will re-enable them once the duplicate is completed.
2) For an active production RAC environment, you must use a SET UNTIL clause, otherwise the archivelogs would not have been backed up and the duplicate would fail with RMAN-06025.
To get the sequence number, you need to look at the following:
RMAN> list backup of archivelog all;
We need to determine the most recent archivelog backed up from each thread, and then take the least recent of these.
Example
Parameter file (init.ora) would include:
CONTROL_FILES=+DISK2,+DISK2
DB_FILE_NAME_CONVERT=+DISK1,+DISK2
LOG_FILE_NAME_CONVERT=+DISK1,+DISK2
Create an SPFILE from the parameter file, and start the auxiliary instance:
SQL> CONNECT ;
SQL> CREATE SPFILE FROM PFILE='location of auxiliary instance pfile';
SQL> STARTUP NOMOUNT;
Then run the following RMAN commands to duplicate the database:
RMAN> CONNECT TARGET /;
RMAN> CONNECT CATALOG rman/cat@catdb;
RMAN> CONNECT AUXILIARY SYS/oracle@dupdb;
RMAN> run {
set until sequence x thread y;
DUPLICATE TARGET DATABASE TO dupdb;
}
==> replace the sequence and thread number as appropriate
When the DUPLICATE command completes, the duplicate database is created, with datafiles, online logs and control files in ASM disk group +DISK2.
Shutdown the database and add all the RAC related parameters and then start the database.
Note:- The only difference between duplicate from RAC ASM and standalone ASM is not to perform. the last step i.e. adding of the RAC related parameters
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/23135684/viewspace-703619/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- Duplicate database from non ASM to ASM to a different host [ID 382669.1]DatabaseASM
- Performing duplicate database with ASM/OMF/RMAN (Doc ID 340848.1)ORMDatabaseASM
- DUPLICATE (Backup based) DATABASE from non ASM to ASM to different host_382669.1DatabaseASM
- Duplicate database from non ASM to ASM (vise versa) to a different host-382669.1DatabaseASM
- 【RAC,DATAGUARD】Creating a physical standby from ASM (RAC ) primary之四ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之三ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary 之二ASM
- 【RAC】Creating a filesystem physical standby from ASM (RAC ) primary之一ASM
- How To Upgrade ASM from 10.2 to 11.1 (RAC)ASM
- 使用RMAN將RAC+ASM複製到單例項+ASM上ASM單例
- goldengate + asm + racGoASM
- RAC+ASM+DATAGUARDASM
- 【ASM】Oracle RAC css啟動報錯"Duplicate voting file found"ASMOracleCSS
- Step By Step Guide On Creating Physical Standby Using RMAN Duplicate In ASM Filesystem For ASM PrimaGUIIDEASM
- Oracle11g RMAN Duplicate from Active DatabaseOracleDatabase
- RMAN duplicate from active database 複製資料庫Database資料庫
- RAC(ASM)歸檔模式修改ASM模式
- ORACLE RAC重建ASM磁碟組OracleASM
- RMAN duplicate 建立standby RAC資料庫資料庫
- 11g rman新特性 duplicate target database for standby from active databaseDatabase
- How to move ASM database files from one diskgroup to anotherASMDatabase
- RMAN duplicate databaseDatabase
- RAC+DG(asm單例項)ASM單例
- 【RAC】asm_diskgroups 引數ASM
- 11G+ASM RAC關機ASM
- Some adminitration script for RAC % ASMASM
- oracle rac 無法建立asm磁碟OracleASM
- Reinstall ASM or DB HOME on One RAC Node From the Install Media_864614.1ASM
- Create Physical stdby Using RMAN Duplicate In ASM File... For ASM Prim-837102.1ASM
- Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASEDatabase
- How to copy a datafile from ASM to a file system not using RMANASM
- RAC和ASM環境下打patchASM
- RAC安裝【AIX 7 + 11.2.0.4 + ASM】AIASM
- RAW+ASM 的RAC 安裝文件ASM
- 11gR2 RAC ASM 啟動ASM
- UDEV方式配置Oracle RAC ASM共享磁碟devOracleASM
- RAC 11.2.0.3 ASM管理 (一) 引數ASM