-
Hi,
I was trying to simulate a recovery environment. I took the cold backup of all the files(control,log,data,etc..). I have deleted the original files (log,data) and have restored from backup. I am trying to recover the database, by issuing the following
1) svrmgr> startup mount;
2) svrmgr>alter database recover using backup controlfile.
(THis statement was issued after copying all the backup files to the main directory indivisually)
statement processed.
3) However,while opening database, it say
ora-01589: must use resetlogs or noresetlogs option for database open;
4) alter database open resetlogs;
*ora -01113:file 1 needs media recovery
ora-1110 : data file 1: 'D:\...\sys1orcl.ora'
How can I bring up by database.
Badrinath
-
You are doing everything correct but the last statement. When you are using Recover database using backup controlfile. You must use Resetlogs option. Try applying this you should be OK.
-
svrmgrl> startup mount
svrmgrl> alter database recover until cancel using backup controlfile;
svrmgrl> alter database recover continue default;
svrmgrl> alter database recover continue default;
(This process continues until you have applied all your archived redo logs)
svrmgrl> alter database recover cancel;
svrmgrl> alter database open resetlogs;
[Edited by marist89 on 01-17-2001 at 01:18 PM]
-
If you're restoring from a cold backup, you shouldn't need to recover from anything, since everything is from a single point in time and is all synchronized as far as SCN's and data are concerned.
If you're recovering a hot backup which requires applying archived redo logs, then you need to follow the steps outlined already by the others.
If the log files from your cold backup need media recovery, just
> startup mount
> alter database recover until cancel;
> alter database recover cancel; // might say recovery hasn't started
> alter database open resetlogs;
-
I would like to bring to your notice that, after the cold backup and before the actual deletion of the datafiles and log files, some transactions have happened like insertions/delete/drop tables.
The database is in archive log mode. All the archive files are intact.
while trying to follow the steps of Mr.pwoneil
I get the following
svrmgr>startup mount
statement processed
svrmgr>alter database recover until cancel;
I GET: ORA-00275: media recovery has already been started.
I then issued
svrmgr> alter database recover cancel
I GET: ORA-00279:change 14072 generated at 01/17/01 12:45:26 needed for thread 1
ORA-00289: suggestion :D:\orant\d...\archive\orclorcls.arc
ORA-00280: change 14072 for thread 1 is in sequence #1
Because, the archiving was on, does it mean I cannot make the recovery from cold backup; At this stage
How dow i make cold backup restoration(I know I will lose data)
-
You said cold backup first, and didn't mention archived log mode or archive logs, so my steps were for a cold backup since nothing should have been modified.
You should be able to recover by applying the logs after restoring the cold backup. Follow the suggestions of marist89 to apply all of the archived logs.
-
Just use the Archive logfile/s from the suggestions given by oracle and you should be able to open the database
-
Oh, it's possible for you to lose data if you restore your cold backup and overwrite your online redo logs. If any redo information was contained in your online logs before they were archived, and you either lost, or overwrote the files you won't be able to recover that data.
To protect that you should have mirrored redo logs.
-
Hi, I am trying to follow these command for cold backup recovery
svrmgrl> startup mount
statement processed
svrmgrl> alter database recover until cancel using backup controlfile;
ORA-00279: change 14072 generated at 01/17/01 12:45 needed for thread 1
ORA-00289: suggestion : D"\ORNT\DATABASE\ARCHIVE\ORCLORCLS.arc
ORA-00280: change 14072 for thread 1 is in sequence #1
svrmgrl> alter database recover continue default;
ORA-00310; archived log contains sequence 7;sequence 1 required
ORA-00334:archived log:'D:\orant\database\archive\orclorcls.arc';
svrmgrl> alter database recover cancel;
ORA-01547:warning:RECOVER succeded but OPEN RESETLOGS would get error below
ORA-01152:file 1 was not restored from a sufficiently old backup
ORA-01110:data file 1: 'D:\ORANT\DATABASE\SYS1ORCL.ora'
svrmgrl> alter database open resetlogs;
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110:datafile 1:'D:\orant\database\sys10RCL.ora'
The database still does not come up. Please help me.
Badrinath
-
Ok. Just to open the database (without regarding data loss) from a cold backup, all you have to do (provided your cold backup contains all datafiles, control files, and log files), is to restore all the files from your cold backup, then you should be able to "startup" from svrmgrl. No need to worry about database recovery.
Test that to see if it works. If it doesn't, do you have all of your datafiles, control files, and log files in the backup? Was it taken while the database was closed?
Once that opens, shut it down, and restore the cold backup again. Now you can try to get back data that was commited after the cold backup was taken.
Restore all the files from the cold backup
svrmgrl> startup mount
svrmgrl> alter database recover until cancel using backup controlfile;
-- here it should start prompting for archived logs
svrmgrl> alter database recover continue default;
-- repeat that until there are no more suggestions, or when you apply it it says "no such file or directory"
svrmgrl> alter database recover cancel;
svrmgrl> alter database open resetlogs;
The second method assumes you have the archived logs from the database. However it looks like you might not have all of the archived logs available, or they are corrupted.
00310, 00000, "archived log contains sequence %s; sequence %s required"
// *Cause: The archived log is out of sequence, probably because it
// is corrupted or the wrong redo log filename was specified
-
Cold backup restoration (if you willing to lose data after the backup) --
Restore all the datafiles, Control files, Redolog files (though you may not need the redo logs because with cold backup your database already may have applied all the transactions if there was no rollback at shutdown)
Then --
svrmgrl> startup mount
svrmgrl> alter database open
(this should open the database though you will lose data after the cold backup.
If you need the data after the backup (becasue you are in archive log mode) you should try the following method --
Assuming you have a copy of the latest control file (if you had multiplexed your control files and didn't delete all of them), use that Control file for Mounting the database (this control file has the latest SCN not the restored control file)
svrmgrl> startup mount
svrmgrl> alter database recover // this should automatically get the available archived logs and apply those.
svrmgrl> alter database open
Only problem may arise, if you don't have that copy of the control file then you will need the backup controlfile (if you had created one)
- Rajeev
