on 06-21-2016 5:34 PM
Hello Experts,
We are running on Oracle 11 and planning for a restore and recovery from PRD to QAS
We had a successful online backup in our PRD system and Archive logs are also available.
However, as a pre-requisite step we did not generate Control file in PRD before trigger of online backup and proceeded with the Oracle restore in QAS.
We had online backup of PRD which was completed @ 5:00 AM, however we have generated Control file in PRD @ 3 PM post completion of online backup to use it in QAS
Below are the steps we did to restore data in QAS but unsuccessful in Recovery:
We had deleted all the files in QAS
Placed PRD files in QAS and changed the SID respective to QAS.
There are no addition of data files after online backup, so we generated control file in PRD after the completion of online backup and used to recover database using command "Recover database using backup controlfile until cancel;" (Changed contents of control as usual)
However, system is continuously requesting for Archive log files which are not even generated in PRD yet
Below is the error: (initially requested for archive sequence 1111. After giving 1111, it is again asking for 1112)
ORA-00279: change 504756556 generated at 06/21/2016 22:05:47 needed for thread 1
ORA-00289: suggestion : /oracle/QAS/oraarch/QASarch1_1112_857256673.dbf
ORA-00280: change 504756556 for thread 1 is in sequence #1112
ORA-00278: log file '/oracle/QAS/oraarch/QASarch1_1111_857256673.dbf' no longer
needed for this recovery
ORA-00308: cannot open archived log
'/oracle/QAS/oraarch/QASarch1_1112_857256673.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
Could you please assist on how to proceed further?
Thanks,
Subbu
Hi, if the archive logs don't exist, issue the command "cancel" then open the database with the resetlogs option: "alter database open resetlogs".
You can also check if the file 1112 wasn't archived yet - issue the following command at the source (PRD) system.
select sequence# from v$log where status= 'CURRENT';
Then you can issue the command "ALTER SYSTEM SWITCH LOGFILE;" and copy the archive logs to QAS system.
Regards,
André Nunes
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Once the recovery session is cancelled due to unavailability of archive log, fire "alter database open resetlogs".
It will alter your database and opens it in read/write mode for use.
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,
If you have the file 1112, then you have to copy the file to the proper location and issue the recover command. If there are no more logfiles, it is time for you to open the database with the "alter database open resetlogs" command. But remember, once you opened the database, you will not be able to re-start the recovery.
thanks
Samson
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 | |
24 | |
11 | |
9 | |
7 | |
5 | |
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.