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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- 【RMAN】RMAN-20020: DATABASE INCARNATION NOT SETDatabase
- Step by Step Guide on Creating Physical Standby Using RMAN DUPLICATE...FROM ACTIVE DATABASE WithoutGUIIDEDatabase
- Oracle 12Cr2 Using CloneDB to clone a databaseOracleDatabase
- Duplicate Database from ASM to Non- ASM Database Using RMANDatabaseASM
- Oracle rman incarnationOracle
- Using RMAN Incremental Backups to Refresh a Standby DatabaseREMDatabase
- Duplicating Database using RMAN duplicate commandDatabase
- PHP中 new clone __clone區別PHP
- oracle create a new database using backup controlfile to traceOracleDatabase
- Oracle clone databaseOracleDatabase
- LIST INCARNATION OF DATABASE含義Database
- A example that using JQuery clonejQuery
- Using RMAN Incremental Backups to Roll Forward a Physical Standby DatabaseREMForwardDatabase
- Clone a database on the same serverDatabaseServer
- Creating Physical Standby using RMAN Duplicate Without Shutting Primary_789370.1
- 體驗跨越incarnation進行flashback database相比傳統RMAN RECOVER的便捷性Database
- Converting Oracle Database from Linux to Windows using RMANOracleDatabaseLinuxWindows
- Converting Oracle Database from Windows to Linux using RMANOracleDatabaseWindowsLinux
- Creating a Physical Standby using RMAN DUPLICATE FROM ACTIVE DATABASEDatabase
- How a Clone Database Is Mounted (296)Database
- Creating Physical Standby using RMAN Duplicate Without Shutting down The Primary [ID 789370.1]
- Step By Step Guide To Create Physical Standby Database Using RMAN [ID 469493.1]GUIIDEDatabase
- rman 穿越incarnation恢復資料
- New cache mode for BI 7.0 without directory
- How To Restore 12cR1DB to New Host File System using RMAN(一)REST
- Export a DataSet to Microsoft Excel without using the COM objectsExportROSExcelObject
- Creating a Standby Database using RMAN (Recovery Manager) [ID 118409.1]Database
- [Notes]New cache mode for BI 7.0 without directory
- rman duplicate clone庫的尷尬
- Creating a Data Guard Database with RMAN using Duplicate Command [ID 183570.1]Database
- RMAN duplicat databaseDatabase
- rman recover databaseDatabase
- RMAN duplicate databaseDatabase
- Using Regular Expressions in Oracle DatabaseExpressOracleDatabase
- Java 中的 clone( ) 和 new,哪個效率更高?Java
- SQL SERVER – Attach mdf file without ldf file in DatabaseSQLServerDatabase
- 翻譯 | Learning React Without Using React Part 2React
- 翻譯 | Learning React Without Using React Part 1React