It can never be used for a restore/recover operation.
Oracle will remove the backup set pieces from the flash recovery area.
The backup has been used at least once to restore and recover the database.
The backup is no longer valid because of a resetlogs operation.
The physical backup set pieces are missing from the media.
第1题:
What does it mean if a backup is expired?()
第2题:
Why would you run the delete obsolete command?()
第3题:
Which step is required for recover from an instance failure? ()
第4题:
Which of the following RMAN structures can data from a datafile span?()
第5题:
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()
第6题:
dd
tar
restore
installios
第7题:
recovery cannot be performed because a backup was not performed after the last incomplete recovery
restore all the files from Sunday’s backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
restore all the files from Sunday’s backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
restore all the files from Sunday’s backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
第8题:
Restore the 19ths backup, restore all archived redo logs, recover the database to the 20th,and open the database.
Tell them that their request cannot be met with the current backup strategy.
Restore the 19ths backup, apply the online redo logs,and open the database.
Switch the database into ARCHIVELOG mode,restore the 19th’s backup,restore all archived redo logs,and recover the database to the 20th.
Use the recover database command to roll back the database from today to the 19th of the month.
第9题:
dd
tar
cpio
restore
第10题:
The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.
The backup set has one or more invalid blocks in it and is not usable for recovery.
The backup set contains one or more tablespaces no longer in the database.
The backup set contains one or more missing backup set pieces.
The backup set is from a previous version of RMAN and was not upgraded.
第11题:
Create a system restore point.
Create a backup of all file categories.
Create a Complete PC Backup and Restore image.
Perform an Automated System Recovery (ASR) backup.
第12题:
It can never be used for a restore/recover operation.
Oracle will remove the backup set pieces from the flash recovery area.
The backup has been used at least once to restore and recover the database.
The backup is no longer valid because of a resetlogs operation.
The physical backup set pieces are missing from the media.
第13题:
Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option. A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday’s backup is the most recent backup available. What would you do in this scenario?()
第14题:
If a backup is expired, which of the following is true?()
第15题:
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?()
第16题:
You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()
第17题:
Your developers have asked you to restore the development database, which is in NOARCHIVELOG mode, back to last Tuesday the 20th. Your last backup is from Monday the 19th. What do you do?()
第18题:
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.
第19题:
dd
tar
cpio
restore
第20题:
Full backups every month, daily incremental backups
Full backups every month, daily differential backups
Full backup Saturday night, incremental backups the rest of the week
Full backup Saturday night, differential backups the rest of the week
第21题:
restore the tablespace from the backup; there is no need to apply the redo information
restore the full database to recover the data up to the point when you performed the backup
restore the tablespace from the backup and then perform a recovery using the backup control file
restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
第22题:
restore the tablespace from the backup, and then perform an incomplete recovery
restore the tablespace from the backup, and then apply all the redo information
restore all the data files in the database, and then perform an incomplete recovery
restore the tablespace from the backup
第23题:
RMAN image copies
RMAN database backups
RMAN tablespace backups
usermanaged backups placed in the flash recovery area
usermanaged backups that have been cataloged with RMAN
usermanaged data file backups for which the full path name is specified
第24题:
register database
recover catalog
load backupset
synch metadata
catalog start with