Home » RDBMS Server » Backup & Recovery » Database duplicate Finished but redo log files not created
Database duplicate Finished but redo log files not created [message #243127] Wed, 06 June 2007 03:11 Go to next message
LaFilipina
Messages: 46
Registered: May 2007
Location: spain
Member
Hi All,

After I am done with duplicating one of our prod db to a dev db using rman, I got this warning:

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/tmdev01/oradata/tmdev/system_00.dbf'
released channel: t1
released channel: t2
released channel: t3
released channel: t4
released channel: t5
released channel: t6
released channel: t7
released channel: t8
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/05/2007 11:16:10
RMAN-03015: error occurred in stored script Memory Script
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 27056 lowscn 3013029320 found to restore
RMAN-06025: no backup of log thread 1 seq 27055 lowscn 3013026702 found to restore


I tried to run alter database open resetlog but here's what is telling me:

ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/tmdev01/oradata/tmdev/system_00.dbf'


I tried doing a recover on the database but discovered that there were no redo log files created even if I have explicitly included that in my duplicate script.. here's the part of the script were redo log files are indicated:

duplicate target database to tmdev
logfile
group 1 ('/u02/oradata/SID/redo01a.log',
'/u01/oradata/SID/redo01b.log') size 5M,
group 2 ('/u02/oradata/SID/redo02a.log',
'/u01/oradata/SID/redo02b.log') size 5M,
group 3 ('/u02/oradata/SID/redo03a.log',
'/u01/oradata/SID/redo03b.log') size 5M;


Any thoughts on this? I am thinking of running the duplicate again, but I want to know what went wrong... why redo log files where not created?

Thanks to all as always!

[Updated on: Wed, 06 June 2007 03:13]

Report message to a moderator

Re: Database duplicate Finished but redo log files not created [message #243246 is a reply to message #243127] Wed, 06 June 2007 10:42 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Quote:
group 1 ('/u02/oradata/SID/redo01a.log',
'/u01/oradata/SID/redo01b.log') size 5M,
group 2 ('/u02/oradata/SID/redo02a.log',
'/u01/oradata/SID/redo02b.log') size 5M,
group 3 ('/u02/oradata/SID/redo03a.log',
'/u01/oradata/SID/redo03b.log') size 5M;


The size of redologs are same on both???

or use reuse clause
Re: Database duplicate Finished but redo log files not created [message #243345 is a reply to message #243127] Thu, 07 June 2007 00:29 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hi,


Did you specified in init.ora the following parameter's

db_file_name_convert and log_file_name_convert

Babu
Previous Topic: RMAN-10035 while doing database duplicate
Next Topic: Host...
Goto Forum:
  


Current Time: Sat Dec 03 18:18:34 CST 2016

Total time taken to generate the page: 0.15922 seconds