validate the datafile in Physical standby DB which corrupted in primary DB
validate check logical datafile 2;
Backup the datafile on Physical standby DB
backup as copy datafile 2 format '/app/oracle/sysaux01.dbf'
In Primary DB, make the corrupted the datafile offline
alter database datafile 2 offline;
copy the backupon primary DB server and catalog the datafilebackup
catalog datafilecopy '/app/oracle/sysaux01.dbf'
Using rman, restore and recover the datafile in primary DB
restore datafile 2
recover datafile 2
Bring the datafile online after successfully restore
sql 'alter database datafile 2 online';
Friday, 20 January 2017
Script to restore database until Point in time Recovery
export ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_2
export ORACLE_SID=TDRARQ
BOX=`uname -a | awk '{print$2}'`
DAYNAM=`date | awk '{print$1}'`
# ----------------------------------
date
# ----------------------------------
rman nocatalog log=/home/oracle/scripts/full_restore_time.log <<EOF
connect target sys/WRWYTW
run {
set until time "TO_DATE('29-12-2016 10:00:00','DD-MM-YYYY HH24:MI:SS')";
RESTORE DATABASE;
RECOVER DATABASE;
ALTER DATABASE OPEN RESETLOGS;
}
EOF
Restore Until TIME (RMAN Point-In-Time Recovery)
Restore Until TIME (RMAN Point-In-Time
Recovery)
Database point-in-time recovery (DBPITR) restores
the database from backups prior to the target time for recovery, then uses
incremental backups and redo to roll the database forward to the target time.
DBPITR is sometimes called incomplete
recovery because it does not use all of the available redo or completely
recover all changes to your database.
The target SCN can be specified using a date and time, in
which case the operation is sometimes called time-based recovery
1. Restore & recover the database to that very same point and time.
(Put highest time). Before starting media
recovery, the instance that is performing the recovery should be started in
MOUNT mode
export
ORACLE_HOME=/app/oracle/product/11.2.0/dbhome_2
export
ORACLE_SID=TDMFIN
BOX=`uname
-a | awk '{print$2}'`
DAYNAM=`date
| awk '{print$1}'`
#
----------------------------------
date
#
----------------------------------
rman
log=/home/oracle/scripts/full_restore_time.log <<EOF
connect
target sys/synergy
run {
set
until time "TO_DATE('28-12-2016 16:59:00','DD-MM-YYYY HH24:MI:SS')";
RESTORE
DATABASE;
RECOVER
DATABASE;
ALTER
DATABASE OPEN RESETLOGS;
}
EOF
2.
Taken
an incremental level 1 backup
3.
Testing
the restore and recovering the database
Creating a table
create
table total_clarity.test_restore
(
test1
varchar(200)
);
Insert a value
SET
DEFINE OFF;
Insert
into TOTAL_CLARITY.TEST_RESTORE
(TEST1)
Values
('2');
Insert
into TOTAL_CLARITY.TEST_RESTORE
(TEST1)
Values
('1');
COMMIT;
4.
Move
or delete the tablespace space
5.
After
deleting the tablespace, tried to insert the value and that fails
Insert
into TOTAL_CLARITY.TEST_RESTORE
(TEST1)
Values
('12');
6.
Shutdown
the database and start the database in mount mode to restore the DB
7.
After
database started in mount then restore & recover the database to that very same point and time (Put
highest time) as mentioned in the step 1
8.
Restore
and recover DB output
Recovery
Manager: Release 11.2.0.4.0 - Production on Wed Dec 28 17:05:17 2016
Copyright
(c) 1982, 2011, Oracle and/or its affiliates.
All rights reserved.
RMAN>
connected
to target database: TDMFIN (DBID=3908821090, not open)
RMAN>
2> 3> 4> 5> 6>
executing
command: SET until clause
Starting
restore at 28-DEC-16
using
target database control file instead of recovery catalog
allocated
channel: ORA_DISK_1
channel
ORA_DISK_1: SID=123 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 /data/oradata/TDMFIN/sysaux01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013540_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013540_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:45
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 00003 to /data/oradata/TDMFIN/undotbs01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013541_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013541_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:46
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/oradata/TDMFIN/system01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013542_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013542_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:01:45
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 00008 to
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L013543_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013543_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:45
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 00013 to
/data/oradata/TDMFIN/TOTREST_OF_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L013544_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013544_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:46
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 00025 to /data/oradata/TDMFIN/GMP01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L013545_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013545_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:25
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 00010 to
/data/oradata/TDMFIN/TOTREST_OF_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013546_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013546_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:35
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 00005 to
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013547_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013547_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:25
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 00019 to /data/oradata/TDMFIN/TOTJOURNAL_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013548_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013548_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 00022 to /data/oradata/TDMFIN/TOTEVENT_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013549_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013549_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 00011 to /data/oradata/TDMFIN/TOTREST_OF_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013550_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013550_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:35
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 00021 to
/data/oradata/TDMFIN/TOTEVENT_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013551_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013551_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:15
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 00014 to
/data/oradata/TDMFIN/TOTREST_OF_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013552_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013552_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00018 to
/data/oradata/TDMFIN/TOTJOURNAL_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013553_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013553_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00006 to
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013554_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013554_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 00007 to
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013555_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013555_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00009 to
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013556_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013556_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00012 to
/data/oradata/TDMFIN/TOTREST_OF_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013557_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013557_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00020 to
/data/oradata/TDMFIN/TOTJOURNAL_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013558_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013558_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00023 to
/data/oradata/TDMFIN/TOTEVENT_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013559_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013559_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 00024 to /data/oradata/TDMFIN/RMAN01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013560_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013560_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
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 00015 to
/data/oradata/TDMFIN/TOTXFORMER_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L013561_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013561_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:04
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 00016 to
/data/oradata/TDMFIN/TOTXFORMER_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L013562_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013562_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 00017 to
/data/oradata/TDMFIN/TOTXFORMER_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L013563_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013563_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:03
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 00004 to /data/oradata/TDMFIN/users01.dbf
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L013565_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L013565_1.bak
tag=WEEKLY_FULL_BACKUP_L0
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished
restore at 28-DEC-16
Starting
recover at 28-DEC-16
using
channel ORA_DISK_1
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00002: /data/oradata/TDMFIN/sysaux01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113579_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113579_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:35
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00003: /data/oradata/TDMFIN/undotbs01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113580_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113580_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00001: /data/oradata/TDMFIN/system01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113581_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113581_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00008: /data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113582_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113582_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00013:
/data/oradata/TDMFIN/TOTREST_OF_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113583_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113583_1.bak tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00025: /data/oradata/TDMFIN/GMP01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113584_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113584_1.bak tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00010: /data/oradata/TDMFIN/TOTREST_OF_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113585_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113585_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00005:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113586_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113586_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00019: /data/oradata/TDMFIN/TOTJOURNAL_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113587_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113587_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00022: /data/oradata/TDMFIN/TOTEVENT_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113588_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113588_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00011: /data/oradata/TDMFIN/TOTREST_OF_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113589_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113589_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00021: /data/oradata/TDMFIN/TOTEVENT_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113590_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113590_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00014:
/data/oradata/TDMFIN/TOTREST_OF_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113591_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113591_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00018: /data/oradata/TDMFIN/TOTJOURNAL_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113592_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113592_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00006:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113593_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113593_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00007: /data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113594_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113594_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00009:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113595_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113595_1.bak tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00012: /data/oradata/TDMFIN/TOTREST_OF_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113596_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113596_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00020: /data/oradata/TDMFIN/TOTJOURNAL_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113597_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113597_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00023: /data/oradata/TDMFIN/TOTEVENT_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113598_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113598_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00024: /data/oradata/TDMFIN/RMAN01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113599_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113599_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00015: /data/oradata/TDMFIN/TOTXFORMER_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113600_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113600_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00016: /data/oradata/TDMFIN/TOTXFORMER_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113601_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113601_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00017: /data/oradata/TDMFIN/TOTXFORMER_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113602_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113602_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00004: /data/oradata/TDMFIN/users01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113604_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113604_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00002: /data/oradata/TDMFIN/sysaux01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113618_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113618_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:46
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00003: /data/oradata/TDMFIN/undotbs01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113619_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113619_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00001: /data/oradata/TDMFIN/system01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113620_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113620_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:15
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00008: /data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113621_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113621_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00013:
/data/oradata/TDMFIN/TOTREST_OF_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113622_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113622_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00025: /data/oradata/TDMFIN/GMP01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113623_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113623_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00010: /data/oradata/TDMFIN/TOTREST_OF_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113624_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113624_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00005:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113625_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113625_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00019: /data/oradata/TDMFIN/TOTJOURNAL_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113626_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113626_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00022: /data/oradata/TDMFIN/TOTEVENT_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113627_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113627_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00011: /data/oradata/TDMFIN/TOTREST_OF_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113628_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113628_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00021: /data/oradata/TDMFIN/TOTEVENT_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113629_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113629_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00014:
/data/oradata/TDMFIN/TOTREST_OF_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113630_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113630_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00018: /data/oradata/TDMFIN/TOTJOURNAL_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113631_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113631_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00006:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113632_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113632_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00007:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113633_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113633_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00009: /data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113634_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113634_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00012: /data/oradata/TDMFIN/TOTREST_OF_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113635_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113635_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00020: /data/oradata/TDMFIN/TOTJOURNAL_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113636_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113636_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00023: /data/oradata/TDMFIN/TOTEVENT_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113637_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113637_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00024: /data/oradata/TDMFIN/RMAN01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113638_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113638_1.bak tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00015: /data/oradata/TDMFIN/TOTXFORMER_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113639_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113639_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00016: /data/oradata/TDMFIN/TOTXFORMER_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113640_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113640_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00017: /data/oradata/TDMFIN/TOTXFORMER_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113641_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113641_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00004: /data/oradata/TDMFIN/users01.dbf
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113643_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113643_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00002: /data/oradata/TDMFIN/sysaux01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113658_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113658_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:25
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00003: /data/oradata/TDMFIN/undotbs01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113659_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113659_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00001: /data/oradata/TDMFIN/system01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113660_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113660_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:07
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00008: /data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113661_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113661_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00013:
/data/oradata/TDMFIN/TOTREST_OF_INDEX_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113662_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113662_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00025: /data/oradata/TDMFIN/GMP01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113663_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113663_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00010: /data/oradata/TDMFIN/TOTREST_OF_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113664_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113664_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00005:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LARGE01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113665_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113665_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00019: /data/oradata/TDMFIN/TOTJOURNAL_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113666_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113666_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00022: /data/oradata/TDMFIN/TOTEVENT_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113667_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113667_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00011: /data/oradata/TDMFIN/TOTREST_OF_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113668_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113668_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00021: /data/oradata/TDMFIN/TOTEVENT_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113669_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113669_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00014:
/data/oradata/TDMFIN/TOTREST_OF_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113670_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113670_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00018: /data/oradata/TDMFIN/TOTJOURNAL_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113671_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113671_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00006:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113672_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113672_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00007:
/data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113673_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113673_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00009: /data/oradata/TDMFIN/TOTARCHIVE_MESSAGE_INDEX_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113674_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113674_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00012: /data/oradata/TDMFIN/TOTREST_OF_DATA_SMALL01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113675_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113675_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00020: /data/oradata/TDMFIN/TOTJOURNAL_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113676_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113676_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00023: /data/oradata/TDMFIN/TOTEVENT_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113677_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113677_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00024: /data/oradata/TDMFIN/RMAN01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113678_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113678_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00015: /data/oradata/TDMFIN/TOTXFORMER_DATA01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113679_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113679_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00016: /data/oradata/TDMFIN/TOTXFORMER_INDEX01.DBF
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_DATABASE_L113680_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113680_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00017: /data/oradata/TDMFIN/TOTXFORMER_LOBS01.DBF
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113681_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113681_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel
ORA_DISK_1: starting incremental datafile backup set restore
channel
ORA_DISK_1: specifying datafile(s) to restore from backup set
destination
for restore of datafile 00004: /data/oradata/TDMFIN/users01.dbf
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_DATABASE_L113683_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_DATABASE_L113683_1.bak
tag=DAILY_INCR_BACKUP_L1
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
starting
media recovery
archived
log for thread 1 with sequence 3314 is already on disk as file
/archivelogs/TDMFIN/archivelog/1_3314_902328162.dbf
archived
log for thread 1 with sequence 3315 is already on disk as file
/archivelogs/TDMFIN/archivelog/1_3315_902328162.dbf
archived
log for thread 1 with sequence 3316 is already on disk as file
/archivelogs/TDMFIN/archivelog/1_3316_902328162.dbf
archived
log for thread 1 with sequence 3317 is already on disk as file /archivelogs/TDMFIN/archivelog/1_3317_902328162.dbf
channel
ORA_DISK_1: starting archived log restore to default destination
channel
ORA_DISK_1: restoring archived log
archived
log thread=1 sequence=3312
channel
ORA_DISK_1: reading from backup piece /backup/TDMFIN/TDMFIN_ARCHIVES_13690_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_ARCHIVES_13690_1.bak
tag=DAILY_INCR_ARCHIVELOGS
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:15
archived
log file name=/archivelogs/TDMFIN/archivelog/1_3312_902328162.dbf thread=1
sequence=3312
channel
ORA_DISK_1: starting archived log restore to default destination
channel
ORA_DISK_1: restoring archived log
archived
log thread=1 sequence=3313
channel
ORA_DISK_1: reading from backup piece
/backup/TDMFIN/TDMFIN_ARCHIVES_13691_1.bak
channel
ORA_DISK_1: piece handle=/backup/TDMFIN/TDMFIN_ARCHIVES_13691_1.bak
tag=DAILY_INCR_ARCHIVELOGS
channel
ORA_DISK_1: restored backup piece 1
channel
ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived
log file name=/archivelogs/TDMFIN/archivelog/1_3313_902328162.dbf thread=1
sequence=3313
archived
log file name=/archivelogs/TDMFIN/archivelog/1_3314_902328162.dbf thread=1
sequence=3314
archived
log file name=/archivelogs/TDMFIN/archivelog/1_3315_902328162.dbf thread=1
sequence=3315
media
recovery complete, elapsed time: 00:00:16
Finished
recover at 28-DEC-16
database
opened
RMAN>
Recovery
Manager complete.
9.
Verifying
the table created and the inserted value after restoring the database to point
in failure.
Subscribe to:
Posts (Atom)