You are performing an online backup of the PROD database and a power outage occurs. Once the database is mounted, you qu

santosh
Posts: 1311
Joined: Wed Sep 07, 2016 4:43 pm

You are performing an online backup of the PROD database and a power outage occurs. Once the database is mounted, you qu

Postby santosh » Sat Nov 12, 2016 3:11 pm

You are performing an online backup of the PROD database and a power outage occurs. Once the database is mounted, you query V$BACKUP and determine that of the five data files being backed up, the second file was left in “hot backup” mode. Which action should you take to synchronize the data files so that you can open the database to users?

A. Place the tablespace containing the data file offline by issuing the ALTER TABLESPACE <name> OFFLINE command.
B. Unfreeze the header for File #2 by issuing the ALTER DATABASE DATAFILE 3 END BACKUP command.
C. Shut down the database and restore from the previous full offline backup.
D. Shut down the database; restart it, then issue the RECOVER DATAFILE command to recover the second data file.
E. Determine the tablespace containing the second file and unfreeze the header by issuing the ALTER TABLESPACE <name> END BACKUP command.



Return to “Oracle”

Who is online

Users browsing this forum: No registered users and 1 guest