Complete database recovery.
Incomplete database recovery.
Approximate database recovery.
Archived database recovery.
The database could not be recovered with RMAN.
第1题:
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?()
第2题:
You are using RMAN to perform a closed database backup of your database. You issue these RMAN commands: STARTUP MOUNT; BACKUP FORMAT ’/BACKUP/df_%d_%s_%p.bus’ DATABASE filesperset = 2; Which components are included in the backup?()
第3题:
You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()
第4题:
Your database is running in ARCHIVELOG mode, and the database is open. You execute an RMAN backupand specify the KEEP clause.Which components are backed up when this option is specified?()
第5题:
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode?()
第6题:
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
第7题:
If you lost your entire database,including the database spfile,control files,online redo logs,and database datafiles,what kind of recovery would be required with RMAN?()
第8题:
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()
第9题:
You are using recovery Manager (RMAN) with a recovery catalog to backup up your production database. The backups and the archived redo log files are copied to a tape drive on a daily basis. The database was open and transactions were recorded in the redo logs. Because of fire in the building you lost your servers having the production database and the recovery catalog database. The archive log files generated after the last backup are intact on one of the remote locations. While performing a disaster recovery of the production database what is the next step that you must perform after restoring the data files and applying archived redo logs?()
第10题:
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?()