I faced following error message while creating a
standby database from live database using RMAN DUPLICATE command.
C:\Users\administrator>rman
target sys/pass11g@pri auxiliary sys/pass11g@aux
Recovery
Manager: Release 11.2.0.3.0 - Production on Wed Sep 9 12:35:18 2015
Copyright
(c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
connected
to target database: PROD (DBID=3343192461)
connected
to auxiliary database: STBY (not mounted)
RMAN>
run{
2> allocate channel c1 type disk;
3> allocate auxiliary channel standby-db type
disk;
4> duplicate target database for standby from
active database;
5> }
using
target database control file instead of recovery catalog
allocated
channel: c1
channel
c1: SID=695 instance=prod1 device type=DISK
allocated
channel: standby-db
channel
standby-db: SID=465 instance=prod2 device type=DISK
Starting
Duplicate Db at 09-SEP-15
contents
of Memory Script:
{
backup as copy reuse
;
released
channel: c1
released
channel: stby
RMAN-00571:
===========================================================
RMAN-00569:
=============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002:
failure of Duplicate Db command at 09/09/2015 12:35:46
RMAN-05501:
aborting duplication of target database
RMAN-00600:
internal error, arguments [9222] [] [] [] []
RMAN-01009:
syntax error: found ";": expecting one of: "archivelog, as,
auxiliary, backupset, backup, channel, check, controlfilecopy, copies, copy,
cumulative, current, database, datafilecopy, datafile, db_file_name_convert,
db_recovery_file_dest, device, diskratio, duration, filesperset, force, f
RMAN-01007:
at line 3 column 4 file: Memory Script
|
Solution
For standby database to work properly and connect
with the primary (and primary to connect with the standby), password file of
primary needs to be copied to the standby database host. In my case, I forgot
to do this before executing DUPLICATE command “FROM ACTIVE DATABASE”. After
copying password file, my duplicate command executed successfully.
hello... did the same but still had the same error again.
ReplyDelete