Before deleting the entire database files for simulating the scenario I ensured I have a full database backup which I took some time back.
C:\Users\Mahi>set ORACLE_SID=ORCL
C:\Users\Mahi>rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Sun Sep 24 19:19:13 2017
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1482239337)
RMAN> list backup summary ;
using target database control file instead of recovery catalog
List of Backups
===============
Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- --------------- ------- ------- ---------- ---
1 B A X DISK 12-SEP-17 1 1 NO TAG20170912T225210
2 B A A DISK 12-SEP-17 1 1 NO TAG20170912T225432
3 B F A DISK 12-SEP-17 1 1 NO TAG20170912T225434
4 B A A DISK 13-SEP-17 1 1 NO TAG20170913T221354
5 B A A DISK 13-SEP-17 1 1 NO TAG20170913T221354
6 B A A DISK 13-SEP-17 1 1 NO TAG20170913T222738
7 B A A DISK 13-SEP-17 1 1 NO TAG20170913T222738
8 B A A DISK 13-SEP-17 1 1 NO TAG20170913T223828
9 B A A DISK 13-SEP-17 1 1 NO TAG20170913T223828
10 B A A DISK 13-SEP-17 1 1 NO TAG20170913T223828
11 B A A DISK 13-SEP-17 1 1 NO TAG20170913T223828
12 B F A DISK 18-SEP-17 1 1 NO TAG20170918T215104
13 B F A DISK 18-SEP-17 1 1 NO TAG20170918T215210
14 B F A DISK 19-SEP-17 1 1 NO TAG20170919T223124
15 B F A DISK 19-SEP-17 1 1 NO TAG20170919T223221
16 B F A DISK 20-SEP-17 1 1 NO TAG20170920T093037
17 B F A DISK 20-SEP-17 1 1 NO TAG20170920T093037
18 B F A DISK 20-SEP-17 1 1 NO TAG20170920T093037
19 B F A DISK 20-SEP-17 1 1 NO TAG20170920T093234
RMAN> show all;
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 3 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'E:\Rman\Backup_%d_set%s_piece%p_%T_%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'E:\APP\MAHI\PRODUCT\12.1.0\DBHOME_3\DATABASE\SNCFORCL.ORA'; # default
RMAN> exit
Recovery Manager complete.
I haven't enabled FRA for my database also I enabled CONTROLFILE AUTOBACKUP ON. So default location of controlfile autobackup will be $ORACLE_HOME/database(for windows).
C:\Users\Mahi>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 24 19:20:17 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string
db_recovery_file_dest_size big integer 6930M
recovery_parallelism integer 0
SQL>
SQL> select name from v$controlfile;
NAME
--------------------------------------------------------------------------------
E:\ORADATA\ORCL\CONTROL01.CTL
E:\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL
SQL> select member from v$logfile;
MEMBER
--------------------------------------------------------------------------------
E:\ORADATA\ORCL\REDO03.LOG
E:\ORADATA\ORCL\REDO02.LOG
E:\ORADATA\ORCL\REDO01.LOG
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------
E:\ORADATA\ORCL\SYSTEM01.DBF
E:\ORADATA\ORCL\EXAMPLE01.DBF
E:\ORADATA\ORCL\SYSAUX01.DBF
E:\ORADATA\ORCL\UNDOTBS01.DBF
E:\ORADATA\ORCL\USERS01.DBF
SQL> select name from v$tempfile;
NAME
--------------------------------------------------------------------------------
E:\ORADATA\ORCL\TEMP01.DBF
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination E:\archive\
Oldest online log sequence 17
Next log sequence to archive 19
Current log sequence 19
Let's do some transaction and generate archive logs for that.
SQL> create table emp as select * from hr.employees ;
Table created.
SQL>
SQL> select count(*) from emp;
COUNT(*)
----------
107
SQL> alter system switch logfile;
System altered.
SQL> update emp set SALARY=10000;
107 rows updated.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
System altered.
SQL> update emp set SALARY=555555;
107 rows updated.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
System altered.
SQL> select sum(salary) from emp;
SUM(SALARY)
-----------
59444385
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Take the entire archivelog backup and delete it - as we have enabled controlfile autobackup the controlfile will automatically backed up at the end of the archivelog bakcup .
C:\Users\Mahi>rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Sun Sep 24 19:29:27 2017
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1482239337)
RMAN> backup archivelog all delete input;
Starting backup at 24-SEP-17
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=373 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=15 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=134 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=12 RECID=9 STAMP=954542282
input archived log thread=1 sequence=13 RECID=10 STAMP=954542321
input archived log thread=1 sequence=14 RECID=11 STAMP=954542322
input archived log thread=1 sequence=15 RECID=22 STAMP=954628034
input archived log thread=1 sequence=16 RECID=23 STAMP=954628034
input archived log thread=1 sequence=17 RECID=24 STAMP=954628034
input archived log thread=1 sequence=18 RECID=25 STAMP=954628034
input archived log thread=1 sequence=19 RECID=26 STAMP=954628034
input archived log thread=1 sequence=20 RECID=27 STAMP=954628034
channel ORA_DISK_1: starting piece 1 at 24-SEP-17
channel ORA_DISK_2: starting archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=18 STAMP=954626630
input archived log thread=1 sequence=2 RECID=19 STAMP=954627226
input archived log thread=1 sequence=3 RECID=20 STAMP=954627378
input archived log thread=1 sequence=4 RECID=21 STAMP=954627507
input archived log thread=1 sequence=5 RECID=28 STAMP=954628058
input archived log thread=1 sequence=6 RECID=29 STAMP=954628707
input archived log thread=1 sequence=7 RECID=30 STAMP=954628880
input archived log thread=1 sequence=8 RECID=31 STAMP=955057332
input archived log thread=1 sequence=9 RECID=32 STAMP=955144317
input archived log thread=1 sequence=10 RECID=33 STAMP=955145066
channel ORA_DISK_2: starting piece 1 at 24-SEP-17
channel ORA_DISK_3: starting archived log backup set
channel ORA_DISK_3: specifying archived log(s) in backup set
input archived log thread=1 sequence=11 RECID=34 STAMP=955146500
input archived log thread=1 sequence=12 RECID=35 STAMP=955146628
input archived log thread=1 sequence=13 RECID=36 STAMP=955147900
input archived log thread=1 sequence=14 RECID=37 STAMP=955184978
input archived log thread=1 sequence=15 RECID=38 STAMP=955185627
input archived log thread=1 sequence=16 RECID=39 STAMP=955231812
input archived log thread=1 sequence=17 RECID=40 STAMP=955490250
input archived log thread=1 sequence=18 RECID=41 STAMP=955566481
input archived log thread=1 sequence=19 RECID=42 STAMP=955567686
channel ORA_DISK_3: starting piece 1 at 24-SEP-17
channel ORA_DISK_1: finished piece 1 at 24-SEP-17
piece handle=E:\RMAN\BACKUP_ORCL_SET23_PIECE1_20170924_0NSF9JO9_1_1 tag=TAG20170924T193118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:12
channel ORA_DISK_1: deleting archived log(s)
archived log file name=E:\ARCHIVE\ORCL_1_12_954458606.ARC RECID=9 STAMP=954542282
archived log file name=E:\ARCHIVE\ORCL_1_13_954458606.ARC RECID=10 STAMP=954542321
archived log file name=E:\ARCHIVE\ORCL_1_14_954458606.ARC RECID=11 STAMP=954542322
archived log file name=E:\ARCHIVE\OLD\ORCL_1_15_954458606.ARC RECID=22 STAMP=954628034
archived log file name=E:\ARCHIVE\OLD\ORCL_1_16_954458606.ARC RECID=23 STAMP=954628034
archived log file name=E:\ARCHIVE\OLD\ORCL_1_17_954458606.ARC RECID=24 STAMP=954628034
archived log file name=E:\ARCHIVE\OLD\ORCL_1_18_954458606.ARC RECID=25 STAMP=954628034
archived log file name=E:\ARCHIVE\OLD\ORCL_1_19_954458606.ARC RECID=26 STAMP=954628034
archived log file name=E:\ARCHIVE\OLD\ORCL_1_20_954458606.ARC RECID=27 STAMP=954628034
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20 RECID=43 STAMP=955567722
input archived log thread=1 sequence=21 RECID=44 STAMP=955567745
input archived log thread=1 sequence=22 RECID=45 STAMP=955567877
channel ORA_DISK_1: starting piece 1 at 24-SEP-17
channel ORA_DISK_2: finished piece 1 at 24-SEP-17
piece handle=E:\RMAN\BACKUP_ORCL_SET24_PIECE1_20170924_0OSF9JO9_1_1 tag=TAG20170924T193118 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:21
channel ORA_DISK_2: deleting archived log(s)
archived log file name=E:\ARCHIVE\ORCL_1_1_954582352.ARC RECID=18 STAMP=954626630
archived log file name=E:\ARCHIVE\ORCL_1_2_954582352.ARC RECID=19 STAMP=954627226
archived log file name=E:\ARCHIVE\ORCL_1_3_954582352.ARC RECID=20 STAMP=954627378
archived log file name=E:\ARCHIVE\ORCL_1_4_954582352.ARC RECID=21 STAMP=954627507
archived log file name=E:\ARCHIVE\ORCL_1_5_954582352.ARC RECID=28 STAMP=954628058
archived log file name=E:\ARCHIVE\ORCL_1_6_954582352.ARC RECID=29 STAMP=954628707
archived log file name=E:\ARCHIVE\ORCL_1_7_954582352.ARC RECID=30 STAMP=954628880
archived log file name=E:\ARCHIVE\ORCL_1_8_954582352.ARC RECID=31 STAMP=955057332
archived log file name=E:\ARCHIVE\ORCL_1_9_954582352.ARC RECID=32 STAMP=955144317
archived log file name=E:\ARCHIVE\ORCL_1_10_954582352.ARC RECID=33 STAMP=955145066
channel ORA_DISK_3: finished piece 1 at 24-SEP-17
piece handle=E:\RMAN\BACKUP_ORCL_SET25_PIECE1_20170924_0PSF9JOB_1_1 tag=TAG20170924T193118 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:12
channel ORA_DISK_3: deleting archived log(s)
archived log file name=E:\ARCHIVE\ORCL_1_11_954582352.ARC RECID=34 STAMP=955146500
archived log file name=E:\ARCHIVE\ORCL_1_12_954582352.ARC RECID=35 STAMP=955146628
archived log file name=E:\ARCHIVE\ORCL_1_13_954582352.ARC RECID=36 STAMP=955147900
archived log file name=E:\ARCHIVE\ORCL_1_14_954582352.ARC RECID=37 STAMP=955184978
archived log file name=E:\ARCHIVE\ORCL_1_15_954582352.ARC RECID=38 STAMP=955185627
archived log file name=E:\ARCHIVE\ORCL_1_16_954582352.ARC RECID=39 STAMP=955231812
archived log file name=E:\ARCHIVE\ORCL_1_17_954582352.ARC RECID=40 STAMP=955490250
archived log file name=E:\ARCHIVE\ORCL_1_18_954582352.ARC RECID=41 STAMP=955566481
archived log file name=E:\ARCHIVE\ORCL_1_19_954582352.ARC RECID=42 STAMP=955567686
channel ORA_DISK_1: finished piece 1 at 24-SEP-17
piece handle=E:\RMAN\BACKUP_ORCL_SET26_PIECE1_20170924_0QSF9JOV_1_1 tag=TAG20170924T193118 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=E:\ARCHIVE\ORCL_1_20_954582352.ARC RECID=43 STAMP=955567722
archived log file name=E:\ARCHIVE\ORCL_1_21_954582352.ARC RECID=44 STAMP=955567745
archived log file name=E:\ARCHIVE\ORCL_1_22_954582352.ARC RECID=45 STAMP=955567877
Finished backup at 24-SEP-17
Starting Control File and SPFILE Autobackup at 24-SEP-17
piece handle=E:\APP\MAHI\PRODUCT\12.1.0\DBHOME_3\DATABASE\C-1482239337-20170924-00 comment=NONE
Finished Control File and SPFILE Autobackup at 24-SEP-17
RMAN> exit
Recovery Manager complete.
C:\Users\Mahi>sqlplus / as sysdba
SQL*Plus: Release 12.1.0.1.0 Production on Sun Sep 24 19:36:38 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> shut abort;
ORACLE instance shut down.
SQL>
Now I will delete all my database files
E:\oradata\ORCL>del *
E:\oradata\ORCL\*, Are you sure (Y/N)? Y
E:\fast_recovery_area\ORCL>del CONTROL02.CTL
E:\app\Mahi\product\12.1.0\dbhome_3\database>del SPFILEORCL.ORA
We lost everything. Now we will recover SPFILE/controlfile from autobackup , as I haven't enabled FRA my autobackup goes to $ORACLE_HOME/database directory.
E:\app\Mahi\product\12.1.0\dbhome_3\database>dir
Volume in drive E is New Volume
Volume Serial Number is 0AF9-618D
Directory of E:\app\Mahi\product\12.1.0\dbhome_3\database
09/24/2017 07:47 PM <DIR> .
09/24/2017 07:47 PM <DIR> ..
09/11/2017 10:38 PM <DIR> archive
09/19/2017 10:32 PM 10,223,616 C-1482239337-20170919-00
09/24/2017 07:31 PM 10,223,616 C-1482239337-20170924-00
09/11/2017 10:52 PM 2,048 hc_orcl.dat
12/22/2005 04:07 AM 31,744 oradba.exe
09/24/2017 07:09 PM 1,763 oradim.log
09/11/2017 11:37 PM 7,680 PWDorcl.ora
09/24/2017 07:31 PM 10,141,696 SNCFORCL.ORA
8 File(s) 30,635,747 bytes
3 Dir(s) 51,603,574,784 bytes free
E:\app\Mahi\product\12.1.0\dbhome_3\database>
C:\Users\Mahi>set ORACLE_SID=ORCL
C:\Users\Mahi>rman target /
Recovery Manager: Release 12.1.0.1.0 - Production on Sun Sep 24 19:50:39 2017
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'E:\APP\MAHI\PRODUCT\12.1.0\DBHOME_3\DATABASE\INITORCL.ORA'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 1068937216 bytes
Fixed Size 2410864 bytes
Variable Size 293602960 bytes
Database Buffers 767557632 bytes
Redo Buffers 5365760 bytes
RMAN> restore spfile from autobackup;
Starting restore at 24-SEP-17
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=169 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/24/2017 19:51:33
RMAN-06495: must explicitly specify DBID with SET DBID command
So for restoring SPFILE from autobacup(and autobackup is in default location) you need to specify SET DBID command. By specifying the DBID you instruct oracle to search for matching autobackup from it's default location . Keep in mind By default, the format of the autobackup file for all configured devices is the substitution variable %F. This variable format translates into c-IIIIIIIIII-YYYYMMDD-QQ, where:
IIIIIIIIII stands for the DBID.RMAN> set dbid 1482239337;
executing command: SET DBID
RMAN> restore spfile from autobackup;
Starting restore at 24-SEP-17
using channel ORA_DISK_1
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170924
channel ORA_DISK_1: AUTOBACKUP found: c-1482239337-20170924-00
channel ORA_DISK_1: restoring spfile from AUTOBACKUP c-1482239337-20170924-00
channel ORA_DISK_1: SPFILE restore from AUTOBACKUP complete
Finished restore at 24-SEP-17
RMAN> shutdown;
Oracle instance shut down
RMAN> startup nomount;
connected to target database (not started)
Oracle instance started
Total System Global Area 626327552 bytes
Fixed Size 2405760 bytes
Variable Size 507513472 bytes
Database Buffers 109051904 bytes
Redo Buffers 7356416 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 24-SEP-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5 device type=DISK
channel ORA_DISK_1: looking for AUTOBACKUP on day: 20170924
channel ORA_DISK_1: AUTOBACKUP found: c-1482239337-20170924-00
channel ORA_DISK_1: restoring control file from AUTOBACKUP c-1482239337-20170924-00
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=E:\ORADATA\ORCL\CONTROL01.CTL
output file name=E:\FAST_RECOVERY_AREA\ORCL\CONTROL02.CTL
Finished restore at 24-SEP-17
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> restore database ;
Starting restore at 24-SEP-17
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=123 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=244 device type=DISK
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 00002 to E:\ORADATA\ORCL\EXAMPLE01.DBF
channel ORA_DISK_1: restoring datafile 00005 to E:\ORADATA\ORCL\UNDOTBS01.DBF
channel ORA_DISK_1: reading from backup piece E:\RMAN\BACKUP_ORCL_SET19_PIECE1_20170920_0JSETV1U_1_1
channel ORA_DISK_2: starting datafile backup set restore
channel ORA_DISK_2: specifying datafile(s) to restore from backup set
channel ORA_DISK_2: restoring datafile 00001 to E:\ORADATA\ORCL\SYSTEM01.DBF
channel ORA_DISK_2: reading from backup piece E:\RMAN\BACKUP_ORCL_SET20_PIECE1_20170920_0KSETV1U_1_1
channel ORA_DISK_3: starting datafile backup set restore
channel ORA_DISK_3: specifying datafile(s) to restore from backup set
channel ORA_DISK_3: restoring datafile 00003 to E:\ORADATA\ORCL\SYSAUX01.DBF
channel ORA_DISK_3: restoring datafile 00006 to E:\ORADATA\ORCL\USERS01.DBF
channel ORA_DISK_3: reading from backup piece E:\RMAN\BACKUP_ORCL_SET21_PIECE1_20170920_0LSETV1V_1_1
channel ORA_DISK_1: piece handle=E:\RMAN\BACKUP_ORCL_SET19_PIECE1_20170920_0JSETV1U_1_1 tag=TAG20170920T093037
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:57
channel ORA_DISK_2: piece handle=E:\RMAN\BACKUP_ORCL_SET20_PIECE1_20170920_0KSETV1U_1_1 tag=TAG20170920T093037
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:01:57
channel ORA_DISK_3: piece handle=E:\RMAN\BACKUP_ORCL_SET21_PIECE1_20170920_0LSETV1V_1_1 tag=TAG20170920T093037
channel ORA_DISK_3: restored backup piece 1
channel ORA_DISK_3: restore complete, elapsed time: 00:01:57
Finished restore at 24-SEP-17
RMAN> recover database ;
Starting recover at 24-SEP-17
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=16
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=17
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=18
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=19
channel ORA_DISK_1: reading from backup piece E:\RMAN\BACKUP_ORCL_SET25_PIECE1_20170924_0PSF9JOB_1_1
channel ORA_DISK_2: starting archived log restore to default destination
channel ORA_DISK_2: restoring archived log
archived log thread=1 sequence=20
channel ORA_DISK_2: restoring archived log
archived log thread=1 sequence=21
channel ORA_DISK_2: restoring archived log
archived log thread=1 sequence=22
channel ORA_DISK_2: reading from backup piece E:\RMAN\BACKUP_ORCL_SET26_PIECE1_20170924_0QSF9JOV_1_1
channel ORA_DISK_2: piece handle=E:\RMAN\BACKUP_ORCL_SET26_PIECE1_20170924_0QSF9JOV_1_1 tag=TAG20170924T193118
channel ORA_DISK_2: restored backup piece 1
channel ORA_DISK_2: restore complete, elapsed time: 00:00:07
channel ORA_DISK_1: piece handle=E:\RMAN\BACKUP_ORCL_SET25_PIECE1_20170924_0PSF9JOB_1_1 tag=TAG20170924T193118
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived log file name=E:\ARCHIVE\ORCL_1_16_954582352.ARC thread=1 sequence=16
archived log file name=E:\ARCHIVE\ORCL_1_17_954582352.ARC thread=1 sequence=17
archived log file name=E:\ARCHIVE\ORCL_1_18_954582352.ARC thread=1 sequence=18
archived log file name=E:\ARCHIVE\ORCL_1_19_954582352.ARC thread=1 sequence=19
archived log file name=E:\ARCHIVE\ORCL_1_20_954582352.ARC thread=1 sequence=20
archived log file name=E:\ARCHIVE\ORCL_1_21_954582352.ARC thread=1 sequence=21
archived log file name=E:\ARCHIVE\ORCL_1_22_954582352.ARC thread=1 sequence=22
archived log file name=E:\ARCHIVE\ORCL_1_23_954582352.ARC thread=1 sequence=23
unable to find archived log
archived log thread=1 sequence=24
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/24/2017 20:02:14
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 24 and starting SCN of 2697270
RMAN> alter database open resetlogs;
Statement processed
RMAN> select sum(salary) from emp;
SUM(SALARY)
-----------
59444385
RMAN>
So my data is intact after recovery.
No comments:
Post a Comment