Point-in-time recovery used by AVAMAR


Sqlplus "/ as sysdba";
Shut immediate
startup nomount
RMAN> @@ABSTEST-72.tmp
2> connect target *;
3> **end-of-file**
4> run {
5> allocate channel c0 type sbt PARMS="SBT_LIBRARY=/opt/AVMRclnt/lib/libobk_avamar64.so" format '%d_%U';
6> send channel 'c0' '"--libport=45603" "--cacheprefix=ABSTEST_c0" "--sysdir=/opt/AVMRclnt/etc" "--bindir=/opt/AVMRclnt/bin" "--vardir=/opt/AVMRclnt/var/clientlogs" "--logfile=/opt/AVMRclnt/var/clientlogs/MOD-1455616226902-2002-OracleABSTEST-avtar.log0" "--ctlcallport=45201"';
7> set until scn 884703403597;
8> restore database;
9> recover database;
10> }
11> alter database open resetlogs;
12>
Tue Feb 16 15:04:19 2016
alter database mount
Tue Feb 16 15:04:23 2016
Successful mount of redo thread 1, with mount id 958204531
Database mounted in Exclusive Mode
Lost write protection disabled
Completed: alter database mount
Tue Feb 16 15:06:46 2016
db_recovery_file_dest_size of 10240 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.
Tue Feb 16 15:07:25 2016
Errors in file /u01/app/oracle/diag/rdbms/abstest/ABSTEST/trace/ABSTEST_ora_28526.trc:
ORA-19930: file /u01/app/oracle/fast_recovery_area/ABSTEST/control02.ctl has invalid checkpoint SCN 0
Tue Feb 16 15:30:02 2016
Full restore complete of datafile 12 /data/ABSTEST/TBL_DATA02.dbf. Elapsed time: 0:21:23 
 checkpoint is 884703300139
Tue Feb 16 15:57:45 2016
Full restore complete of datafile 13 /data/ABSTEST/TBL_INDEX03.dbf. Elapsed time: 0:25:59 
 checkpoint is 884703301047
Tue Feb 16 16:36:41 2016
Full restore complete of datafile 5 /data/ABSTEST/data01.dbf. Elapsed time: 0:38:04 
 checkpoint is 884703301050
Tue Feb 16 16:59:11 2016
Full restore complete of datafile 7 /data/ABSTEST/data/data02.dbf. Elapsed time: 0:21:47 
 checkpoint is 884703302035
Tue Feb 16 17:23:40 2016
Full restore complete of datafile 8 /data/ABSTEST/TBL_INDEX01.dbf. Elapsed time: 0:23:14 
 checkpoint is 884703302016
Tue Feb 16 17:37:45 2016
Full restore complete of datafile 6 /data/ABSTEST/index01.dbf. Elapsed time: 0:13:30 
 checkpoint is 884703303034
Tue Feb 16 17:54:44 2016
Full restore complete of datafile 14 /data/ABSTEST/TBL_DATA03.dbf. Elapsed time: 0:16:30 
 checkpoint is 884703303012
Tue Feb 16 18:03:55 2016
Full restore complete of datafile 3 /data/ABSTEST/data/undotbs01.dbf. Elapsed time: 0:08:33 
 checkpoint is 884703304522
 last deallocation scn is 3
Tue Feb 16 18:13:37 2016
Full restore complete of datafile 1 /data/ABSTEST/data/system01.dbf. Elapsed time: 0:09:12 
 checkpoint is 884703304482
 last deallocation scn is 980671
 Undo Optimization current scn is 633535
Tue Feb 16 18:16:59 2016
Full restore complete of datafile 15 /data/ABSTEST/TBL_INDEX04.dbf. Elapsed time: 0:02:41 
 checkpoint is 884703305045
Tue Feb 16 18:17:52 2016
Full restore complete of datafile 4 /data/ABSTEST/data/users01.dbf. Elapsed time: 0:00:21 
 checkpoint is 884703305157
 last deallocation scn is 3
Tue Feb 16 18:19:19 2016
Full restore complete of datafile 2 /data/ABSTEST/data/sysaux01.dbf. Elapsed time: 0:00:52 
 checkpoint is 884703305143
 last deallocation scn is 982441
