on 10-24-2011 8:03 AM
Dear All,
I have faceing issue to apply archive log in DR server after restore Production server offline backup.
Following is error :
SQL> startup
ORACLE instance started.
Total System Global Area 1526726656 bytes
Fixed Size 2029112 bytes
Variable Size 771754440 bytes
Database Buffers 738197504 bytes
Redo Buffers 14745600 bytes
Database mounted.
Database opened.
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: '/oracle/P01/sapdata1/system_1/system.data1'
Pls. guide me
Thanks in advance,
Regards,
Sweetdiya
Hi,
As i can see that you have opened your DR server and after that you are trying to perform recovery. This is wrong.
Correct method is restore your production db on your DR server and once restore finished then perform the recovery without opening the database.
You need to again restore db and then perform the recovery.
Thanks
Sunny
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Sunny,
I have restore DB and try to apply next arcive log as per bellow:
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-01034: ORACLE not available
SQL> startup;
ORACLE instance started.
Total System Global Area 1526726656 bytes
Fixed Size 2029112 bytes
Variable Size 771754440 bytes
Database Buffers 738197504 bytes
Redo Buffers 14745600 bytes
Database mounted.
Database opened.
SQL>recover database until cancel using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-00600: internal error code, arguments: [2141], [1475563215], [1478279742],
then i have restart server and Try to apply log as per bellow :
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00283: recovery session canceled due to errors
ORA-01124: cannot recover data file 1 - file is in use or recovery
ORA-01110: data file 1: '/oracle/P01/sapdata1/system_1/system.data1'
can you tell me how can i resolve this .
Pls.
Thanks & Regards,
Sweetdiya
> SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
> ORA-01034: ORACLE not available
> SQL> startup;
> ORACLE instance started.
>
> Total System Global Area 1526726656 bytes
> Fixed Size 2029112 bytes
> Variable Size 771754440 bytes
> Database Buffers 738197504 bytes
> Redo Buffers 14745600 bytes
> Database mounted.
> Database opened.
>
> SQL>recover database until cancel using backup controlfile;
> ORA-00283: recovery session canceled due to errors
> ORA-00600: internal error code, arguments: [2141], [1475563215], [1478279742],
Hello,
Do not execute 'startup' i.e. do not 'open' the database before applying the redo-logs.
Start the database in 'nomount' state.
Please execute -
sql> startup nomount
Thanks
Hi,
If after restore you give startup command, then database will not start it will ask you to perform recovery but in your case database is getting open after restore it means someone has cancelled recovery. You need to restore it again and start the db in nomount state and then perform recovery.
Thanks
Sunny
Dear All,
Thanks for reply...and guide me my previous issue is resolve and i am on next step but i have fece bellow issue:-
SQL> RECOVER DATABASE UNTIL CANCEL USING BACKUP CONTROLFILE;
ORA-00279: change 216416820 generated at 10/24/2011 13:33:13 needed for thread
1
ORA-00289: suggestion : /oracle/P01/oraarch/P01arch1_22220_679453534.dbf
ORA-00280: change 216416820 for thread 1 is in sequence #22220
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
AUTO
ORA-00328: archived log ends at change 216396573, need later change 216416820
ORA-00334: archived log: '/oracle/P01/oraarch/P01arch1_22220_679453534.dbf'
SQL>
I have copy all concern log from PRDn server,
Pls. guide me to move forward
Thanks once again ,
Regards,
Sweetdiya
Hello Sweetdiya,
From Oracle the '/oracle/P01/sapdata1/system_1/system.data1' is either still online and the database is open in some instance, or another process is currently doing a media recovery on this file. If you run the following statement
SQL>select name,status from v$datafile;
Then check the status of the system datafile.
If the database is open, you need to issue a shutdown
SQL> shutdown;
let the database shutdown normally, then try to restore the datafile from a consistent backup.
SQL>startup mount
SQL>recover datafile ' '/oracle/P01/sapdata1/system_1/system.data1';
I hope this helps you.
Regards,
Blanca
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
13 | |
13 | |
11 | |
11 | |
7 | |
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.