OraFAQ Forum: Backup & Recovery » cloning file needs more recovery to be consistent

Home » RDBMS Server » Backup & Recovery » cloning file needs more recovery to be consistent

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

cloning file needs more recovery to be consistent [message #228542]

Tue, 03 April 2007 05:58

laksha
Messages: 42
Registered: June 2006

Member

Hi,
I clone a "production" database to "test" database using the cold backup of production database.

I create the controlfile using
CREATE CONTROLFILE SET DATABASE "TEST" RESETLOGS NOARCHIVELOG
......
startup nomount;

when i do a
alter database open resetlogs;
i get the error
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/test_db1/test/db/testdata/system01.dbf'

then I need to do
recover database using backup controlfile;
and apply the online redo log files for recovery and recover the database.

when i clone from a cold backup why do i need to recover database using online redo log files? how do i overcome this.

My understanding is that when one takes the cold backup by using shutdown immediate, all the information from online redo log files is flushed to the datafiles, and thus there is no need for online redo log files from cold backup .

Thanks in advance.

Report message to a moderator

Re: cloning file needs more recovery to be consistent [message #228553 is a reply to message #228542]

Tue, 03 April 2007 06:15

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

This issue always pops up when the database was NOT SHUTDOWN cleanly. I would always try with SHUTDOWN NORMAL.
If you were impatient for SHUTDOWN NORMAL, go for IMMEDIATE or even ABORT.
But immediately do a STARTUP RESTRICT followed by a SHUTDOWN NORMAL
(Now all your information is flushed).

[Updated on: Tue, 03 April 2007 06:15]

Report message to a moderator

Re: cloning file needs more recovery to be consistent [message #228554 is a reply to message #228542]

Tue, 03 April 2007 06:15

ebrian
Messages: 2794
Registered: April 2006

Senior Member

Without insight into all the steps you've completed, you may want to refer to this article.

Report message to a moderator

Previous Topic:	Primary and Standby 10g
Next Topic:	Use form to database backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Nov 23 04:41:56 CST 2024