- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
11.
Your NOARCHIVELOG database has experienced a loss of data file users_01.dbf,
which is associated with a tablespace called USERS. The database is still running. Which
of the following is the most correct answer?
- A.You can take the data file offline, restore the data file from a backup, and then recover the data file using the archived redo logs. You would then bring the data file back online.
- B.You will have to shut down the database and restore the database, online redo logs, and control files that were contained in the last backup. You can then restart the database. There will be data loss.
- C.You will have to shut down the database and restore the database, online redo logs, and control files that were contained in the last backup. You can then restart the database. There will be no data loss.
- D.This failure is not recoverable. You will need to force open the database and then force a recovery.
- E.None of the above is correct.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Since the database is in NOARCHIVELOG mode, loss of a data file is going to require the recovery of the entire database. Therefore, you will need to shut down the database and restore it from the last cold backup along with the online redo logs and control files. You can then restart the database. |
12.
As soon as you discover that you have lost an online redo log, if the database is still
functioning, what should be your first action?
- A.Shut down the database.
- B.Clear the online redo log.
- C.Back up the database.
- D.Checkpoint the database.
- E.Call Oracle support.
- F.Panic.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| When you discover that you have lost an online redo log, and if the database is still up, the first action should be to checkpoint the database. This can serve to reduce the overall risk of data loss. After you checkpoint the database, you can then attempt to clear the online redo log. A backup afterward is highly recommended. |
13.
You have lost all your SYSTEM tablespace data files (system_01.dbf and
system_02.dbf) and the database has crashed. The database is in ARCHIVELOG
mode and you have a current backup. What would be the appropriate order of operations
to correct the situation?
1. Mount the database with the STARTUP MOUNT command.
2. Take the SYSTEM data file offline with the ALTER DATABASE command.
3. Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.
4. Restore all SYSTEM tablespace–related data files from backup media.
5. Issue the RECOVER TABLESPACE SYSTEM command.
6. Issue the RECOVER DATAFILE SYSTEM_01.DBF command.
7. Open the database with the ALTER DATABASE OPEN command.
8. Open the database with the ALTER DATABASE OPEN RESETLOGS command.
1. Mount the database with the STARTUP MOUNT command.
2. Take the SYSTEM data file offline with the ALTER DATABASE command.
3. Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.
4. Restore all SYSTEM tablespace–related data files from backup media.
5. Issue the RECOVER TABLESPACE SYSTEM command.
6. Issue the RECOVER DATAFILE SYSTEM_01.DBF command.
7. Open the database with the ALTER DATABASE OPEN command.
8. Open the database with the ALTER DATABASE OPEN RESETLOGS command.
- A.1,3,6,7
- B.2,4,5,8
- C.1,2,3,6,7
- D.4,1,5,7
- E.2,3,6,5,7
- Answer & Explanation
- Report
Answer : [D]
Explanation :
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. |
14.
You have discovered that one of three control files has been lost. What steps would you
follow to recover that control file?
1. Shut down the database.
2. Restore a control-file copy from backup media.
3. Use the CREATE CONTROLFILE command to create a new control file.
4. Copy the backup control file into place.
5. Create a new copy of the control file from one of the surviving control files.
6. Recover the database using the RECOVER DATABASE USING BACKUP CONTROLFILE command.
7. Start up the database.
1. Shut down the database.
2. Restore a control-file copy from backup media.
3. Use the CREATE CONTROLFILE command to create a new control file.
4. Copy the backup control file into place.
5. Create a new copy of the control file from one of the surviving control files.
6. Recover the database using the RECOVER DATABASE USING BACKUP CONTROLFILE command.
7. Start up the database.
- A.1,2,6,7
- B.3,6,7
- C.1,4,6,7
- D.1,6,7
- E.1,5,7
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| If you lose one or more control files but at least one remains, you should shut down the database. Then use any remaining control file as the source to create new controlfile copies for the control files that were lost. Then restart the database. No recovery is required in this situation. |
15.
Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG
mode? (Choose all that apply.)
- A.Database data files
- B.Control files
- C.Archived redo logs
- D.Online redo logs
- E.Flashback logs
- Answer & Explanation
- Report
Answer : [A,B,D]
Explanation :
Explanation :
| You will need to have the database data files, the control files, and the online redo logs in place to be able to restore the database when it’s in NOARCHIVELOG mode |
|
|
||||||||||||||||||||||||||||
