Question No: 271 – (Topic 7)

You executed the following commands in an RMAN session for your database instance that has failures:

RMANgt; LIST FAILURE;

After some time, you executed the following command in the same session: RMANgt; ADVISE FAILURE;

But there are new failures recorded in the Automatic Diagnostic Repository (ADR) after the execution of the last LIST FAILURE command.

Which statement is true for the above ADVISE FAILURE command in this scenario?

It produces a warning for new failures before advising for CRITICAL and HIGH failures.

It ignores new failures and considers the failures listed in the last LIST FAILURE command only.

It produces an error with recommendation to run the LIST FAILURE command before the ADVISE FAILURE command.

It produces advice only for new failures and the failures listed in the last LIST FAILURE command are ignored.

Answer: A

Question No: 272 – (Topic 7)

You are performing incomplete recovery using RMAN. You execute the following RUN block:

RUN

{

SET UNTIL SCN 1107600; RESTORE DATABASE; RECOVER DATABASE;

}

Which statement is true about the result?

RMAN restores all datafiles from the most recent backup available since the failure and applies the redo logs necessary to recover the database to SCN 1107600

RMAN restores all datafiles needed to restore the database through SCN 1107599 and applies the redo logs necessary to recover the database through SCN 1107599.

RMAN restores all datafiles and control files from the most recent backup

The RUN block fails because you did not specify an UNTIL clause in your RECOVER DATABASE command

Answer: B

Question No: 273 – (Topic 7)

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?

Open the database in NORMAL mode

Open the database in read-only mode

Open the database in RESTRICTED mode

Open the database with the RESETLOGS option

Answer: D Explanation:

Recovering the Database After a Disaster

The procedure for disaster recovery is similar to the procedure for recovering the database with a backup control file in NOCATALOG mode. If you are restoring the database to a new host, then you should also review the considerations described in quot;Restoring a Database on a New Hostquot;.

This scenario assumes that the Linux server on which your database was running has been damaged beyond repair. Fortunately, you backed up the database to Oracle Secure Backup and have the tapes available. The scenario assumes the following:

->Oracle Database is already installed on the new host.

->You are restoring the database to a new Linux host with the same directory structure as the old host.

->You have one tape drive containing backups of all the data files and archived redo logs through log 1124, and autobackups of the control file and server parameter file.

->You do not use a recovery catalog with the database.

To recover the database on the new host:

If possible, restore or re-create all relevant network files such as tnsnames.ora and listener.ora and a password file.

Start RMAN and connect to the target database instance.

At this stage, no initialization parameter file exists. If you have set ORACLE_SID and ORACLE_HOME, then you can use operating system authentication to connect as SYSDBA. For example, start RMAN as follows:

% rman

RMANgt; CONNECT TARGET

/

Specify the DBID for the target database with the SET DBID command, as described in quot;Restoring the Server Parameter Filequot;.

For example, enter the following command: SET DBID 676549873;

Run the STARTUP NOMOUNT command.

When the server parameter file is not available, RMAN attempts to start the instance with a dummy server parameter file.

Allocate a channel to the media manager and then restore the server parameter file from autobackup. For example, enter the following command to restore the server parameter file from Oracle Secure Backup:

# Restore autobackup of the control file. This example assumes that you have

# accepted the default format for the autobackup name. RESTORE CONTROLFILE FROM AUTOBACKUP;

# The set until command is used in case the database

# structure has changed in the most recent backups, and you want to

# recover to that point in time. In this way RMAN restores the database

# to the same structure that the database had at the specified time. ALTER DATABASE MOUNT;

SET UNTIL SEQUENCE 1124 THREAD 1; RESTORE DATABASE;

RECOVER DATABASE;

}

The following example of the RUN command shows the same scenario except with new file

names for the restored data files:

RMANgt; RUN

{

# If you must restore the files to new locations,

# use SET NEWNAME commands:

SET NEWNAME FOR DATAFILE 1 TO #39;/dev/vgd_1_0/rlvt5_500M_1#39;; SET NEWNAME FOR DATAFILE 2 TO #39;/dev/vgd_1_0/rlvt5_500M_2#39;; SET NEWNAME FOR DATAFILE 3 TO #39;/dev/vgd_1_0/rlvt5_500M_3#39;; ALLOCATE CHANNEL t1 DEVICE TYPE sbt;

Question No: 275 – (Topic 7)

While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified.

Which RMAN command do you use to perform BMR and repair the corrupt block?

RECOVER FILE=1201 BLOCK=1968;

RECOVER CORRUPTION LIST;

RECOVER DATAFILE 1201 BLOCK 1968;

RECOVER BLOCK CORRUPTION LIST;

None of the above

Answer: B,C

Question No: 276 – (Topic 7)

Given the following RMAN commands, choose the option that reflects the order required to restore your currently operational ARCHIVELOG mode database.

a: restore database; b: recover database;

c: shutdown immediate d: startup

e: restore archivelog all; f: alter database open

a, b, c, d, e, f

c, b, a, d, e, f

c, b, a, d, f

c, a, b, d

c, a, e, b, d, f

Answer: C

Question No: 277 – (Topic 7)

View the Exhibit to examine the error during the database startup. You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:

RMANgt; REPAIR FAILURE;

Which statement describes the consequence of the command? Exhibit:

The command performs the recovery and closes the failures.

The command only displays the advice and the RMAN script required for repair.

The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).

Answer: C

Question No: 278 – (Topic 7)

You have control-file autobackups enabled. When starting your database from SQL*Plus, you receive the following error message:

SQLgt; startup

ORA-01078: failure in processing system parameters

LRM-00109: could not open parameter file #39;C:\ORACLE\PRODUCT\11.1.0\DB_1\DATABASE

\INITORCL.ORA#39;

Using RMAN, how would you respond to this error?

Issue the startup nomount command and then issue the restore parameter file command from the RMAN prompt.

Issue the startup nomount command and then issue the restore spfile command from the RMAN prompt.

Issue the startup nomount command and then issue the restore spfile from autobackup command from the RMAN prompt.

Issue the startup nomount command and then issue the restore spfile from backup command from the RMAN prompt.

Issue the restore spfile from autobackup command from the RMAN prompt.

Answer: C

Question No: 279 – (Topic 7)

You are using Recovery Manager (RMAN) for backup and recovery operations with a recovery catalog. You have been taken database backups every evening. On November 15, 2007, at 11:30 AM, you were informed that the USER_DATA tablespace was accidentally dropped. On investigation, you found that the tablespace existed until 11:00 AM, and important transactions were done after that.

So you decided to perform incomplete recovery until 11:00 AM. All the archive logs needed to perform recovery are intact. In NOMOUNT state you restored the control file that has information about the USER_DATA tablespace from the latest backup. Then you mounted the database. Identify the next set of commands that are required to accomplish the task?

Option A

Option B

Option C

Option D

Answer: A

Question No: 280 – (Topic 7)

Identify two situations in which you can use Data Recovery Advisor for recovery. (Choose two.)

The user has dropped an important table that needs to be recovered.

The database files are corrupted when the database is open.

You are not able to start up the database instance because the required database files are missing.