Dear Friends ,
I got a problem when recovering my database using rman . I am using oracle (10.2.0.1) in redhat ent linux 5 , 64 bit server . I have a old rman backup data. Now when I restore it then I can successfully restore the controlfile and make database on MOUNT stage . But when give the restore command then face the below error :
----------
[oracle@pbltest2 rmanback]$ rman target /
Recovery Manager: Release 10.2.0.1.0 - Production on Mon May 5 12:22:38 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: PBLPRIM (not mounted)
RMAN> restore controlfile from '/rman/rmanback/20130630_194453_9035_LVL_0_FuLL_Current_CF_DBID_548469730_PBLPRIM';
Starting restore at 05-MAY-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=158 devtype=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:02
output filename=/u01/app/oracle/oradata/PBLPRIM/control01.ctl
output filename=/u01/app/oracle/oradata/PBLPRIM/control02.ctl
output filename=/u01/app/oracle/oradata/PBLPRIM/control03.ctl
Finished restore at 05-MAY-14
RMAN> alter database mount;
database mounted
released channel: ORA_DISK_1
RMAN> restore database;
Starting restore at 05-MAY-14
Starting implicit crosscheck backup at 05-MAY-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=158 devtype=DISK
Crosschecked 321 objects
Finished implicit crosscheck backup at 05-MAY-14
Starting implicit crosscheck copy at 05-MAY-14
using channel ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck copy at 05-MAY-14
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 05/05/2014 12:23:32
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
-------------------------
For your information . I keep my old backup data to a specified folder and try to restore it from that specified directory . Here is my restore script :
--
[oracle@pbltest2 ~]$ cat rman_res.sh
export $ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1
export $ORACLE_SID=PBLPRIM
$ORACLE_HOME/bin/rman target / << !
run {
allocate channel c1 device type disk format '/rman/rmanback/%F';
restore database;
release channel c1;
}
---
Waiting for your kind help ... ...