Last updated on NOVEMBER 05, 2014
Applies to:
Oracle Database - Enterprise Edition - Version 11.1.0.6 to 11.2.0.2 [Release 11.1 to 11.2]Information in this document applies to any platform.
***Checked for relevance on 03-Apr-2013***
Symptoms
Using following 11g duplicate command to create standby database:
run {
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
allocate auxiliary channel stby3 type disk;
allocate auxiliary channel stby4 type disk;
duplicate target database for standby from active database nofilenamecheck;
}
allocate channel prmy1 type disk;
allocate channel prmy2 type disk;
allocate channel prmy3 type disk;
allocate auxiliary channel stby1 type disk;
allocate auxiliary channel stby2 type disk;
allocate auxiliary channel stby3 type disk;
allocate auxiliary channel stby4 type disk;
duplicate target database for standby from active database nofilenamecheck;
}
But it failed with following error messages:
oracle:~> rman target / auxiliary sys/***@*** cmdfile=$HOME/gen_stb.rcv
Recovery Manager: Release 11.1.0.7.0 - Production on Fri Sep 25 19:39:48 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: DRSCPPRD (DBID=407926103)
connected to auxiliary database: DRSCPPRD (not mounted)
...
Starting Duplicate Db at 25-SEP-09
contents of Memory Script:
{
backup as copy reuse
;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code for command Duplicate Db : 600
RMAN-00600: internal error, arguments [8049] [] [] [] []
RMAN-01009: syntax error: found ";": expecting one of: "archivelog, auxiliary, as, backup, backupset, blocks, channel, check, copy, copies, controlfilecopy, cumulative, current, database, datafile, datafilecopy, device, diskratio, db_recovery_file_dest, db_file_name_convert, duration, filesperset, for, format, from, full, force, file, incremental, keep, (, maxsetsize, nochecksum, noexclude, nokeep, not, proxy, pool, reuse, recovery, section, skip, spfile, skip readonly, setsize, tablespace, tag, to, validate"
RMAN-01007: at line 3 column 4 file: Memory Script
Recovery Manager: Release 11.1.0.7.0 - Production on Fri Sep 25 19:39:48 2009
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: DRSCPPRD (DBID=407926103)
connected to auxiliary database: DRSCPPRD (not mounted)
...
Starting Duplicate Db at 25-SEP-09
contents of Memory Script:
{
backup as copy reuse
;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code for command Duplicate Db : 600
RMAN-00600: internal error, arguments [8049] [] [] [] []
RMAN-01009: syntax error: found ";": expecting one of: "archivelog, auxiliary, as, backup, backupset, blocks, channel, check, copy, copies, controlfilecopy, cumulative, current, database, datafile, datafilecopy, device, diskratio, db_recovery_file_dest, db_file_name_convert, duration, filesperset, for, format, from, full, force, file, incremental, keep, (, maxsetsize, nochecksum, noexclude, nokeep, not, proxy, pool, reuse, recovery, section, skip, spfile, skip readonly, setsize, tablespace, tag, to, validate"
RMAN-01007: at line 3 column 4 file: Memory Script
Changes
New installation
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms