13 Replies Latest reply: Jun 15, 2014 11:34 PM by DK2010 RSS

    Error while restoring rman

    Venkadesh Raja

      Hi Experts,

       

      i have done following..

       

      Microsoft Windows XP [Version 5.1.2600]

      (C) Copyright 1985-2001 Microsoft Corp.

       

       

      C:\Documents and Settings\siva>rman target /

       

       

      Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 10 21:20:16 2014

       

       

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

       

       

      connected to target database: RAJA (DBID=2318737290)

       

       

      RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

       

       

      using target database control file instead of recovery catalog

      new RMAN configuration parameters:

      CONFIGURE CONTROLFILE AUTOBACKUP ON;

      new RMAN configuration parameters are successfully stored

       

       

      RMAN> BACKUP DATABASE PLUS ARCHIVELOG;

       

       

       

       

      Starting backup at 10-JUN-14

      current log archived

      allocated channel: ORA_DISK_1

      channel ORA_DISK_1: sid=140 devtype=DISK

      allocated channel: ORA_DISK_2

      channel ORA_DISK_2: sid=159 devtype=DISK

      channel ORA_DISK_1: starting archive log backupset

      channel ORA_DISK_1: specifying archive log(s) in backup set

      input archive log thread=1 sequence=3 recid=1 stamp=849561057

      input archive log thread=1 sequence=4 recid=2 stamp=849604045

      input archive log thread=1 sequence=5 recid=3 stamp=849641566

      channel ORA_DISK_1: starting piece 1 at 10-JUN-14

      channel ORA_DISK_2: starting archive log backupset

      channel ORA_DISK_2: specifying archive log(s) in backup set

      input archive log thread=1 sequence=12 recid=10 stamp=849821908

      input archive log thread=1 sequence=13 recid=11 stamp=849906362

      input archive log thread=1 sequence=14 recid=12 stamp=849907236

      channel ORA_DISK_2: starting piece 1 at 10-JUN-14

      channel ORA_DISK_1: finished piece 1 at 10-JUN-14

      piece handle=C:\BKP\1311 tag=TAG20140610T212037 comment=NONE

      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:11

      channel ORA_DISK_2: finished piece 1 at 10-JUN-14

      piece handle=C:\BKP\1411 tag=TAG20140610T212037 comment=NONE

      channel ORA_DISK_2: backup set complete, elapsed time: 00:00:11

      channel ORA_DISK_1: starting archive log backupset

      channel ORA_DISK_1: specifying archive log(s) in backup set

      input archive log thread=1 sequence=6 recid=4 stamp=849709211

      input archive log thread=1 sequence=7 recid=5 stamp=849710627

      input archive log thread=1 sequence=8 recid=6 stamp=849712766

      input archive log thread=1 sequence=9 recid=7 stamp=849719687

      input archive log thread=1 sequence=10 recid=8 stamp=849720042

      input archive log thread=1 sequence=11 recid=9 stamp=849820164

      channel ORA_DISK_1: starting piece 1 at 10-JUN-14

      channel ORA_DISK_1: finished piece 1 at 10-JUN-14

      piece handle=C:\BKP\1511 tag=TAG20140610T212037 comment=NONE

      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04

      Finished backup at 10-JUN-14

       

       

      Starting backup at 10-JUN-14

      using channel ORA_DISK_1

      using channel ORA_DISK_2

      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\RAJA\SYSTEM01.DBF

       

       

      input datafile fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RAJA\USERS01.DBF

      channel ORA_DISK_1: starting piece 1 at 10-JUN-14

      channel ORA_DISK_2: starting full datafile backupset

      channel ORA_DISK_2: specifying datafile(s) in backupset

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

       

       

      input datafile fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\RAJA\UNDOTBS01.DB

      F

      channel ORA_DISK_2: starting piece 1 at 10-JUN-14

      channel ORA_DISK_2: finished piece 1 at 10-JUN-14 with 2 copies and tag TAG20140

      610T212055

      piece handle=C:\BKP\1711 comment=NONE

      piece handle=C:\BKP\1712 comment=NONE

      channel ORA_DISK_2: backup set complete, elapsed time: 00:00:45

      channel ORA_DISK_1: finished piece 1 at 10-JUN-14 with 2 copies and tag TAG20140

      610T212055

      piece handle=C:\BKP\1611 comment=NONE

      piece handle=C:\BKP\1612 comment=NONE

      channel ORA_DISK_1: backup set complete, elapsed time: 00:01:00

      Finished backup at 10-JUN-14

       

       

      Starting backup at 10-JUN-14

      current log archived

      using channel ORA_DISK_1

      using channel ORA_DISK_2

      channel ORA_DISK_1: starting archive log backupset

      channel ORA_DISK_1: specifying archive log(s) in backup set

      input archive log thread=1 sequence=15 recid=13 stamp=849907317

      channel ORA_DISK_1: starting piece 1 at 10-JUN-14

      channel ORA_DISK_1: finished piece 1 at 10-JUN-14

      piece handle=C:\BKP\1811 tag=TAG20140610T212157 comment=NONE

      channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

      Finished backup at 10-JUN-14

       

       

      Starting Control File and SPFILE Autobackup at 10-JUN-14

      piece handle=C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\RAJA\AUTOBACKUP\2014_0

      6_10\O1_MF_S_849907320_9SHPCB00_.BKP comment=NONE

      Finished Control File and SPFILE Autobackup at 10-JUN-14

       

       

      RMAN> exit

       

       

       

       

      Recovery Manager complete.

       

       

      C:\Documents and Settings\siva>dbca

       

      then i connected dbca deleted my "raja" database

       

      now am trying to restore database from my backup but am getting below error pls help..

       

       

      C:\Documents and Settings\siva>rman

       

       

      Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jun 10 21:36:22 2014

       

       

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

       

       

      RMAN> connect target /

       

       

      RMAN-00571: ===========================================================

      RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

      RMAN-00571: ===========================================================

      ORA-12560: TNS:protocol adapter error

       

       

      RMAN>

       

      NOTE:

      am referring this link http://www.exploreoracle.com/2009/09/12/rman-recovery-restore-controlfile/