Thursday 19 May 2016

RMAN-03002 RMAN-12001 RMAN-10008 RMAN-10003 ORA-12154

ORA-ERROR

RMAN> CATALOG START WITH '/u04/orabackup/orcl/rman_backup/';

Starting implicit crosscheck backup at 19-MAY-16
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of catalog command at 05/19/2016 14:52:51
RMAN-12001: could not open channel ORA_DISK_1
RMAN-10008: could not create channel context
RMAN-10003: unable to connect to target database
ORA-12154: TNS:could not resolve the connect identifier specified



Sol:-

RMAN> CONFIGURE channel 1 device type disk clear;

old RMAN configuration parameters:
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CONNECT '*';
old RMAN configuration parameters are successfully deleted

RMAN> CONFIGURE channel 1 device type 'SBT_TAPE' clear;

old RMAN configuration parameters are successfully deleted

RMAN> CATALOG START WITH '/u04/orabackup/orcl/rman_backup/';

Starting implicit crosscheck backup at 19-MAY-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1647 devtype=DISK
Crosschecked 341 objects
Finished implicit crosscheck backup at 19-MAY-16

Starting implicit crosscheck copy at 19-MAY-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 19-MAY-16

searching for all files in the recovery area
cataloging files...
no files cataloged


No comments:

Post a Comment