| Error message for create standby using rman! [message #193670] |
Mon, 18 September 2006 20:33  |
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!
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
