Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?
A. shutdown restore datafile 4; recover datafile 4; alter database open;
B. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open;
C. Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online;
D. Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4;
Sql alter database datafile 4 online;
E. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database datafile 4 online;
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?
a. Restored the control file with the RMAN restore controlfile command.
b. Mounted the DSL instance with the alter database mount command.
c. Restored the datafiles for the DSL database with the RMAN restore command.
d. Opened the DSL database with the alter database open resetlogs command.
e. Recovered the datafiles for the DSL database with the RMAN recover command.
f. Started the DSL instance.
g. Connected to the recovery catalog with RMAN.
A. a, b, c, d, e, f, g
B. b, c, d, g, f, e, a
C. g, f, a, b, c, e, d
D. c, a, d, b, f, e, g
E. g, f, a, b, e, c, d
Which command would you use to determine what database backups are currently available for restore?
A. list database backup;
B. report database backup;
C. list backup of database;
D. list summary backup;
E. report backup of database;
What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?
B. list backup
E. backup validate
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?
A. synch catalog
B. resync catalog
C. replicate catalog
D. update catalog
E. restore catalog
You want to make sure that your database backup does not exceed 10 hours in length. What command would you issue that would meet this condition?
A. backup database plus archivelog;
ivlog until time 10:00;
B. backup database plus arch
C. backup database plus archivelog timeout 10:00;
D. backup database plus archivelog duration 10:00;
E. backup database plus archivelog timeout 10:00;
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
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.
Why would you run the delete obsolete command? (Choose all that apply.)
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
What does it mean if a backup is expired?
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.
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 exam questions.
If you can master all lead2pass questions you will able to pass 100% guaranteed.
|One Time Purchase||✔||✖||✖||✖||✖|
|100% Pass Guarantee||✔||✖||✖||✖||✖|
|100% Money Back||✔||✖||✖||✖||✖|