Oracle RMAN: restore database ..
https://anuj-singh.blogspot.com/2010/01/oracle-datafile-need-recovery.htmlexport TWO_TASK= export NLS_DATE_FORMAT='dd-mm-yyyy hh:mi:ss'
rman target / | tee rman.log
run {
allocate channel ch1 device type DISK;
allocate channel ch2 device type DISK;
backup incremental level=0 tag "RMANFULL" format '/u03/RAC/%d_T%T_db_s%s_p%p_t%t' database filesperset 4 plus archivelog tag "RMANFULL";
sql "alter system archive log current";
backup format '/u03/RAC/%d_T%T_arch_s%s_p%p_t%t' archivelog all filesperset 4 tag "RMANFULL";
backup format '/u03/RAC/%d_T%T_cf%s_p%p_t%t' current controlfile tag "RMANFULL";
sql "alter system archive log current";
restore database preview;
}
====
export NLS_DATE_FORMAT='DD-MON-YY HH24:MI:SS'
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/Rman/%F';
rman target / | tee /u01/app/Rman/rman_`/bin/date +\%d\%m\%y:%H:%M:%S`.log
run {
allocate channel ch1 device type DISK;
backup incremental level=0 tag "RMANFULL" format '/u01/app/Rman/%d_T%T_db_s%s_p%p_t%t' database filesperset 4 plus archivelog tag "RMANFULL";
sql "alter system archive log current";
sql "alter system archive log current";
backup format '/u01/app/Rman/%d_T%T_arch_s%s_p%p_t%t' archivelog all filesperset 4 tag "RMANFULL";
backup format '/u01/app/Rman/%d_T%T_cf%s_p%p_t%t' current controlfile tag "RMANFULLCONTRL";
sql "alter system archive log current";
restore database preview;
}=======
http://anuj-singh.blogspot.com/2016/09/rman-create-set-newname-script.html http://anuj-singh.blogspot.com/2016/09/rman-create-set-newname-script.html << for diffrent location cat initorcl12c.ora <<< pfile orcl12c.__data_transfer_cache_size=0 orcl12c.__db_cache_size=222298112 orcl12c.__java_pool_size=4194304 orcl12c.__large_pool_size=125829120 orcl12c.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment orcl12c.__pga_aggregate_target=293601280 orcl12c.__sga_target=545259520 orcl12c.__shared_io_pool_size=0 orcl12c.__shared_pool_size=184549376 orcl12c.__streams_pool_size=0 *._ash_size=25165824 *._catalog_foreign_restore=FALSE *.audit_file_dest='/u01/app/oracle/admin/orcl12c/adump' *.audit_trail='db' *.compatible='12.1.0.2.0' *.control_files='/u01/app/oracle/oradata/orcl12c/control01.ctl','/u01/app/oracle/fast_recovery_area/orcl12c/control02.ctl'#Restore Controlfile *.db_block_size=8192 *.db_domain='' *.db_name='orcl12c' *.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area' *.db_recovery_file_dest_size=4560m *.diagnostic_dest='/u01/app/oracle' *.dispatchers='(PROTOCOL=TCP) (SERVICE=orcl12cXDB)' *.enable_pluggable_database=true *.local_listener='LISTENER_ORCL12C' *.log_archive_dest_1='location=/u01/app/oracle/Archive' *.memory_target=800m *.open_cursors=300 *.processes=300 *.remote_login_passwordfile='EXCLUSIVE' *.shared_servers=25 *.threaded_execution=FALSE *.undo_tablespace='UNDOTBS2' SQL> startup nomount pfile=initorcl12c.ora ; ORACLE instance started. Total System Global Area 838860800 bytes Fixed Size 8798312 bytes Variable Size 620760984 bytes Database Buffers 205520896 bytes Redo Buffers 3780608 bytes SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production [oracle@vbgeneric dbs]$ rman target / Recovery Manager: Release 12.2.0.1.0 - Production on Sat Oct 2 08:14:34 2021 Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved. connected to target database: ORCL12C (not mounted) RMAN> RESTORE CONTROLFILE from '/u02/app/oracle/RmanBackup/ORCL12C_20210925_106_1_CONTROL'; Starting restore at 02-10-2021 08:15:20 using target database control file instead of recovery catalog allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=35 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/oradata/orcl12c/control01.ctl output file name=/u01/app/oracle/fast_recovery_area/orcl12c/control02.ctl Finished restore at 02-10-2021 08:15:23 RMAN> alter database mount ; Statement processed released channel: ORA_DISK_1
from web 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 #' SELECT fe.inst_id, fe.CON_ID, 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, 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 ; Instance # CON_ID File # File name Checkpoint # Checkpoint time Last change # STATUS ---------- ---------- -------- ---------------------------------------------------------------------- --------------- -------------------- -------------------- ------- 1 1 1 /u01/app/oracle/oradata/orcl12c/system01.dbf 16329399 09/25/2021 10:45:45 SYSTEM 1 1 3 /u01/app/oracle/oradata/orcl12c/sysaux01.dbf 16329399 09/25/2021 10:45:45 ONLINE 1 2 5 /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf 14804862 12/26/2020 06:28:00 SYSOFF 1 1 6 /u01/app/oracle/oradata/orcl12c/users01.dbf 16329399 09/25/2021 10:45:45 ONLINE 1 2 7 /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf 14804862 12/26/2020 06:28:00 OFFLINE 1 3 8 /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf 16329339 09/25/2021 10:43:20 SYSTEM 1 3 9 /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf 16329339 09/25/2021 10:43:20 ONLINE 1 3 10 /u01/app/oracle/oradata/orcl12c/orcl/SAMPLE_SCHEMA_users01.dbf 16329339 09/25/2021 10:43:20 ONLINE 1 3 11 /u01/app/oracle/oradata/orcl12c/orcl/example01.dbf 16329339 09/25/2021 10:43:20 ONLINE 1 3 12 /u01/app/oracle/oradata/orcl12c/orcl/APEX_1851336378250219.dbf 16329339 09/25/2021 10:43:20 ONLINE 1 3 13 /u01/app/oracle/oradata/orcl12c/orcl/APEX_5457999048253711.dbf 16329339 09/25/2021 10:43:20 ONLINE 1 1 17 /u01/app/oracle/oradata/orcl12c/undotbs2.dbf 16329399 09/25/2021 10:45:45 ONLINE 1 1 18 /u01/app/oracle/oradata/orcl12c/apex01.dbf 16329399 09/25/2021 10:45:45 ONLINE 1 3 19 /u01/app/oracle/oradata/orcl12c/orcl/APEX_5500333564645084.dbf 16329339 09/25/2021 10:43:20 ONLINE 1 5 21 /u01/app/oracle/oradata/orcl12c/ANUJ/system01.dbf 16313846 09/25/2021 09:50:40 SYSOFF 1 5 22 /u01/app/oracle/oradata/orcl12c/ANUJ/sysaux01.dbf 16313846 09/25/2021 09:50:40 OFFLINE 1 5 23 /u01/app/oracle/oradata/orcl12c/ANUJ/users01.dbf 16313846 09/25/2021 09:50:40 OFFLINE 1 3 34 /u01/app/oracle/oradata/orcl12c/orcl/tts01_.dbf 7375942 03/26/2018 16:08:23 ONLINE 1 5 36 /u01/app/oracle/oradata/orcl12c/ANUJ/tts01_.dbf 7383435 03/26/2018 16:48:17 ONLINE 19 rows selected.
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
;
find out file# no 1 and scn no i.e. 16329399 +1 =16329400 set linesize 300 alter session set nls_date_format='dd-mm-yyyy hh24:mi';
set numf 99999999999999999 select * from v$database_incarnation ; scn no for restore 16329400 set linesize 300 alter session set nls_date_format='dd-mm-yyyy hh24:mi';
set numf 99999999999999999select * from v$database_incarnation where RESETLOGS_CHANGE# in (select max(RESETLOGS_CHANGE#) from v$database_incarnation where RESETLOGS_CHANGE#< 16329400 ) ; INCARNATION# RESETLOGS_CHANGE# RESETLOGS_TIME PRIOR_RESETLOGS_CHANGE# PRIOR_RESETLOGS_ STATUS RESETLOGS_ID PRIOR_INCARNATION# FLASHBACK_DATABASE_ALLOWED CON_ID ------------ ----------------- ---------------- ----------------------- ---------------- ------- ------------ ------------------ -------------------------- ---------- 4 16210201 25-09-2021 09:05 8232571 23-08-2020 11:43 PARENT 1084179948 3 NO 0 set to this incarnation RMAN> reset database to incarnation 4; RMAN> database reset to incarnation 4 run{ set until scn 16329400; restore database; RESTORE DATABASE CHECK READONLY; recover database; } RMAN> run{ set until scn 16329400; restore database; RESTORE DATABASE CHECK READONLY; recover database; } RMAN> executing command: SET until clause Starting restore at 02-10-2021 08:35:25 Starting implicit crosscheck backup at 02-10-2021 08:35:25 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=42 device type=DISK Crosschecked 13 objects Finished implicit crosscheck backup at 02-10-2021 08:35:30 Starting implicit crosscheck copy at 02-10-2021 08:35:30 using channel ORA_DISK_1 Finished implicit crosscheck copy at 02-10-2021 08:35:30 searching for all files in the recovery area cataloging files... cataloging done List of Cataloged Files ======================= File Name: /u01/app/oracle/fast_recovery_area/ORCL12C/autobackup/2021_10_02/o1_mf_n_1084857936_joj9dkql_.bkp File Name: /u01/app/oracle/fast_recovery_area/ORCL12C/autobackup/2021_09_26/o1_mf_s_1084268218_jo0xvv3j_.bkp File Name: /u01/app/oracle/fast_recovery_area/ORCL12C/autobackup/2021_09_25/o1_mf_s_1084186180_jnyfr4r1_.bkp File Name: /u01/app/oracle/fast_recovery_area/ORCL12C/autobackup/2021_09_25/o1_mf_s_1084194159_jnyokhxr_.bkp File Name: /u01/app/oracle/fast_recovery_area/ORCL12C/autobackup/2021_09_25/o1_mf_s_1084190659_jnyl445c_.bkp using channel ORA_DISK_1 skipping datafile 34; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/tts01_.dbf 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 /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/orcl12c/orcl/SAMPLE_SCHEMA_users01.dbf channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/orcl12c/orcl/example01.dbf channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/orcl12c/orcl/APEX_1851336378250219.dbf channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/oradata/orcl12c/orcl/APEX_5457999048253711.dbf channel ORA_DISK_1: restoring datafile 00019 to /u01/app/oracle/oradata/orcl12c/orcl/APEX_5500333564645084.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/RmanBackup/ORCL12C_20210925_99_1_FULL channel ORA_DISK_1: piece handle=/u02/app/oracle/RmanBackup/ORCL12C_20210925_99_1_FULL tag=ORCLEE_FULL channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:06: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 00001 to /u01/app/oracle/oradata/orcl12c/system01.dbf channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/orcl12c/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/orcl12c/users01.dbf channel ORA_DISK_1: restoring datafile 00017 to /u01/app/oracle/oradata/orcl12c/undotbs2.dbf channel ORA_DISK_1: restoring datafile 00018 to /u01/app/oracle/oradata/orcl12c/apex01.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/RmanBackup/ORCL12C_20210925_100_1_FULL channel ORA_DISK_1: piece handle=/u02/app/oracle/RmanBackup/ORCL12C_20210925_100_1_FULL tag=ORCLEE_FULL channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:04: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 00021 to /u01/app/oracle/oradata/orcl12c/ANUJ/system01.dbf channel ORA_DISK_1: restoring datafile 00022 to /u01/app/oracle/oradata/orcl12c/ANUJ/sysaux01.dbf channel ORA_DISK_1: restoring datafile 00023 to /u01/app/oracle/oradata/orcl12c/ANUJ/users01.dbf channel ORA_DISK_1: restoring datafile 00036 to /u01/app/oracle/oradata/orcl12c/ANUJ/tts01_.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/RmanBackup/ORCL12C_20210925_101_1_FULL channel ORA_DISK_1: piece handle=/u02/app/oracle/RmanBackup/ORCL12C_20210925_101_1_FULL tag=ORCLEE_FULL channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02: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 00005 to /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf channel ORA_DISK_1: reading from backup piece /u02/app/oracle/RmanBackup/ORCL12C_20210925_102_1_FULL channel ORA_DISK_1: piece handle=/u02/app/oracle/RmanBackup/ORCL12C_20210925_102_1_FULL tag=ORCLEE_FULL channel ORA_DISK_1: restored backup piece 1 channel ORA_DISK_1: restore complete, elapsed time: 00:02:25 Finished restore at 02-10-2021 08:51:18 Starting restore at 02-10-2021 08:51:19 using channel ORA_DISK_1 skipping datafile 34; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/tts01_.dbf skipping datafile 36; already restored to file /u01/app/oracle/oradata/orcl12c/ANUJ/tts01_.dbf skipping datafile 1; already restored to file /u01/app/oracle/oradata/orcl12c/system01.dbf skipping datafile 3; already restored to file /u01/app/oracle/oradata/orcl12c/sysaux01.dbf skipping datafile 6; already restored to file /u01/app/oracle/oradata/orcl12c/users01.dbf skipping datafile 17; already restored to file /u01/app/oracle/oradata/orcl12c/undotbs2.dbf skipping datafile 18; already restored to file /u01/app/oracle/oradata/orcl12c/apex01.dbf skipping datafile 5; already restored to file /u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf skipping datafile 7; already restored to file /u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf skipping datafile 8; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/system01.dbf skipping datafile 9; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/sysaux01.dbf skipping datafile 10; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/SAMPLE_SCHEMA_users01.dbf skipping datafile 11; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/example01.dbf skipping datafile 12; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/APEX_1851336378250219.dbf skipping datafile 13; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/APEX_5457999048253711.dbf skipping datafile 19; already restored to file /u01/app/oracle/oradata/orcl12c/orcl/APEX_5500333564645084.dbf skipping datafile 21; already restored to file /u01/app/oracle/oradata/orcl12c/ANUJ/system01.dbf skipping datafile 22; already restored to file /u01/app/oracle/oradata/orcl12c/ANUJ/sysaux01.dbf skipping datafile 23; already restored to file /u01/app/oracle/oradata/orcl12c/ANUJ/users01.dbf restore not done; all files read only, offline, excluded, or already restored Finished restore at 02-10-2021 08:51:20 Starting recover at 02-10-2021 08:51:20 using channel ORA_DISK_1 datafile 34 not processed because file is read-only datafile 36 not processed because file is read-only 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=11 channel ORA_DISK_1: reading from backup piece /u02/app/oracle/RmanBackup/ORCL12C_20210925_104_1_ARCHIVE channel ORA_DISK_1: piece handle=/u02/app/oracle/RmanBackup/ORCL12C_20210925_104_1_ARCHIVE tag=ORCLEE_ARCHIVE 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/1_11_1084179948.dbf thread=1 sequence=11 media recovery complete, elapsed time: 00:00:00 Finished recover at 02-10-2021 08:51:24 RMAN> always check path before resetlogs .. !!!!!!!!!!!!!!!!!imp col member for a70 select member from v$logfile; MEMBER ---------------------------------------------------------------------- /u01/app/oracle/oradata/orcl12c/redo03.log /u01/app/oracle/oradata/orcl12c/redo02.log /u01/app/oracle/oradata/orcl12c/redo01.log if above path correct .. alter database open resetlogs; select fhdbn,fhdbi,hxfil,fhsta,fhscn,fhafs,fhrba_seq,fhtnm tbs_name from x$kcvfh; FHDBN FHDBI HXFIL FHSTA FHSCN FHAFS FHRBA_SEQ TBS_NAME --------- ---------- ---------- ---------- -------------------- -------------------- ---------- ------------------------------ ORCL12C 743937264 1 8196 16329404 0 1 SYSTEM ORCL12C 743937264 3 4 16329404 0 1 SYSAUX ORCL12C 743937264 5 8192 14804862 0 459 SYSTEM ORCL12C 743937264 6 4 16329404 0 1 USERS ORCL12C 743937264 7 0 14804862 0 459 SYSAUX ORCL12C 743937264 8 8196 16329573 0 1 SYSTEM ORCL12C 743937264 9 4 16329573 0 1 SYSAUX ORCL12C 743937264 10 4 16329573 0 1 USERS ORCL12C 743937264 11 4 16329573 0 1 EXAMPLE ORCL12C 743937264 12 4 16329573 0 1 APEX_1851336378250219 ORCL12C 743937264 13 4 16329573 0 1 APEX_5457999048253711 ORCL12C 743937264 17 4 16329404 0 1 UNDOTBS2 ORCL12C 743937264 18 4 16329404 0 1 APEX ORCL12C 743937264 19 4 16329573 0 1 APEX_5500333564645084 ORCL12C 743937264 21 8192 16329560 0 1 SYSTEM ORCL12C 743937264 22 0 16329560 0 1 SYSAUX ORCL12C 743937264 23 0 16329560 0 1 USERS ORCL12C 743937264 34 0 7375942 0 170 TTS ORCL12C 743937264 36 0 7383435 0 170 TTS 19 rows selected.
***********************************************
Another restore ..
export TWO_TASK=
export NLS_DATE_FORMAT='dd-mm-yyyy hh:mi:ss'
rman target / | tee rman.log
run {
allocate channel ch1 device type DISK;
allocate channel ch2 device type DISK;
backup incremental level=0 tag "RMANFULL" format '/u01/app/oracle/RmanBackup/%d_T%T_db_s%s_p%p_t%t' database filesperset 4 plus archivelog tag "RMANFULL";
sql "alter system archive log current";
backup format '/u01/app/oracle/RmanBackup/%d_T%T_arch_s%s_p%p_t%t' archivelog all filesperset 4 tag "RMANFULL";
backup format '/u01/app/oracle/RmanBackup/%d_T%T_cf%s_p%p_t%t' current controlfile tag "RMANFULL";
sql "alter system archive log current";
restore database preview;
}
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=269 device type=DISK
allocated channel: ch2
channel ch2: SID=33 device type=DISK
Starting backup at 27-12-2022 10:15:24
current log archived
channel ch1: starting archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=159 RECID=1 STAMP=1124532569
channel ch1: starting piece 1 at 27-12-2022 10:15:26
channel ch2: starting archived log backup set
channel ch2: specifying archived log(s) in backup set
input archived log thread=1 sequence=160 RECID=2 STAMP=1124532925
channel ch2: starting piece 1 at 27-12-2022 10:15:26
channel ch1: finished piece 1 at 27-12-2022 10:15:27
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s2_p1_t1124532926 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
channel ch2: finished piece 1 at 27-12-2022 10:15:27
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s3_p1_t1124532926 tag=RMANFULL comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:01
Finished backup at 27-12-2022 10:15:27
Starting backup at 27-12-2022 10:15:27
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00003 name=/oracle/db/oradata/orcl/sysaux01.dbf
input datafile file number=00014 name=/oracle/db/oradata/orcl/dbfs01.dbf
channel ch1: starting piece 1 at 27-12-2022 10:15:29
channel ch2: starting incremental level 0 datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00001 name=/oracle/db/oradata/orcl/system01.dbf
input datafile file number=00005 name=/oracle/db/oradata/orcl/WCPVM_webcenter_portlet.dbf
input datafile file number=00009 name=/oracle/db/oradata/orcl/WCPVM_svctbl.dbf
input datafile file number=00006 name=/oracle/db/oradata/orcl/users01.dbf
channel ch2: starting piece 1 at 27-12-2022 10:15:29
channel ch1: finished piece 1 at 27-12-2022 10:16:04
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s4_p1_t1124532929 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:35
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00013 name=/oracle/db/oradata/orcl/WCPVM_iasactivities.dbf
input datafile file number=00007 name=/oracle/db/oradata/orcl/WCPVM_iaswebcenter.dbf
input datafile file number=00011 name=/oracle/db/oradata/orcl/WCPVM_mds.dbf
input datafile file number=00010 name=/oracle/db/oradata/orcl/WCPVM_iau.dbf
channel ch1: starting piece 1 at 27-12-2022 10:16:04
channel ch2: finished piece 1 at 27-12-2022 10:16:04
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s5_p1_t1124532929 tag=RMANFULL comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:35
channel ch2: starting incremental level 0 datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00012 name=/oracle/db/oradata/orcl/WCPVM_ocs.dbf
input datafile file number=00004 name=/oracle/db/oradata/orcl/undotbs01.dbf
input datafile file number=00008 name=/oracle/db/oradata/orcl/WCPVM_iasjive.dbf
input datafile file number=00002 name=/oracle/db/oradata/orcl/WCPVM_ias_opss.dbf
channel ch2: starting piece 1 at 27-12-2022 10:16:05
channel ch1: finished piece 1 at 27-12-2022 10:16:05
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s6_p1_t1124532964 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
channel ch2: finished piece 1 at 27-12-2022 10:16:12
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s7_p1_t1124532965 tag=RMANFULL comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:07
Finished backup at 27-12-2022 10:16:12
Starting backup at 27-12-2022 10:16:13
current log archived
channel ch1: starting archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=161 RECID=3 STAMP=1124532973
channel ch1: starting piece 1 at 27-12-2022 10:16:13
channel ch1: finished piece 1 at 27-12-2022 10:16:14
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s8_p1_t1124532973 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-12-2022 10:16:14
Starting Control File Autobackup at 27-12-2022 10:16:14
piece handle=/u01/app/oracle/Archive/ORCL/autobackup/2022_12_27/o1_mf_n_1124532974_ktpfmh1g_.bkp comment=NONE
Finished Control File Autobackup at 27-12-2022 10:16:15
sql statement: alter system archive log current
Starting backup at 27-12-2022 10:16:16
current log archived
channel ch1: starting archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=159 RECID=1 STAMP=1124532569
channel ch1: starting piece 1 at 27-12-2022 10:16:19
channel ch2: starting archived log backup set
channel ch2: specifying archived log(s) in backup set
input archived log thread=1 sequence=160 RECID=2 STAMP=1124532925
input archived log thread=1 sequence=161 RECID=3 STAMP=1124532973
input archived log thread=1 sequence=162 RECID=4 STAMP=1124532975
channel ch2: starting piece 1 at 27-12-2022 10:16:19
channel ch1: finished piece 1 at 27-12-2022 10:16:20
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s10_p1_t1124532979 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
channel ch1: starting archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=163 RECID=5 STAMP=1124532978
channel ch1: starting piece 1 at 27-12-2022 10:16:20
channel ch2: finished piece 1 at 27-12-2022 10:16:20
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s11_p1_t1124532979 tag=RMANFULL comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:01
channel ch1: finished piece 1 at 27-12-2022 10:16:21
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_arch_s12_p1_t1124532980 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-12-2022 10:16:21
Starting backup at 27-12-2022 10:16:23
channel ch1: starting full datafile backup set
channel ch1: specifying datafile(s) in backup set
including current control file in backup set
channel ch1: starting piece 1 at 27-12-2022 10:16:24
channel ch1: finished piece 1 at 27-12-2022 10:16:25
piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_cf13_p1_t1124532983 tag=RMANFULL comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 27-12-2022 10:16:25
Starting Control File Autobackup at 27-12-2022 10:16:25
piece handle=/u01/app/oracle/Archive/ORCL/autobackup/2022_12_27/o1_mf_n_1124532986_ktpfmt6s_.bkp comment=NONE
Finished Control File Autobackup at 27-12-2022 10:16:27
sql statement: alter system archive log current
Starting restore at 27-12-2022 10:16:27
List of Backup Sets
===================
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
------- ---- -- ---------- ----------- ------------ -------------------
7 Incr 0 79.70M DISK 00:00:06 27-12-2022 10:16:07
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 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
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
3 1 161 A 27-12-2022 10:15:24
Name: /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_161_ktpfmf3c_.arc
4 1 162 A 27-12-2022 10:16:13
Name: /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_162_ktpfmhxb_.arc
5 1 163 A 27-12-2022 10:16:15
Name: /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_163_ktpfml6n_.arc
6 1 164 A 27-12-2022 10:16:18
Name: /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_164_ktpfmv70_.arc
recovery will be done up to SCN 3351471
Media recovery start SCN is 3351471
Recovery must be done beyond SCN 3351496 to clear datafile fuzziness
Finished restore at 27-12-2022 10:16:28
released channel: ch1
released channel: ch2
[oracle@wcp12cr2 dbs]$ rman target / | tee rman_`/bin/date +\%d\%m\%y:%H:%M:%S`.log
Recovery Manager: Release 12.2.0.1.0 - Production on Tue Dec 27 13:19:02 2022
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
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 27-DEC-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=255 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 27-DEC-22
RMAN> startup mount ;
database is already started
database mounted
released channel: ORA_DISK_1
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
;
Instance # CON_ID File # File name Checkpoint # Checkpoint time Last change # SCNSTATUS STATUS
---------- ---------- -------- ---------------------------------------------------------------------- --------------- -------------------- -------------------- --------------- -------
1 0 1 /oracle/db/oradata/orcl/system01.dbf 3351530 12/27/2022 10:16:18<-Good SYSTEM
1 0 2 /oracle/db/oradata/orcl/WCPVM_ias_opss.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 3 /oracle/db/oradata/orcl/sysaux01.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 4 /oracle/db/oradata/orcl/undotbs01.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 5 /oracle/db/oradata/orcl/WCPVM_webcenter_portlet.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 6 /oracle/db/oradata/orcl/users01.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 7 /oracle/db/oradata/orcl/WCPVM_iaswebcenter.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 8 /oracle/db/oradata/orcl/WCPVM_iasjive.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 9 /oracle/db/oradata/orcl/WCPVM_svctbl.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 10 /oracle/db/oradata/orcl/WCPVM_iau.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 11 /oracle/db/oradata/orcl/WCPVM_mds.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 12 /oracle/db/oradata/orcl/WCPVM_ocs.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 13 /oracle/db/oradata/orcl/WCPVM_iasactivities.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
1 0 14 /oracle/db/oradata/orcl/dbfs01.dbf 3351530 12/27/2022 10:16:18<-Good ONLINE
14 rows selected.
SQL> SQL>
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 ;
}
RMAN>
RMAN>
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET until clause
Starting restore at 27-DEC-22
Starting implicit crosscheck backup at 27-DEC-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=258 device type=DISK
Crosschecked 12 objects
Finished implicit crosscheck backup at 27-DEC-22
Starting implicit crosscheck copy at 27-DEC-22
using channel ORA_DISK_1
Finished implicit crosscheck copy at 27-DEC-22
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_164_ktpq66td_.arc
File Name: /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_164_ktpfmv70_.arc
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 /u01/app/oracle/Datafile/system01.dbf
channel ORA_DISK_1: restoring datafile 00005 to /u01/app/oracle/Datafile/WCPVM_webcenter_portlet.dbf
channel ORA_DISK_1: restoring datafile 00006 to /u01/app/oracle/Datafile/users01.dbf
channel ORA_DISK_1: restoring datafile 00009 to /u01/app/oracle/Datafile/WCPVM_svctbl.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s5_p1_t1124532929
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s5_p1_t1124532929 tag=RMANFULL
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 00003 to /u01/app/oracle/Datafile/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00014 to /u01/app/oracle/Datafile/dbfs01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s4_p1_t1124532929
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s4_p1_t1124532929 tag=RMANFULL
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 00007 to /u01/app/oracle/Datafile/WCPVM_iaswebcenter.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/Datafile/WCPVM_iau.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/Datafile/WCPVM_mds.dbf
channel ORA_DISK_1: restoring datafile 00013 to /u01/app/oracle/Datafile/WCPVM_iasactivities.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s6_p1_t1124532964
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s6_p1_t1124532964 tag=RMANFULL
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 00002 to /u01/app/oracle/Datafile/WCPVM_ias_opss.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/Datafile/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00008 to /u01/app/oracle/Datafile/WCPVM_iasjive.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/Datafile/WCPVM_ocs.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/ORCL_T20221227_db_s7_p1_t1124532965
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/ORCL_T20221227_db_s7_p1_t1124532965 tag=RMANFULL
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:15
Finished restore at 27-DEC-22
datafile 1 switched to datafile copy
input datafile copy RECID=15 STAMP=1124544114 file name=/u01/app/oracle/Datafile/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=16 STAMP=1124544114 file name=/u01/app/oracle/Datafile/WCPVM_ias_opss.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=17 STAMP=1124544114 file name=/u01/app/oracle/Datafile/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=18 STAMP=1124544114 file name=/u01/app/oracle/Datafile/undotbs01.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=19 STAMP=1124544114 file name=/u01/app/oracle/Datafile/WCPVM_webcenter_portlet.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=20 STAMP=1124544114 file name=/u01/app/oracle/Datafile/users01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=21 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_iaswebcenter.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=22 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_iasjive.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=23 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_svctbl.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=24 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_iau.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=25 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_mds.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=26 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_ocs.dbf
datafile 13 switched to datafile copy
input datafile copy RECID=27 STAMP=1124544115 file name=/u01/app/oracle/Datafile/WCPVM_iasactivities.dbf
datafile 14 switched to datafile copy
input datafile copy RECID=28 STAMP=1124544115 file name=/u01/app/oracle/Datafile/dbfs01.dbf
renamed tempfile 1 to /u01/app/oracle/Datafile/temp.dbf in control file
renamed tempfile 2 to /u01/app/oracle/Datafile/WCPVM_iastemp.dbf in control file
renamed tempfile 3 to /u01/app/oracle/Datafile/WCPVM_ocstemp.dbf in control file
Starting recover at 27-DEC-22
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 161 is already on disk as file /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_161_ktpfmf3c_.arc
archived log for thread 1 with sequence 162 is already on disk as file /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_162_ktpfmhxb_.arc
archived log for thread 1 with sequence 163 is already on disk as file /u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_163_ktpfml6n_.arc
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_161_ktpfmf3c_.arc thread=1 sequence=161
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_162_ktpfmhxb_.arc thread=1 sequence=162
archived log file name=/u01/app/oracle/Archive/ORCL/archivelog/2022_12_27/o1_mf_1_163_ktpfml6n_.arc thread=1 sequence=163
media recovery complete, elapsed time: 00:00:01
Finished recover at 27-DEC-22
SQL>
set linesize 200
col member for a70
select GROUP#,STATUS,member from v$logfile;SQL> SQL>
GROUP# STATUS MEMBER
---------- ------- ----------------------------------------------------------------------
3 /oracle/db/oradata/orcl/redo03.log
2 /oracle/db/oradata/orcl/redo02.log
1 /oracle/db/oradata/orcl/redo01.log
SQL>
alter database rename file '/oracle/db/oradata/orcl/redo01.log' to '/u01/app/oracle/Datafile/log01.log';SQL>
Database altered.
SQL>
alter database rename file '/oracle/db/oradata/orcl/redo02.log' to '/u01/app/oracle/Datafile/log02.log';SQL>
Database altered.
SQL>
alter database rename file '/oracle/db/oradata/orcl/redo03.log' to '/u01/app/oracle/Datafile/log03.log';
SQL>
Database altered.
RMAN> alter database open resetlogs;
Statement processed
RMAN> exit
select GROUP#,STATUS,member from v$logfile;
GROUP# STATUS MEMBER
---------- ------- ----------------------------------------------------------------------
3 /u01/app/oracle/Datafile/log03.log
2 /u01/app/oracle/Datafile/log02.log
1 /u01/app/oracle/Datafile/log01.log
set linesize 200 pagesize 200
column member format a50
column first_change# format 99999999999999999999
column next_change# format 99999999999999999999
select l.thread#,
lf.group#,
lf.member,
trunc(l.bytes/1024/1024) as size_mb,
l.status,
l.archived,
lf.type,
lf.is_recovery_dest_file as rdf,
l.sequence#,
l.first_change#,
l.next_change#
from v$logfile lf , v$log l
where l.group# = lf.group#
union
select l.thread#,
lf.group#,
lf.member,
trunc(l.bytes/1024/1024) as size_mb,
l.status,
l.archived,
lf.type,
lf.is_recovery_dest_file as rdf,
l.sequence#,
l.first_change#,
l.next_change#
from v$logfile lf , v$standby_log l
where l.group# = lf.group#
order by 7;
--With tablespace name
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
col FNNAM for a70
SELECT
fe.inst_id,
fe.CON_ID, ---- for >12c
tablespace_name,
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
-- ,FNNAM
FROM x$kccfe fe, x$kccfn fn,v$datafile_header vh
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
and vh.file#=fn.fnfno
ORDER BY fe.fenum
;
Instance # CON_ID TABLESPACE_NAME File # File name Checkpoint # Checkpoint time Last change # SCNSTATUS STATUS
---------- ---------- ------------------------------ -------- ---------------------------------------------------------------------- --------------- -------------------- -------------------- --------------- -------
1 1 SYSTEM 1 /u01/app/oracle/oradata/ORCLCDB/system01.dbf 4196453 12/31/2022 05:31:37 <-Good SYSTEM
1 1 SYSAUX 3 /u01/app/oracle/oradata/ORCLCDB/sysaux01.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 2 SYSTEM 5 /u01/app/oracle/oradata/ORCLCDB/pdbseed/system01.dbf 2163739 05/31/2019 15:32:31 2163739 <-Good SYSOFF
1 2 SYSAUX 6 /u01/app/oracle/oradata/ORCLCDB/pdbseed/sysaux01.dbf 2163739 05/31/2019 15:32:31 2163739 <-Good OFFLINE
1 1 USERS 7 /u01/app/oracle/oradata/ORCLCDB/users01.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 2 UNDOTBS1 8 /u01/app/oracle/oradata/ORCLCDB/pdbseed/undotbs01.dbf 2163739 05/31/2019 15:32:31 2163739 <-Good OFFLINE
1 3 SYSTEM 9 /u01/app/oracle/oradata/ORCLCDB/orcl/system01.dbf 4196453 12/31/2022 05:31:37 <-Good SYSTEM
1 3 SYSAUX 10 /u01/app/oracle/oradata/ORCLCDB/orcl/sysaux01.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 3 USERS 12 /u01/app/oracle/oradata/ORCLCDB/orcl/users01.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 3 APEX_1291597703607401 13 /u01/app/oracle/oradata/ORCLCDB/orcl/APEX_1291597703607401.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 1 UNDOTBS2 14 /u01/app/oracle/oradata/ORCLCDB/undotbs2.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 3 UNDOTBS2 15 /u01/app/oracle/oradata/ORCLCDB/orcl/undotbs2.dbf 4196453 12/31/2022 05:31:37 <-Good ONLINE
1 4 16 /u01/app/oracle/oradata/ORCLCDB/orcld/system01.dbf 4078427 12/30/2022 17:42:42 <-Good SYSOFF
1 4 17 /u01/app/oracle/oradata/ORCLCDB/orcld/sysaux01.dbf 4078427 12/30/2022 17:42:42 4079972 <-Good OFFLINE
1 4 18 /u01/app/oracle/oradata/ORCLCDB/orcld/undotbs01.dbf 4078427 12/30/2022 17:42:42 4079972 <-Good OFFLINE
1 4 19 /u01/app/oracle/oradata/ORCLCDB/orcld/orcld.dbf 4078427 12/30/2022 17:42:42 4079972 <-Good OFFLINE
16 rows selected.
********************************************************************************************
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
====
RMAN>
run {
set until sequence=5;
restore database;
recover database;
}
====================================================
another restore
recovery will be done up to SCN 4456406
Media recovery start SCN is 4456406
Recovery must be done beyond SCN 4456467 to clear datafile fuzziness
Finished restore at 13-10-2024:12:20:31
define SCN_bkupstart=4456406
alter session set nls_date_format='DD-MON-RRRR HH24:MI:SS';
set linesize 300 pagesize 300
col name for a80
select name, thread#, sequence#, status, first_time, next_time, first_change#, next_change#
from v$archived_log
where &SCN_bkupstart between first_change# and next_change#;
NAME THREAD# SEQUENCE# S FIRST_TIME NEXT_TIME FIRST_CHANGE# NEXT_CHANGE#
-------------------------------------------------------------------------------- ---------- ---------- - -------------------- -------------------- ------------- ------------
/u01/app/oracle/fra/ORADB/archivelog/2024_10_13/o1_mf_1_43_mjq0pd3l_.arc 1 43 A 13-OCT-2024 12:15:11 13-OCT-2024 12:20:28 4456381 4456566
restore archivelog from logseq=seq_bkupstart until logseq=seq_bkupend;
set linesize 200 pagesize 100
col inst_id for 9999999 heading 'Instance #'
col file_nr for 9999999 heading 'File #'
col file_name for A60 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 #'
SELECT
fe.inst_id,
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,
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
;
Instance # File # File name Checkpoint # Checkpoint time Last change # STATUS
---------- -------- ------------------------------------------------------------ --------------- -------------------- -------------------- -------
1 1 /u01/app/oracle/oradata/ORADB/system01.dbf 4456566 10/13/2024 12:20:28 SYSTEM
1 3 /u01/app/oracle/oradata/ORADB/sysaux01.dbf 4456566 10/13/2024 12:20:28 ONLINE
1 4 /u01/app/oracle/oradata/ORADB/undotbs01.dbf 4456566 10/13/2024 12:20:28 ONLINE
1 5 /u01/app/oracle/oradata/ORADB/pdbseed/system01.dbf 3955320 04/20/2024 22:20:35 3955320 SYSOFF
1 6 /u01/app/oracle/oradata/ORADB/pdbseed/sysaux01.dbf 3955320 04/20/2024 22:20:35 3955320 OFFLINE
1 7 /u01/app/oracle/oradata/ORADB/users01.dbf 4456566 10/13/2024 12:20:28 ONLINE
1 8 /u01/app/oracle/oradata/ORADB/pdbseed/undotbs01.dbf 3955320 04/20/2024 22:20:35 3955320 OFFLINE
1 9 /u01/app/oracle/oradata/ORADB/pdb1/system01.dbf 4456566 10/13/2024 12:20:28 SYSTEM
1 10 /u01/app/oracle/oradata/ORADB/pdb1/sysaux01.dbf 4456566 10/13/2024 12:20:28 ONLINE
1 11 /u01/app/oracle/oradata/ORADB/pdb1/undotbs01.dbf 4456566 10/13/2024 12:20:28 ONLINE
1 12 /u01/app/oracle/oradata/ORADB/pdb1/users01.dbf 4456566 10/13/2024 12:20:28 ONLINE
11 rows selected.
RMAN> restore controlfile from '/u01/app/oracle/RmanBackup/20241013_oradb_19_1_1182255625';
Starting restore at 13-OCT-2024 12:48:18
using channel ORA_DISK_1
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=/u01/app/oracle/oradata/ORADB/control01.ctl
output file name=/u01/app/oracle/fra/ORADB/control02.ctl
Finished restore at 13-OCT-2024 12:48:19
RMAN> alter database mount ;
released channel: ORA_DISK_1
Statement processed
RMAN>
ecovery will be done up to SCN 4456406
Media recovery start SCN is 4456406
Recovery must be done beyond SCN 4456467 to clear datafile fuzziness
Finished restore at 13-10-2024:12:20:31
4456467+1
run {
set until scn 4456468;
Restore Database;
Recover Database;
Alter Database Open Resetlogs;
}
connected to target database: ORADB (DBID=2803372975, not open)
RMAN>
run {
set until scn 4456468;
Restore Database;
Recover Database;
Alter Database Open Resetlogs;
}
RMAN> 2> 3> 4> 5> 6>
executing command: SET until clause
Starting restore at 13-OCT-2024 12:58:34
Starting implicit crosscheck backup at 13-OCT-2024 12:58:34
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
Crosschecked 18 objects
Finished implicit crosscheck backup at 13-OCT-2024 12:58:35
Starting implicit crosscheck copy at 13-OCT-2024 12:58:35
using channel ORA_DISK_1
Finished implicit crosscheck copy at 13-OCT-2024 12:58:35
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u01/app/oracle/fra/ORADB/archivelog/2024_10_13/o1_mf_1_43_mjq0pd3l_.arc
File Name: /u01/app/oracle/fra/ORADB/autobackup/2024_10_13/o1_mf_s_1182255629_mjq0pfrp_.bkp
using channel ORA_DISK_1
skipping datafile 5; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/system01.dbf
skipping datafile 6; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/sysaux01.dbf
skipping datafile 8; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/undotbs01.dbf
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 /u01/app/oracle/oradata/ORADB/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORADB/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORADB/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ORADB/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/20241013_oradb_16_1_1182255319
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/20241013_oradb_16_1_1182255319 tag=TAG20241013T121519
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02: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 00009 to /u01/app/oracle/oradata/ORADB/pdb1/system01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/ORADB/pdb1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/ORADB/pdb1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/ORADB/pdb1/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/20241013_oradb_17_1_1182255445
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/20241013_oradb_17_1_1182255445 tag=TAG20241013T121519
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:15
Finished restore at 13-OCT-2024 13:01:56
Starting recover at 13-OCT-2024 13:01:56
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 43 is already on disk as file /u01/app/oracle/fra/ORADB/archivelog/2024_10_13/o1_mf_1_43_mjq0pd3l_.arc
archived log file name=/u01/app/oracle/fra/ORADB/archivelog/2024_10_13/o1_mf_1_43_mjq0pd3l_.arc thread=1 sequence=43
media recovery complete, elapsed time: 00:00:01
Finished recover at 13-OCT-2024 13:01:58
Statement processed
RMAN>
=====================================
Another restore !!!!!!
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORADB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION OFF;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/RmanBackup/control%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL 1 DEVICE TYPE DISK MAXPIECESIZE 4 G FORMAT '/u01/app/oracle/RmanBackup/%U';
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0/db_1/dbs/snapcf_oradb.f'; # default
RMAN>
[oracle@srv1 RmanBackup]$ cat rman0.sh
#!/bin/bash
export NLS_DATE_FORMAT='dd-mm-yyyy:hh24:mi:ss'
export ORACLE_SID=oradb
export ORACLE_HOME=/u01/app/oracle/product/19.0.0/db_1
export PATH=$ORACLE_HOME/bin:/usr/bin:/usr/sbin:/bin:/usr/local/bin
export LOG=/u01/app/oracle/RmanBackup/rman_`/bin/date +\%d\%m\%y:%H:%M:%S`.log
echo "level 0 backup :`date`" >$LOG
rman target / <<EOF>>$LOG
run {
backup as compressed backupset
incremental level 0
format '/u01/app/oracle/RmanBackup/%T_@_%s_%p_%t' database include current controlfile plus archivelog;
}
list backup of controlfile;
report schema;
restore database preview;
run {
delete noprompt expired backup of database;
}
EOF
echo "End level 0 backup at `date`" >> $LOG
exit ;
[oracle@srv1 RmanBackup]$
check logfile !!!
recovery will be done up to SCN 4528528
Media recovery start SCN is 4528528
Recovery must be done beyond SCN 4528611 to clear datafile fuzziness <<<<
Finished restore at 01-11-2024:14:24:30
-rw-r--r-- 1 oracle oinstall 12213 Nov 1 14:01 rman_011124:13:56:40.log
-rw-r----- 1 oracle oinstall 21031424 Nov 1 14:19 20241101_oradb_55_1_1183904344
-rw-r----- 1 oracle oinstall 970047488 Nov 1 14:21 20241101_oradb_56_1_1183904347
-rw-r----- 1 oracle oinstall 738394112 Nov 1 14:22 20241101_oradb_57_1_1183904473
-rw-r----- 1 oracle oinstall 775602176 Nov 1 14:24 20241101_oradb_58_1_1183904568
-rw-r----- 1 oracle oinstall 1130496 Nov 1 14:24 20241101_oradb_59_1_1183904664
-rw-r----- 1 oracle oinstall 31744 Nov 1 14:24 20241101_oradb_60_1_1183904666
-rw-r----- 1 oracle oinstall 18808832 Nov 1 14:24 controlc-2803372975-20241101-03
-rw-r--r-- 1 oracle oinstall 13229 Nov 1 14:24 rman_011124:14:19:02.log
SQL> startup nomount pfile=initoradb.ora ;
ORACLE instance started.
Total System Global Area 1073740992 bytes
Fixed Size 9186496 bytes
Variable Size 817889280 bytes
Database Buffers 239075328 bytes
Redo Buffers 7589888 bytes
export NLS_DATE_FORMAT='dd-mm-yyyy hh:mi:ss'
rman target / | tee rman_`/bin/date +\%d\%m\%y:%H:%M:%S`.log
RESTORE CONTROLFILE from '/u01/app/oracle/RmanBackup/controlc-2803372975-20241101-03';
RMAN> RESTORE CONTROLFILE from '/u01/app/oracle/RmanBackup/controlc-2803372975-20241101-03';
Starting restore at 01-11-2024 05:01:47
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=403 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/oradata/ORADB/control01.ctl
Finished restore at 01-11-2024 05:01:49
RMAN> alter database mount ;
released channel: ORA_DISK_1
Statement processed
Recovery must be done beyond SCN 4528611 to clear datafile fuzziness
Finished restore at 01-11-2024:14:24:30
run{
set until scn 4528612;
restore database;
RESTORE DATABASE CHECK READONLY;
recover database;
}
RMAN>
run{
set until scn 4528612;
restore database;
RESTORE DATABASE CHECK READONLY;
recover database;
}
RMAN> 2> 3> 4> 5> 6>
executing command: SET until clause
Starting restore at 01-11-2024 05:05:08
Starting implicit crosscheck backup at 01-11-2024 05:05:08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=406 device type=DISK
Crosschecked 20 objects
Finished implicit crosscheck backup at 01-11-2024 05:05:09
Starting implicit crosscheck copy at 01-11-2024 05:05:09
using channel ORA_DISK_1
Finished implicit crosscheck copy at 01-11-2024 05:05:09
searching for all files in the recovery area
cataloging files...
no files cataloged
using channel ORA_DISK_1
skipping datafile 5; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/system01.dbf
skipping datafile 6; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/sysaux01.dbf
skipping datafile 8; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/undotbs01.dbf
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 /u01/app/oracle/oradata/ORADB/system01.dbf
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/ORADB/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/ORADB/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/ORADB/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/20241101_oradb_56_1_1183904347
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/20241101_oradb_56_1_1183904347 tag=TAG20241101T141907
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:02:16
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 /u01/app/oracle/oradata/ORADB/pdb1/system01.dbf
channel ORA_DISK_1: restoring datafile 00010 to /u01/app/oracle/oradata/ORADB/pdb1/sysaux01.dbf
channel ORA_DISK_1: restoring datafile 00011 to /u01/app/oracle/oradata/ORADB/pdb1/undotbs01.dbf
channel ORA_DISK_1: restoring datafile 00012 to /u01/app/oracle/oradata/ORADB/pdb1/users01.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/RmanBackup/20241101_oradb_57_1_1183904473
channel ORA_DISK_1: piece handle=/u01/app/oracle/RmanBackup/20241101_oradb_57_1_1183904473 tag=TAG20241101T141907
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:01:16
Finished restore at 01-11-2024 05:08:42
Starting restore at 01-11-2024 05:08:42
using channel ORA_DISK_1
skipping datafile 1; already restored to file /u01/app/oracle/oradata/ORADB/system01.dbf
skipping datafile 3; already restored to file /u01/app/oracle/oradata/ORADB/sysaux01.dbf
skipping datafile 4; already restored to file /u01/app/oracle/oradata/ORADB/undotbs01.dbf
skipping datafile 7; already restored to file /u01/app/oracle/oradata/ORADB/users01.dbf
skipping datafile 5; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/system01.dbf
skipping datafile 6; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/sysaux01.dbf
skipping datafile 8; already restored to file /u01/app/oracle/oradata/ORADB/pdbseed/undotbs01.dbf
skipping datafile 9; already restored to file /u01/app/oracle/oradata/ORADB/pdb1/system01.dbf
skipping datafile 10; already restored to file /u01/app/oracle/oradata/ORADB/pdb1/sysaux01.dbf
skipping datafile 11; already restored to file /u01/app/oracle/oradata/ORADB/pdb1/undotbs01.dbf
skipping datafile 12; already restored to file /u01/app/oracle/oradata/ORADB/pdb1/users01.dbf
restore not done; all files read only, offline, excluded, or already restored
Finished restore at 01-11-2024 05:08:42
Starting recover at 01-11-2024 05:08:42
using channel ORA_DISK_1
starting media recovery
archived log for thread 1 with sequence 10 is already on disk as file /u01/app/oracle/fra/ORADB/archivelog/2024_11_01/o1_mf_1_10_ml9c2tbw_.arc
archived log file name=/u01/app/oracle/fra/ORADB/archivelog/2024_11_01/o1_mf_1_10_ml9c2tbw_.arc thread=1 sequence=10
media recovery complete, elapsed time: 00:00:01
Finished recover at 01-11-2024 05:08:44
RMAN>
RMAN> alter database open read only;
Statement processed
===========
RMAN> select * from v$database ;
DBID NAME CREATED RESETLOGS_CHANGE# RESETLOGS
---------- --------- --------- ----------------- ---------
PRIOR_RESETLOGS_CHANGE# PRIOR_RES LOG_MODE CHECKPOINT_CHANGE#
----------------------- --------- ------------ ------------------
ARCHIVE_CHANGE# CONTROL CONTROLFI CONTROLFILE_SEQUENCE# CONTROLFILE_CHANGE#
--------------- ------- --------- --------------------- -------------------
CONTROLFI OPEN_RESETL VERSION_T OPEN_MODE PROTECTION_MODE
--------- ----------- --------- -------------------- --------------------
PROTECTION_LEVEL REMOTE_A ACTIVATION# SWITCHOVER# DATABASE_ROLE
-------------------- -------- ----------- ----------- ----------------
ARCHIVELOG_CHANGE# ARCHIVEL SWITCHOVER_STATUS DATAGUAR GUARD_S SUPPLEME SUP
------------------ -------- -------------------- -------- ------- -------- ---
SUP FORCE_LOGGING PLATFORM_ID
--- --------------------------------------- -----------
PLATFORM_NAME
--------------------------------------------------------------------------------
RECOVERY_TARGET_INCARNATION# LAST_OPEN_INCARNATION# CURRENT_SCN
---------------------------- ---------------------- -----------
FLASHBACK_ON SUP SUP DB_UNIQUE_NAME
------------------ --- --- ------------------------------
STANDBY_BECAME_PRIMARY_SCN FS_FAILOVER_MODE FS_FAILOVER_STATUS
-------------------------- ------------------- ----------------------
FS_FAILOVER_CURRENT_TARGET FS_FAILOVER_THRESHOLD FS_FAIL
------------------------------ --------------------- -------
FS_FAILOVER_OBSERVER_HOST
--------------------------------------------------------------------------------
CON PRIMARY_DB_UNIQUE_NAME SUP MIN_REQUIRED_CAPTURE_CHANGE# CDB
--- ------------------------------ --- ---------------------------- ---
CON_ID
----------
PENDING_ROLE_CHANGE_TASKS
--------------------------------------------------------------------------------
CON_DBID FOR SUP
---------- --- ---
2803372975 ORADB 03-SEP-20 4470954 01-NOV-24
4456469 13-OCT-24 ARCHIVELOG 4528505
4528697 BACKUP 03-SEP-20 4811 4528717
01-NOV-24 REQUIRED 01-NOV-24 READ ONLY MAXIMUM PERFORMANCE
MAXIMUM PERFORMANCE ENABLED 2937133401 2937133401 PRIMARY
4528701 DISABLED NOT ALLOWED DISABLED NONE NO NO
NO NO 13
Linux x86 64-bit
4 4 4528611
NO NO NO oradb
0 DISABLED DISABLED
0
NO NO YES
0
NOT APPLICABLE
2803372975 NO NO
RMAN>
RMAN> shutdown immediate ;
database closed
database dismounted
Oracle instance shut down
SQL> startup mount pfile=initoradb.ora ;
ORACLE instance started.
Total System Global Area 1073740992 bytes
Fixed Size 9186496 bytes
Variable Size 817889280 bytes
Database Buffers 239075328 bytes
Redo Buffers 7589888 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL>
4 comments:
Oracle How to get only file name
http://anuj-singh.blogspot.com/2012/01/oracle-how-to-get-only-file-name-with.html
set linesize 200
col file_name format a100
select 'set newname for datafile ' ||FILE#|| ' to '||'''/oradata/dbase/'|| substr(name,instr(name,'/',-1)+1, instr(substr(name,instr(name,'/',-1)+1),'.')-1 )|| FILE# ||'.dbf'' ;' file_name from v$datafile;
Oracle How to Restore Of Single PDB via RMAN
Rman to Restore Of Single PDB in Multitenant
http://anuj-singh.blogspot.com/2022/12/oracle-how-to-restore-of-single-pdb-via.html
Archive log info
http://anuj-singh.blogspot.com/2011/05/log-switch-info-archive-log-info.html
Post a Comment