cancel
Showing results for 
Search instead for 
Did you mean: 

restore and apply online redologs into different directory

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Andrey,

Did you take your backup with brbackup? Is it online or offline backup?

Best regards,

Orkun Gedik

Former Member
0 Kudos

Hi Orkun.

I perform my backup with brbackup. it's online backup

Former Member
0 Kudos

Hi Andrey,

Ok. It means that you have datafiles and offline redolog files in your backup set. So, are planning to you change host and/or SID of the database?

Best regards,

Orkun Gedik

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

many thanks! Orkun, i try perform this steps...

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

Thank you Orkun and Nick !

Edited by: Andrey Burakov on Jun 7, 2011 7:25 AM