Home » Server Options » Data Guard » rman 05507
rman 05507 [message #324019] Fri, 30 May 2008 05:08 Go to next message
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)
Re: rman 05507 [message #324024 is a reply to message #324019] Fri, 30 May 2008 05:33 Go to previous messageGo to next message
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
Re: rman 05507 [message #324068 is a reply to message #324024] Fri, 30 May 2008 09:40 Go to previous messageGo to next message
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?
Re: rman 05507 [message #324145 is a reply to message #324068] Sat, 31 May 2008 02:33 Go to previous messageGo to next message
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.
Re: rman 05507 [message #324196 is a reply to message #324145] Sat, 31 May 2008 08:21 Go to previous message
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.
Previous Topic: ORA-00305: log 2 of thread 1 inconsistent;
Next Topic: error after creating physical standby
Goto Forum:
  


Current Time: Fri Mar 29 01:33:56 CDT 2024