358.What command is used to reset a database to a previous incarnation?
A. reset incarnation
B. incarnation reset
C. reset database to incarnation
D. reset database incarnation
E. reset databse incarnation number
Answer: C
答案解析:
参考:http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta2007.htm#RCMRF90293
RESET DATABASE
Use the RESET DATABASE TO INCARNATION
command to reset the incarnation of the target database in the RMAN repository to a previous database incarnation. You are only required to use this command in the following scenarios:
-
You use
RESTORE
orRECOVER
to return the database to an SCN before the currentRESETLOGS
timestamp. -
You use
FLASHBACK DATABASE
to rewind the database to an orphaned database incarnation.
See Also:
Oracle Database Backup and Recovery User's Guide to learn about the circumstances in which it is necessary to use theRESET DATABASE
command
Execute RESET DATABASE TO INCARNATION
only at the RMAN prompt. RMAN must be connected to a target database.
If RMAN runs in NOCATALOG
mode, then the target database must be mounted. The mounted control file must contain a record of the specified database incarnation.
If RMAN runs in CATALOG
mode, then the target database can be mounted or unmounted. If the database is mounted, then the control file must contain a record of the specified database incarnation.
When you use RMAN in NOCATALOG
mode, the RESET DATABASE TO INCARNATION
command is persistent across RMAN sessions.
Syntax Element | Description |
---|---|
primaryKey | Changes the current incarnation to a noncurrent database incarnation specified by the primary key of theDBINC record for the database incarnation. An incarnation key is used to uniquely tag and identify a stream of redo. Run |
Example 3-17 Resetting RMAN to a Previous Incarnation in NOCATALOG Mode
In NOCATALOG
mode, you must mount a control file that contains information about the incarnation to recover. The following scenario resets the database to an abandoned incarnation of database trgt
and performs incomplete recovery.