A database is running in ARCHIVELOG mode and regular backups are performed. A user
receives the following
Error message:
Which is the recommended sequence of operations you need to perform for the query successfully?
A.
Drop the affected tablespace, re-create the tablespace, restore the datafiles, and the
tablespace.
B.
Take the affected datafile offline (if not already offline), restore the damaged image of the
datafile, and then bring it online.
C.
Restart the database in MOUNT mode, restore the damaged datafile, recover the datafile
and then open the database with resetlogs.
D.
Put the database in RESTRICTED mode, restore all the datafiles in the affected datafile
and recover the tablespace, and then put the database in normal operational mode.
Explanation:
It supposed to none of answer is correct.
I think B is correct
+1
None of these answers are correct.
Here we have a corrupted non critical datafile.
Standard practice it to
1. Take the damaged datafile offline.
2. Restore the datafile.
3. Recover the datafile.
4. Bring the datafile online.
None of the answers above actually does this.
Therefore the “explanation given” (ses above) is correct (although it is in very bad english)
I suggest another question instead …
A user sends you an email with the following error message:
CREATE TABLE idtable(id number)
*
ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: ‘/oracle01/oradata/orcl/users01.dbf’
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
You can choose from the following steps:
a. Restore the missing database datafiles.
b. Take the missing datafile offline.
c. Shut down the database.
d. Issue the recover tablespace USERS command.
e. Issue the STARTUP MOUNT command to mount the database.
f. Bring the USERS tablespace online.
g. Issue the ALTER DATABASE OPEN command.
Which is the correct order of these steps in this case?
A. b, a, d, f
B. c, a, e, b, d, f, g
C. c, e, d, g
D. b, d, f
E. e, d, g
Answer A is correct.
You would first take the missing datafile offline with
ALTER DATABASE DATAFILE 4 offline
then restore the datafiles that have been lost.
Then issue
recover tablespace USERS
to recover the USERS tablespace. Use the
ALTER DATABASE DATAFILE 4 online
command to bring the USERS tablespace online.
B is not good cause it doesnt mention recovering.
C is ok answer if u are unable to offline the datafile .