CMS专题
单选题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？（）AThey will be renamed.BNothing will happe
题目
They will be renamed.
Nothing will happen to them. The backup set pieces do not exist.
They will be deleted immediately since they are not in the flash recovery area.
You will need to manually remove the physical files listed in the output of the commands.
They will become hidden files and removed 10 days later.
相似问题和答案
第1题：
The backup retention policy is configured as RECOVERY WINDOW 2. You executed the following command in Recovery Manager （RMAN） against your database： RMAN> REPORT OBSOLETE； What would you see in the output？（）
- A、 a list of all those files that have been deleted in the last two days
- B、 a list of all those files that have been recovered within the last two days
- C、 a list of all the expired backups and copies
- D、 a list of backups and copies that are outside the range covered by the current retention policy
正确答案:D
第2题：
Your PROD database has been started using the server parameter file. In your PROD database you are using RMAN for backup and recovery operations. You issue the following commands from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP OFF； RMAN> BACKUP DATABASE； Which files from the database will be backed up as a result of this BACKUP command？（）
- A、 control file
- B、 all datafiles
- C、 password file
- D、 online redo log file
- E、 archive redo log file
- F、 server parameter file
- G、 only the SYSTEM datafile
正确答案:A,B,F
第3题：
Multiple RMAN sessions are connected to the database instance.Examine the following output when backup commands are running in server sessions:What could have helped you to correlate server sessions with channels?（）
A. Implement RMAN multiplexing
B. Set the DEBUG ON in the RMAN script
C. Specify the command ID in the RMAN script
D. Use a tag with the RMAN BACKUP command
第4题：
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.
正确答案:B
第5题：
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）
- A、 when you change the name of a datafile
- B、 when you drop a table from the database
- C、 when you take an export of the database
- D、 when you back up the database using OS utilities
- E、 when you issue an ALTER SYSTEM SWITCH LOGFILE statement
- F、 when you issue a BACKUP command from inside the RMAN run block
正确答案:A,E,F
第6题：
In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；
- A、 to configure RMAN to maintain backup information in the RMAN repository for seven days
- B、 to configure RMAN to maintain backup information in the control file for at least seven days
- C、 to display the list of files that have not been backed up for the last seven days
- D、 to display the list of files that must be backed up within seven days
正确答案:C
第7题：
You have created a script in the recovery catalog called backup_database. Which of the following commands would successfully execute that script？（）
- A、 run { open script backup_database； run script backup_database }
- B、 run { engage script backup_database； }
- C、 run { run script backup_database； }
- D、 Run { execute script backup_database； }
- E、 The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would result in an error.
正确答案:D
第8题：
You executed the following command in Recovery Manager （RMAN） against your Oracle 10g database：RMAN> REPORT NEED BACKUP days 3；What would be the output of this command？（）
- A、 a list of files that require a backup within three days
- B、 a list of files that have not been backed up for three days
- C、 a list of files that RMAN recommends be backed up only once in every three days， based on low volatility
- D、 a list of files for which a backup has already been performed and may need a backup after three days
正确答案:B
第9题：
You executed the following command in the Recovery Manager （RMAN）： RMAN> REPORT NEED BACKUP days 3； What is the output of this command？（）
- A、 A list of files that require a backup within 3 days
- B、 A list of files requiring more than 3 days of archivelogs to apply
- C、 A list of files that RMAN recommends be backed up only once in every three days，based on low volatility
- D、 A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them
正确答案:B
第10题：
You execute the following RMAN commands in the order shown below： BACKUP VALIDATE DATABASE; BLOCKRECOVER CORRUPTION LIST; What will these commands do？（）
- A、create a backup of the database and recover all corrupted blocks found in the backup
- B、run a backup validation and list all the logically corrupt blocks as well as physically corrupt blocks in the database
- C、run a backup validation to populate V$COPY_CORRUPTION view， and then list any corrupt blocks recorded in the view
- D、run a backup validation to populate V$DATABASE_BLOCK_CORRUPTION view， and then repair any corrupt blocks recorded in the view
- E、run a backup validation， repair any corrupt blocks found during the validation process， and then update V$DATABASE_BLOCK_CORRUPTION view to indicate which corrupt blocks have been repaired
正确答案:D