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
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.
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.
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.
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.
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
You run the following commands：
RMAN> list expired backup； RMAN> delete expired backup；
What will happen to the backup set pieces associated with the backups that appear in the list expired backup command？（）
A. They will be renamed.
B. Nothing will happen to them. The backup set pieces do not exist.
C. They will be deleted immediately since they are not in the flash recovery area.
D. You will need to manually remove the physical files listed in the output of the commands.
E. They will become hidden files and removed 10 days later.
You have lost all your RMAN backup set pieces due to a disk failure. Unfortunately， you have an automated cross-check script that also does a delete expired backupset command. You have restored all the backup set pieces from tape.
What command would you use to get those backup set pieces registered in the recovery catalog and the control file of the database again？（）
A. register database
B. recover catalog
C. load backupset
D. synch metadata
E. catalog start with
最新试题
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 command creates an image copy？（）
In your production database， users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason， you realize that another user executed the TRUNCATE TABLE command， which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data？（）
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？（）
While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch？（）
Which three statements are true about persistent configuration？（）
View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation： RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； } What is the multiplexing level in the preceding backup process？（）
Which two operations are NOT performed by the DUPLICATE command in Recovery Manager （RMAN） while duplicating a running database？（）
In Recovery Manager （RMAN）， you are taking image copies of the datafiles of your production database and rolling them forward as regular intervals. You attempt to restart your database instance after a regular maintenance task， you realize that one of the data files that belongs to the USERS tablespace is damaged and you need to recover the datafile by using the image copy. You could perform the following steps to accomplish this： 1） Mount the database 2） Take the data file offline 3） Bring the data file online 4） Use the RMAN SWITCH TO command to switch the image copy 5） Apply the archived redo logs 6） Open the database 7） Use the RMAN RESTORE TO command to switch to the image copy Which two options illustrate the correct sequence of steps that you could follow？（）
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？（）