clone database using RMAN without new incarnation (with NORESETLOGS)_1608236.1
How to clone the database using RMAN without new incarnation (with NORESETLOGS) (Doc ID 1608236.1)
In this Document
Goal |
Solution |
References |
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.2 to 11.2.0.4 [Release 10.2 to 11.2]
Information in this document applies to any platform.
Goal
++ To Clone the database WITHOUT new incarnation (with NO RESETLOGS).
Solution
++ In general while performing incomplete recovery in another server using RMAN backup, it requires resetlogs.
++ Since we are specific NOT to resetlogs, we can try below option
Assuming: (a) Full backup is taken at Server A ,
(b) And backup pieces are moved to host Server B ( Auxiliary).
At Server B (auxiliary instance )
step: (1) Startup auxiliary instance at NOMOUNT state
step: (2) Initiate RMAN session and Restore controlfile from backup
step: (3) Mount database
step: (4) catalog the backup piece
step: (5) Restore database
step: (6) shutdown immediate Auxiliary instance
step: (7) shutdown the Source database (Server A) AND COPY below files to (cloned ) auxiliary instance ( Server B)
(7a) controlfile
(7b) archivelogs # which is newly generated after backup at source database (Server A)
(7c) REDO logs
At Server B ( Auxiliary Instance ):
step: (8) Replace the auxiliary instance controlfile with newly copied controlfile
Startup mount with new controlfile and catalog the archivelogs
Step: (9) if Datafile and REDO file location of cloned database (Server B) is different from source database (Server A) then
We should rename the datafiles and redo logs . Otherwise this step not necessary
Step: (10) recover database and open database (without resetlogs )
sql > recover database ;
sql > alter database open;
Example:
Here example is on windows platform. The steps are same for unix.
At Server A ( Source Database ) RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON; RMAN> backup database plus archivelog ; Assuming : Full database backup is taken and copied to Server B
At Server B ( Auxiliary Instance ): ~~~~~~~~~~~~~~~~~~~~~~~ step:(1) sqlplus sys/syspwd@tnsmast112aux as sysdba
..
Total System Global Area 363266048 bytes
Starting restore at 14-DEC-13 channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
step: (3) RMAN> alter database mount; searching for all files that match the pattern F:\Share
List of Files Unknown to the Database
Do you really want to catalog the above files (enter YES or NO)? yes
List of Cataloged Files
datafile 1 switched to datafile copy
Using OS command or winscp copy following files to Server B ( Auxiliary instance )
*.ctl At Server B ( Auxiliary Instance ):
Startup mount with new controlfile and catalog the archivelogs in any of below methods
or
Step:(9) In this test case, Datafile, Redo location, Archivelog , Control location are NOT identical amount source database and destination database.
|
Please keep in mind if you want to register this 'cloned' database to same RMAN Catalog as
TARGET (Source Database) is registered, then you must change the DBID to get a unique DBID for this cloned database.
Otherwise if you register a database with a DBID which already exist in RMAN Catalog, this will corrupt the RMAN Catalog.
(Doc ID 863800.1) How to Change the DBID, DBNAME Using NID Utility in version 10gR2 onwards.
References
NOTE:863800.1 - How to Change the DBID, DBNAME Using NID Utility in version 10gR2 onwards
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/17252115/viewspace-1160607/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- LIST INCARNATION OF DATABASE含義Database
- Oracle clone databaseOracleDatabase
- 在rman恢復中incarnation的概念
- RMAN深入解析之--Incarnation應用(不完全恢復)
- 翻譯 | Learning React Without Using React Part 2React
- 翻譯 | Learning React Without Using React Part 1React
- recover database using backup controlfile理解Database
- RMAN restore validate database報ORA-19693RESTDatabase
- git clone 報錯 “URL using bad/illegal format or missing URL“GitORM
- Java 中的 clone( ) 和 new,哪個效率更高?Java
- G009-ORACLE-ASK Using In-Database ArchivingOracleDatabase
- 使用RMAN複製資料庫 active database資料庫Database
- 1 Oracle Database Release 20c New FeaturesOracleDatabase
- 備份恢復Lesson 04.Using the RMAN Recovery Catalog
- HowTo Restore RMAN Disk backups of RAC Database to Single Instance On Another NoRESTDatabase
- 理解RMAN backup database plus archivelog delete all input命令DatabaseHivedelete
- Oracle Database 19c(19.9) RAC On RedHat 8.3 Using VirtualBox and MacBookOracleDatabaseRedhatMac
- Oracle 12c RMAN Performing Cross-Platform Transport of a PDB Using InconsistentOracleROSPlatform
- 透過RMAN備份standby database成功恢復還原Database
- Using V$BACKUP_ASYNC_IO / V$BACKUP_SYNC_IO to Monitor RMAN PerformanceORM
- Bug 12725963 - New database connection fails with ORA-12541 after vip failoverDatabaseAI
- Controlfile 重建控制檔案 noresetlogs, resetlogs..
- List Incarnation 語法含義
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid不同UXDatabaseOracle
- rman duplicate建立異地auxiliary Database oracle_11g oracle_sid相同UXDatabaseOracle
- ORA-19909: datafile 1 belongs to an orphan incarnation
- SCSS without和withCSS
- sourcetree github clone 報錯 hg clone fails with “repository not found“GithubAI
- Performance Without the Event LoopORMOOP
- scp without interative password
- (十三).clone方法
- WSL git cloneGit
- 【RMAN】RMAN備份至ASMASM
- docker_sshd without passwordDocker
- Installing Windows Features without InternetWindows
- MySQL 索引優化 Using where, Using filesortMySql索引優化
- Oracle 11G RAC複製備庫RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 RMAN-10038Oracle
- 1.3.2.1.2.3 Refreshable Clone PDBs