Your database has a backup that was taken yesterday (Tuesday) between 13:00 and 15:00 hours. This is the only backup you have. You have lost all the archived redo logs generated since the previous Monday, but you have archived redo logs available from the previous Sunday and earlier. You now need to restore your backup due to database loss. To which point can you restore your database?
A. 13:00 on Tuesday.
B. 15:00 on Tuesday.
C. Up until the last available archived redo log on Sunday.
D. To any point; all the redo should still be available in the online redo logs.
E. The database is not recoverable.
Which of the following files cannot be backed up by RMAN? (Choose all that apply.)
A. Database datafiles
B. Control files
C. Online redo logs
D. Database pfiles
E. Archived redo logs
Which of the following RMAN structures can data from a datafile span?
A. RMAN backup-set pieces spanning backup sets
B. RMAN backup-set pieces within a given backup set
C. RMAN backups
D. RMAN channels
E. None of the above
Which RMAN backup command is used to create the block-change tracking file?
A. alter database create block change tracking file
B. alter database enable block change file
C. alter database enable block change tracking using file ,,/ora01/opt/ block_change_tracking.fil
D. alter system enable block change tracking using file ‘/ora01/opt/block_ change_tracking.fil’
E. alter system block change tracking on
A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java. Knowing that your database is in danger, which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?
A. backup database all
B. backup compressed database
C. backup as compressed backupset database;
D. backup as compressed backup database plus archivelog all;
E. backup as compressed backupset database plus compress archivelog all;
What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
A. Make backups faster
B. Store RMAN metadata
C. Store RMAN scripts
D. Provide the ability to do centralized backup reporting.
E. Make recovery faster
RMAN provides more granular catalog security through which feature?
A. Virtual private database
B. Virtual private catalog
C. RMAN virtual database
D. RMAN secure catalog
E. Oracle Database Vault
You can back up the RMAN recovery catalog with RMAN.
What RMAN command must you use before you can back up a database using the recovery catalog?
A. create catalog
B. install database
C. catalog database
D. merge Catalog with database
E. register database
You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:
SQL> startup ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file ,,
C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE\INITORCL.ORA Using RMAN,
how would you respond to this error?
A. Issue the startup nomount command and then issue the restore parameter file command from the
B. Issue the startup nomount command and then issue the restore spfile command from the RMAN
C. Issue the startup nomount command and then issue the restore spfile from autobackup command
from the RMAN prompt.
D. Issue the startup nomount command and then issue the restore spfile from backup command from
the RMAN prompt.
E. Issue the restore spfile from autobackup command from the RMAN prompt.
If you want to pass Oracle 1Z0-053 successfully, donot missing to read latest lead2pass Oracle 1Z0-053 dumps.
If you can master all lead2pass questions you will able to pass 100% guaranteed.