What would be the appropriate order of operations to correct the situation?

You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf)
and the database has crashed.
What would be the appropriate order of operations to correct the situation?

You have lost all your SYSTEM tablespace datafiles (system_01.dbf and system_02.dbf)
and the database has crashed.
What would be the appropriate order of operations to correct the situation?

A.
Mount the database with the startup mount command.
a, c, f, g

B.
Take the SYSTEM data file offline with the alter database command.
b, d, e, h

C.
Restore the SYSTEM_01.dbf data file from backup media with the required archived redo
logs.
a, b, c, f, g

D.
Restore all SYSTEM tablespace–related datafiles from backup media.
d, a, e, g

E.
Issue the recover tablespace SYSTEM command.
b, c, f, e, g

F.
Issue the recover data file SYSTEM_01.dbf command.

G.
Open the database with the alter database open command.

H.
Open the database with the alter database open RESETLOGS command.

A.
Mount the database with the startup mount command.
a, c, f, g

B.
Take the SYSTEM data file offline with the alter database command.
b, d, e, h

C.
Restore the SYSTEM_01.dbf data file from backup media with the required archived redo
logs.
a, b, c, f, g

D.
Restore all SYSTEM tablespace–related datafiles from backup media.
d, a, e, g

E.
Issue the recover tablespace SYSTEM command.
b, c, f, e, g

Explanation:
Because there is NO controlfile damaged, and there is NO PITR recover, you don’t need to
use RESETLOGS option.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


noe

noe

A.Mount the database with the startup mount command.

B. Take the SYSTEM data file offline with the alter database command.

C.Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.

D. Restore all SYSTEM tablespace–related datafiles from backup media.

E. Issue the recover tablespace SYSTEM command.

F. Issue the recover data file SYSTEM_01.dbf command.

G. Open the database with the alter database open command.

H. Open the database with the alter database open RESETLOGS command.

A.
a, c, f, g

B.
b, d, e, h

C.
a, b, c, f, g

D.
d, a, e, g

E.
b, c, f, e, g

DD

DD

the correct answer: a,d,e,g

Eamon

Eamon

actually steps a and d can be interchanged.