How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)

rongshiyuan發表於2014-09-04
DatabaseHive

How to Duplicate a Database in NOARCHIVELOG mode (Doc ID 275480.1)


Applies to:

Oracle Database - Enterprise Edition - Version 9.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2013***


Goal

Can RMAN duplicate be used if a target database running in NOARCHIVELOG?

Solution

Yes it can.

When the target database is in noarchivelog mode, RMAN automatically does recovery with "noredo" clause.

This can be seen in the memory script created by RMAN's duplicate command. It will show "recover database noredo".

 

For 11gR2:
--------
For more Details see RMAN Reference Guide:
.
http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#CHDEDFFH
Oracle? Database Backup and Recovery Reference
11g Release 2 (11.2)
E10643-06

DUPLICATE
...
Prerequisites
....
Backup-Based Duplication

In backup-based duplication of databases with a connection to the target database and in NOARCHIVELOG mode,
media recovery uses the NOREDO option.
Thus, if incremental backups exist, RMAN applies only these incremental backups to the restored files during recovery.

For backup-based duplication of databases without a connection to the target database, RMAN cannot
determine whether the source database was in NOARCHIVELOG mode. Therefore, you must use the NOREDO
option when the source database was in NOARCHIVELOG mode when the backups were taken.
You can also use the NOREDO option when you do not want to apply archived redo log files to a consistent backup.

 

 

Document Details

 
Email link to this documentOpen document in new windowPrintable Page
Type:
Status:
Last Major Update:
Last Update:
HOWTO
MODERATED
6/21/2013
6/21/2013
     
 

Related Products

 
Oracle Database - Enterprise Edition
     
 

Document References

 
No References available for this document.
     

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17252115/viewspace-1263474/，如需轉載，請註明出處，否則將追究法律責任。

相關文章