Home » RDBMS Server » Backup & Recovery » Error message for create standby using rman!
Error message for create standby using rman! [message #193670] Mon, 18 September 2006 20:33 Go to next message
Tom_webex
Messages: 13
Registered: July 2006
Location: China
Junior Member

I have a product server(instancename prod),I setup a standby db(instancename standby1) on the same server with different directory.I have copy the init.ora and pwssword file to the standby and changed.I also use rman backup the prod server using
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
#backup data
backup incremental level 0 tag 'db0' format 'e:\backup\db0%u_%s_%p' database include current controlfile for standby;
#backup archive log
sql 'alter system archive log current';
backup archivelog from time 'sysdate-1' format 'e:\backup\log_t%t_s%s_p%p';
release channel c1;
release channel c2;
release channel c3;
}

Now according to the oracle document,I run the following:

rman catalog rman/rman@oracle target internal/oracle@prod
auxiliary internal/oracle@standby1
run {
set newname for datafile 1 to "D:\ORACLE\ORADATA\clonedb\SYSTEM01.DBF";
set newname for datafile 2 to "D:\ORACLE\ORADATA\clonedb\RBS01.DBF";
set newname for datafile 3 to "D:\ORACLE\ORADATA\clonedb\USERS01.DBF";
set newname for datafile 4 to "D:\ORACLE\ORADATA\clonedb\TEMP01.DBF";
set newname for datafile 5 to "D:\ORACLE\ORADATA\clonedb\TOOLS01.DBF";
set newname for datafile 6 to "D:\ORACLE\ORADATA\clonedb\INDX01.DBF";
set newname for datafile 7 to "D:\ORACLE\ORADATA\clonedb\DR01.DBF";
allocate auxiliary channel dev1 type disk;
duplicate target database for standby dorecover;
}

But I get the error message:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03006: non-retryable error occurred during execution of command: sql
RMAN-07004: unhandled exception during command execution on channel clone_defaul
t
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: alter database moun
t standby database
RMAN-11001: Oracle Error: ORA-01103: database name 'prod' in controlfile is not 'standby1'

Who can help me? Thanks very muck!
Re: Error message for create standby using rman! [message #193671 is a reply to message #193670] Mon, 18 September 2006 20:33 Go to previous messageGo to next message
Tom_webex
Messages: 13
Registered: July 2006
Location: China
Junior Member

My oracle version is 8.1.7
Re: Error message for create standby using rman! [message #193870 is a reply to message #193670] Tue, 19 September 2006 14:45 Go to previous message
gans_dba
Messages: 2
Registered: September 2006
Junior Member
I think you have a syntax error,
It should be as follows

duplicate target database for standby;
dorecover;

Hope this helps.
Previous Topic: How to organize backup strategy
Next Topic: Using retention policy and delete obsolete in RMAN
Goto Forum:
  


Current Time: Sat Dec 10 18:41:06 CST 2016

Total time taken to generate the page: 0.07440 seconds