Day: January 15, 2019

RMAN-05001: auxiliary file name conflicts with a file used by the target database

In 11g, duplicate a standby database from active database with “RMAN-05001” error:

RMAN> run {
      duplicate target database for standby from active database;
      }

RMAN-05001: auxiliary file name /u02/oradata/TESTDBSTY/sysaux01.dbf 
            conflicts with a file used by the target database

WORKAROUND

The issue is a bug, it seems the file system for both primary and standby database are the same, though “db_file_name_convert” and “log_file_name_convert” are configured already.

Add “NOFILENAMECHECK” option into duplicate RMAN command:

RMAN> run 
      {
         duplicate target database for standby 
         from active database nofilenamecheck;
      }

This issue does not happen on 12c, so it seems a bug for 11g.

RMAN-03002 RMAN-05501 RMAN-03015 RMAN-03009 ORA-17629 ORA-17627 ORA-27101 ORA-17629 duplicate target database for standby from active database

In 12c , try to duplicate a standby database with below errors:

channel ORA_DISK_1: SID=158 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/15/2019 18:35:32
RMAN-05501: aborting duplication of target database
RMAN-03015: error occurred in stored script Memory Script
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/15/2019 18:35:32
ORA-17629: Cannot connect to the remote database server
ORA-17627: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3651
Additional information: -603812709
ORA-17629: Cannot connect to the remote database server

WORKAROUND

In tnsnames.ora of both primary and standby database server, add  “(UR = A)” for the standby database entry :

TESTDBSTY =
(DESCRIPTION =
   (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521))
   (CONNECT_DATA = (SERVICE_NAME = TESTDBSTY)(UR=A))
)

ORA-01017: invalid username/password; logon denied

Try to connect to 12c standby database , then get “ORA-01017” error.

$ sqlplus sys/password@TESTDBSTY as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Tue Jan 15 18:07:54 2019

Copyright (c) 1982, 2014, Oracle. All rights reserved.

ERROR:
ORA-01017: invalid username/password; logon denied

After investigation, found the listener is running by 11R2 binary, instead of 12cR1 binary.

Restart the listener in 12cR1 ORACLE_HOME, then everything is fine.

Always run listener by using the highest version of all ORACLE_HOME.

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

Before start to create standby database by using DUPLICATE command, try to connect to  auxiliary instance:

RMAN>  connect auxiliary  sys/password@testdbsty

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-04006: error from auxiliary database: 
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
$ sqlplus sys/password@testdbsty as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 15 15:18:35 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

ERROR:
ORA-12154: TNS:could not resolve the connect identifier specified

Workaround:

Add an entry in listener.ora, and then reload listener to make it effective:

SID_LIST_LISTENER =
(SID_LIST =
   (SID_DESC =
      (GLOBAL_DBNAME = TESTDBSTY)
      (SID_NAME = TESTDBSTY)
      (ORACLE_HOME = /u01/app/oracle/product/11.2.0/dbhome_1)
  )
..
.
}

$lsnrctl status
Services Summary...
Service "TESTDBSTY" has 2 instance(s).
  Instance "TESTDBSTY", status UNKNOWN, has 1 handler(s) for this service...
  Instance "TESTDBSTY", status BLOCKED, has 1 handler(s) for this service...
...
.
.

ORA-17628 RMAN-03009 duplicate target database for standby from active database

While run RMAN “duplicate target database for standby from active database nofilenamecheck” in 11g database, then got below errors:

...
..
.
set newname for datafile 3 to "/u02/oradata/TESTDBSTY/undotbs01.dbf";
...
..
.
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/u02/oradata/TESTDB/undotbs01.dbf
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 01/15/2019 15:53:17
ORA-17628: Oracle error 19505 returned by remote Oracle server
continuing other job steps, job failed will not be re-run
...
..
.

Subscribe to get access

Read more of this content when you subscribe today.

Subscribe