Restore Database

Recovery Manager complete.

dbname oracle@hostname:/home/oracle>sqldba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Aug 7 09:02:44 2014

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> alter database mount;

Database altered.

SQL> exit

dbname oracle@hostname:/home/oracle>vi dbname_restore.sh

export PATH=$PATH:/oracle/product/11.2.0.3/db/bin

export ORACLE_HOME=/oracle/product/11.2.0.3/db

export ORACLE_SID=dbname

rman <<EOF

connect target /

run

{

CONFIGURE DEFAULT DEVICE TYPE TO sbt;

CONFIGURE CHANNEL DEVICE TYPE sbt parms 'ENV=(NSR_CLIENT=sourcehostname,NSR_RECOVER_POOL=DDBoostORA,NSR_DATA_DOMAIN_INTERFACE=eth11a.562,N

SR_SERVER=backupserverhostname)';

CONFIGURE DEVICE TYPE sbt PARALLELISM 8;

restore DATABASE;

}

EOF

exit

dbname oracle@hostname:/home/oracle>

dbname oracle@hostname:/home/oracle>

dbname oracle@hostname:/home/oracle>./dbname_restore.sh                                    

Recovery Manager: Release 11.2.0.3.0 - Production on Thu Aug 7 09:48:26 2014

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

RMAN>

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

RMAN> 2> 3> 4> 5> 6> 7>

using target database control file instead of recovery catalog

new RMAN configuration parameters:

CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';

new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(NSR_CLIENT=sourcehostname,NSR_SERVER=backupserverhostname,NSR_DATA_VOLUME_POOL=DDBoostORA)' FORMAT   'DBNAME_FULL_%T_%u_%s_%p' MAXOPENFILES 1;

new RMAN configuration parameters:

CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS  'ENV=(NSR_CLIENT= sourcehostname,NSR_SERVER= backupserverhostname)';

new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 12 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters:

CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 8 BACKUP TYPE TO BACKUPSET;

new RMAN configuration parameters are successfully stored

Starting restore at 07-AUG-14

Starting implicit crosscheck backup at 07-AUG-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=35 device type=DISK

Crosschecked 1 objects

Finished implicit crosscheck backup at 07-AUG-14

Starting implicit crosscheck copy at 07-AUG-14

using channel ORA_DISK_1

Finished implicit crosscheck copy at 07-AUG-14

searching for all files in the recovery area

cataloging files...

no files cataloged

allocated channel: ORA_SBT_TAPE_1

channel ORA_SBT_TAPE_1: SID=129 device type=SBT_TAPE

channel ORA_SBT_TAPE_1: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_2

channel ORA_SBT_TAPE_2: SID=156 device type=SBT_TAPE

channel ORA_SBT_TAPE_2: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_3

channel ORA_SBT_TAPE_3: SID=190 device type=SBT_TAPE

channel ORA_SBT_TAPE_3: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_4

channel ORA_SBT_TAPE_4: SID=221 device type=SBT_TAPE

channel ORA_SBT_TAPE_4: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_5

channel ORA_SBT_TAPE_5: SID=4 device type=SBT_TAPE

channel ORA_SBT_TAPE_5: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_6

channel ORA_SBT_TAPE_6: SID=96 device type=SBT_TAPE

channel ORA_SBT_TAPE_6: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_7

channel ORA_SBT_TAPE_7: SID=36 device type=SBT_TAPE

channel ORA_SBT_TAPE_7: NMDA Oracle v1.6.0

allocated channel: ORA_SBT_TAPE_8

channel ORA_SBT_TAPE_8: SID=67 device type=SBT_TAPE

channel ORA_SBT_TAPE_8: NMDA Oracle v1.6.0

using channel ORA_DISK_1

channel ORA_SBT_TAPE_1: starting datafile backup set restore

channel ORA_SBT_TAPE_1: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_1: restoring datafile 00012 to +DBNAME/dbname/datafile/tbs_dbname.278.849440549

channel ORA_SBT_TAPE_1: reading from backup piece DBNAME_FULL_20140807_i2pfb08g_3650_1

channel ORA_SBT_TAPE_2: starting datafile backup set restore

channel ORA_SBT_TAPE_2: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_2: restoring datafile 00007 to +DBNAME/dbname/datafile/tbs_dbname.273.849440543

channel ORA_SBT_TAPE_2: reading from backup piece DBNAME_FULL_20140807_htpfb08g_3645_1

channel ORA_SBT_TAPE_3: starting datafile backup set restore

channel ORA_SBT_TAPE_3: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_3: restoring datafile 00011 to +DBNAME/dbname/datafile/tbs_dbname.277.849440547

channel ORA_SBT_TAPE_3: reading from backup piece DBNAME_FULL_20140807_i1pfb08g_3649_1

channel ORA_SBT_TAPE_4: starting datafile backup set restore

channel ORA_SBT_TAPE_4: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_4: restoring datafile 00010 to +DBNAME/dbname/datafile/tbs_dbname.276.849440547

channel ORA_SBT_TAPE_4: reading from backup piece DBNAME_FULL_20140807_i0pfb08g_3648_1

channel ORA_SBT_TAPE_5: starting datafile backup set restore

channel ORA_SBT_TAPE_5: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_5: restoring datafile 00003 to +DBNAME/dbname/datafile/undotbs1.262.849427443

channel ORA_SBT_TAPE_5: reading from backup piece DBNAME_FULL_20140807_hspfb08g_3644_1

channel ORA_SBT_TAPE_6: starting datafile backup set restore

channel ORA_SBT_TAPE_6: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_6: restoring datafile 00015 to +DBNAME/dbname/datafile/tbs_dbname.281.849440553

channel ORA_SBT_TAPE_6: reading from backup piece DBNAME_FULL_20140807_i5pfb08h_3653_1

channel ORA_SBT_TAPE_7: starting datafile backup set restore

channel ORA_SBT_TAPE_7: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_7: restoring datafile 00008 to +DBNAME/dbname/datafile/tbs_dbname.274.849440543

channel ORA_SBT_TAPE_7: reading from backup piece DBNAME_FULL_20140807_hupfb08g_3646_1

channel ORA_SBT_TAPE_8: starting datafile backup set restore

channel ORA_SBT_TAPE_8: specifying datafile(s) to restore from backup set

channel ORA_SBT_TAPE_8: restoring datafile 00013 to +DBNAME/dbname/datafile/tbs_dbname.279.849440551