Archive

Archive for June, 2010

ORA-19505: failed to identify file “/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat”

June 11, 2010 1 comment

Symptoms

When duplicate a database by RMAN,
channel ORA_AUX_DISK_1: reading from backup piece /export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat
channel ORA_AUX_DISK_1: ORA-19870: error while restoring backup piece /export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat
ORA-19505: failed to identify file “/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat”
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3

Fixed
RMAN> list backupset

RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=492 instance=cviqa1 device type=DISK
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat RECID=647 STAMP=709021876
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_649_1_709022294.dat RECID=648 STAMP=709022294
crosschecked backup piece: found to be ‘EXPIRED’
backup piece handle=/export/home/oracle/bkup/cviqa/ctlfile_c-188335673-20100123-00.dat RECID=649 STAMP=709022296
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/cviqa/bkup_CVIQA_765_1_721395939.dat RECID=750 STAMP=721395939
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/cviqa/bkup_CVIQA_766_1_721397036.dat RECID=751 STAMP=721397036
crosschecked backup piece: found to be ‘AVAILABLE’
backup piece handle=/bkuppool/oracle/bkup/databases/cviqa/bkup_ctl_c-188335673-20100611-01.dat RECID=752 STAMP=721397038
Crosschecked 6 objects
RMAN> delete expired backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
——- ——- — — ———– ———– ———-
647     647     1   1   EXPIRED     DISK        /export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat
648     648     1   1   EXPIRED     DISK        /export/home/oracle/bkup/cviqa/bkup_CVIQA_649_1_709022294.dat
649     649     1   1   EXPIRED     DISK        /export/home/oracle/bkup/cviqa/ctlfile_c-188335673-20100123-00.dat

Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_648_1_709021874.dat RECID=647 STAMP=709021876
deleted backup piece
backup piece handle=/export/home/oracle/bkup/cviqa/bkup_CVIQA_649_1_709022294.dat RECID=648 STAMP=709022294
deleted backup piece
backup piece handle=/export/home/oracle/bkup/cviqa/ctlfile_c-188335673-20100123-00.dat RECID=649 STAMP=709022296
Deleted 3 EXPIRED objects

Categories: TroubleShooting

ORA-12528: TNS:listener: all appropriate instances are blocking new connections

June 11, 2010 3 comments

Symptoms

– Start RMAN to duplicate a new database from existing database, I got the following messages

$ rman target / nocatalog auxiliary sys/12345@mhqa1

Recovery Manager: Release 11.1.0.7.0 – Production on Fri Jun 11 10:19:36 2010

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

connected to target database: CVIQA (DBID=188335673)
using target database control file instead of recovery catalog
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropriate instances are blocking new connections

Causes

Most probably your auxiliary database (in nomount state) is the only instance works on current ORACLE_HOME. Each instance is registered in listener by PMON process, which starts only when database is at least mounted. If there is nothing registered in listener before, instance in blocked.

Workaround

You can do 2 things:
1. Modify listener.ora like this:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = AUXDB)
(ORACLE_HOME = /app/oracle/product/10.2.0/)
(SID_NAME = AUXDB)
)
)
OR
2. Modify tnsnames.ora (10g only!) :

AUXDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = AUXDB)(UR=A)
)
)

Categories: TroubleShooting