Control File Restore

Dbname oracle@hostname:/home/oracle>rman target /

connected to target database: dbname(DBID=1556411790, not open)

RMAN> connect catalog username/password@catalogdbtns

connected to recovery catalog database

RMAN> list backup of controlfile;

List of Backup Sets

===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

32255   Full    21.75M     SBT_TAPE    00:00:04     06-AUG-14     

        BP Key: 32257   Status: AVAILABLE  Compressed: NO  Tag: TAG20140806T080650

        Handle: c-1556411790-20140806-00   Media: DDBoostORA.001

  Control File Included: Ckp SCN: 11810187652312   Ckp time: 06-AUG-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

32989   Full    21.75M     SBT_TAPE    00:00:03     07-AUG-14     

        BP Key: 32991   Status: AVAILABLE  Compressed: NO  Tag: TAG20140807T072909

        Handle: dbname_FULL_20140807_kupfb4u7_3742_1   Media: DDBoostORA.001

  Control File Included: Ckp SCN: 11810723943559   Ckp time: 07-AUG-14

BS Key  Type LV Size       Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

33000   Full    21.75M     SBT_TAPE    00:00:02     07-AUG-14     

        BP Key: 33002   Status: AVAILABLE  Compressed: NO  Tag: TAG20140807T072917

        Handle: c-1556411790-20140807-00   Media: DDBoostORA.001

  Control File Included: Ckp SCN: 11810723949892   Ckp time: 07-AUG-14

RMAN> run

 {

 set until scn 11810723949892;

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=sourcehostname,NSR_SERVER=backupserverhostname)';

RESTORE CONTROLFILE;

  RELEASE channel t1;

 }

executing command: SET until clause

allocated channel: t1

channel t1: SID=66 device type=SBT_TAPE

channel t1: NMDA Oracle v1.6.0

Starting restore at 07-AUG-14

released channel: t1

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

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

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

RMAN-03002: failure of restore command at 08/07/2014 08:53:54

RMAN-06496: must use the TO clause when the database is mounted or open

RMAN> exit

Recovery Manager complete.

dDBNAME oracle@hostname:/home/oracle>sqldba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 7 08:54:02 2014

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, Automatic Storage Management, OLAP, Data Mining

and Real Application Testing options

SQL> shu immediate;

ORA-01109: database not open

Database dismounted.

ORACLE instance shut down.

SQL> SQL> SQL> SQL>

SQL>

SQL>

SQL> startup nomount   pfile='/oracle/product/11.2.0.3/db/dbs/rman_pfile';

ORACLE instance started.

Total System Global Area 2.0510E+10 bytes

Fixed Size                  2191480 bytes

Variable Size            2550140808 bytes

Database Buffers         1.7918E+10 bytes

Redo Buffers               40038400 bytes

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

dDBNAME oracle@hostname:/home/oracle>rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Aug 7 08:55:35 2014

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DBNAME (not mounted)

RMAN>

RMAN> connect catalog username/password@catalogdbtns

connected to recovery catalog database

run

{

 set until scn 11810723949892;

allocate channel t1 type 'SBT_TAPE' parms 'ENV=(NSR_CLIENT=sourcehostname,NSR_SERVER= backupserverhostname)';

RESTORE CONTROLFILE;

RELEASE channel t1;

}

executing command: SET until clause

allocated channel: t1

channel t1: SID=35 device type=SBT_TAPE

channel t1: NMDA Oracle v1.6.0

Starting restore at 07-AUG-14

channel t1: starting datafile backup set restore

channel t1: restoring control file

channel t1: reading from backup piece c-1556411790-20140807-00

channel t1: piece handle=c-1556411790-20140807-00 tag=TAG20140807T072917

channel t1: restored backup piece 1

channel t1: restore complete, elapsed time: 00:04:05

output file name=+DBNAME/dDBNAME/controlfile/current.261.854728895

output file name=+DBNAME/dDBNAME/controlfile/current.260.854728895

Finished restore at 07-AUG-14

released channel: t1

RMAN> exit