My Oracle Support Banner

OEM Standby Creation failed with RMAN-01008: the bad identifier was: and RMAN-01009 RMAN-06174 (Doc ID 2453583.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Stand-By database creation is failing with error "RMAN-06174: not connected to auxiliary database."

RMAN>
connected to target database : <db name> (DBID=1629301901)
RMAN>
RMAN-00571
RMAN-00569
RMAN-00571
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting on of: "newline, ;"
RMAN-01008: the bad identifier was: Maj0rFaceLifts#(4~All_DBSs!)"@(DESCRIPTION  <<<<<
RMAN-01007: at line 1 column 25 file: standard input

RMAN>
echo set on
RMAN> run {
SQL CLONE "ALTER SYSTEM SET standby_file_management = ''MANUAL''";
allocate channel CH1 type disk;
allocate channel CH2 type disk;
allocate auxiliary channel DUP1 type disk;
DUPLICATE TARGET DATABASE FOR STANDBY
FROM ACTIVE DATABASE;
SQL CLONE "ALTER SYSTEM SET standby_file_management = ''AUTO''";
}
RMAN-00571
RMAN-00569
RMAN-00571
RMAN-03002
RMAN-06174: not connected to auxiliary database  <<<<<

RMAN> EXIT;

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.