Oracle RMAN restore until time script

by , under Oracle

When you did any mistake on your Oracle database such as drop tables or drop databases, you can recover it from the backup copy and archive log files with “RMAN restore until time script” as following;

 

 

RMAN> shutdown immediate;

database closed
database dismounted
Oracle instance shut down

RMAN> RUN
2> {
3> startup mount;
4> ALLOCATE CHANNEL c1_restore DEVICE TYPE DISK;
5>
6> set until time= “to_date(’23/09/2015 17:10:00′,’dd/mm/yyyy hh24:mi:ss’)”;
7> RESTORE DATABASE;
8> RECOVER DATABASE;
9> RELEASE CHANNEL c1_restore;
10> }

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area 17771253760 bytes

Fixed Size 2288480 bytes
Variable Size 6777996448 bytes
Database Buffers 10938744832 bytes
Redo Buffers 52224000 bytes

allocated channel: c1_restore
channel c1_restore: SID=263 device type=DISK

executing command: SET until clause

Starting restore at 23-SEP-15

channel c1_restore: starting datafile backup set restore
channel c1_restore: specifying datafile(s) to restore from backup set
channel c1_restore: restoring datafile 00001 to +DATA/limsprod/datafile/system.276.881074097
channel c1_restore: restoring datafile 00002 to +DATA/limsprod/datafile/sysaux.277.881074097
channel c1_restore: restoring datafile 00003 to +DATA/limsprod/datafile/undotbs1.278.881074097
channel c1_restore: restoring datafile 00004 to +DATA/limsprod/datafile/users.279.881074097
channel c1_restore: restoring datafile 00005 to +DATA/limsprod/datafile/lims_archive.286.881076053
channel c1_restore: restoring datafile 00006 to +DATA/limsprod/datafile/lims_base.287.881076073
channel c1_restore: restoring datafile 00007 to +DATA/limsprod/datafile/lims_common.288.881076097
channel c1_restore: restoring datafile 00008 to +DATA/limsprod/datafile/lims_data.289.881076443
channel c1_restore: restoring datafile 00009 to +DATA/limsprod/datafile/lims_data.290.881076535
channel c1_restore: restoring datafile 00010 to +DATA/limsprod/datafile/lims_data.291.881076625
channel c1_restore: restoring datafile 00011 to +DATA/limsprod/datafile/lims_data.292.881076865
channel c1_restore: restoring datafile 00012 to +DATA/limsprod/datafile/lims_data.293.881077055
channel c1_restore: restoring datafile 00013 to +DATA/limsprod/datafile/lims_data.294.881077235
channel c1_restore: restoring datafile 00014 to +DATA/limsprod/datafile/lims_data.295.881077657
channel c1_restore: restoring datafile 00015 to +DATA/limsprod/datafile/lims_data.296.881077735
channel c1_restore: restoring datafile 00016 to +DATA/limsprod/datafile/lims_data.299.881078031
channel c1_restore: restoring datafile 00017 to +DATA/limsprod/datafile/lims_index.300.881078289
channel c1_restore: restoring datafile 00018 to +DATA/limsprod/datafile/lims_index.301.881078439
channel c1_restore: restoring datafile 00019 to +DATA/limsprod/datafile/lims_index.302.881078505
channel c1_restore: restoring datafile 00020 to +DATA/limsprod/datafile/lims_index.303.881078609
channel c1_restore: restoring datafile 00021 to +DATA/limsprod/datafile/lims_index.304.881078723
channel c1_restore: restoring datafile 00022 to +DATA/limsprod/datafile/lims_index.306.881078811
channel c1_restore: restoring datafile 00023 to +DATA/limsprod/datafile/lims_index.308.881078901
channel c1_restore: restoring datafile 00024 to +DATA/limsprod/datafile/lims_index.314.881079053
channel c1_restore: restoring datafile 00025 to +DATA/limsprod/datafile/lims_index.316.881079155
channel c1_restore: restoring datafile 00026 to +DATA/limsprod/datafile/lims_index.324.881079755
channel c1_restore: restoring datafile 00027 to +DATA/limsprod/datafile/lims_index.327.881079851
channel c1_restore: restoring datafile 00028 to +DATA/limsprod/datafile/undotbs1.335.881080165
channel c1_restore: restoring datafile 00029 to +DATA/limsprod/datafile/sysaux.337.883641629
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_1_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_1_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 1
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_2_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_2_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 2
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_3_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_3_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 3
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_4_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_4_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 4
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_5_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_5_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 5
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_6_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_6_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 6
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_7_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_7_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 7
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_8_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_8_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 8
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_9_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_9_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 9
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_10_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_10_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 10
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_11_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_11_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 11
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_12_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_12_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 12
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_13_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_13_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 13
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_14_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_14_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 14
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_15_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_15_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 15
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_16_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_16_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 16
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_17_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_17_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 17
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_18_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_18_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 18
channel c1_restore: reading from backup piece V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_19_891188665
channel c1_restore: piece handle=V:\LIMSPROD\LIMSPROD_FULL_LIMSPROD_G6QHSTDP_19_891188665 tag=TAG20150923T162425
channel c1_restore: restored backup piece 19
channel c1_restore: restore complete, elapsed time: 00:31:19
Finished restore at 23-SEP-15

