Redo logs applying on Oracle

[Former Member]

Hi,

I have taken a main Production database backup using Brtools and restored on SAP Disaster recover server. Then I tried to apply the logs. It applied around 30 logs. After that it asked for a different sequence of logs to get applied which is not available in the source location. Then I created the control file by copying from main production to the DR. Then I tried to apply logs in a mount state. When I fire 'recover database using backup controlfile; it gives me the following error:

ORA-00283: recovery session canceled due to errors

ORA-19909: datafile 1 belongs to an orphan incarnation

ORA-01110: data file 1: '/oracle/TAP/sapdata1/system_1/system.data1'

Can someone help me to resolve as i need to bring the DR in sysnc with main Production.

regards,

raj

[Former Member · Accepted solution]

Hi,

It seems that you restored the system.data1 file from a database where a "open resetlogs" was performed.

Please check SAP Note 941517 - Recovery over resetlogs operation

Also have a look at below thread.

Please check your alert log file for details of error.

Hope this helps.

Thanks,

Sushil

[Former Member · Accepted solution]

Hi,

I have restored the fresh database online backup on SAP DR. I tried applying the logs. The sequence of log files are as follows.

TAParch1_11456_662340033.dbf

TAParch1_11457_662340033.dbf

TAParch1_11458_662340033.dbf

TAParch1_11459_662340033.dbf

TAParch1_11460_662340033.dbf

After applying the above logs, it asks to apply the below changed sequence of log files wherein this log is not existing at source location at all. So it stopped in this place. I couldn't find this log anywhere.

TAParch1_2_680809446.dbf

please help.

regards,

Raj

[Former Member · Accepted solution]

Hi Raj,

Can you check whether the file "TAParch1_2_680809446.dbf" is present in orarach directory or in that anyother directory is there please rename/move it some other folder and then try to apply logs again.

Hope it works

regards

Punit Maini

[former_member603052 · Accepted solution]

Hi Raj,

> I have restored the fresh database online backup on SAP DR. I tried applying the logs. The sequence of log files are as follows.

> TAParch1_11456_662340033.dbf

> TAParch1_11457_662340033.dbf

> TAParch1_11458_662340033.dbf

> TAParch1_11459_662340033.dbf

> TAParch1_11460_662340033.dbf

I think at this point you opened the database with open resetlogs and so the log sequence number starts newly from 0,1,2 and so on.Now when you are trying to recover its asking for archive log 2 which is not yet generated.

> After applying the above logs, it asks to apply the below changed sequence of log files wherein this log is not existing at source location at all. So it stopped in this place. I couldn't find this log anywhere.

>

> TAParch1_2_680809446.dbf

Run this command in the new system which you are restoring and see the sequence numbers.

SQL>select sequence# from V$log;

Regards,

Kalyan

[Former Member · Accepted solution]

Hi Kalyan,

Yes. Exactly what you say is right. I think I got the DB opened and it changed the log sequence.

Can I try to take one more fresh online backup & try restoring it.

regards,

raj

[former_member603052 · Accepted solution]

Hi Raj,

Yes you can try again with fresh backup and restore it but if you open the database you cannot apply the logs of the source system in the target system.

If you want to apply the logs continuously, the system should be in mount state and try recovering all archive logs.

Best Wishes

Regards,

Kalyan

[Former Member · Accepted solution]

Raj,

Please go through the attached thread. You may find it useful.

[]

Hope this helps.

Manoj

[Former Member]

Hi Raj,

Just follow the above steps i mentioned earlier, That should be easiest way.

And as told by you, do not make a controlfile using trc. Because that should be a open controlfile.

Just create a standby controlfile from source system(in my earlier reply) and restore the same in controlfile locations.

All steps are mentioned above.

Let us know if any issue, and then we can suggest.

Regards

Nick Loy

[former_member603052]

Hi Raj,

> . Then I tried to apply the logs. It applied around 30 logs.

As per my knowledge, the logs are applied means the DR site is already having a control file which is being used and when the last log is applied it asks for another log which doesnt exist in source means recovery is finished.

>After that it asked for a different sequence of logs to get applied which is not available in the source location.

Then you need to stop recovery using command RECOVER CANCEL

> Then I created the control file by copying from main production to the DR.

You need to create control file only when the file structure of source system and target system were different.

Along with backup,the control files are backed up and i think you restored correctly else 30 logs will not be applied.At this point you no need to create another control file.

Regards,

Kalyan

[Former Member]

Hi Raj,

Before proceding "recover database using backup controlfile;" .please check your sapdata's and datafiles permission.it should be 755 and ownership as ora<sid>:dba.

please use below command

"recover automatic database until cancel using backup controlfile;"

monitor alert log file.

Regards,

Krishna reddy

[Former Member]

Hi,

Please try by restore & recovery using BRTOOLS(Point in time recovery). It will take care of all redo log files needed automatically.

http://help.sap.com/erp2005_ehp_04/helpdata/EN/93/4ffb72309fb04e80ebfefae1b7a96f/frameset.htm

Hope it helps.

Thanks,

Sushil

[Former Member]

Hi Raj,

I think you are restoring the database on DR.

Then database should be in standby mode. Here you need to follow below steps to apply next archive logs.

1) Restore full database

2) Copy one standby controlfile from source database to target database(HERE FROM PRO TO DR) using below command

sqlplus>>alter database create controlfile as '/tmp/standby.ctl';

3) Mount your database using below commands

sqlplus>>>startup nomount

sqlplus>>>alter database mount standby database;

4) Apply redologs using below command

sqlplus>>>recover standby database;

It will prompt you the next log sequence to by synced. Place the sequence starts from in your archive directory, then recover will start automatically.

Regards

Nick Loy

sqlplus>>>>>

[Former Member]

Raj,

I would like to suggest use of BRTOOLS (option 5 restore and recovery) for the complete recovery. You can use point-in-time recovery for the same.

I did this last week and worked fine for me.

Note: you can use time, SCN, LSN for the recovery.

Hope this helps.

Manoj Chintawar

[Former Member]

Hi Raj,

It seems like some one altered data base with reset logs option. That is the reason your system has changed the log sequence starting from 0.

Make sure with which commands you are recovering your database. There is some issues.

In this situation i will recommend to restore entire database again and try to apply logs.

Mean while send us the recovery steps you are using.

Regards

Nick Loy

[Former Member]

Hi ,

In fact, I had restored for the 2nd time. First time, when I restored, I created the control file & applied the logs. Then I had tried opening the database using open reset logs. Since, then i was not able to apply logs. Then again Now I had restored for the 2nd time. I am trying to apply the logs using the following command:

'recover using database backup controlfile;'

It asks for the different sequence of log. Should I need to create any control files? I tried with that too. It doesn't help. Is there any solution that I can continue applying logs with going for the another restoration?

regards,

raj

[Former Member]

Hi,

It seems like the issue not getting resolved. Finally, I am going to take a fresh database backup and try restoring it and start applying logs. Steps i am going to follow is :

1)Take a online backup of main production database using brtools. I will schedule it via DB13 as option as 'Full database online backup+redo logs'

2)Then I will shutdown the standy database DB and restore the database. Then I will create a control file using a tracefile and then start applying the logs using the command 'Recover database using backup controlfile;

Hope the above procedure will resolve my issues.

regards,

raj

[Former Member]

Hi,

Can you give time as backup completion time below command & try.

database using backup controlfile until time '2009-03-10:10:00:00'

Also check you archSID.log file whether all offline redo logs entry is thr or not?

Thanks,

Sushil