-- move older pfiles in dbs directory
[oracle@subhen-db02 dbs]$ ls -ltr|grep -i ORCLDB
-rw-rwxr--+ 1 oracle oinstall 46 Dec 5 17:20 initORCLDB_2.ora
-rw-rwx---+ 1 oracle oinstall 2560 Dec 5 17:21 orapwORCLDB
-rw-rwxr--+ 1 oracle oinstall 69 Dec 7 16:14 initORCLDB_3.ora
-rw-rwx---+ 1 oracle oinstall 1544 Jan 17 18:42 hc_ORCLDB_2.dat
-rw-rwxr--+ 1 oracle oinstall 69 Jan 17 23:02 initORCLDB_1.ora
-rw-rwx---+ 1 oracle oinstall 1544 Mar 25 11:14 hc_ORCLDB_1.dat
-rw-rwx---+ 1 oracle oinstall 1544 Apr 16 16:32 hc_ORCLDB_3.dat
[oracle@subhen-db02 dbs]$ mv initORCLDB_3.ora initORCLDB_3.ora.old
[oracle@subhen-db02 dbs]$ mv initORCLDB_1.ora initORCLDB_1.ora.old
[oracle@subhen-db02 dbs]$ mv initORCLDB_2.ora initORCLDB_2.ora.old
-- make dummy pfile to prepare the database for startup force nomount option
[oracle@subhen-db02 dbs]$ cat initORCLDB_1.ora
sga_target=4G
db_name=ORCLDB
-- set dbid and startup force nomount from RMAN prompt and restore spfile from autobackup or any valid backup location
[oracle@subhen-db02 dbs]$ . oraenv
ORACLE_SID = [oracle] ? ORCLDB_1
The Oracle base has been set to /oracle/app
[oracle@subhen-db02 dbs]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Apr 17 14:59:41 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> set dbid 783526276
executing command: SET DBID
RMAN> startup force nomount
Oracle instance started
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 822084792 bytes
Database Buffers 3439329280 bytes
Redo Buffers 12132352 bytes
RMAN> restore spfile from '+FRA/ORCLDB/backupset/2013_04_10/ncsnf0_backup_ORCLDB_di_0410130300_0.9694.812386853';
Starting restore at 17-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/ORCLDB/backupset/2013_04_10/ncsnf0_backup_ORCLDB_di_0410130300_0.9694.812386853
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 17-APR-13
-- shutdown and startup again for the spfile to take effect and restore control from autobackup or any valid backup location and mount database
[oracle@subhen-db02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 15:02:53 2013
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> shu immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@subhen-db02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 15:05:31 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 4143972520 bytes
Database Buffers 2231369728 bytes
Redo Buffers 36098048 bytes
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/app/database/11.2.0.3/
dbhome_1/dbs/spfileORCLDB_1.
ora
SQL> exit
[oracle@subhen-db02 dbs]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Apr 17 15:06:02 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLDB (not mounted)
RMAN> set dbid 783526276
executing command: SET DBID
RMAN> restore controlfile from '+FRA/ORCLDB/backupset/2013_04_10/ncsnf0_backup_ORCLDB_di_0410130300_0.9694.812386853';
Starting restore at 17-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=835 instance=ORCLDB_1 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output file name=+DATA/ORCLDB/controlfile/current.819.812991983
output file name=+FRA/ORCLDB/controlfile/current.15606.801246979
Finished restore at 17-APR-13
RMAN> sql 'alter database mount';
sql statement: alter database mount
released channel: ORA_DISK_1
-- restore and reover database from backup
RMAN> restore database
2> ;
Starting restore at 17-APR-13
Starting implicit crosscheck backup at 17-APR-13
allocated channel: ORA_DISK_1
Crosschecked 28 objects
Finished implicit crosscheck backup at 17-APR-13
Starting implicit crosscheck copy at 17-APR-13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 17-APR-13
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_10/ncsnf0_BACKUP_ORCLDB_DI_0410130300_0.9694.812386853
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_10/annnf0_BACKUP_ORCLDB_DI_0410130300_0.9209.812386865
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_10/ncnnf0_BACKUP_ORCLDB_DI_0410130300_0.15191.812386887
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_16/annnf0_BACKUP_ORCLDB_DI_0416130216_0.15334.812902583
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_15/annnf0_BACKUP_ORCLDB_DI_0415130216_0.9957.812816187
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_14/annnf0_BACKUP_ORCLDB_DI_0414130216_0.8798.812729787
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_12/annnf0_BACKUP_ORCLDB_DI_0412130216_0.4151.812557003
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_11/annnf0_BACKUP_ORCLDB_DI_0411130216_0.23705.812470583
File Name: +FRA/ORCLDB/snapcf_dir/ORCLDB.f
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/ORCLDB/datafile/system.3924.801247003
channel ORA_DISK_1: restoring datafile 00002 to +DATA/ORCLDB/datafile/sysaux.3923.801247003
channel ORA_DISK_1: restoring datafile 00003 to +DATA/ORCLDB/datafile/undotbs1.3926.801247003
channel ORA_DISK_1: restoring datafile 00004 to +DATA/ORCLDB/datafile/users.3929.801247003
channel ORA_DISK_1: restoring datafile 00005 to +DATA/ORCLDB/datafile/undotbs2.3928.801247003
channel ORA_DISK_1: restoring datafile 00006 to +DATA/ORCLDB/datafile/undotbs3.3927.801247003
channel ORA_DISK_1: restoring datafile 00007 to +DATA/ORCLDB/datafile/ggate_data.3925.801247003
channel ORA_DISK_1: restoring datafile 00008 to +DATA/ORCLDB/datafile/nwhads_plum.341.801756351
channel ORA_DISK_1: restoring datafile 00009 to +DATA/ORCLDB/datafile/nwhads_ddm1.406.801756537
channel ORA_DISK_1: restoring datafile 00010 to +DATA/ORCLDB/datafile/nwhads_ddm2.347.801756577
channel ORA_DISK_1: restoring datafile 00011 to +DATA/ORCLDB/datafile/nwhads_pah.3157.801756615
channel ORA_DISK_1: restoring datafile 00012 to +DATA/ORCLDB/datafile/superstream.3830.809895841
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_10/nnndf0_backup_ORCLDB_di_0410130300_0.11438.812386815
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_10/nnndf0_backup_ORCLDB_di_0410130300_0.11438.812386815 tag=BACKUP_ORCLDB_DI_041013030001
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 17-APR-13
RMAN> recover database;
Starting recover at 17-APR-13
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 355 is already on disk as file +FRA/ORCLDB/onlinelog/group_7.15602.801247063
archived log for thread 1 with sequence 356 is already on disk as file +FRA/ORCLDB/onlinelog/group_8.6650.801247065
archived log for thread 1 with sequence 357 is already on disk as file +FRA/ORCLDB/onlinelog/group_1.15605.801247059
archived log for thread 1 with sequence 358 is already on disk as file +FRA/ORCLDB/onlinelog/group_2.15467.801247061
archived log for thread 2 with sequence 328 is already on disk as file +FRA/ORCLDB/onlinelog/group_10.7498.801331015
archived log for thread 2 with sequence 329 is already on disk as file +FRA/ORCLDB/onlinelog/group_3.15603.801247047
archived log for thread 2 with sequence 330 is already on disk as file +FRA/ORCLDB/onlinelog/group_4.7512.801247051
archived log for thread 2 with sequence 331 is already on disk as file +FRA/ORCLDB/onlinelog/group_9.15809.801330803
archived log for thread 3 with sequence 298 is already on disk as file +FRA/ORCLDB/onlinelog/group_6.15604.801247055
archived log for thread 3 with sequence 299 is already on disk as file +FRA/ORCLDB/onlinelog/group_11.572.801331045
archived log for thread 3 with sequence 300 is already on disk as file +FRA/ORCLDB/onlinelog/group_12.7522.801331055
archived log for thread 3 with sequence 301 is already on disk as file +FRA/ORCLDB/onlinelog/group_5.15608.801247053
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=287
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=340
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=315
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_10/annnf0_backup_ORCLDB_di_0410130300_0.9209.812386865
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_10/annnf0_backup_ORCLDB_di_0410130300_0.9209.812386865 tag=BACKUP_ORCLDB_DI_041013030001
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_315.19551.812992121 thread=2 sequence=315
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_340.13806.812992121 thread=1 sequence=340
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_287.5203.812992123 thread=3 sequence=287
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_315.19551.812992121 RECID=952 STAMP=812992122
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=316
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=288
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=341
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=289
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=342
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=317
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_11/annnf0_backup_ORCLDB_di_0411130216_0.23705.812470583
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_11/annnf0_backup_ORCLDB_di_0411130216_0.23705.812470583 tag=BACKUP_ORCLDB_DI_041113021603
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_316.1665.812992123 thread=2 sequence=316
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_287.5203.812992123 RECID=954 STAMP=812992122
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_288.11356.812992123 thread=3 sequence=288
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_340.13806.812992121 RECID=953 STAMP=812992122
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_341.17196.812992123 thread=1 sequence=341
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_288.11356.812992123 RECID=957 STAMP=812992128
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_289.17321.812992123 thread=3 sequence=289
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_341.17196.812992123 RECID=959 STAMP=812992130
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_342.19551.812992123 thread=1 sequence=342
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_316.1665.812992123 RECID=958 STAMP=812992128
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_317.13977.812992123 thread=2 sequence=317
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_317.13977.812992123 RECID=956 STAMP=812992127
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=318
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=343
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=290
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=344
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=319
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=345
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=346
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=320
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=291
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_12/annnf0_backup_ORCLDB_di_0412130216_0.4151.812557003
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_12/annnf0_backup_ORCLDB_di_0412130216_0.4151.812557003 tag=BACKUP_ORCLDB_DI_041213021604
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_318.13806.812992145 thread=2 sequence=318
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_342.19551.812992123 RECID=960 STAMP=812992131
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_343.5203.812992145 thread=1 sequence=343
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_289.17321.812992123 RECID=955 STAMP=812992127
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_290.1665.812992145 thread=3 sequence=290
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_343.5203.812992145 RECID=964 STAMP=812992148
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_344.13671.812992147 thread=1 sequence=344
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_319.21419.812992145 thread=2 sequence=319
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_345.18453.812992145 thread=1 sequence=345
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_344.13671.812992147 RECID=962 STAMP=812992147
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_345.18453.812992145 RECID=961 STAMP=812992146
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_318.13806.812992145 RECID=965 STAMP=812992148
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_346.13977.812992143 thread=1 sequence=346
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_319.21419.812992145 RECID=963 STAMP=812992147
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_320.17196.812992145 thread=2 sequence=320
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_290.1665.812992145 RECID=968 STAMP=812992149
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_291.11356.812992145 thread=3 sequence=291
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_346.13977.812992143 RECID=969 STAMP=812992150
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=347
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=292
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=321
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=322
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=348
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=293
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=323
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=324
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=349
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=350
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=294
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=325
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_14/annnf0_backup_ORCLDB_di_0414130216_0.8798.812729787
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_14/annnf0_backup_ORCLDB_di_0414130216_0.8798.812729787 tag=BACKUP_ORCLDB_DI_041413021601
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_347.21419.812992157 thread=1 sequence=347
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_291.11356.812992145 RECID=966 STAMP=812992148
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_292.17321.812992157 thread=3 sequence=292
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_320.17196.812992145 RECID=967 STAMP=812992149
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_321.13671.812992157 thread=2 sequence=321
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_321.13671.812992157 RECID=972 STAMP=812992163
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_322.14387.812992163 thread=2 sequence=322
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_347.21419.812992157 RECID=979 STAMP=812992170
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_348.13977.812992155 thread=1 sequence=348
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_292.17321.812992157 RECID=971 STAMP=812992163
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_293.18453.812992157 thread=3 sequence=293
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_322.14387.812992163 RECID=975 STAMP=812992169
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_323.14434.812992167 thread=2 sequence=323
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_324.3028.812992163 thread=2 sequence=324
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_348.13977.812992155 RECID=981 STAMP=812992173
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_323.14434.812992167 RECID=974 STAMP=812992167
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_349.5203.812992157 thread=1 sequence=349
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_349.5203.812992157 RECID=970 STAMP=812992162
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_350.1665.812992157 thread=1 sequence=350
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_293.18453.812992157 RECID=973 STAMP=812992166
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_294.19551.812992163 thread=3 sequence=294
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_324.3028.812992163 RECID=977 STAMP=812992169
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_325.13806.812992157 thread=2 sequence=325
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_325.13806.812992157 RECID=976 STAMP=812992169
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=326
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=295
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=351
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=327
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=296
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=352
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=353
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=297
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=354
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_15/annnf0_backup_ORCLDB_di_0415130216_0.9957.812816187
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_15/annnf0_backup_ORCLDB_di_0415130216_0.9957.812816187 tag=BACKUP_ORCLDB_DI_041513021602
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_326.13806.812992195 thread=2 sequence=326
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_294.19551.812992163 RECID=978 STAMP=812992170
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_295.3028.812992195 thread=3 sequence=295
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_350.1665.812992157 RECID=980 STAMP=812992172
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_351.18453.812992195 thread=1 sequence=351
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_326.13806.812992195 RECID=990 STAMP=812992199
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_327.14434.812992195 thread=2 sequence=327
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_295.3028.812992195 RECID=989 STAMP=812992198
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_296.13977.812992195 thread=3 sequence=296
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_351.18453.812992195 RECID=988 STAMP=812992198
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_352.14387.812992195 thread=1 sequence=352
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_352.14387.812992195 RECID=987 STAMP=812992196
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_353.17321.812992195 thread=1 sequence=353
archived log file name=+FRA/ORCLDB/onlinelog/group_10.7498.801331015 thread=2 sequence=328
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_353.17321.812992195 RECID=985 STAMP=812992196
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_327.14434.812992195 RECID=982 STAMP=812992195
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_296.13977.812992195 RECID=983 STAMP=812992195
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_297.21419.812992197 thread=3 sequence=297
archived log file name=+FRA/ORCLDB/onlinelog/group_6.15604.801247055 thread=3 sequence=298
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_354.5203.812992195 thread=1 sequence=354
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_354.5203.812992195 RECID=984 STAMP=812992195
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_297.21419.812992197 RECID=986 STAMP=812992196
archived log file name=+FRA/ORCLDB/onlinelog/group_7.15602.801247063 thread=1 sequence=355
archived log file name=+FRA/ORCLDB/onlinelog/group_3.15603.801247047 thread=2 sequence=329
archived log file name=+FRA/ORCLDB/onlinelog/group_11.572.801331045 thread=3 sequence=299
archived log file name=+FRA/ORCLDB/onlinelog/group_8.6650.801247065 thread=1 sequence=356
archived log file name=+FRA/ORCLDB/onlinelog/group_4.7512.801247051 thread=2 sequence=330
archived log file name=+FRA/ORCLDB/onlinelog/group_12.7522.801331055 thread=3 sequence=300
archived log file name=+FRA/ORCLDB/onlinelog/group_1.15605.801247059 thread=1 sequence=357
archived log file name=+FRA/ORCLDB/onlinelog/group_5.15608.801247053 thread=3 sequence=301
archived log file name=+FRA/ORCLDB/onlinelog/group_2.15467.801247061 thread=1 sequence=358
archived log file name=+FRA/ORCLDB/onlinelog/group_9.15809.801330803 thread=2 sequence=331
media recovery complete, elapsed time: 00:00:14
Finished recover at 17-APR-13
RMAN> sql 'alter database open resetlogs';
sql statement: alter database open resetlogs
RMAN> exit
-- login database again and change the spfile location from local to ASM if required as below
[oracle@subhen-db02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 15:11:57 2013
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/app/database/11.2.0.3/
dbhome_1/dbs/spfileORCLDB_1.
ora
SQL> create pfile='/tmp/initORCLDB.ora' from spfile='/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileORCLDB_1.ora';
File created.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
[oracle@subhen-db02 dbs]$ ls -ltr|grep -i ORCLDB
-rw-rwxr--+ 1 oracle oinstall 46 Dec 5 17:20 initORCLDB_2.ora
-rw-rwx---+ 1 oracle oinstall 2560 Dec 5 17:21 orapwORCLDB
-rw-rwxr--+ 1 oracle oinstall 69 Dec 7 16:14 initORCLDB_3.ora
-rw-rwx---+ 1 oracle oinstall 1544 Jan 17 18:42 hc_ORCLDB_2.dat
-rw-rwxr--+ 1 oracle oinstall 69 Jan 17 23:02 initORCLDB_1.ora
-rw-rwx---+ 1 oracle oinstall 1544 Mar 25 11:14 hc_ORCLDB_1.dat
-rw-rwx---+ 1 oracle oinstall 1544 Apr 16 16:32 hc_ORCLDB_3.dat
[oracle@subhen-db02 dbs]$ mv initORCLDB_3.ora initORCLDB_3.ora.old
[oracle@subhen-db02 dbs]$ mv initORCLDB_1.ora initORCLDB_1.ora.old
[oracle@subhen-db02 dbs]$ mv initORCLDB_2.ora initORCLDB_2.ora.old
-- make dummy pfile to prepare the database for startup force nomount option
[oracle@subhen-db02 dbs]$ cat initORCLDB_1.ora
sga_target=4G
db_name=ORCLDB
-- set dbid and startup force nomount from RMAN prompt and restore spfile from autobackup or any valid backup location
[oracle@subhen-db02 dbs]$ . oraenv
ORACLE_SID = [oracle] ? ORCLDB_1
The Oracle base has been set to /oracle/app
[oracle@subhen-db02 dbs]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Apr 17 14:59:41 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> set dbid 783526276
executing command: SET DBID
RMAN> startup force nomount
Oracle instance started
Total System Global Area 4275781632 bytes
Fixed Size 2235208 bytes
Variable Size 822084792 bytes
Database Buffers 3439329280 bytes
Redo Buffers 12132352 bytes
RMAN> restore spfile from '+FRA/ORCLDB/backupset/2013_04_10/ncsnf0_backup_ORCLDB_di_0410130300_0.9694.812386853';
Starting restore at 17-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 device type=DISK
channel ORA_DISK_1: restoring spfile from AUTOBACKUP +FRA/ORCLDB/backupset/2013_04_10/ncsnf0_backup_ORCLDB_di_0410130300_0.9694.812386853
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 17-APR-13
-- shutdown and startup again for the spfile to take effect and restore control from autobackup or any valid backup location and mount database
[oracle@subhen-db02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 15:02:53 2013
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> shu immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@subhen-db02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 15:05:31 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2240344 bytes
Variable Size 4143972520 bytes
Database Buffers 2231369728 bytes
Redo Buffers 36098048 bytes
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/app/database/11.2.0.3/
dbhome_1/dbs/spfileORCLDB_1.
ora
SQL> exit
[oracle@subhen-db02 dbs]$ rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Wed Apr 17 15:06:02 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCLDB (not mounted)
RMAN> set dbid 783526276
executing command: SET DBID
RMAN> restore controlfile from '+FRA/ORCLDB/backupset/2013_04_10/ncsnf0_backup_ORCLDB_di_0410130300_0.9694.812386853';
Starting restore at 17-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=835 instance=ORCLDB_1 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output file name=+DATA/ORCLDB/controlfile/current.819.812991983
output file name=+FRA/ORCLDB/controlfile/current.15606.801246979
Finished restore at 17-APR-13
RMAN> sql 'alter database mount';
sql statement: alter database mount
released channel: ORA_DISK_1
-- restore and reover database from backup
RMAN> restore database
2> ;
Starting restore at 17-APR-13
Starting implicit crosscheck backup at 17-APR-13
allocated channel: ORA_DISK_1
Crosschecked 28 objects
Finished implicit crosscheck backup at 17-APR-13
Starting implicit crosscheck copy at 17-APR-13
using channel ORA_DISK_1
Finished implicit crosscheck copy at 17-APR-13
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_10/ncsnf0_BACKUP_ORCLDB_DI_0410130300_0.9694.812386853
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_10/annnf0_BACKUP_ORCLDB_DI_0410130300_0.9209.812386865
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_10/ncnnf0_BACKUP_ORCLDB_DI_0410130300_0.15191.812386887
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_16/annnf0_BACKUP_ORCLDB_DI_0416130216_0.15334.812902583
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_15/annnf0_BACKUP_ORCLDB_DI_0415130216_0.9957.812816187
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_14/annnf0_BACKUP_ORCLDB_DI_0414130216_0.8798.812729787
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_12/annnf0_BACKUP_ORCLDB_DI_0412130216_0.4151.812557003
File Name: +FRA/ORCLDB/BACKUPSET/2013_04_11/annnf0_BACKUP_ORCLDB_DI_0411130216_0.23705.812470583
File Name: +FRA/ORCLDB/snapcf_dir/ORCLDB.f
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to +DATA/ORCLDB/datafile/system.3924.801247003
channel ORA_DISK_1: restoring datafile 00002 to +DATA/ORCLDB/datafile/sysaux.3923.801247003
channel ORA_DISK_1: restoring datafile 00003 to +DATA/ORCLDB/datafile/undotbs1.3926.801247003
channel ORA_DISK_1: restoring datafile 00004 to +DATA/ORCLDB/datafile/users.3929.801247003
channel ORA_DISK_1: restoring datafile 00005 to +DATA/ORCLDB/datafile/undotbs2.3928.801247003
channel ORA_DISK_1: restoring datafile 00006 to +DATA/ORCLDB/datafile/undotbs3.3927.801247003
channel ORA_DISK_1: restoring datafile 00007 to +DATA/ORCLDB/datafile/ggate_data.3925.801247003
channel ORA_DISK_1: restoring datafile 00008 to +DATA/ORCLDB/datafile/nwhads_plum.341.801756351
channel ORA_DISK_1: restoring datafile 00009 to +DATA/ORCLDB/datafile/nwhads_ddm1.406.801756537
channel ORA_DISK_1: restoring datafile 00010 to +DATA/ORCLDB/datafile/nwhads_ddm2.347.801756577
channel ORA_DISK_1: restoring datafile 00011 to +DATA/ORCLDB/datafile/nwhads_pah.3157.801756615
channel ORA_DISK_1: restoring datafile 00012 to +DATA/ORCLDB/datafile/superstream.3830.809895841
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_10/nnndf0_backup_ORCLDB_di_0410130300_0.11438.812386815
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_10/nnndf0_backup_ORCLDB_di_0410130300_0.11438.812386815 tag=BACKUP_ORCLDB_DI_041013030001
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:46
Finished restore at 17-APR-13
RMAN> recover database;
Starting recover at 17-APR-13
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 355 is already on disk as file +FRA/ORCLDB/onlinelog/group_7.15602.801247063
archived log for thread 1 with sequence 356 is already on disk as file +FRA/ORCLDB/onlinelog/group_8.6650.801247065
archived log for thread 1 with sequence 357 is already on disk as file +FRA/ORCLDB/onlinelog/group_1.15605.801247059
archived log for thread 1 with sequence 358 is already on disk as file +FRA/ORCLDB/onlinelog/group_2.15467.801247061
archived log for thread 2 with sequence 328 is already on disk as file +FRA/ORCLDB/onlinelog/group_10.7498.801331015
archived log for thread 2 with sequence 329 is already on disk as file +FRA/ORCLDB/onlinelog/group_3.15603.801247047
archived log for thread 2 with sequence 330 is already on disk as file +FRA/ORCLDB/onlinelog/group_4.7512.801247051
archived log for thread 2 with sequence 331 is already on disk as file +FRA/ORCLDB/onlinelog/group_9.15809.801330803
archived log for thread 3 with sequence 298 is already on disk as file +FRA/ORCLDB/onlinelog/group_6.15604.801247055
archived log for thread 3 with sequence 299 is already on disk as file +FRA/ORCLDB/onlinelog/group_11.572.801331045
archived log for thread 3 with sequence 300 is already on disk as file +FRA/ORCLDB/onlinelog/group_12.7522.801331055
archived log for thread 3 with sequence 301 is already on disk as file +FRA/ORCLDB/onlinelog/group_5.15608.801247053
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=287
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=340
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=315
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_10/annnf0_backup_ORCLDB_di_0410130300_0.9209.812386865
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_10/annnf0_backup_ORCLDB_di_0410130300_0.9209.812386865 tag=BACKUP_ORCLDB_DI_041013030001
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_315.19551.812992121 thread=2 sequence=315
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_340.13806.812992121 thread=1 sequence=340
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_287.5203.812992123 thread=3 sequence=287
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_315.19551.812992121 RECID=952 STAMP=812992122
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=316
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=288
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=341
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=289
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=342
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=317
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_11/annnf0_backup_ORCLDB_di_0411130216_0.23705.812470583
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_11/annnf0_backup_ORCLDB_di_0411130216_0.23705.812470583 tag=BACKUP_ORCLDB_DI_041113021603
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_316.1665.812992123 thread=2 sequence=316
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_287.5203.812992123 RECID=954 STAMP=812992122
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_288.11356.812992123 thread=3 sequence=288
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_340.13806.812992121 RECID=953 STAMP=812992122
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_341.17196.812992123 thread=1 sequence=341
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_288.11356.812992123 RECID=957 STAMP=812992128
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_289.17321.812992123 thread=3 sequence=289
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_341.17196.812992123 RECID=959 STAMP=812992130
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_342.19551.812992123 thread=1 sequence=342
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_316.1665.812992123 RECID=958 STAMP=812992128
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_317.13977.812992123 thread=2 sequence=317
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_317.13977.812992123 RECID=956 STAMP=812992127
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=318
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=343
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=290
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=344
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=319
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=345
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=346
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=320
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=291
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_12/annnf0_backup_ORCLDB_di_0412130216_0.4151.812557003
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_12/annnf0_backup_ORCLDB_di_0412130216_0.4151.812557003 tag=BACKUP_ORCLDB_DI_041213021604
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_318.13806.812992145 thread=2 sequence=318
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_342.19551.812992123 RECID=960 STAMP=812992131
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_343.5203.812992145 thread=1 sequence=343
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_289.17321.812992123 RECID=955 STAMP=812992127
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_290.1665.812992145 thread=3 sequence=290
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_343.5203.812992145 RECID=964 STAMP=812992148
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_344.13671.812992147 thread=1 sequence=344
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_319.21419.812992145 thread=2 sequence=319
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_345.18453.812992145 thread=1 sequence=345
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_344.13671.812992147 RECID=962 STAMP=812992147
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_345.18453.812992145 RECID=961 STAMP=812992146
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_318.13806.812992145 RECID=965 STAMP=812992148
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_346.13977.812992143 thread=1 sequence=346
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_319.21419.812992145 RECID=963 STAMP=812992147
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_320.17196.812992145 thread=2 sequence=320
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_290.1665.812992145 RECID=968 STAMP=812992149
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_291.11356.812992145 thread=3 sequence=291
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_346.13977.812992143 RECID=969 STAMP=812992150
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=347
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=292
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=321
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=322
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=348
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=293
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=323
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=324
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=349
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=350
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=294
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=325
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_14/annnf0_backup_ORCLDB_di_0414130216_0.8798.812729787
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_14/annnf0_backup_ORCLDB_di_0414130216_0.8798.812729787 tag=BACKUP_ORCLDB_DI_041413021601
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:25
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_347.21419.812992157 thread=1 sequence=347
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_291.11356.812992145 RECID=966 STAMP=812992148
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_292.17321.812992157 thread=3 sequence=292
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_320.17196.812992145 RECID=967 STAMP=812992149
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_321.13671.812992157 thread=2 sequence=321
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_321.13671.812992157 RECID=972 STAMP=812992163
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_322.14387.812992163 thread=2 sequence=322
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_347.21419.812992157 RECID=979 STAMP=812992170
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_348.13977.812992155 thread=1 sequence=348
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_292.17321.812992157 RECID=971 STAMP=812992163
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_293.18453.812992157 thread=3 sequence=293
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_322.14387.812992163 RECID=975 STAMP=812992169
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_323.14434.812992167 thread=2 sequence=323
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_324.3028.812992163 thread=2 sequence=324
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_348.13977.812992155 RECID=981 STAMP=812992173
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_323.14434.812992167 RECID=974 STAMP=812992167
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_349.5203.812992157 thread=1 sequence=349
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_349.5203.812992157 RECID=970 STAMP=812992162
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_350.1665.812992157 thread=1 sequence=350
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_293.18453.812992157 RECID=973 STAMP=812992166
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_294.19551.812992163 thread=3 sequence=294
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_324.3028.812992163 RECID=977 STAMP=812992169
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_325.13806.812992157 thread=2 sequence=325
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_325.13806.812992157 RECID=976 STAMP=812992169
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=326
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=295
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=351
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=327
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=296
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=352
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=353
channel ORA_DISK_1: restoring archived log
archived log thread=3 sequence=297
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=354
channel ORA_DISK_1: reading from backup piece +FRA/ORCLDB/backupset/2013_04_15/annnf0_backup_ORCLDB_di_0415130216_0.9957.812816187
channel ORA_DISK_1: piece handle=+FRA/ORCLDB/backupset/2013_04_15/annnf0_backup_ORCLDB_di_0415130216_0.9957.812816187 tag=BACKUP_ORCLDB_DI_041513021602
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_326.13806.812992195 thread=2 sequence=326
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_294.19551.812992163 RECID=978 STAMP=812992170
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_295.3028.812992195 thread=3 sequence=295
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_350.1665.812992157 RECID=980 STAMP=812992172
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_351.18453.812992195 thread=1 sequence=351
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_326.13806.812992195 RECID=990 STAMP=812992199
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_327.14434.812992195 thread=2 sequence=327
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_295.3028.812992195 RECID=989 STAMP=812992198
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_296.13977.812992195 thread=3 sequence=296
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_351.18453.812992195 RECID=988 STAMP=812992198
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_352.14387.812992195 thread=1 sequence=352
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_352.14387.812992195 RECID=987 STAMP=812992196
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_353.17321.812992195 thread=1 sequence=353
archived log file name=+FRA/ORCLDB/onlinelog/group_10.7498.801331015 thread=2 sequence=328
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_353.17321.812992195 RECID=985 STAMP=812992196
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_2_seq_327.14434.812992195 RECID=982 STAMP=812992195
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_296.13977.812992195 RECID=983 STAMP=812992195
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_297.21419.812992197 thread=3 sequence=297
archived log file name=+FRA/ORCLDB/onlinelog/group_6.15604.801247055 thread=3 sequence=298
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_354.5203.812992195 thread=1 sequence=354
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_1_seq_354.5203.812992195 RECID=984 STAMP=812992195
channel default: deleting archived log(s)
archived log file name=+FRA/ORCLDB/archivelog/2013_04_17/thread_3_seq_297.21419.812992197 RECID=986 STAMP=812992196
archived log file name=+FRA/ORCLDB/onlinelog/group_7.15602.801247063 thread=1 sequence=355
archived log file name=+FRA/ORCLDB/onlinelog/group_3.15603.801247047 thread=2 sequence=329
archived log file name=+FRA/ORCLDB/onlinelog/group_11.572.801331045 thread=3 sequence=299
archived log file name=+FRA/ORCLDB/onlinelog/group_8.6650.801247065 thread=1 sequence=356
archived log file name=+FRA/ORCLDB/onlinelog/group_4.7512.801247051 thread=2 sequence=330
archived log file name=+FRA/ORCLDB/onlinelog/group_12.7522.801331055 thread=3 sequence=300
archived log file name=+FRA/ORCLDB/onlinelog/group_1.15605.801247059 thread=1 sequence=357
archived log file name=+FRA/ORCLDB/onlinelog/group_5.15608.801247053 thread=3 sequence=301
archived log file name=+FRA/ORCLDB/onlinelog/group_2.15467.801247061 thread=1 sequence=358
archived log file name=+FRA/ORCLDB/onlinelog/group_9.15809.801330803 thread=2 sequence=331
media recovery complete, elapsed time: 00:00:14
Finished recover at 17-APR-13
RMAN> sql 'alter database open resetlogs';
sql statement: alter database open resetlogs
RMAN> exit
-- login database again and change the spfile location from local to ASM if required as below
[oracle@subhen-db02 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.3.0 Production on Wed Apr 17 15:11:57 2013
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, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> show parameter pfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /oracle/app/database/11.2.0.3/
dbhome_1/dbs/spfileORCLDB_1.
ora
SQL> create pfile='/tmp/initORCLDB.ora' from spfile='/oracle/app/database/11.2.0.3/dbhome_1/dbs/spfileORCLDB_1.ora';
File created.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
