单项选择题Why would you execute the report obsolete command?()  

A. To list all backups that were no longer available for restore operations
B. To list all backups that had aged beyond the RMAN retention criteria
C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the backup media
D. To list all datafiles that are no longer part of the database and thus do not need to be backed up
E. To list all archived redo logs that are no longer needed for any database recovery


您可能感兴趣的试卷

你可能感兴趣的试题

1.单项选择题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 days. The datafile is not recoverable. 
D. Lists all datafiles that need to be backed up due to unrecoverable operations.
E. Lists all datafiles not backed up in the last three days. It does not imply that the datafile is not recoverable.

2.单项选择题

What does the output on this report indicate?()  
RMAN> report need backup; 
RMAN retention policy will be applied to the command 
RMAN retention policy is set to redundancy 1 
Report of files with less than 1 redundant backups 
File #bkps Name 
5 0 C:\ORACLE\ORADATA\ORCL\MY_DATA_01.DBF  

A. The my_data_01.dbf datafile is corrupted and needs to be restored.
B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in the datafile can not be recovered.
C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the datafile can not be recovered.
D. The my_data_01.dbf datafile no longer meets the retention criteria for backups.
E. Datafile 5 is missing.

3.单项选择题

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 operations 
File Type of Backup Required Name 
4 full or incremental C:\ORACLE\ORADATA\ORCL\USERS01.DBF  

A. There are no backup sets with any backups of the users01.dbf datafile.
B. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or some data loss is possible during a recovery.
C. The users01.dbf datafile is corrupted.
D. The users01.dbf datafile backup exceeds the retention criteria.
E. The last backup of the users01.dbf datafile failed and must be rerun.

4.单项选择题What view might you use to try to determine how long a particular backup will take?()  

A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SESSION_LONGOPS

6.单项选择题

What is the impact of the following backup if it exceeds the duration allowance?()
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 failbut any datafile successfully backed up will be usable for recovery.
C. If this backup fails,subsequent backups will prioritize datafiles not backed up.
D. If this backup fails,an error will be raised and any other commands will not be executed. 
E. If this backup fails,no error will be raised and any other commands will be executed.

7.单项选择题

How long will this backup be allowed to run?() 
Backup as compressed backupset duration 2:00 minimize load database

A. 2 minutes
B. 2 hours
C. 2 days
D. The command will generate an error.
E. This backup is not constrained by any time limitation.

8.单项选择题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. The backup set piece is lost forever.
E. Call Oracle support,their assistance is required.

9.单项选择题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 in the database.
D. The backup set contains one or more missing backup set pieces.
E. The backup set is from a previous version of RMAN and was not upgraded.

10.多项选择题Why would you run the delete obsolete command?()  

A. To remove missing backup set pieces physically from disk
B. To remove metadata related to backup set pieces in the control file and the recovery catalog
C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
D. To delete backup set pieces associated with backups that are no longer needed due to retention criteria
E. To remove old versions of RMAN backups

最新试题

Indentify two advantages of using recovery catalog instead of the control file of the database in Recovery Manager (RMAN).()

题型:多项选择题

You want to configure the Flashback Database feature and retain flashback logs for three days. Presently the database is open and configured in ARCHIVELOG mode. The following steps must be performed in the correct sequence to do this:  1. Set the retention target: SQL> ALTER SYSTEM SET DB_FLASHBACK_RETENTION_TARGET=4320; 2. Enable Flashback Database: SQL> ALTER DATABASE FLASHBACK ON; 3. Mount the database: SQL> STARTUP MOUNT EXCLUSIVE 4. Shutdown the instance: SQL> SHUTDOWN IMMEDIATE 5. Open the database: SQL> ALTER DATABASE OPEN;  Choose the correct sequence.()

题型:单项选择题

Which option is best practice for creating a recovery catalog owner in the catalog database?()  

题型:单项选择题

Examine the following ALTER command:  SQL> ALTER DISKGROUP dgroup1 UNDROP DISKS;  What is the purpose of the command?()  

题型:单项选择题

The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()  

题型:单项选择题

Examine the following RMAN command:  RMAN> CONFIGURE ENCRYPTION FOR DATABASE ON; RMAN> BACKUP DATABASE PLUS ARCHIVELOG;  Which prerequisite must be met before accomplishing the backup?()

题型:单项选择题

Which three statements are true about persistent configuration?()  

题型:多项选择题

Which two statements are true about a job chain?()

题型:多项选择题

Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()

题型:多项选择题

User SCOTT wants to back out the transactions on the REGIONS table in his schema. As a DBA, which commands must you execute to enable SCOTT to flash back the transactions?()

题型:多项选择题