| Database duplicate Finished but redo log files not created [message #243127] |
Wed, 06 June 2007 03:11  |
LaFilipina
Messages: 51
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
