RMAN Duplicate for standby [message #70515] |
Tue, 25 June 2002 05:35 |
Bruno
Messages: 12 Registered: May 2002
|
Junior Member |
|
|
Hi everybody !
I have some trouble. I try to create a standby database with RMAN.
but ...
RMAN> run {
2> allocate auxiliary channel ch1 type disk;
3> allocate auxiliary channel ch2 type disk;
4> allocate auxiliary channel ch3 type disk;
5> duplicate target database for standby;
6> }
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=11 devtype=DISK
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch2
RMAN-08500: channel ch2: sid=12 devtype=DISK
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch3
RMAN-08500: channel ch3: sid=13 devtype=DISK
RMAN-03022: compiling command: Duplicate Db
RMAN-03027: 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';
}
RMAN-03021: executing script: Memory Script
RMAN-03022: compiling command: restore
RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel ch1: starting datafile backupset restore
RMAN-08502: set_count=41 set_stamp=465491372 creation_time=25-JUN-02
RMAN-08021: channel ch1: restoring controlfile
RMAN-08505: output filename=C:U01APPORACLEORADATAUTI2CONTROL01.CTL
RMAN-08023: channel ch1: restored backup piece 1
RMAN-08511: piece handle=C:RMANSTB_TEST19DRTLDC_1_1 tag=null params=NULL
RMAN-08024: channel ch1: restore complete
RMAN-03022: compiling command: replicate
RMAN-03023: executing command: replicate
RMAN-08058: replicating controlfile
RMAN-08506: input filename=C:U01APPORACLEORADATAUTI2CONTROL01.CTL
RMAN-08505: output filename=C:U01APPORACLEORADATAUTI2CONTROL02.CTL
RMAN-08505: output filename=C:U01APPORACLEORADATAUTI2CONTROL03.CTL
RMAN-03022: compiling command: sql
RMAN-06162: sql statement: alter database mount standby database
RMAN-03023: executing command: sql
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: ch1
RMAN-08031: released channel: ch2
RMAN-08031: released channel: ch3
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: Duplicate Db
RMAN-06136: ORACLE error from auxiliary database: ORA-06550: line 1, column 166:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated
RMAN-06031: could not translate database keyword
Can someone help me ?
It's on the same host, and it's RMAN release 8170.
I correctly set the parameter LOCK_NAME_SPACE, LOG_FILE_NAME_CONVERT and DB_FILE_NAME_CONVERT.
If db_name is different of my primary database, the command duplicate target database for "db_name" sucessfully complete....
|
|
|
|
|