46.
Which are the correct steps, in order, to deal with the loss of an online redo log if the database
has not yet crashed?
a. Issue a checkpoint.
b. Shut down the database.
c. Issue an alter database open command to open the database.
d. Startup mount the database.
e. Issue an alter database clear logfile command.
f. Recover all database datafiles.
b. Shut down the database.
c. Issue an alter database open command to open the database.
d. Startup mount the database.
e. Issue an alter database clear logfile command.
f. Recover all database datafiles.
- A.a, b, c, d
- B.b, d, e, c
- C.a, b, d, e, c
- D.b, f, d, f, c
- E.b, d, a, c
- Answer & Explanation
- Report
Answer : [C]
Explanation :
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. |
47.
What methods of point-in-time recovery are available? (Choose all that apply.)
- A.Change-based
- B.Cancel-based
- C.Time-based
- D.Sequence number-based
- E.Transaction number-based
- Answer & Explanation
- Report
Answer : [A, B, C, D]
Explanation :
Explanation :
| Change-based application allows you to recover the database to a specific SCN. Cancel-based recovery provides the ability for you 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. |
48.
Which files are required for a full recovery of the database in ARCHIVELOG mode?
(Choose three.)
- A.Database datafiles
- B.Online redo logs
- C.Archived redo logs
- D.Backup control file
- E.Control file from a backup
- Answer & Explanation
- Report
Answer : [A, C, D]
Explanation :
Explanation :
| To perform a full recovery of the database that is in ARCHIVELOG, you would need the database datafiles, the archived redo logs, and a backup control file. |
49.
What is the proper procedure to recover a lost tempfile?
- A.Restore the backup copy of the tempfile from the backup media.
- B.Re-create the tempfile with the create tempfile command.
- C.Copy an existing tempfile from another database.
- D.Re-create the tempfile with the create tablespace command.
- E.Re-create the tempfile with the alter tablespace command.
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| You use the alter tablespace add tempfile command to re-create a missing tempfile or add a new tempfile to a temporary tablespace. |
50.
Upon starting your database, you receive the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 171581440 bytes
Fixed Size 1298640 bytes
Variable Size 146804528 bytes
Database Buffers 20971520 bytes
Redo Buffers 2506752 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log'
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log'
You can choose from the following steps:
a. Restore the database datafiles.
b. Issue the alter database clear unarchived logfile group 1 command.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using point-in-time recovery.
f. Issue the Startup Mount command to mount the database.
g. Back up the database.
Which is the correct order of these steps in this case?
ORACLE instance started.
Total System Global Area 171581440 bytes
Fixed Size 1298640 bytes
Variable Size 146804528 bytes
Database Buffers 20971520 bytes
Redo Buffers 2506752 bytes
Database mounted.
ORA-00313: open failed for members of log group 1 of thread 1
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01.log'
ORA-00312: online log 1 thread 1: '/oracle01/oradata/orcl/redo01a.log'
You can choose from the following steps:
a. Restore the database datafiles.
b. Issue the alter database clear unarchived logfile group 1 command.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using point-in-time recovery.
f. Issue the Startup Mount command to mount the database.
g. Back up the database.
Which is the correct order of these steps in this case?
- A.a, f, e, d, g
- B.f, e, d
- C.f, b, c, g
- D.a, f, c
- E.The database cannot be recovered.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
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 re-create 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. |
|
|
||||||||||||||||||||||||||||
