on 03-10-2009 6:14 AM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>>>>>
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
95 | |
11 | |
11 | |
10 | |
9 | |
8 | |
6 | |
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.