Database Reference
In-Depth Information
14.
What methods are available to recover lost control files? (Choose all that apply.)
A.
Backup control file
B.
Emergency control file
C.
The
CREATE CONTROLFILE
command
D.
The
RESTORE CONTROLFILE
S Q L*P l u s
command
E.
No backup is required. The database will recreate the control file when it is dis-
covered to be lost.
15.
Your ARCHIVELOG-mode database has lost three data files and shut down. One is
assigned to the
SYSTEM
tablespace and two are assigned to the
USERS
tablespace. You
can choose from the following steps to recover your database:
1.
Restore the three database data files that were lost.
2.
Issue the
STARTUP MOUNT
command to mount the database.
3.
Issue the
ALTER DATABASE OPEN
command.
4.
Issue the
ALTER DATABASE OPEN RESETLOGS
command.
5.
Recover the database using the
RECOVER DATABASE
command.
6.
Recover the data files with the
RECOVER DATAFILE
command.
7.
Take the data files offline.
Which is the correct order of these steps in this case?
A.
1,2,5,3
B.
2,5,4
C.
1,2,4,3
D.
4,7, 3, 6
E.
1,2,4,6
16.
You have lost all your online redo logs. As a result, your database has crashed. You
have tried to restart the database and clear the online redo log files, but when you try
to open the database you get the following error:
SQL> startup
ORACLE instance started.
Total System Global Area 167395328 bytes
Fixed Size 1298612 bytes
Variable Size 142610252 bytes
Database Buffers 20971520 bytes
Redo Buffers 2514944 bytes
Database mounted.
ORA-00313: open failed for members of log group 2 of thread 1
Search WWH ::
Custom Search