on 06-02-2011 9:00 AM
Hi all!
I need to restore oracle db to other directory of another sap system (instance).
I successfully restored control files & datafiles into other directory but oracle not starting.
Probably because there is no necessary online archive redologs.
How can i restore necessary online redologs into different directory and apply them?
Thanks for help
Hi Andrey,
Did you take your backup with brbackup? Is it online or offline backup?
Best regards,
Orkun Gedik
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No, i dont planing change sid and hostname. That system which restore are ready. I want restore my backup from tape with brbackup into other system.
My syntax to restore datafiles : brrestore -m /oracle/SID/sapdata1/sr3700_1/sr3700.data1=zone/root/oracle/otherSID/sapdata1/sr3700_1/
Control file: brrestore -m 0=/zone/root/oracle/otherSID/sapdata1/cntrl/
Edited by: Andrey Burakov on Jun 2, 2011 12:45 PM
Edited by: Andrey Burakov on Jun 2, 2011 12:59 PM
Hi Andrey,
You are correct that you don't need existing online redolog files while opening the database. They will be created, automatically.
In order to be safe side, follow the procedure, below;
1) Create control.sql by executing the command at the productive system, below;
alter database backup controlfile to trace resetlogs;
2) Goto "/oracle/<SID>/saptrace/usertrace" and open newly created trace file,
3) Copy lines between "STARTUP NOMOUNT" and "-- Commands to re-create incarnation table" strings. Please note that these strings will not be included, just between of them
4) Create a control.sql file by ora<sid> user and paste the SQL statement, at the 3rd step
5) Now, you can change all the paths, regarding your needs in the file
6) Now that you have a control.sql file, then you can create the control files,
7) Delete all control files on the database. They have been determined in the SPFILE or init<SID>.ora file.
😎 On ora<sid> user
a) sqlplus u201C/as sysdbau201D
b) startup nomount
c) @<path>\control.sql
d) shutdown
9) Now apply the online redolog files;
a) startup mount
b) recover database using backup controlfile until cancel;
c) alter database open resetlogs;
d) shutdown
e) startup
f) exit
After you apply the steps respectively, the database should be started successfully.
Best regards,
Orkun Gedik
I have some troubles. Maybe /oracle/TSM/sapdata1/system_1/system.data1' really unconssistent?
But i recovered datafiles from tape....
SQL> @/oracle/TSM/saptrace/usertrace/control.sql
Control file created.
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Database mounted.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 113646088 generated at 05/27/2011 18:04:28 needed for thread
1
ORA-00289: suggestion : /oracle/TSM/oraarch/TSMarch1_3817_598559720.dbf
ORA-00280: change 113646088 for thread 1 is in sequence #3817
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00308: cannot open archived log
'/oracle/TSM/oraarch/TSMarch1_3817_598559720.dbf'
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/TSM/sapdata1/system_1/system.data1'
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/TSM/sapdata1/system_1/system.data1'
SQL> shutdown
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
Edited by: Andrey Burakov on Jun 2, 2011 5:04 PM
Edited by: Andrey Burakov on Jun 2, 2011 5:05 PM
Hi Andrey,
Did you copied "TSMarch1_3817_598559720.dbf" under "/oracle/TSM/oraarch" and give required permission to the file? Please note that this file may not be good enough to open the database. You may need to import more offline redolog files in order to be able to open the database. So you can find the minimum required sequence number at the end of the backup logfile
Second way to open the database is, importing redolog files by sequence and execute Steps 9 b-c for each imported offline redolog file. When see "database altered" message after you execute step (9 c), you will be able to open the database, successfully.
Best regards,
Orkun Gedik
Dear sir
'
I am facing same problem while recovering datafile,
SQL> RECOVER DATAFILE 'D:\ORACLE\DEJ\SAPDATA2\UNDO_1\UNDO.DATA1';
ORA-00279: change 12126866 generated at 04/02/2011 09:30:41 needed for thread 1
ORA-00289: suggestion : D:\ORACLE\DEJ\ORAARCH\DEJARCHARC00018_0745865994.001
ORA-00280: change 12126866 for thread 1 is in sequence #18
its asking oraarch file but we have deleted that file without taking backup of \DEJARCHARC00018_0745865994.001 file
what to do ?
can you please give me the solution
regards
krishna
Online backup restore needs redologs to open the database.
Suggest you to read and follow the standard system copy guide for more info.
Regards,
Nick Loy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.