callicon +1 210-504-8191
whatsAppIcon +1 210-504-8191
emailIcon info@koenig-solutions.com
koenig-logo
logo-30-years
Login
koenig-logo
+1 210-504-8191
+1 210-504-8191

Oracle Database 19c: Backup and Recovery Quiz Questions and Answers

Answer :
  • 6,2,3,7

Explanation :

You should first start the database in mount mode using the STARTUP MOUNT command. You then issue the ALTER DATABASE CLEAR UNARCHIVED LOGFILE command. This will clear the log file if it needs to be archived and recreate the online redo log group. If that command is successful, then you issue the ALTER DATABASE OPEN command. The last step, backing up the database, is very important since your previous backup will not be able to recover the database beyond the point of the cleared redo log sequence number. This is because you have skipped a redo log in the redo log stream.
Answer :
  • c, a, b, d, f

Explanation :

In the event of complete loss of your database, you will need to first restore the database spfile. Once you have restored the database spfile, you will need to restore the database control file. Having restored the database control file, you would restore the database and then recover the database. Finally, since this would be an incomplete recovery (because you lost the entire database, the online redo logs are gone too), you would need to open the database using the ALTER DATABASE OPEN RESETLOGS command.
Answer :
  • 1,2,4,5,3

Explanation :

If the database has not shut down yet, you have an opportunity to preserve your data changes. Issue a checkpoint, which will flush dirty buffers to disk. Then shut down the database normally, if possible (SHUTDOWN, SHUTDOWN IMMEDIATE). You then should mount the database with the STARTUP MOUNT command followed by clearing and rebuilding the log file with the ALTER DATABASE CLEAR LOGFILE command. Finally, attempt to open the database with the ALTER DATABASE OPEN command.
Answer :
  • Change-based
  • Cancel-based
  • Time-based
  • Sequence number-based

Explanation :

Change-based recovery allows you to recover the database to a specific SCN. Cancel-based recovery provides the ability to cancel recovery after each archived redo log application. Time-based recovery provides the ability to recover the database up to a specific point in time. Sequence number–based recovery allows you to recover the database up to a specific log sequence number.
Answer :
  • Attempting to restore gold_copy may or may not succeed.

Explanation :

Since the retention policy is set to redundancy of 1, the gold_copy backup is not required to meet the retention criteria. Since the backup was not made in a way that will exclude or alter the retention criteria, then the gold_copy backup is no longer needed and may be removed at any time. It is possible that it will still be available for restore purposes, however.
Answer :
  • 4,1,5,7

Explanation :

First, you would restore the missing data files. Notice in the question that there are two data files that were lost. Next, you would mount the database, and then you would recover the SYSTEM tablespace. Since it is the SYSTEM tablespace, you would not be able to open the database first. Then you would open the database with the ALTER DATABASE OPEN command.
Answer :
  • Nothing will happen to them. The backup set pieces do not exist.

Explanation :

Expired backup set pieces are those backup set pieces that do not exist. They are discovered via the CROSSCHECK command and marked as expired. The LIST EXPIRED command reports backup set records that are marked as expired. The DELETE EXPIRED BACKUP command marks the backup metadata in the control file and recov- ery catalog with a status of DELETED .