Recover Database from Online backup with no redo logs files. [message #54783] |
Wed, 04 December 2002 15:59 |
sticky
Messages: 3 Registered: December 2002
|
Junior Member |
|
|
My 9i database is in ARCHIVELOG MODE, I have all the datafiles, the control files, a backup control file, and the archive log files. I DO NOT however have any of the redo log files. Is it possible to open or recover this database without the redo log files?
|
|
|
|
Re: Recover Database from Online backup with no redo logs files. [message #54796 is a reply to message #54794] |
Thu, 05 December 2002 08:57 |
sticky
Messages: 3 Registered: December 2002
|
Junior Member |
|
|
Great! Thanks, but could you possibly tell me the commands. If I mount it and then issue the recover command I get the following error.
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
So I try this next, and still an error.
SQL> recover using backup controlfile;
ORA-00279: change 65132 generated at 12/05/2000 10:33:44 needed for thread 1
ORA-00289: suggestion : /oracle/archive/1_9.dbf
ORA-00280: change 65132 for thread 1 is in sequence #9
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log '/oracle/archive/1_9.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
Its looking for the 1_9.dbf archive log file. The problem is there is no file by that name. before the online backup there was a 1_7.dbf file, then after the online backup the "archive log current" command switched to the next log file. 1_8.dbf. The database was then shut down and the redo logs were removed.
Any idea how to open with out this 1_9.dbf file?
|
|
|
Re: Recover Database from Online backup with no redo logs files. [message #54798 is a reply to message #54794] |
Thu, 05 December 2002 09:32 |
sticky
Messages: 3 Registered: December 2002
|
Junior Member |
|
|
What if you have all the files (dbf's, control, etc.) but you do NOT have the REDO or the Archive log files.
Is it possible to open the database?
Example: I have a 1TB database. All the data files and control files are intact. The database was shutdown properly. The drives containing the redo logs and archive logs are destroyed. How do I bring the database back up... =(
|
|
|
|