OraFAQ Forum: Data Guard

Home » Server Options » Data Guard » rman 05507

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

rman 05507 [message #324019]

Fri, 30 May 2008 05:08

malvika
Messages: 55
Registered: May 2008
Location: india

Member

RMAN> run {
2> allocate auxiliary channel RESTLG device type disk;
3> duplicate target database for standby nofilenamecheck dorecover;
4> }

allocated channel: RESTLG
channel RESTLG: sid=17 devtype=DISK

Starting Duplicate Db at 30-MAY-08

printing stored script: Memory Script
{
restore clone standby controlfile to clone_cf;
replicate clone controlfile from clone_cf;
sql clone 'alter database mount standby database';
}
executing script: Memory Script

Starting restore at 30-MAY-08

channel RESTLG: restoring controlfile
output filename=/newdata/app/oracle/oradata/RESTLG/ctlRESTLG.ctl
channel RESTLG: copied controlfile copy
input filename=/newdata/app/oracle/oradata/ESTLG_BKUP/ctlRESTLG.ctl
output filename=/newdata/app/oracle/oradata/RESTLG/ctlRESTLG.ctl recid=0 stamp=0
Finished restore at 30-MAY-08

replicating controlfile
input filename=/newdata/app/oracle/oradata/RESTLG/ctlRESTLG.ctl

sql statement: alter database mount standby database
released channel: RESTLG
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==============================================================
RMAN-03002: failure of Duplicate Db command at 05/30/2008 16:05:19
RMAN-05507: standby controlfile checkpoint (313020) is more recent than duplication point in time (312577)

Report message to a moderator

Re: rman 05507 [message #324024 is a reply to message #324019]

Fri, 30 May 2008 05:33

malvika
Messages: 55
Registered: May 2008
Location: india

Member

above error solve by performing following steps

1)sql> backup full database include current controlfile for standby database;
2)alter system archive log current;

and again do above procedure and it works.

but i can't get archivelog
tell me what i do next

Report message to a moderator

Re: rman 05507 [message #324068 is a reply to message #324024]

Fri, 30 May 2008 09:40

ebrian
Messages: 2794
Registered: April 2006

Senior Member

malvika wrote on Fri, 30 May 2008 06:33

but i can't get archivelog

What do you mean by this?

Report message to a moderator

Re: rman 05507 [message #324145 is a reply to message #324068]

Sat, 31 May 2008 02:33

malvika
Messages: 55
Registered: May 2008
Location: india

Member

means i create standby database using rman .

but my standby database i work like duplicate database.

in standby database archive or log automatic apply but on my standby it not apply.
why?

and here mrp process also not start.

Report message to a moderator

Re: rman 05507 [message #324196 is a reply to message #324145]

Sat, 31 May 2008 08:21

ebrian
Messages: 2794
Registered: April 2006

Senior Member

You may want to archive the current log on the primary and then create another standby control file. Once you have performed this, you should try to recreate the standby database.

Report message to a moderator

Previous Topic:	ORA-00305: log 2 of thread 1 inconsistent;
Next Topic:	error after creating physical standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 22:56:27 CST 2025