You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact. Which of the following is true regarding your recovery?()
You lost the index tablespace in your database. You decided to re-create the index tablespace and the indexes in the tablespace. What methods can you use to re-create the indexes?()
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 control file command. g. Start up the database.
Tom()since he lost his job three weeks ago.
You lost the PRODSTD tablespace, which was read/write. The tablespace was read/x7fonly when the last backup was performed. How would you recover the tablespace?()
You have lost all members of your current redo log file group. You issue this query: SQL> select * from v$log; GROUP# SEQ# BYTES ARC STATUS FIRST_NAME 1 60 153600 NO INACTIVE 01-03-09:19:34 2 61 153600 NO CURRENT 01-03-09:19:50 You then perform an incomplete recover. You receive this message: ORA-00279: change 309141...03/09/01 19:50:14 Needed for thread 1 ORA-00289: suggestion : /disk1/archive/arch_61.rdo ORA-00280: change 309043 for thread 1 is in sequence #61 Specify log: {=suggested | filename | AUTO | CANCEL} How should you respond to this message?()
What methods are available to recover lost control files?()
It is not until you have lost your health()you know its value.
One of the redo log members in your database is lost. You queried V$logfile for further details. What would be the member’s status?()
All the team members tried their best. We lost the game,()