Tue Feb 16 18:19:46 2016
Incremental restore complete of datafile 9 /data/ABSTEST/TBL_DATA.dbf
 checkpoint is 884703403260
Tue Feb 16 18:20:01 2016
Incremental restore complete of datafile 10 /data/ABSTEST/TBL_INDEX02.dbf
 checkpoint is 884703403263
Tue Feb 16 18:20:16 2016
Incremental restore complete of datafile 12 /data/ABSTEST/TBL_DATA02.dbf
 checkpoint is 884703403372
Tue Feb 16 18:20:31 2016
Incremental restore complete of datafile 11 /data/ABSTEST/TBL_DATA01.dbf
 checkpoint is 884703403369
Tue Feb 16 18:20:47 2016
Incremental restore complete of datafile 5 /data/ABSTEST/data01.dbf
 checkpoint is 884703403501
Tue Feb 16 18:21:02 2016
Incremental restore complete of datafile 13 /data/ABSTEST/TBL_INDEX03.dbf
 checkpoint is 884703403498
Tue Feb 16 18:21:16 2016
Incremental restore complete of datafile 7 /data/ABSTEST/data/data02.dbf
 checkpoint is 884703403518
Tue Feb 16 18:21:32 2016
Incremental restore complete of datafile 8 /data/ABSTEST/TBL_INDEX01.dbf
 checkpoint is 884703403515
Tue Feb 16 18:21:47 2016
Incremental restore complete of datafile 14 /data/ABSTEST/TBL_DATA03.dbf
 checkpoint is 884703403532
Tue Feb 16 18:22:02 2016
Incremental restore complete of datafile 6 /data/ABSTEST/index01.dbf
 checkpoint is 884703403535
Tue Feb 16 18:22:19 2016
Incremental restore complete of datafile 1 /data/ABSTEST/data/system01.dbf
 checkpoint is 884703403556
 last deallocation scn is 980671
Tue Feb 16 18:22:38 2016
Incremental restore complete of datafile 3 /data/ABSTEST/data/undotbs01.dbf
 checkpoint is 884703403559
 last deallocation scn is 3
Tue Feb 16 18:22:58 2016
Incremental restore complete of datafile 15 /data/ABSTEST/TBL_INDEX04.dbf
 checkpoint is 884703403579
Tue Feb 16 18:23:16 2016
Incremental restore complete of datafile 2 /data/ABSTEST/data/sysaux01.dbf
 checkpoint is 884703403582
 last deallocation scn is 982441
Tue Feb 16 18:23:28 2016
Incremental restore complete of datafile 4 /data/ABSTEST/data/users01.dbf
 checkpoint is 884703403597
 last deallocation scn is 3
Tue Feb 16 18:23:32 2016
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
Completed: alter database recover datafile list
 1 , 2 , 3 , 4 , 5 , 6 , 7 , 8 , 9 , 10 , 11 , 12 , 13 , 14 , 15
alter database recover if needed
 start until change 884703403597 using backup controlfile
Media Recovery Start
 started logmerger process
Parallel Media Recovery started with 8 slaves
ORA-279 signalled during: alter database recover if needed
 start until change 884703403597 using backup controlfile
