********************************************************************************************
export NLS_DATE_FORMAT='dd-mm-yyyy hh:mi:ss'
rman target / | tee /home/oracle/rman_`/bin/date +\%d\%m\%y:%H:%M:%S`.log
1.
RMAN> restore controlfile from '/u01/app/oracle/RmanBackup/ORCL_T20221227_cf13_p1_t1124532983';
Starting restore at 28-12-2022 02:17:03
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=237 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/Datafile/control01.ctl
Finished restore at 28-12-2022 02:17:07
RMAN> startup mount ;
database is already started
database mounted
released channel: ORA_DISK_1
2.
to find SCN No
set linesize 300 pagesize 100
col inst_id for 9999999 heading 'Instance #'
col file_nr for 9999999 heading 'File #'
col file_name for A70 heading 'File name'
col checkpoint_change_nr for 99999999999999 heading 'Checkpoint #'
col checkpoint_change_time for A20 heading 'Checkpoint time'
col last_change_nr for 99999999999999 heading 'Last change #'
col SCNStatus for a15
SELECT
fe.inst_id,
fe.CON_ID, ---- for >12c
fe.fenum file_nr,
fn.fnnam file_name,
TO_NUMBER (fe.fecps) checkpoint_change_nr,
fe.fecpt checkpoint_change_time,
fe.fests last_change_nr,
NVL2(fe.fecps, '<-Good', 'Recover to this scn') SCNStatus, ---- Recover to max 'scn'
DECODE (
fe.fetsn,
0, DECODE (BITAND (fe.festa, 2), 0, 'SYSOFF', 'SYSTEM'),
DECODE (BITAND (fe.festa, 18),
0, 'OFFLINE',
2, 'ONLINE',
'RECOVER')
) status
FROM x$kccfe fe, x$kccfn fn
WHERE ( (fe.fepax != 65535 AND fe.fepax != 0 ) OR (fe.fepax = 65535 OR fe.fepax = 0) )
AND fn.fnfno = fe.fenum
AND fe.fefnh = fn.fnnum
AND fe.fedup != 0
AND fn.fntyp = 4
AND fn.fnnam IS NOT NULL
AND BITAND (fn.fnflg, 4) != 4
ORDER BY fe.fenum
;
3.
RMAN>
run {
SET NEWNAME FOR DATABASE to '/u01/app/oracle/Datafile/%b';
set newname for tempfile 1 to '/u01/app/oracle/Datafile/temp.dbf';
set until scn 3351530;
restore database;
switch datafile all;
switch tempfile all;
recover database ;
}
4.
define 1='/u01/app/oracle/Datafile/'
set linesize 200
col file_name for a150
select 'ALTER DATABASE RENAME FILE ''' ||member|| ''' to '||'''&1'|| substr(member,instr(member,'/',-1)+1, instr(substr(member,instr(member,'/',-1)+1),'.')-1 )||'.log' ||''' ;' file_name
from V$logfile;
FILE_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------
ALTER DATABASE RENAME FILE '/oracle/db/oradata/orcl/redo03.log' to '/u01/app/oracle/Datafile/redo03.log' ;
ALTER DATABASE RENAME FILE '/oracle/db/oradata/orcl/redo02.log' to '/u01/app/oracle/Datafile/redo02.log' ;
ALTER DATABASE RENAME FILE '/oracle/db/oradata/orcl/redo01.log' to '/u01/app/oracle/Datafile/redo01.log' ;
5.
RMAN> alter database open resetlogs;
Statement processed
========================================
from
https://smarttechways.com/2020/06/23/incomplete-recovery-script-with-sequence-and-time-which-generate-set-until-statement-for-rman/
Incomplete recovery script with sequence and time which generate set until statement for RMAN
col inputgb for 9999.99
col outputgb for 9999.99
col time for 9999.99
col start_Time for a21
col end_time for a21
col status for a10
select session_key,session_recid,session_stamp, to_char(start_time, 'DD-MON-YYYY HH24:MI:SS') Start_time,
to_char(END_Time, 'DD-MON-YYYY HH24:MI:SS') END_Time, input_bytes/(1024*1024*1024) as "InputGB", output_bytes/(1024*1024*1024) as "outputGB",
status,elapsed_seconds/60/60 as "time" from v$rman_backup_job_details order by 1;
SESSION_KEY SESSION_RECID SESSION_STAMP START_TIME END_TIME InputGB outputGB STATUS time
----------- ------------- ------------- --------------------- --------------------- -------- -------- ---------- --------
2 2 1124532910 27-DEC-2022 10:15:24 27-DEC-2022 10:16:24 2.81 2.08 COMPLETED .02
select 'set until sequence ' || seq# || ' thread ' || thread# || '; ' || chr(13)|| chr(10) || 'recover database ;' "Recover Command"
from (
select * from (
select thread#, sequence# + 1 seq#, next_change# from (
select * from v$backup_archivelog_details
where thread# || '_' || sequence# in
(select thread# || '_' || max(sequence#) from v$backup_archivelog_details group by thread#)
) order by next_change#
) where rownum = 1 ) ;
Recover Command
---------------------------------------------------------------------------------------------------------------------------------
set until sequence 164 thread 1;
recover database ;
col "Restore Command" for a100
select ' restore archivelog from logseq ' || Min_arch_backup.startNo || ' until logseq ' || Max_arch_backup.endNo || ' thread=' || Max_arch_backup.thread# || ';' "Restore Command"
from
(select thread#,session_key,session_recid,session_stamp,min(sequence#) startNo from v$backup_archivelog_details group by thread#,session_key,session_recid,session_stamp) Min_arch_backup,
(select thread#,session_key,session_recid,session_stamp, max(sequence#) endNo from v$backup_archivelog_details group by thread#,session_key,session_recid,session_stamp) Max_arch_backup
where Min_arch_backup.thread# = Max_arch_backup.thread# and Min_arch_backup.session_key = Max_arch_backup.session_key
and Min_arch_backup.session_recid = Max_arch_backup.session_recid
and Min_arch_backup.session_stamp = Max_arch_backup.session_stamp
;
Restore Command
----------------------------------------------------------------------------------------------------
restore archivelog from logseq 159 until logseq 163 thread=1;
col NEXT_CHANGE# heading "*NEXT_CHANGE#*"
select session_key,session_recid,session_stamp,thread#,FIRST_CHANGE#,NEXT_CHANGE# ,Sequence# "LastArchiveLogBackupSequence#",to_char(next_time,'DD-MON-YYYY HH24:MI:SS') "Time"
from v$backup_archivelog_details
where thread# || '_' || sequence# in (select thread# || '_' || max(sequence#)
from v$backup_archivelog_details
group by thread#
);
SESSION_KEY SESSION_RECID SESSION_STAMP THREAD# FIRST_CHANGE# *NEXT_CHANGE#* LastArchiveLogBackupSequence# Time
----------- ------------- ------------- ---------- ------------- -------------- ----------------------------- -----------------------------
2 2 1124532910 1 3351522 3351530 163 27-DEC-2022 10:16:18
--For last 16 Sequence time detail
select * from (
select session_key,session_recid,session_stamp,thread#,FIRST_CHANGE#,NEXT_CHANGE#, Sequence# "LastArchiveLogBackupSequence#",
to_char(next_time,'DD-MON-YYYY HH24:MI:SS') "Time" from v$backup_archivelog_details order by sequence# desc)
where rownum <= 16;
SESSION_KEY SESSION_RECID SESSION_STAMP THREAD# FIRST_CHANGE# NEXT_CHANGE# LastArchiveLogBackupSequence# Time
----------- ------------- ------------- ---------- ------------- ------------ ----------------------------- -----------------------------
2 2 1124532910 1 3351522 3351530 163 27-DEC-2022 10:16:18
2 2 1124532910 1 3351504 3351522 162 27-DEC-2022 10:16:15
2 2 1124532910 1 3351464 3351504 161 27-DEC-2022 10:16:13
2 2 1124532910 1 3351464 3351504 161 27-DEC-2022 10:16:13
2 2 1124532910 1 3350945 3351464 160 27-DEC-2022 10:15:24
2 2 1124532910 1 3350945 3351464 160 27-DEC-2022 10:15:24
2 2 1124532910 1 3331357 3350945 159 27-DEC-2022 10:09:28
2 2 1124532910 1 3331357 3350945 159 27-DEC-2022 10:09:28
8 rows selected.
RMAN> startup nomount ;
Oracle instance started
Total System Global Area 1895825408 bytes
Fixed Size 8622048 bytes
Variable Size 570425376 bytes
Database Buffers 1308622848 bytes
Redo Buffers 8155136 bytes
RMAN> restore controlfile from '/u01/app/oracle/RmanBackup/ORCL_T20221227_cf13_p1_t1124532983';
Starting restore at 29-12-2022 04:08:28
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=237 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/Datafile/control01.ctl
Finished restore at 29-12-2022 04:08:31
RMAN> alter database mount;
Statement processed
released channel: ORA_DISK_1
RMAN> list backup ;
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
1 Full 9.80M DISK 00:00:00 27-12-2022 10:13:32
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20221227T101332
Piece Name: /u01/app/oracle/Archive/ORCL/autobackup/2022_12_27/o1_mf_n_1124532812_ktpfgdmn_.bkp
Control File Included: Ckp SCN: 3351072 Ckp time: 27-12-2022 10:13:32
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
2 6.31M DISK 00:00:00 27-12-2022 10:15:26
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s3_p1_t1124532926
List of Archived Logs in backup set 2
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 160 3350945 27-12-2022 10:09:28 3351464 27-12-2022 10:15:24
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
3 46.44M DISK 00:00:01 27-12-2022 10:15:27
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s2_p1_t1124532926
List of Archived Logs in backup set 3
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 159 3331357 26-12-2022 08:29:03 3350945 27-12-2022 10:09:28
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
4 Incr 0 910.52M DISK 00:00:29 27-12-2022 10:15:58
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s5_p1_t1124532929
List of Datafiles in backup set 4
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
1 0 Incr 3351472 27-12-2022 10:15:29 NO /oracle/db/oradata/orcl/system01.dbf
5 0 Incr 3351472 27-12-2022 10:15:29 NO /oracle/db/oradata/orcl/WCPVM_webcenter_portlet.dbf
6 0 Incr 3351472 27-12-2022 10:15:29 NO /oracle/db/oradata/orcl/users01.dbf
9 0 Incr 3351472 27-12-2022 10:15:29 NO /oracle/db/oradata/orcl/WCPVM_svctbl.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Incr 0 1000.22M DISK 00:00:31 27-12-2022 10:16:00
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s4_p1_t1124532929
List of Datafiles in backup set 5
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
3 0 Incr 3351471 27-12-2022 10:15:29 NO /oracle/db/oradata/orcl/sysaux01.dbf
14 0 Incr 3351471 27-12-2022 10:15:29 NO /oracle/db/oradata/orcl/dbfs01.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Incr 0 33.38M DISK 00:00:01 27-12-2022 10:16:05
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s6_p1_t1124532964
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
7 0 Incr 3351495 27-12-2022 10:16:04 NO /oracle/db/oradata/orcl/WCPVM_iaswebcenter.dbf
10 0 Incr 3351495 27-12-2022 10:16:04 NO /oracle/db/oradata/orcl/WCPVM_iau.dbf
11 0 Incr 3351495 27-12-2022 10:16:04 NO /oracle/db/oradata/orcl/WCPVM_mds.dbf
13 0 Incr 3351495 27-12-2022 10:16:04 NO /oracle/db/oradata/orcl/WCPVM_iasactivities.dbf
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0 79.70M DISK 00:00:06 27-12-2022 10:16:11
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s7_p1_t1124532965
List of Datafiles in backup set 7
File LV Type Ckp SCN Ckp Time Abs Fuz SCN Sparse Name
---- -- ---- ---------- ------------------- ----------- ------ ----
2 0 Incr 3351496 27-12-2022 10:16:05 NO /oracle/db/oradata/orcl/WCPVM_ias_opss.dbf
4 0 Incr 3351496 27-12-2022 10:16:05 NO /oracle/db/oradata/orcl/undotbs01.dbf
8 0 Incr 3351496 27-12-2022 10:16:05 NO /oracle/db/oradata/orcl/WCPVM_iasjive.dbf
12 0 Incr 3351496 27-12-2022 10:16:05 NO /oracle/db/oradata/orcl/WCPVM_ocs.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
8 40.00K DISK 00:00:00 27-12-2022 10:16:13
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s8_p1_t1124532973
List of Archived Logs in backup set 8
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 161 3351464 27-12-2022 10:15:24 3351504 27-12-2022 10:16:13
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
9 Full 9.80M DISK 00:00:01 27-12-2022 10:16:15
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20221227T101614
Piece Name: /u01/app/oracle/Archive/ORCL/autobackup/2022_12_27/o1_mf_n_1124532974_ktpfmh1g_.bkp
Control File Included: Ckp SCN: 3351513 Ckp time: 27-12-2022 10:16:14
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
10 6.35M DISK 00:00:00 27-12-2022 10:16:19
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s11_p1_t1124532979
List of Archived Logs in backup set 10
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 160 3350945 27-12-2022 10:09:28 3351464 27-12-2022 10:15:24
1 161 3351464 27-12-2022 10:15:24 3351504 27-12-2022 10:16:13
1 162 3351504 27-12-2022 10:16:13 3351522 27-12-2022 10:16:15
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
11 46.44M DISK 00:00:00 27-12-2022 10:16:19
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s10_p1_t1124532979
List of Archived Logs in backup set 11
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 159 3331357 26-12-2022 08:29:03 3350945 27-12-2022 10:09:28
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
12 2.50K DISK 00:00:00 27-12-2022 10:16:20
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: RMANFULL
Piece Name: /u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s12_p1_t1124532980
List of Archived Logs in backup set 12
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 163 3351522 27-12-2022 10:16:15 3351530 27-12-2022 10:16:18 -----<<<<<<recover to this time -1
--- '27-12-2022 10:16:17','DD-MM-YYYY HH24:MI:SS'
set until time="to_date('2021/08/11 02:55:48', 'yyyy/mm/dd hh24:mi:ss')";
restore database;
recover database;
run {
SET NEWNAME FOR DATABASE to '/u01/app/oracle/Datafile/%U';
set newname for tempfile 1 to '/u01/app/oracle/Datafile/temp.dbf';
set until time "to_date('27-12-2022 10:16:17','DD-MM-YYYY HH24:MI:SS')";
restore database;
switch datafile all;
switch tempfile all;
recover database ;
}
RMAN>
run {
SET NEWNAME FOR DATABARMAN> 2> SE to '/u01/app/oracle/Datafile/%U';
set newname for tempfile 1 to '/u01/app/oracle/Datafile/temp.dbf';
set until time "to_date('27-12-2022 10:16:17','DD-MM-YYYY HH24:MI:SS')";
restore database;
switch datafile all;
switch tempfile all;
recover database ;
}3> 4> 5> 6> 7> 8> 9>
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET until clause
Starting restore at 29-12-2022 04:09:31
Starting implicit crosscheck backup at 29-12-2022 04:09:31
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 device type=DISK
Crosschecked 12 objects
Finished implicit crosscheck backup at 29-12-2022 04:09:34
Starting implicit crosscheck copy at 29-12-2022 04:09:34
using channel ORA_DISK_1
Finished implicit crosscheck copy at 29-12-2022 04:09:34
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
skipping datafile 1; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-SYSTEM_FNO-1
skipping datafile 5; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_PORTLET_FNO-5
skipping datafile 6; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-USERS_FNO-6
skipping datafile 9; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_STB_FNO-9
skipping datafile 2; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_OPSS_FNO-2
skipping datafile 4; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-UNDOTBS1_FNO-4
skipping datafile 8; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_DISCUSS_FNO-8
skipping datafile 12; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_OCS_FNO-12
skipping datafile 3; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-SYSAUX_FNO-3
skipping datafile 14; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-DBFS_TS_FNO-14
skipping datafile 7; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_WEBCENTER_FNO-7
skipping datafile 10; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAU_FNO-10
skipping datafile 11; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_MDS_FNO-11
skipping datafile 13; already restored to file /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_ACTIVITY_FNO-13
restore not done; all files read only, offline, excluded, or already restored
Finished restore at 29-12-2022 04:09:36
datafile 1 switched to datafile copy
input datafile copy RECID=15 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-SYSTEM_FNO-1
datafile 2 switched to datafile copy
input datafile copy RECID=16 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_OPSS_FNO-2
datafile 3 switched to datafile copy
input datafile copy RECID=17 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-SYSAUX_FNO-3
datafile 4 switched to datafile copy
input datafile copy RECID=18 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-UNDOTBS1_FNO-4
datafile 5 switched to datafile copy
input datafile copy RECID=19 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_PORTLET_FNO-5
datafile 6 switched to datafile copy
input datafile copy RECID=20 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-USERS_FNO-6
datafile 7 switched to datafile copy
input datafile copy RECID=21 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_WEBCENTER_FNO-7
datafile 8 switched to datafile copy
input datafile copy RECID=22 STAMP=1124683776 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_DISCUSS_FNO-8
datafile 9 switched to datafile copy
input datafile copy RECID=23 STAMP=1124683777 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_STB_FNO-9
datafile 10 switched to datafile copy
input datafile copy RECID=24 STAMP=1124683777 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAU_FNO-10
datafile 11 switched to datafile copy
input datafile copy RECID=25 STAMP=1124683777 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_MDS_FNO-11
datafile 12 switched to datafile copy
input datafile copy RECID=26 STAMP=1124683777 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_OCS_FNO-12
datafile 13 switched to datafile copy
input datafile copy RECID=27 STAMP=1124683777 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_ACTIVITY_FNO-13
datafile 14 switched to datafile copy
input datafile copy RECID=28 STAMP=1124683777 file name=/u01/app/oracle/Datafile/data_D-ORCL_TS-DBFS_TS_FNO-14
renamed tempfile 1 to /u01/app/oracle/Datafile/temp.dbf in control file
renamed tempfile 2 to /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_IAS_TEMP_FNO-2 in control file
renamed tempfile 3 to /u01/app/oracle/Datafile/data_D-ORCL_TS-WCPVM_OCS_TEMP_FNO-3 in control file
Starting recover at 29-12-2022 04:09:38
using channel ORA_DISK_1
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=161
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=162
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s11_p1_t1124532979
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s11_p1_t1124532979 tag=RMANFULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_29/o1_mf_1_161_ktv0w4wb_.arc thread=1 sequence=161
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_29/o1_mf_1_161_ktv0w4wb_.arc RECID=6 STAMP=1124683780
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_29/o1_mf_1_162_ktv0w4xq_.arc thread=1 sequence=162
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_29/o1_mf_1_162_ktv0w4xq_.arc RECID=7 STAMP=1124683780
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=163
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s12_p1_t1124532980
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s12_p1_t1124532980 tag=RMANFULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_29/o1_mf_1_163_ktv0w6sl_.arc thread=1 sequence=163
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_29/o1_mf_1_163_ktv0w6sl_.arc RECID=8 STAMP=1124683782
media recovery complete, elapsed time: 00:00:00
Finished recover at 29-12-2022 04:09:44
========================
--- Rename redo logs
define 1='/u01/app/oracle/Datafile/' -----<<<<< chnage your path
set linesize 200
col file_name for a150
select 'ALTER DATABASE RENAME FILE ''' ||member|| ''' to '||'''&1'|| substr(member,instr(member,'/',-1)+1, instr(substr(member,instr(member,'/',-1)+1),'.')-1 )||'.log' ||''' ;' file_name
from V$logfile;
ALTER DATABASE RENAME FILE '/oracle/db/oradata/orcl/redo03.log' to '/u01/app/oracle/Datafile/redo03.log'
ALTER DATABASE RENAME FILE '/oracle/db/oradata/orcl/redo02.log' to '/u01/app/oracle/Datafile/redo02.log' ;
ALTER DATABASE RENAME FILE '/oracle/db/oradata/orcl/redo01.log' to '/u01/app/oracle/Datafile/redo01.log' ;
Database altered.
SQL>
Database altered.
SQL>
Database altered.
===============================================
RMAN> alter database open resetlogs;
Statement processed
RMAN>
as per metalink RMAN: RAC Backup, Restore and Recovery using RMAN (Doc ID 243760.1)
===
Oracle Rac database restore !!!!!
RMAN> set dbid 1222414252;
executing command: SET DBID
RMAN> startup force nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initibrac1.ora'
starting Oracle instance without parameter file for retrieval of spfile
Oracle instance started
Total System Global Area 1073741824 bytes
Fixed Size 8628936 bytes
Variable Size 369100088 bytes
Database Buffers 687865856 bytes
Redo Buffers 8146944 bytes
RMAN>
restore spfile !!!
RMAN>
run
{
allocate channel d1 type disk;
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dumps/IBRAC/%F';
Restore spfile from autobackup;
Release channel d1;
}
RMAN> 2> 3> 4> 5> 6> 7>
released channel: ORA_DISK_1
allocated channel: d1
channel d1: SID=993 device type=DISK
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
Starting restore at 28-08-2023 07:31:38
channel d1: looking for AUTOBACKUP on day: 20230828
channel d1: AUTOBACKUP found: /dumps/IBRAC/c-1222414252-20230828-00
channel d1: restoring spfile from AUTOBACKUP /dumps/IBRAC/c-1222414252-20230828-00
channel d1: SPFILE restore from AUTOBACKUP complete
Finished restore at 28-08-2023 07:31:40
released channel: d1
RMAN>
====
run
{
allocate channel d1 type disk;
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dumps/IBRAC/%F';
Restore CONTROLFILE from autobackup;
Release channel d1;
}
RMAN>
run
{
allocate channel d1 type disk;
set CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/dumps/IBRAC/%F';
Restore CONTROLFILE from autobackup;
Release channel d1;
}
RMAN> 2> 3> 4> 5> 6> 7>
allocated channel: d1
channel d1: SID=993 device type=DISK
executing command: SET CONTROLFILE AUTOBACKUP FORMAT
Starting restore at 28-08-2023 07:37:32
channel d1: looking for AUTOBACKUP on day: 20230828
channel d1: AUTOBACKUP found: /dumps/IBRAC/c-1222414252-20230828-00
channel d1: restoring control file from AUTOBACKUP /dumps/IBRAC/c-1222414252-20230828-00
channel d1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/product/12.2.0/dbhome_1/dbs/cntrlibrac1.dbf
Finished restore at 28-08-2023 07:37:33
released channel: d1
-rw-r----- 1 oracle oinstall 5632 Aug 28 07:31 spfileibrac1.ora
-rw-r----- 1 oracle oinstall 20430848 Aug 28 07:37 cntrlibrac1.dbf
/u01/app/oracle/product/12.2.0/dbhome_1/dbs/cntrlibrac1.dbf
modify pfile with above control file !!!!!
startup mount pfile='initibrac1.ora';
ORACLE instance started.
Total System Global Area 4294967296 bytes
Fixed Size 8628936 bytes
Variable Size 1677722936 bytes
Database Buffers 2600468480 bytes
Redo Buffers 8146944 bytes
Database mounted.
SQL> SQL>
SQL>
SQL>
select thread#,max(sequence#) sequence# from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change#
group by thread#
;
THREAD# SEQUENCE#
---------- ----------
1 13
2 24
alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss' ;
set numf 99999999999999 linesize 300
select sequence#,NEXT_TIME, thread#, first_change#, next_change# from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change#
and sequence# in (13,24);
SEQUENCE# NEXT_TIME THREAD# FIRST_CHANGE# NEXT_CHANGE#
--------------- ------------------- --------------- --------------- ---------------
13 26-08-2023 22:30:04 2 2771303261 2771622222
13 28-08-2023 01:00:04 1 2791076362 2793397863 +1 *(243760.1) In a RAC environment, use the lower to ensure we have the redo required from threads
24 28-08-2023 01:00:05 2 2793157493 2793398098
or
all in one sql ...
set numf 99999999999999
select (min(next_change# )+1) MINSCN from (select thread#,sequence#, first_change#, next_change# from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change#
and (thread#,sequence#) in (select thread#,max(sequence#) sequence# from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change#
group by thread#
)
)
;
MINSCN
---------------
2793397864
or
set numf 99999999999999 pagesize 0
select 'set until scn ' ||(min(next_change# )+1) ||';'
from (select thread#,sequence#, first_change#, next_change# from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change#
and (thread#,sequence#) in (select thread#,max(sequence#) sequence# from v$archived_log L, v$database D
where L.resetlogs_change# = D.resetlogs_change#
group by thread#
)
)
;
set until scn 2793397864;
restore database !!!
run {
set until scn 2793397864;
Restore Database;
Recover Database;
Alter Database Open Resetlogs;
}
RMAN>
RMAN>
RMAN> 2> 3> 4> 5> 6>
executing command: SET until clause
Starting restore at 28-08-2023 07:52:50
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=737 instance=ibrac1 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 00001 to +DATA/IBRAC/system01.dbf
channel ORA_DISK_1: restoring datafile 00002 to +DATA/IBRAC/apex_data01.dbf
channel ORA_DISK_1: restoring datafile 00003 to +DATA/IBRAC/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to +DATA/IBRAC/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00005 to +DATA/IBRAC/undotbs02.dbf
channel ORA_DISK_1: restoring datafile 00007 to +DATA/IBRAC/users01.dbf
channel ORA_DISK_1: restoring datafile 00008 to +DATA/IBRAC/test_data01.dbf
channel ORA_DISK_1: restoring datafile 00009 to +DATA/IBRAC/test_data_ind_01.dbf
channel ORA_DISK_1: restoring datafile 00010 to +DATA/IBRAC/DATAFILE/lobtest.319.1145681515
channel ORA_DISK_1: restoring datafile 00011 to +DATA/IBRAC/DATAFILE/test_uniform.3791.1145681597
channel ORA_DISK_1: restoring datafile 00012 to +DATA/IBRAC/DATAFILE/test.3794.1145681591
channel ORA_DISK_1: restoring datafile 00013 to +DATA/IBRAC/DATAFILE/test1.3789.1145681597
channel ORA_DISK_1: restoring datafile 00014 to +DATA/IBRAC/DATAFILE/test1.3786.1145681597
channel ORA_DISK_1: restoring datafile 00015 to +DATA/IBRAC/DATAFILE/bigtabs.3754.1145681517
channel ORA_DISK_1: restoring datafile 00016 to +DATA/IBRAC/test_data02.dbf
channel ORA_DISK_1: reading from backup piece /dumps/IBRAC/20230827_ibrac1_1838_1_1145926871
channel ORA_DISK_1: piece handle=/dumps/IBRAC/20230827_ibrac1_1838_1_1145926871 tag=TAG20230827T010111
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:07:15
Finished restore at 28-08-2023 08:00:06
Starting recover at 28-08-2023 08:00:06
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 11 is already on disk as file +DATA/IBRAC/ONLINELOG/group_5.3741.1145682259
archived log for thread 1 with sequence 12 is already on disk as file +DATA/IBRAC/ONLINELOG/group_6.3736.1145682259
archived log for thread 1 with sequence 13 is already on disk as file +DATA/IBRAC/ONLINELOG/group_1.3735.1145682261
archived log for thread 1 with sequence 14 is already on disk as file +DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_1_seq_14.3714.1146035535
archived log for thread 2 with sequence 22 is already on disk as file +DATA/IBRAC/ONLINELOG/group_4.3745.1145682259
archived log for thread 2 with sequence 23 is already on disk as file +DATA/IBRAC/ONLINELOG/group_7.3740.1145682259
archived log for thread 2 with sequence 24 is already on disk as file +DATA/IBRAC/ONLINELOG/group_8.3737.1145682259
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=16
channel ORA_DISK_1: reading from backup piece /dumps/IBRAC/20230827_ibrac1_1840_1_1145927134
channel ORA_DISK_1: piece handle=/dumps/IBRAC/20230827_ibrac1_1840_1_1145927134 tag=TAG20230827T010534
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_1_seq_10.281.1146038409 thread=1 sequence=10
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_2_seq_16.3717.1146038409 thread=2 sequence=16
archived log file name=+DATA/IBRAC/ONLINELOG/group_5.3741.1145682259 thread=1 sequence=11
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=17
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=18
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=19
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=20
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=21
channel ORA_DISK_1: reading from backup piece /dumps/IBRAC/20230828_ibrac1_1842_1_1146013207
channel ORA_DISK_1: piece handle=/dumps/IBRAC/20230828_ibrac1_1842_1_1146013207 tag=TAG20230828T010007
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_2_seq_17.4021.1146038411 thread=2 sequence=17
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_2_seq_18.3725.1146038411 thread=2 sequence=18
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_2_seq_19.3730.1146038411 thread=2 sequence=19
archived log file name=+DATA/IBRAC/ONLINELOG/group_6.3736.1145682259 thread=1 sequence=12
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_2_seq_20.5052.1146038411 thread=2 sequence=20
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_2_seq_21.3722.1146038411 thread=2 sequence=21
archived log file name=+DATA/IBRAC/ONLINELOG/group_4.3745.1145682259 thread=2 sequence=22
archived log file name=+DATA/IBRAC/ONLINELOG/group_1.3735.1145682261 thread=1 sequence=13
archived log file name=+DATA/IBRAC/ONLINELOG/group_7.3740.1145682259 thread=2 sequence=23
archived log file name=+DATA/IBRAC/ONLINELOG/group_8.3737.1145682259 thread=2 sequence=24
archived log file name=+DATA/IBRAC/ARCHIVELOG/2023_08_28/thread_1_seq_14.3714.1146035535 thread=1 sequence=14
media recovery complete, elapsed time: 00:00:20
Finished recover at 28-08-2023 08:01:36
Statement processed
SQL> startup nomount pfile='initibrac1.ora';
ORA-32006: UTL_FILE_DIR initialization parameter has been deprecated
ORACLE instance started.
restore controlfile to '+DATA' from '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/cntrlibrac1.dbf';
RMAN>
restore controlfile to '+DATA' from '/u01/app/oracle/product/12.2.0/dbhome_1/dbs/cntrlibrac1.dbf';
RMAN>
Starting restore at 28-08-2023 08:05:04
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1831 instance=ibrac1 device type=DISK
channel ORA_DISK_1: copied control file copy
Finished restore at 28-08-2023 08:05:05
find -t CONTROLFILE +DATA/IBRAC *
ASMCMD [+DATA/IBRAC/CONTROLFILE] >
find -t CONTROLFILE +DATA/IBRAC *ASMCMD [+DATA/IBRAC/CONTROLFILE] >
WARNING:option 't' is deprecated for 'find'
please use 'type'
+DATA/IBRAC/CONTROLFILE/current.3989.1145681321
+DATA/IBRAC/CONTROLFILE/current.4022.1146038705
ASMCMD [+DATA/IBRAC/CONTROLFILE] > ls -l +DATA/IBRAC/CONTROLFILE/current.4022.1146038705
Type Redund Striped Time Sys Name
CONTROLFILE UNPROT FINE AUG 28 08:00:00 Y current.4022.1146038705
SQL> create spfile from pfile='initibrac1.ora';
File created.
-rw-r----- 1 oracle oinstall 5632 Aug 28 08:31 spfileibrac1.ora
create spfile='+DATA' from pfile='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initibrac1.ora';
create spfile='+DATA' from pfile='/u01/app/oracle/product/12.2.0/dbhome_1/dbs/initibrac1.ora';SQL> SQL>
File created.
ASMCMD [+] > find + spfile*
+DATA/GARBAGE/PARAMETERFILE/spfile.269.966963741
+DATA/IBRAC/PARAMETERFILE/spfile.274.1146040391
ASMCMD [+] > ls -l +DATA/IBRAC/PARAMETERFILE/spfile.274.1146040391
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE AUG 28 08:00:00 Y spfile.274.1146040391
ASMCMD [+] >
[grid@ibrac01 ~]$ date
Mon Aug 28 08:36:39 EDT 2023
$srvctl config database -d ibrac
Database unique name: ibrac
Database name:
Oracle home: /u01/app/oracle/product/12.2.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/IBRAC/PARAMETERFILE/spfile.274.1146040391
Password file: +DATA/IBRAC/PASSWORD/pwdibrac.4019.1145693377
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: ibrac1,ibrac2
Configured nodes: ibrac01,ibrac02
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
asmcmd ls -l +DATA/IBRAC/PARAMETERFILE/spfile.274.1146040391
Type Redund Striped Time Sys Name
PARAMETERFILE UNPROT COARSE AUG 28 08:00:00 Y spfile.274.1146040391
if required ..
srvctl modify database -d ibrac -spfile +DATA/IBRAC/PARAMETERFILE/spfile.274.1146040391
$srvctl status database -d ibrac -v
Instance ibrac1 is running on node ibrac01. Instance status: Open.
Instance ibrac2 is running on node ibrac02. Instance status: Open.
RMAN>
List of Archived Logs in backup set 51
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 55 2263162 19-10-2023 23:55:02 2263171 19-10-2023 23:55:02
1 56 2263171 19-10-2023 23:55:02 2263179 19-10-2023 23:55:03 +1
set until time "to_date('19-10-2023 23:55:04','DD-MM-YYYY HH24:MI:SS')";
run
{
set until time "to_date('19-10-2023 23:55:04','DD-MM-YYYY HH24:MI:SS')";
set newname for database to '/oracle/db/oradata1/orcl/%b';
restore database;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
recover database;
alter database open resetlogs;
}
RMAN>
run
{
set until time "to_date('19-10-2023 23:55:04','DD-MM-YYYY HH24:MI:SS')";
set newname for database to '/oracle/db/oradata1/orcl/%b';
restore database;
SWITCH DATAFILE ALL;
SWITCH TEMPFILE ALL;
recover database;
alter database open resetlogs;
}
RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10>
executing command: SET until clause
executing command: SET NEWNAME
Starting restore at 20-10-2023 04:33:14
Starting implicit crosscheck backup at 20-10-2023 04:33:14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=248 device type=DISK
Crosschecked 52 objects
Finished implicit crosscheck backup at 20-10-2023 04:33:14
Starting implicit crosscheck copy at 20-10-2023 04:33:14
using channel ORA_DISK_1
Crosschecked 2 objects
Finished implicit crosscheck copy at 20-10-2023 04:33:14
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /oracle/db/oradata1/orcl/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /oracle/db/oradata1/orcl/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /oracle/db/oradata1/orcl/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00006 to /oracle/db/oradata1/orcl/users01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610386_10_1_0a299qui_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610386_10_1_0a299qui_1_1 tag=ORCL_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:05
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 /oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
channel ORA_DISK_1: restoring datafile 00005 to /oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
channel ORA_DISK_1: restoring datafile 00007 to /oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
channel ORA_DISK_1: restoring datafile 00008 to /oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
channel ORA_DISK_1: restoring datafile 00009 to /oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
channel ORA_DISK_1: restoring datafile 00010 to /oracle/db/oradata1/orcl/WCPVM_iau.dbf
channel ORA_DISK_1: restoring datafile 00011 to /oracle/db/oradata1/orcl/WCPVM_mds.dbf
channel ORA_DISK_1: restoring datafile 00012 to /oracle/db/oradata1/orcl/WCPVM_ocs.dbf
channel ORA_DISK_1: restoring datafile 00013 to /oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610451_11_1_0b299r0j_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610451_11_1_0b299r0j_1_1 tag=ORCL_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 20-10-2023 04:34:35
datafile 1 switched to datafile copy
input datafile copy RECID=15 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=16 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=17 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=18 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=19 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=20 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=21 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=22 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=23 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=24 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_iau.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=25 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_mds.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=26 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_ocs.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=27 STAMP=1150691675 file name=/oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
renamed tempfile 1 to /oracle/db/oradata1/orcl/temp01.dbf in control file
renamed tempfile 2 to /oracle/db/oradata1/orcl/WCPVM_iastemp.dbf in control file
renamed tempfile 3 to /oracle/db/oradata1/orcl/WCPVM_ocstemp.dbf in control file
Starting recover at 20-10-2023 04:34:36
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 00001: /oracle/db/oradata1/orcl/system01.dbf
destination for restore of datafile 00002: /oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
destination for restore of datafile 00004: /oracle/db/oradata1/orcl/undotbs01.dbf
destination for restore of datafile 00005: /oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
destination for restore of datafile 00008: /oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
destination for restore of datafile 00010: /oracle/db/oradata1/orcl/WCPVM_iau.dbf
destination for restore of datafile 00013: /oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610538_13_1_0d299r3a_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610538_13_1_0d299r3a_1_1 tag=ORCL_FULL
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 00003: /oracle/db/oradata1/orcl/sysaux01.dbf
destination for restore of datafile 00006: /oracle/db/oradata1/orcl/users01.dbf
destination for restore of datafile 00007: /oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
destination for restore of datafile 00009: /oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
destination for restore of datafile 00011: /oracle/db/oradata1/orcl/WCPVM_mds.dbf
destination for restore of datafile 00012: /oracle/db/oradata1/orcl/WCPVM_ocs.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610538_14_1_0e299r3a_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610538_14_1_0e299r3a_1_1 tag=ORCL_FULL
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 00001: /oracle/db/oradata1/orcl/system01.dbf
destination for restore of datafile 00002: /oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
destination for restore of datafile 00004: /oracle/db/oradata1/orcl/undotbs01.dbf
destination for restore of datafile 00005: /oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
destination for restore of datafile 00008: /oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
destination for restore of datafile 00010: /oracle/db/oradata1/orcl/WCPVM_iau.dbf
destination for restore of datafile 00013: /oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610627_21_1_0l299r63_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610627_21_1_0l299r63_1_1 tag=ORCL_FULL
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 00003: /oracle/db/oradata1/orcl/sysaux01.dbf
destination for restore of datafile 00006: /oracle/db/oradata1/orcl/users01.dbf
destination for restore of datafile 00007: /oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
destination for restore of datafile 00009: /oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
destination for restore of datafile 00011: /oracle/db/oradata1/orcl/WCPVM_mds.dbf
destination for restore of datafile 00012: /oracle/db/oradata1/orcl/WCPVM_ocs.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610627_22_1_0m299r63_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150610627_22_1_0m299r63_1_1 tag=ORCL_FULL
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 00001: /oracle/db/oradata1/orcl/system01.dbf
destination for restore of datafile 00002: /oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
destination for restore of datafile 00004: /oracle/db/oradata1/orcl/undotbs01.dbf
destination for restore of datafile 00005: /oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
destination for restore of datafile 00008: /oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
destination for restore of datafile 00010: /oracle/db/oradata1/orcl/WCPVM_iau.dbf
destination for restore of datafile 00013: /oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673340_29_1_0t29bods_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673340_29_1_0t29bods_1_1 tag=ORCL_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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: /oracle/db/oradata1/orcl/sysaux01.dbf
destination for restore of datafile 00006: /oracle/db/oradata1/orcl/users01.dbf
destination for restore of datafile 00007: /oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
destination for restore of datafile 00009: /oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
destination for restore of datafile 00011: /oracle/db/oradata1/orcl/WCPVM_mds.dbf
destination for restore of datafile 00012: /oracle/db/oradata1/orcl/WCPVM_ocs.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673340_30_1_0u29bods_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673340_30_1_0u29bods_1_1 tag=ORCL_FULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
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: /oracle/db/oradata1/orcl/system01.dbf
destination for restore of datafile 00002: /oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
destination for restore of datafile 00004: /oracle/db/oradata1/orcl/undotbs01.dbf
destination for restore of datafile 00005: /oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
destination for restore of datafile 00008: /oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
destination for restore of datafile 00010: /oracle/db/oradata1/orcl/WCPVM_iau.dbf
destination for restore of datafile 00013: /oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673612_38_1_1629bomc_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673612_38_1_1629bomc_1_1 tag=ORCL_FULL
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 00003: /oracle/db/oradata1/orcl/sysaux01.dbf
destination for restore of datafile 00006: /oracle/db/oradata1/orcl/users01.dbf
destination for restore of datafile 00007: /oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
destination for restore of datafile 00009: /oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
destination for restore of datafile 00011: /oracle/db/oradata1/orcl/WCPVM_mds.dbf
destination for restore of datafile 00012: /oracle/db/oradata1/orcl/WCPVM_ocs.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673612_39_1_1729bomc_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150673612_39_1_1729bomc_1_1 tag=ORCL_FULL
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 00001: /oracle/db/oradata1/orcl/system01.dbf
destination for restore of datafile 00002: /oracle/db/oradata1/orcl/WCPVM_ias_opss.dbf
destination for restore of datafile 00004: /oracle/db/oradata1/orcl/undotbs01.dbf
destination for restore of datafile 00005: /oracle/db/oradata1/orcl/WCPVM_webcenter_portlet.dbf
destination for restore of datafile 00008: /oracle/db/oradata1/orcl/WCPVM_iasjive.dbf
destination for restore of datafile 00010: /oracle/db/oradata1/orcl/WCPVM_iau.dbf
destination for restore of datafile 00013: /oracle/db/oradata1/orcl/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150674900_47_1_1f29bpuk_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150674900_47_1_1f29bpuk_1_1 tag=ORCL_FULL
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 00003: /oracle/db/oradata1/orcl/sysaux01.dbf
destination for restore of datafile 00006: /oracle/db/oradata1/orcl/users01.dbf
destination for restore of datafile 00007: /oracle/db/oradata1/orcl/WCPVM_iaswebcenter.dbf
destination for restore of datafile 00009: /oracle/db/oradata1/orcl/WCPVM_svctbl.dbf
destination for restore of datafile 00011: /oracle/db/oradata1/orcl/WCPVM_mds.dbf
destination for restore of datafile 00012: /oracle/db/oradata1/orcl/WCPVM_ocs.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150674900_48_1_1g29bpuk_1_1
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/rman_bkp_inc_ORCL_1150674900_48_1_1g29bpuk_1_1 tag=ORCL_FULL
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 55 is already on disk as file /oracle/db/oradata/orcl/redo01.log
archived log for thread 1 with sequence 56 is already on disk as file /oracle/db/oradata/orcl/redo02.log
archived log for thread 1 with sequence 57 is already on disk as file /oracle/db/oradata/orcl/redo03.log
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=54
channel ORA_DISK_1: reading from backup piece /home/oracle/RmanBackup/Arc_1150674903_set51_piece1.rman
channel ORA_DISK_1: piece handle=/home/oracle/RmanBackup/Arc_1150674903_set51_piece1.rman tag=TAG20231019T235503
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/oracle/db/fast_recovery_area/ORCL/archivelog/2023_10_20/o1_mf_1_54_lm4sgw0s_.arc thread=1 sequence=54
channel default: deleting archived log(s)
archived log file name=/oracle/db/fast_recovery_area/ORCL/archivelog/2023_10_20/o1_mf_1_54_lm4sgw0s_.arc RECID=29 STAMP=1150691692
archived log file name=/oracle/db/oradata/orcl/redo01.log thread=1 sequence=55
archived log file name=/oracle/db/oradata/orcl/redo02.log thread=1 sequence=56
archived log file name=/oracle/db/oradata/orcl/redo03.log thread=1 sequence=57
media recovery complete, elapsed time: 00:00:00
Finished recover at 20-10-2023 04:34:53
Statement processed