Oracle 1Z0-053 dumps - 100% Pass Guarantee!

Which statement about recovering from the loss of a redo log group is true?

A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.

B. If the lost redo log group is CURRENT, you must clear the log file.

C. If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

D. If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.

Examine the following scenario:

Database is running in ARCHIVELOG mode.

Complete consistent backup is taken every Sunday.

On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted

The disk having active online redo log files is also corrupted. The hardware is repaired and the paths for online redo log files and control files are still valid.

Which option would you use to perform the recovery of database till the point of failure?

A. Restore the latest whole backup, perform complete recovery, and open the database normally

B. Restore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.

C. Restore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.

D. Restore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.

Which mode of database shutdown requires an instance recovery at the time of the next database startup?

A. ABORT

B. NORMAL

C. IMMEDIATE

D. TRANSACTIONAL

You issued the following commands to configure setting in RMAN;

RMAN> CONFIGURE DEVICE TYPE sbt PARALLELISM 1;

RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE sbt TO 2;

RMAN> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 2;

Then you issued the following command to take the backup:

RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

Which statement is true about the execution of the above command?

A. The backup will terminate because the FORMAT clause was not configured for the channel

B. It backs up two copies of data files to tape and disk, and two copies of archived log file on tape

C. It backs up the data files and archived log files to disk, making two copies of each data file and archived log file

D. It backs up the data files and archived log files to tape, making two copies of each data file and archived log file

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