...
Tue Feb 16 18:23:53 2016
alter database recover logfile '/data/ABSTEST/arch/1_281525_816695906.dbf'
Media Recovery Log /data/ABSTEST/arch/1_281525_816695906.dbf
Tue Feb 16 18:23:54 2016
Incomplete Recovery applied until change 884703403597 time 02/14/2016 23:01:48
Media Recovery Complete (ABSTEST)
Completed: alter database recover logfile '/data/ABSTEST/arch/1_281525_816695906.dbf'
alter database open resetlogs
RESETLOGS after incomplete recovery UNTIL CHANGE 884703403597
Archived Log entry 281357 added for thread 1 sequence 281532 ID 0x33e8d7de dest 1:
Archived Log entry 281358 added for thread 1 sequence 281533 ID 0x33e8d7de dest 1:
Archived Log entry 281359 added for thread 1 sequence 281531 ID 0x33e8d7de dest 1:
Clearing online redo logfile 4 /data/ABSTEST/data/redo04a.log
Clearing online log 4 of thread 1 sequence number 281532
Tue Feb 16 18:24:28 2016
Clearing online redo logfile 4 complete
Clearing online redo logfile 5 /data/ABSTEST/data/redo05a.log
Clearing online log 5 of thread 1 sequence number 281533
Clearing online redo logfile 5 complete
Clearing online redo logfile 6 /data/ABSTEST/data/redo06a.log
Clearing online log 6 of thread 1 sequence number 281531
Tue Feb 16 18:24:41 2016
Clearing online redo logfile 6 complete
Resetting resetlogs activation ID 870897630 (0x33e8d7de)
Online log /data/ABSTEST/data/redo04a.log: Thread 1 Group 4 was previously cleared
Online log /data/ABSTEST/data/redo04b.log: Thread 1 Group 4 was previously cleared
Online log /data/ABSTEST/data/redo05a.log: Thread 1 Group 5 was previously cleared
Online log /data/ABSTEST/data/redo05b.log: Thread 1 Group 5 was previously cleared
Online log /data/ABSTEST/data/redo06a.log: Thread 1 Group 6 was previously cleared
Online log /data/ABSTEST/data/redo06b.log: Thread 1 Group 6 was previously cleared
Tue Feb 16 18:24:41 2016
Setting recovery target incarnation to 2
CHANGE TRACKING file is not current. It appears to be
older than the current control file. This probably means
that an old backup of this file has been restored.
Resetting change tracking file.
CHANGE TRACKING is reinitializing the change tracking file.
Using SCN growth rate of 16384 per second
Tue Feb 16 18:24:44 2016
Assigning activation ID 958204531 (0x391d0a73)
LGWR: STARTING ARCH PROCESSES
Tue Feb 16 18:24:44 2016
ARC0 started with pid=19, OS id=19546 
ARC0: Archival started
LGWR: STARTING ARCH PROCESSES COMPLETE
ARC0: STARTING ARCH PROCESSES
Tue Feb 16 18:24:45 2016
ARC1 started with pid=24, OS id=21385 
Thread 1 opened at log sequence 1
 Current log# 4 seq# 1 mem# 0: /data/ABSTEST/data/redo04a.log
 Current log# 4 seq# 1 mem# 1: /data/ABSTEST/data/redo04b.log
Successful open of redo thread 1
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Tue Feb 16 18:24:45 2016
ARC2 started with pid=25, OS id=21460 
Tue Feb 16 18:24:45 2016
ARC3 started with pid=26, OS id=21529 
ARC1: Archival started
ARC2: Archival started
ARC1: Becoming the 'no FAL' ARCH
ARC1: Becoming the 'no SRL' ARCH
ARC2: Becoming the heartbeat ARCH
Starting background process CTWR
Tue Feb 16 18:24:45 2016
CTWR started with pid=27, OS id=21777 
Block change tracking service is active.
Tue Feb 16 18:24:45 2016
SMON: enabling cache recovery
ARC3: Archival started
ARC0: STARTING ARCH PROCESSES COMPLETE
[28526] Successfully onlined Undo Tablespace 2.
Undo initialization finished serial:0 start:2262413862 end:2262414566 diff:704 (7 seconds)
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 AL32UTF8
No Resource Manager plan active
replication_dependency_tracking turned off (no async multimaster replication found)
Starting background process QMNC
Tue Feb 16 18:24:49 2016
QMNC started with pid=28, OS id=28664 
LOGSTDBY: Validating controlfile with logical metadata
LOGSTDBY: Validation complete
Tue Feb 16 18:24:53 2016
Starting background process CJQ0
Tue Feb 16 18:24:53 2016
CJQ0 started with pid=31, OS id=4665 
Tue Feb 16 18:25:14 2016
Completed: alter database open resetlogs
Tue Feb 16 18:29:50 2016
Starting background process SMCO
Tue Feb 16 18:29:50 2016

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: