ORA-264

tbotev
tbotev used Ask the Experts™
on
I have a cold backup of the control and database files. I have some newer archived redo log file that I want to apply after restoring the backup.

I restore everything from the backup - control files, database files, redo logs.

Then I try RECOVER command in SQL*Plus I receive:
ORA-264 no recovery required.

Could you please advise a way to apply the archived redo logs?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Recover Database Until Cancel

Will then prompt w/suggested Archive names, either hit enter if correct or type in correct path and enter. When done type cancel.
The suggestion provided by cdion may not work as the database is consistent with the information available in the control_files and the data files. When you have restored, did you make a backup of the previous control file?. If so, copy the original control file ( before the restore) and try recovering the database.

The reason why you cannot apply archive logs is that the scn number in controlfile, redolog and the datafiles is same. This is because of the cold backup.

HTH.

Commented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
Accept rramineni's comment as answer
Please leave any comments here within the next seven days.
 
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!
 
jpkemp
EE Cleanup Volunteer

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial