Home » RDBMS Server » Backup & Recovery » Recover Database from Online backup with no redo logs files.
Recover Database from Online backup with no redo logs files. [message #54783] Wed, 04 December 2002 15:59 Go to next message
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 #54794 is a reply to message #54783] Thu, 05 December 2002 03:44 Go to previous messageGo to next message
B
Messages: 327
Registered: August 1999
Senior Member
Yes it is

Simply restore all datafiles and control files ( assume that the archivelog are older then the oldest backuped datafiles and that U have all archivelog )
mount Ur database
recover it
open it with resetlogs
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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... =(
Re: Recover Database from Online backup with no redo logs files. [message #54830 is a reply to message #54783] Mon, 09 December 2002 07:01 Go to previous message
hojjat ghodrati
Messages: 1
Registered: December 2002
Junior Member
hi
i have a question about oracle.7
my question is log2.ora is have error and it cant startup mount please give me some guide about this problem

thanks
hojat ghodrati
Previous Topic: Oracle BackUp
Next Topic: Corrupt block header, no backup, need media recovery
Goto Forum:
  


Current Time: Thu Mar 28 06:10:33 CDT 2024