OCP-1Z0-053-V12.02-372题

本文主要是介绍OCP-1Z0-053-V12.02-372题，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

 

 

372.Which command do you use to generate a report of database incarnations?

A. list incarnation of database

B. report incarnation of database

C. list database incarnation

D. database incarnation list

E. report database incarnation

Answer: A

答案解析：

参考：http://docs.oracle.com/cd/E11882_01/backup.112/e10643/rcmsynta027.htm#RCMRF90230

RMAN> list incarnation of database;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

1       1       TEST1107 2336818266       PARENT  1          17-SEP-11

2       2       TEST1107 2336818266       PARENT  995548     06-NOV-13

3       3       TEST1107 2336818266       CURRENT 1199286    06-NOV-13

INCARNATION

Displays information about the incarnations of a database. Whenever you open a database with the RESETLOGS option, you create a new incarnation of the database. IfLIST INCARNATION displays n incarnations of a database, then you have reset the online redo logs for this database n-1 times. The LIST output includes the primary keys of all database incarnation records for the specified database name (in the column Inc Key, which contains the incarnation key). Use the key in a RESET DATABASE command to change the incarnation that RMAN considers to be current to a previous incarnation. See Also: Table 2-24 for an explanation of the column headings of the LIST INCARNATION output table andExample 2-98 for an illustration

OF DATABASE    database_name

Specifies the name of the database. If you do not specify the OF DATABASE option, then LIST displays all databases registered in the recovery catalog.

Table 2-24 List of Database Incarnations

Column	Indicates
DB Key	When combined with the Inc Key, the unique key by which RMAN identifies the database incarnation in the recovery catalog. Use this key to unregister a database from a recovery catalog, that is, delete all the rows associated with that database from the recovery catalog.
Inc Key	When combined with DB Key, the unique key by which RMAN identifies the database incarnation in the recovery catalog. Use this key in RESET DATABASE TO INCARNATION when recovering the database to a time before the most recent RESETLOGS.
DB Name	The database name as listed in the DB_NAME parameter.
DB ID	The database identification number, which the database generates automatically at database creation.
STATUS	CURRENT for the current incarnation, PARENT for the parent incarnations of the current incarnation, and ORPHANfor orphaned incarnations.
Reset SCN	The SCN at which the incarnation was created.
Reset Time	The time at which the incarnation was created.

Example 2-98 Listing Database Incarnations

This example lists all database incarnations recorded in the recovery catalog.

RMAN> LIST INCARNATION;

List of Database Incarnations

DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time

------- ------- -------- ---------------- --- ---------- ----------

78      94      PROD     1619073740       PARENT  1          14-FEB-07

78      79      PROD     1619073740       CURRENT 388003     15-FEB-07

这篇关于OCP-1Z0-053-V12.02-372题的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---