register database
recover catalog
load backupset
synch metadata
catalog start with
第1题:
Why would you run the delete obsolete command?()
第2题:
You configured the default backup device type as disk for RMAN backups. In your database,because of business requirements,you have to take a simultaneous duplicate backup of the data files when the RMAN BACKUP command is used. What must you set using the RMAN CONFIGURE command to achieve this?()
第3题:
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?()
第4题:
Your database is configured in NOARCHIVELOG mode. All the control files have been lost due to a hard disk failure but the data files are not lost. You have the closed whole database backup available to you. Which two statements are true in this scenario?()
第5题:
To remove missing backup set pieces physically from disk
To remove metadata related to backup set pieces in the control file and the recovery catalog
To mark as deleted records in the control file and the recovery catalog associated with obsolete backup sets
To delete backup set pieces associated with backups that are no longer needed due to retention criteria
To remove old versions of RMAN backups
第6题:
RECOVER DATABASE;
SWITCH DATAFILE ALL;
RESTORE CONTROL FILE;
RECOVER DATABASE USING BACKUP CONTROL FILE;
第7题:
MAXSETSIZE TO 2
DEVICE TYPE DISK PARALLELISM 2
RETENTION POLICY TO REDUNDANCY 2
DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2
第8题:
13:00 on Tuesday.
15:00 on Tuesday.
Up until the last available archived redo log on Sunday.
To any point; all the redo should still be available in the online redo logs.
The database is not recoverable.
第9题:
You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
You can use the SWITCH DATABASE TO COPY Recovery Manager (RMAN) command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
You cannot use Recovery Manager (RMAN) to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.
第10题:
configure a default device for RMAN backups
temporarily disable the retention policy for RMAN backups
configure automatic channel allocation for RMAN backups
use the CONFIGURE command to reconfigure the recovery window to 60 days
第11题:
RMAN backup-set pieces spanning backup sets
RMAN backup-set pieces within a given backup set
RMAN backups
RMAN channels
None of the above
第12题:
The command generates an error.
The command backs up the tablespace and creates a backup set of size 200 MB
The command backs up the tablespace and creates two backup sets of size 100 MB each.
The command backs up the tablespace and creates a backup set with backup pieces of size 100 MB each.
第13题:
Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - The recovery window is set to 7 days in RMAN. - The most recent backup to disk for the TOOLS tablespace was taken on November 3, 2007. - The TOOLS tablespace is read-only since November 4, 2007. On November 23, 2007, you issue the RMAN command to back up the database to disk. Which statement is true regarding the backup of the TOOLS tablespace?()
第14题:
If a backup set is expired, what can you do to correct the problem?()
第15题:
Which of the following RMAN structures can data from a datafile span?()
第16题:
Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage. Which statement is true about migrating from non-ASM disk storage to ASM disk storage?()
第17题:
The RMAN backup fails because the TOOLS tablespace is read-only
The RMAN skips the backup of the tablespace because backup optimization is enabled
The RMAN makes backup because optimization can be enabled only for backups to disk
The RMAN makes the backup because no backup of the tablespace exists within the seven day window
第18题:
Change the retention criteria.
Make the lost backup set pieces available to RMAN again.
Run the crosscheck command to correct the location for the backup set piece contained in the metadata.
Nothing. The backup set piece is lost forever.
Call Oracle support,their assistance is required.
第19题:
register database
recover catalog
load backupset
synch metadata
catalog start with
第20题:
Take the USERS tablespace offline and re-create the lost data file.
Shut down the instance, restore the data file from the last consistent backup, and restart the databaseinstance.
Shut down the instance, restore all the database files from the last consistent backup, and restart thedatabase instance.
Take the USERS tablespace offline, restore all the data files of the USERS tablespace from the lastconsistent backup, and make the tablespace online
第21题:
Restore all the datafiles from the backup.
Restore only the lost datafile from the backup.
Restore all the datafiles for the lost tablespace from the backup.
Restore all the datafiles for the lost tablespace and all the SYSTEM and SYSAUX datafiles from the backup.
第22题:
configure a default device for RMAN backups
temporarily disable the retention policy for RMAN backups
configure automatic channel allocation for RMAN backups
use the CONFIGURE command to reconfigure the recovery window to 60 days
第23题:
The instance aborts.
The database cannot be recovered.
The database can be recovered by restoring the control files from the backup.
The database remains opened and you have to shut it down with the ABORT option.
The database can be restored till the point of the last closed whole database backup.
第24题:
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.