This discussion is archived
2 Replies Latest reply: Nov 11, 2012 4:45 AM by Venkadesh Raja RSS

Error while Restore.

Venkadesh Raja Pro
Currently Being Moderated
Hi Experts.

i take database backup.
MAN> backup database plus archivelog;


Starting backup at 11-NOV-12
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 11-NOV-12

Starting backup at 11-NOV-12
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSTEM01.DBF

input datafile fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\SYSAUX01.DBF

input datafile fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\EXAMPLE01.DB
F
input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\UNDOTBS01.DB
F
input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\TEST\USERS01.DBF
channel ORA_DISK_1: starting piece 1 at 11-NOV-12
channel ORA_DISK_1: finished piece 1 at 11-NOV-12
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2012_11
_11\O1_MF_NNNDF_TAG20121111T170118_89Z347K4_.BKP tag=TAG20121111T170118 comment=
NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:56
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 11-NOV-12
channel ORA_DISK_1: finished piece 1 at 11-NOV-12
piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\TEST\BACKUPSET\2012_11
_11\O1_MF_NCSNF_TAG20121111T170118_89Z36119_.BKP tag=TAG20121111T170118 comment=
NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:06
Finished backup at 11-NOV-12

Starting backup at 11-NOV-12
using channel ORA_DISK_1
specification does not match any archive log in the recovery catalog
backup cancelled because all files were skipped
Finished backup at 11-NOV-12
When i try to restore my controlfile it's showing error like
RMAN> restore controlfile from 'O1_MF_NCSNF_TAG20121111T170118_89Z36119_';

Starting restore at 11-NOV-12
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 11/11/2012 17:23:14
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
Pls Help i dono where i'm going Wrong..

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points