Monday, February 21, 2011

no backup or copy of datafile XX found to restore when backup actually exists

Attempting to restore catalogued backup on another host gives following error:

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 20-FEB-11

released channel: ch01
released channel: ch02
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 02/20/2011 20:35:40
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile XX1 found to restore
RMAN-06023: no backup or copy of datafile XX2 found to restore

but when I did list backup, it shown backup exist.

Erorr was the consequence of  catalog command. There was attempt to catalog backupset with dificult name like /mnt/share/backup/oracle/DBNAME/local-lvl-0-db_3673504914-DB01-20110220-38400-1-1 which catalog was not able to compile.
solution:

Wednesday, February 2, 2011

silent database creation

$ dbca -silent -createDatabase -templateName Transaction_Processing.dbc -gdbname rcat -sid rcat1 -datafileJarLocation /export/home/oracle/oracle/product/10.2.0/db/assistants/dbca/templates -datafileDestination /export/home/oracle/oracle/product/10.2.0/db/oradata -responseFile NO_VALUE -characterset CL8MSWIN1251
Copying database files
1% complete
3% complete

delete/add Oracle Home from Central Inventory

some times it happens...:

$ ./OPatch/opatch lsinv
Invoking OPatch 10.2.0.4.3

Oracle Interim Patch Installer version 10.2.0.4.3
Copyright (c) 2007, Oracle Corporation.  All rights reserved.


Oracle Home       : /export/home/oracle/oracle/product/10.2.0/db
Central Inventory : /u01/oracle/oraInventory
   from           : /var/opt/oracle/oraInst.loc
OPatch version    : 10.2.0.4.3
OUI version       : 10.2.0.4.0
OUI location      : /export/home/oracle/oracle/product/10.2.0/db/oui
Log file location : /export/home/oracle/oracle/product/10.2.0/db/cfgtoollogs/opatch/opatch2011-02-02_14-30-01PM.log

List of Homes on this system:

  Home name= OraDb10g_home2, Location= "/d03/oracle/product/10.2.0/Db1"
Inventory load failed... OPatch cannot load inventory for the given Oracle Home.
Possible causes are:
   Oracle Home dir. path does not exist in Central Inventory
   Oracle Home is a symbolic link
   Oracle Home inventory is corrupted
LsInventorySession failed: OracleHomeInventory gets null oracleHomeInfo

OPatch failed with error code 73



Solution: