ITPub博客

（358）What command is used to reset a database to a previous incarnation?A. reset incarnationB. incarnation resetC. reset database to incarnationD. reset database incarnationE. reset databse incarnation number答案：（C）

（357）How many database instances are used during a database-duplication process?A.  OneB.  TwoC.  ThreeD.  FourE.  Five答案：（B）

（356）Which of the following commands will perform an active database duplication of the ORCL database to the ORCL2 database?A.set oracle_sid=orclrman target=sys/robert auxname=sys/Robert@orcl2create duplicate target database to n...

（355）When you're performing active database duplication, a backup of what kind is required?A. A current RMAN backup-set backup is required.B. No backup is required.C. An RMAN image backup is required.D. A manual backup is required.E. A "duplicate" preparatory backup is required....

（354）Which command is used to begin a tablespace point-in-time recovery?A. Restore tablespaceB. Recover tablespaceC. Tablespace recoverD. Recover to timeE. recover datafile答案：（B）

（353）True or false: tablespace point-in-time recovery is possible only with RMAN.A.   TrueB.   False答案：（B）

（352）If a backup is expired, which of the following is true?A. It can never be used for a restore/recover operation.B. Oracle will remove the backup set pieces from the flash recovery area.C. The backup has been used at least once to restore and recover the database.D. The backup is...

（351）What information does the report schema command not provide? (Choose all that apply.)A. Size of the datafilesB. Size of the tempfilesC. Date of last backup for datafiles and tempfilesD. Filenames for each datafileE. Checkpoint SCN associated with the last RMAN backup...

（350）Why would you execute the report obsolete command?A. To list all backups that were no longer available for restore operationsB. To list all backups that had aged beyond the RMAN retention criteriaC. To list all backup set pieces listed in control-file or recovery-catalog metadata t...

（349）What is the result of this command?RMAN> Report need backup days 3;A. Lists all datafiles created in the last three days that are not backed up.B. Lists all datafiles not recoverable based on the current retention criteria.C. Lists all datafiles not backed up in the last three ...

（348）What does the 'minimize load' database parameter mean when backing up a database?A. RMAN will attempt to make the backup run as fast as possible without any IO limitations.B. RMAN will automatically restrict the number of channels in use to one.C. RMAN will spread the backup IO ove...

（347）What does the output on this report indicate?RMAN> report need backup;RMAN retention policy will be applied to the commandRMAN retention policy is set to redundancy 1Report of files with less than 1 redundant backups...

（346）What is the impact of the results of the output of the following command?RMAN> report unrecoverable database;Report of files that need backup due to unrecoverable operationsFile   Type of Backup Required       Name4    &nbs...

（345）What view might you use to try to determine how long a particular backup will take?A. V$SESSION_EVENTB. V$SESSIONC. V$WAITSD. V$WAITSTATE. V$SESSION_LONGOPS答案：（E）

（344）In what view are you likely to see the following output?SID   SERIAL#    EVENT                                ...

（343）What is the impact of the following backup if it exceeds the duration allowance? (Choose all that apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;A. The entire backup will fail. It will not be usable for recovery.B. The entire backup will fail, b...

（342）How long will this backup be allowed to run?Backup as compressed backupset duration 2:00 minimize load database ;A. 2 minutes           B. 2 hoursC. 2 daysD. The command will generate an error.E. This backup is not const...

（341）If a backup set is expired, what can you do to correct the problem?A. Change the retention criteria.B. Make the lost backup set pieces available to RMAN again.C. Run the crosscheck command to correct the location for the backup set piece contained in the metadata.D. Nothing. Th...

（340）What does it mean if a backup is expired?A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.B. The backup set has one or more invalid blocks in it and is not usable for recovery.C. The backup set contains one or more tablespaces no longer ...

（339）Why would you run the delete obsolete command? (Choose all that apply.)A. To remove missing backup set pieces physically from diskB. To remove metadata related to backup set pieces in the control file and the recovery catalogC. To mark as deleted records in the control file and the...