Hendry's "Oracle and SQL Server DBA Stuff"

Oracle and SQL Server Database Solutions for DBA's please visit http://hendrydba.com for the latest posts. Thanks

ORA-01113: file 1 needs media recovery during open reset logs

Posted by Hendry chinnapparaj on May 16, 2011

Problem

———–

When you’re cloning a database, get the ora error below during open resetlogs

SQL> alter database open resetlogs;

alter database open resetlogs

*

ERROR at line 1:

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: ‘E:\ORADATA\LN3D\SYSTEM01.DBF’

Solution

———

Copy the redolog from the source database where the cold backup was done to the target database redo directory

And then

SQL> recover database using backup controlfile until cancel;

ORA-00279: change 23735596903 generated at 05/16/2011 14:35:45 needed for

thread 1

ORA-00289: suggestion : D:\ORACLE\ORA92\RDBMS\ARC52958.001

ORA-00280: change 23735596903 for thread 1 is in sequence #52958

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

d:\oracle\oradata\ln3d\redo01.log

Log applied.

Media recovery complete.

SQL> alter database open resetlogs;

Database altered.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: