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.
您可能感兴趣的试卷
你可能感兴趣的试题
A. Restore tablespace
B. Recover tablespace
C. Tablespace recover
D. Recover to time
E. recover datafile
A. True
B. False
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 no longer valid because of a resetlogs operation.
E. The physical backup set pieces are missing from the media.
A. Size of the datafiles
B. Size of the tempfiles
C. Date of last backup for datafiles and tempfiles
D. Filenames for each datafile
E. Checkpoint SCN associated with the last RMAN backup
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
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.
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.
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.
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SESSION_LONGOPS
In what view are you likely to see the following output?()
SID SERIAL# EVENT SECONDS_IN_WAIT
121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SYSSTAT
最新试题
Which two statements are true about a job chain?()
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 two commands never trigger an implicit rebalancing within the disk group?()
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager (RMAN) while duplicating a running database?()
To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file?()
Which three statements are true about windows?()
View the Exhibit and examine the disk groups created at the time of migrating the database storage to Automatic Storage Management (ASM). Why does the FRA disk group initially have more free space even though both DATA and FRA disk groups are provided with the same size?()
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 CREATE DISKGROUP command used to create a disk group: SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCY DISK ’ORCL: FRA3’ NAME misc1, ’ORCL: FRA4’ NAME misc2; In which situation would you use this method of disk group creation?()
You are using Recovery Manager (RMAN) with a recovery catalog to back up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. Because of media failure, you lost your production database completely along with the recovery catalog database. You want to recover the target database and make it functional. You consider performing the following steps to accomplish the task: 1) Restore an autobackup of the server parameter file.2) Restore the control file 3) Start the target database instance 4) Mount the database 5) Restore the data files 6) Open the database with RESETLOGS option 7) Recover the data files 8) Set DBID for the target database Which option illustrates the correct sequence that you must use?()