41.
Your database has experienced a loss of datafile users_01.dbf, which is associated with a
tablespace called USERS. The database is still running. Which answer properly describes the
order of the steps that you would use to recover from this error?x
a. Shut down the database.
b. Take the users_01.dbf datafile offline with the alter database command.
c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all users tablespace-related datafiles from backup media.
e. Issue the recover tablespace users command.
f. Issue the recover datafile users_01.dbf command.
g. Start up the database.
h. Bring the users_01.dbf datafile online with the alter database command.
b. Take the users_01.dbf datafile offline with the alter database command.
c. Restore the users_01.dbf datafile from backup media with the required archived redo logs.
d. Restore all users tablespace-related datafiles from backup media.
e. Issue the recover tablespace users command.
f. Issue the recover datafile users_01.dbf command.
g. Start up the database.
h. Bring the users_01.dbf datafile online with the alter database command.
- A.a, c, f, g
- B.b, c, f, h
- C.a, b, c, f, g
- D.a, b, c, f, g, h
- E.b, c, f, e, g
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| First you would take the users_01.dbf datafile offline. You would then restore the users_01.dbf datafile from the most current backup. Once you have restored the datafile, recover the datafile with the recover datafile command. Finally, bring the datafile online with the alter database command. |
42.
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.
- 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. |
43.
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.
b. Take the SYSTEM datafile offline with the alter database command.
c. Restore the SYSTEM_01.dbf datafile 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 datafile 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.
b. Take the SYSTEM datafile offline with the alter database command.
c. Restore the SYSTEM_01.dbf datafile 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 datafile 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
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| First you would restore the missing datafiles. Notice in the question that there are two datafiles 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 open the database with the alter database open command. |
44.
You have discovered that one of three control files has been lost. What steps would you follow
to recover that control file?
a. Shut down the database.
b. Restore a control-file copy from backup media.
c. Use the create control file command to create a new control file.
d. Copy the backup control file into place.
e. Create a new copy of the control file from one of the surviving control files.
f. Recover the database using the recover database using backup controlfile command.
g. Start up the database.
b. Restore a control-file copy from backup media.
c. Use the create control file command to create a new control file.
d. Copy the backup control file into place.
e. Create a new copy of the control file from one of the surviving control files.
f. Recover the database using the recover database using backup controlfile command.
g. Start up the database.
- A.a, b, f, g
- B.c, f, g
- C.a, d, f, g
- D.a, f, g
- E.a, e, g
- 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 control-file copies for the control files that were lost. Then restart the database. No recovery is required in this situation. |
45.
Which files will you need to perform a full recovery of a database backed up in
NOARCHIVELOG mode? (Choose all that apply.)
- A.Database datafiles
- 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 the database datafiles, the control files, and the online redo logs all in place to be able to restore the database when it's in NOARCHIVELOG mode. |
|
|
||||||||||||||||||||||||||||
