Sunday, November 22, 2015

RMAN-00600: internal error, arguments [9222] [] [] [] []

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.





1 comment:

  1. hello... did the same but still had the same error again.

    ReplyDelete