Home » RDBMS Server » Backup & Recovery » RMAN Duplicate for standby
RMAN Duplicate for standby [message #70515] Tue, 25 June 2002 05:35 Go to next message
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....
Re: RMAN Duplicate for standby [message #70520 is a reply to message #70515] Tue, 25 June 2002 06:02 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
did you set NLS_LANG and NLS_DATE_FORMAT
same as the target database??
I'm afraid but you are right ! [message #70521 is a reply to message #70520] Tue, 25 June 2002 06:40 Go to previous message
Bruno
Messages: 12
Registered: May 2002
Junior Member
Hi Mahesh !

You're right.... some NLS parameter was wrong. Thanks a lot for your help.
Previous Topic: Backup Strategy
Next Topic: Problme with Rman : Urgent
Goto Forum:
  


Current Time: Sat Apr 20 08:01:16 CDT 2024