Starting recover at 23-SEP-15

starting media recovery
media recovery complete, elapsed time: 00:00:10

Finished recover at 23-SEP-15

released channel: c1_restore

RMAN>

PS H:\> sqlplus sys as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Wed Sep 23 19:40:04 2015

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

Enter password:

Connected to:
Oracle Database 11g Release 11.2.0.4.0 – 64bit Production
With the Automatic Storage Management option

19:40:15 limsprod> alter database open resetlogs;

Database altered.

Elapsed: 00:00:20.51
19:40:50 limsprod>

 

 

 

The following log is from the alert log of the database while RMAN is recovering the database.

 

 

Wed Sep 23 19:06:32 2015
Shutting down instance (immediate)
Stopping background process SMCO
Shutting down instance: further logons disabled
Stopping background process QMNC
Wed Sep 23 19:06:34 2015
Stopping background process CJQ0
Stopping background process MMNL
Stopping background process MMON
Wed Sep 23 19:06:43 2015
License high water mark = 111
All dispatchers and shared servers shutdown
alter database close
Wed Sep 23 19:06:49 2015
SMON: disabling tx recovery
SMON: disabling cache recovery
Wed Sep 23 19:06:52 2015
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 45
Shutting down archive processes
Archiving is disabled
Wed Sep 23 19:06:52 2015
ARCH shutting down
ARC2: Archival stopped
Wed Sep 23 19:06:52 2015
NOTE: Deferred communication with ASM instance
Wed Sep 23 19:06:52 2015
ARCH shutting down
Wed Sep 23 19:06:52 2015
ARCH shutting down
ARC0: Archival stopped
Wed Sep 23 19:06:52 2015
ARCH shutting down
ARC3: Archival stopped
ARC1: Archival stopped
Thread 1 closed at log sequence 2231
Successful close of redo thread 1
Wed Sep 23 19:06:55 2015
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 3
Wed Sep 23 19:06:59 2015
Completed: alter database close
alter database dismount
Shutting down archive processes
Archiving is disabled
Wed Sep 23 19:06:59 2015
NOTE: Deferred communication with ASM instance
NOTE: deferred map free for map id 2
Completed: alter database dismount
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Sep 23 19:07:04 2015
NOTE: Database dismounted; ASMB process exiting
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Wed Sep 23 19:07:05 2015
NOTE: Shutting down MARK background process
Wed Sep 23 19:07:05 2015
Stopping background process VKTM
Wed Sep 23 19:07:10 2015
Instance shutdown complete
Wed Sep 23 19:07:53 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Initial number of CPU is 6
Number of processor cores in the system is 6
Number of processor sockets in the system is 2
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
IMODE=BR
ILAT =85
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up:
Oracle Database 11g Release 11.2.0.4.0 – 64bit Production.
Windows NT Version V6.1 Service Pack 1
CPU : 6 – type 8664, 6 Physical Cores
Process Affinity : 0x0x0000000000000000
Memory (Avail/Total): Ph:22985M/36863M, Ph+PgF:41931M/73725M
VM name : VMWare Version (6)
Using parameter settings in server-side pfile C:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITLIMSPROD.ORA
System parameters with non-default values:
processes = 500
sessions = 774
sga_max_size = 17024M
shared_pool_size = 6016M
java_pool_size = 64M
spfile = “+DATA/limsprod/spfilelimsprod.ora”
sga_target = 17024M
memory_target = 18048M
memory_max_target = 18048M
control_files = “+DATA/limsprod/controlfile/current.280.881074207”
db_block_size = 8192
compatible = “11.2.0.4.0”
log_archive_dest_1 = “LOCATION=Z:\oradata\limsprod\arch”
log_archive_format = “ARC%S_%R.%T”
db_create_file_dest = “+DATA”
db_recovery_file_dest = “Z:\oradata\limsprod\fast_recovery_area”
db_recovery_file_dest_size= 4182M
undo_tablespace = “UNDOTBS1”
remote_login_passwordfile= “EXCLUSIVE”
db_domain = “WESTERNFOREST.COM”
dispatchers = “(PROTOCOL=TCP) (SERVICE=LIMSPRODXDB)”
audit_file_dest = “C:\ORACLE\ADMIN\LIMSPROD\ADUMP”
audit_trail = “NONE”
db_name = “LIMSPROD”
open_cursors = 300
pga_aggregate_target = 1000M
optimizer_secure_view_merging= FALSE
diagnostic_dest = “C:\ORACLE”
Wed Sep 23 19:07:54 2015
PMON started with pid=2, OS id=4328
Wed Sep 23 19:07:54 2015
PSP0 started with pid=3, OS id=2820
Wed Sep 23 19:07:55 2015
VKTM started with pid=4, OS id=3084 at elevated priority
VKTM running at (10)millisec precision with DBRM quantum (100)ms
Wed Sep 23 19:07:55 2015
GEN0 started with pid=5, OS id=4556
Wed Sep 23 19:07:55 2015
DIAG started with pid=6, OS id=4856
Wed Sep 23 19:07:55 2015
DBRM started with pid=7, OS id=6032
Wed Sep 23 19:07:55 2015
DIA0 started with pid=8, OS id=6436
Wed Sep 23 19:07:55 2015
MMAN started with pid=9, OS id=3248
Wed Sep 23 19:07:55 2015
DBW0 started with pid=10, OS id=3896
Wed Sep 23 19:07:55 2015
LGWR started with pid=11, OS id=3584
Wed Sep 23 19:07:55 2015
CKPT started with pid=12, OS id=1280
Wed Sep 23 19:07:55 2015
SMON started with pid=13, OS id=6736
Wed Sep 23 19:07:55 2015
RECO started with pid=14, OS id=5536
Wed Sep 23 19:07:55 2015
RBAL started with pid=15, OS id=6316
Wed Sep 23 19:07:55 2015
ASMB started with pid=16, OS id=2604
Wed Sep 23 19:07:55 2015
MMON started with pid=17, OS id=4000
Wed Sep 23 19:07:55 2015
MMNL started with pid=18, OS id=4544
NOTE: initiating MARK startup
Starting background process MARK
Wed Sep 23 19:07:55 2015
MARK started with pid=19, OS id=6328
NOTE: MARK has subscribed
starting up 1 dispatcher(s) for network address ‘(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))’…
starting up 1 shared server(s) …
ORACLE_BASE from environment = C:\Oracle
Wed Sep 23 19:07:57 2015
ALTER SYSTEM SET local_listener=’ (ADDRESS=(PROTOCOL=TCP)(HOST=10.102.248.172)(PORT=1521))’ SCOPE=MEMORY SID=’limsprod’;
Wed Sep 23 19:07:58 2015
alter database mount
NOTE: Loaded library: System
SUCCESS: diskgroup DATA was mounted
NOTE: dependency between database LIMSPROD and diskgroup resource ora.DATA.dg is established
Successful mount of redo thread 1, with mount id 1278723982
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Wed Sep 23 19:18:29 2015
Full restore complete of datafile 3 +DATA/limsprod/datafile/undotbs1.278.881074097. Elapsed time: 0:10:21
checkpoint is 4298719146844
last deallocation scn is 3
Undo Optimization current scn is 4298719137466
Full restore complete of datafile 8 +DATA/limsprod/datafile/lims_data.289.881076443. Elapsed time: 0:10:23
checkpoint is 4298719146844
Full restore complete of datafile 9 +DATA/limsprod/datafile/lims_data.290.881076535. Elapsed time: 0:10:23
checkpoint is 4298719146844
Full restore complete of datafile 10 +DATA/limsprod/datafile/lims_data.291.881076625. Elapsed time: 0:10:27
checkpoint is 4298719146844
Full restore complete of datafile 11 +DATA/limsprod/datafile/lims_data.292.881076865. Elapsed time: 0:10:30
checkpoint is 4298719146844
Wed Sep 23 19:18:43 2015
Full restore complete of datafile 12 +DATA/limsprod/datafile/lims_data.293.881077055. Elapsed time: 0:10:35
checkpoint is 4298719146844
Full restore complete of datafile 13 +DATA/limsprod/datafile/lims_data.294.881077235. Elapsed time: 0:10:39
checkpoint is 4298719146844
Full restore complete of datafile 14 +DATA/limsprod/datafile/lims_data.295.881077657. Elapsed time: 0:10:43
checkpoint is 4298719146844
Wed Sep 23 19:22:59 2015
db_recovery_file_dest_size of 4182 MB is 0.00% used. This is a
user-specified limit on the amount of space that will be used by this
database for recovery-related files, and does not reflect the amount of
space available in the underlying filesystem or ASM diskgroup.
Wed Sep 23 19:28:35 2015
Full restore complete of datafile 15 +DATA/limsprod/datafile/lims_data.296.881077735. Elapsed time: 0:10:06
checkpoint is 4298719146844
Full restore complete of datafile 16 +DATA/limsprod/datafile/lims_data.299.881078031. Elapsed time: 0:10:07
checkpoint is 4298719146844
Full restore complete of datafile 17 +DATA/limsprod/datafile/lims_index.300.881078289. Elapsed time: 0:10:07
checkpoint is 4298719146844
Wed Sep 23 19:28:48 2015
Full restore complete of datafile 18 +DATA/limsprod/datafile/lims_index.301.881078439. Elapsed time: 0:10:13
checkpoint is 4298719146844
Wed Sep 23 19:28:58 2015
Full restore complete of datafile 19 +DATA/limsprod/datafile/lims_index.302.881078505. Elapsed time: 0:10:20
checkpoint is 4298719146844
Full restore complete of datafile 20 +DATA/limsprod/datafile/lims_index.303.881078609. Elapsed time: 0:10:25
checkpoint is 4298719146844
Wed Sep 23 19:29:18 2015
Full restore complete of datafile 21 +DATA/limsprod/datafile/lims_index.304.881078723. Elapsed time: 0:10:31
checkpoint is 4298719146844
Full restore complete of datafile 22 +DATA/limsprod/datafile/lims_index.306.881078811. Elapsed time: 0:10:35
checkpoint is 4298719146844
Wed Sep 23 19:31:37 2015
Full restore complete of datafile 6 +DATA/limsprod/datafile/lims_base.287.881076073. Elapsed time: 0:02:11
checkpoint is 4298719146844
Wed Sep 23 19:33:39 2015
Full restore complete of datafile 7 +DATA/limsprod/datafile/lims_common.288.881076097. Elapsed time: 0:02:02
checkpoint is 4298719146844
Wed Sep 23 19:35:51 2015
Full restore complete of datafile 27 +DATA/limsprod/datafile/lims_index.327.881079851. Elapsed time: 0:02:12
checkpoint is 4298719146844
Wed Sep 23 19:37:06 2015
Full restore complete of datafile 1 +DATA/limsprod/datafile/system.276.881074097. Elapsed time: 0:01:15
checkpoint is 4298719146844
last deallocation scn is 895285
Undo Optimization current scn is 4298719142269
Full restore complete of datafile 4 +DATA/limsprod/datafile/users.279.881074097. Elapsed time: 0:00:03
checkpoint is 4298719146844
last deallocation scn is 3
Full restore complete of datafile 5 +DATA/limsprod/datafile/lims_archive.286.881076053. Elapsed time: 0:00:01
checkpoint is 4298719146844
Wed Sep 23 19:38:28 2015
Full restore complete of datafile 2 +DATA/limsprod/datafile/sysaux.277.881074097. Elapsed time: 0:09:20
checkpoint is 4298719146844
last deallocation scn is 896771
Full restore complete of datafile 29 +DATA/limsprod/datafile/sysaux.337.883641629. Elapsed time: 0:09:10
checkpoint is 4298719146844
Wed Sep 23 19:38:57 2015
Full restore complete of datafile 23 +DATA/limsprod/datafile/lims_index.308.881078901. Elapsed time: 0:10:22
checkpoint is 4298719146844
Full restore complete of datafile 24 +DATA/limsprod/datafile/lims_index.314.881079053. Elapsed time: 0:10:19
checkpoint is 4298719146844
Full restore complete of datafile 25 +DATA/limsprod/datafile/lims_index.316.881079155. Elapsed time: 0:10:19
checkpoint is 4298719146844
Full restore complete of datafile 26 +DATA/limsprod/datafile/lims_index.324.881079755. Elapsed time: 0:10:09
checkpoint is 4298719146844
Wed Sep 23 19:39:27 2015
Full restore complete of datafile 28 +DATA/limsprod/datafile/undotbs1.335.881080165. Elapsed time: 0:10:29
checkpoint is 4298719146844
Undo Optimization current scn is 4298719142501
Wed Sep 23 19:39:29 2015
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15 , 16 , 17 , 18 , 19 , 20
alter database recover datafile list
21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29
Completed: alter database recover datafile list
21 , 22 , 23 , 24 , 25 , 26 , 27 , 28 , 29
alter database recover if needed
start until time ‘SEP 23 2015 17:10:00’
Media Recovery Start
started logmerger process
Parallel Media Recovery started with 6 slaves
Wed Sep 23 19:39:30 2015
Recovery of Online Redo Log: Thread 1 Group 3 Seq 2229 Reading mem 0
Mem# 0: +DATA/limsprod/onlinelog/group_3.283.881074219
Incomplete Recovery applied until change 4298719150809 time 09/23/2015 17:10:00
Completed: alter database recover if needed
start until time ‘SEP 23 2015 17:10:00’
Wed Sep 23 19:40:14 2015
alter database open
Errors in file C:\ORACLE\diag\rdbms\limsprod\limsprod\trace\limsprod_ora_5844.trc:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
ORA-1589 signalled during: alter database open…
Wed Sep 23 19:40:30 2015
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 4298719150809
Archived Log entry 2223 added for thread 1 sequence 2231 ID 0x4b9dee9c dest 1:
Resetting resetlogs activation ID 1268641436 (0x4b9dee9c)
Deleted Oracle managed file +DATA/limsprod/onlinelog/group_1.281.881074211
Deleted Oracle managed file +DATA/limsprod/onlinelog/group_2.282.881074215
Deleted Oracle managed file +DATA/limsprod/onlinelog/group_3.283.881074219
Wed Sep 23 19:40:38 2015
Setting recovery target incarnation to 3
Wed Sep 23 19:40:38 2015
Assigning activation ID 1278723982 (0x4c37c78e)
LGWR: STARTING ARCH PROCESSES
Wed Sep 23 19:40:38 2015
ARC0 started with pid=28, OS id=7032
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Wed Sep 23 19:40:39 2015
ARC1 started with pid=29, OS id=3480
Wed Sep 23 19:40:39 2015
ARC2 started with pid=30, OS id=6808
Wed Sep 23 19:40:39 2015
ARC3 started with pid=31, OS id=5348
ARC1: Archival started
ARC2: Archival started
Thread 1 opened at log sequence 1
Current log# 1 seq# 1 mem# 0: +DATA/limsprod/onlinelog/group_1.281.891200433
Current log# 1 seq# 1 mem# 1: Z:\ORADATA\LIMSPROD\FAST_RECOVERY_AREA\LIMSPROD\ONLINELOG\O1_MF_1_C06RO13Z_.LOG
Successful open of redo thread 1
ARC1: Becoming the ‘no FAL’ ARCH
ARC1: Becoming the ‘no SRL’ ARCH
ARC2: Becoming the heartbeat ARCH
Wed Sep 23 19:40:40 2015
SMON: enabling cache recovery
ARC3: Archival started
Wed Sep 23 19:40:41 2015
[5844] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:910193872 end:910194371 diff:499 (4 seconds)
ARC0: STARTING ARCH PROCESSES COMPLETE
Dictionary check beginning
Dictionary check complete
Verifying file header compatibility for 11g tablespace encryption..
Verifying 11g file header compatibility for tablespace encryption completed
SMON: enabling tx recovery
Database Characterset is WE8MSWIN1252
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Wed Sep 23 19:40:44 2015
QMNC started with pid=32, OS id=4444
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Completed: alter database open resetlogs
Wed Sep 23 19:40:51 2015
Starting background process CJQ0
Wed Sep 23 19:40:51 2015
CJQ0 started with pid=33, OS id=4520

Leave a Reply