Database RAC Dataguard RMAN Performance Tuning Feedback
Database Migration & Upgradation
DataGuard
ASM & RAC
Exadata
RMAN Backup & Recovery
Oracle Cloud AWS Azure Google Cloud
DevOps Ansible Kubernetes Terraform
Shell Scripting Powershell Scripting
Infomratica Others

Thursday, August 18, 2022

Filesystem to ASM restore or RMAN clone easy way to clone databases

Filesystem to ASM restore or RMAN clone easy way to clone databases:


Source:
DB: DEVDB
OH: /u01/app/oracle/product/19.0.0.0/dbhome_1
Hostname: oraclelab1.localdomain.com
Storage: FS (Filesystem)

Target:
DB: DEVDB / TESTDB
OH: /u01/app/oracle/product/19.0.0.0/dbhome_1
Hostname: oraclelab2.localdomain.com
Storage: ASM (Automatic Storage Management)

High Level Steps:

1. Prechecks on Source and Target Servers:
2. Take Source database backup and copy them to target:
3. Restore or clone the Target database on target server:

1. Prechecks on Source and Target Servers:

Source:
ps -ef|grep smon

. oraenv
DEVDB
/u01/app/oracle/product/19.0.0.0/dbhome_1
env |grep ORA

Target:
ps -ef|grep smon

2. Take Source database backup and copy them to target:

Source:
rman target /
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
crosscheck backup;
crosscheck archivelog all;
DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-7';
backup as backupset incremental level 0 database format '/u01/backup/Fullback_%T_%U'
plus archivelog format '/u01/backup/Archive_%T_%U';
backup current controlfile format '/u01/backup/Controlback_%T_%U';
release channel ch1;
release channel ch2;
}

cd /u01/backup
ls -l

scp * oracle@targetserver:/u01/backup

Target:
cd /u01/backup
ls -l

. oraenv
+ASM
/u01/app/19.0.0.0/grid

asmcmd -p lsdg

3. Restore or clone the Target database on target server:

Option1:
Using Restore and Recover method:

. oraenv
DEVDB
/u01/app/oracle/product/19.0.0.0/dbhome_1
env |grep ORA

sqlplus / as sysdba
startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';

rman target /
restore spfile from '/u01/backup/o1_mf_s_1112662593_khhyq9gx_.bkp'; (Optional)
restore controlfile from '/u01/backup/Controlback_20220818_1515ech5_37_1_1';
alter database mount;
catalog start with '/u01/backup/';
run {
restore database;
recover database;
}
alter database open resetlogs;

sqlplus / as sysdba
select name, open_mode from v$database;
select name from v$datafile;
select name from v$controlfile;
select member from v$logfile;

cd /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
cat initDEVDB.ora
*.db_name=DEVDB
*.db_unique_name=DEVDB
*.cluster_database=false
*.audit_file_dest='/u01/app/oracle/admin/DEVDB/adump'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+RECO'
*.db_file_name_convert='/u01/app/oracle/oradata/DEVDB/datafile','+DATA'
*.log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','+DATA','/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog','+RECO'
*.control_files='+DATA/DEVDB/controlfile/control01.ctl','+RECO/DEVDB/controlfile/control02.ctl'
*.db_recovery_file_dest_size=8931M
*.db_recovery_file_dest='+RECO'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

Option2:
RMAN Clone or RMAN duplicate database method:

. oraenv
TESTDB
/u01/app/oracle/product/19.0.0.0/dbhome_1
env |grep ORA

sqlplus / as sysdba
startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initTESTDB.ora';

rman auxiliary /
duplicate target database to TESTDB backup location '/u01/backup' nofilenamecheck;

sqlplus / as sysdba
select name, open_mode from v$database;
select name from v$datafile;
select name from v$controlfile;
select member from v$logfile;

cd /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
cat initTESTDB.ora
*.db_name=TESTDB
*.db_unique_name=TESTDB
*.cluster_database=false
*.audit_file_dest='/u01/app/oracle/admin/TESTDB/adump'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+RECO'
*.db_file_name_convert='/u01/app/oracle/oradata/DEVDB/datafile','+DATA/TESTDB'
*.log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','+DATA','/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog','+RECO'
*.control_files='+DATA/TESTDB/controlfile/control01.ctl','+RECO/TESTDB/controlfile/control02.ctl'
*.db_recovery_file_dest_size=8931M
*.db_recovery_file_dest='+RECO'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'

Logs:

[oracle@oraclelab1 ~]$ ps -ef|grep smon
oracle    4467     1  0 Aug09 ?        00:00:05 ora_smon_DEVDB
oracle   14332 14251  0 00:50 pts/1    00:00:00 grep --color=auto smon
[oracle@oraclelab1 ~]$ . oraenv
ORACLE_SID = [oracle] ? DEVDB
The Oracle base has been set to /u01/app/oracle
[oracle@oraclelab1 ~]$
[oracle@oraclelab1 ~]$ env |grep ORA
ORACLE_SID=DEVDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab1 ~]$

[oracle@oraclelab2 ~]$ ps -ef|grep smon
oracle     820     1  0 Aug10 ?        00:00:04 ora_smon_TESTCDB
oracle   13480     1  0 00:53 ?        00:00:00 ora_smon_DB
oracle   13519 13362  0 00:53 pts/0    00:00:00 grep --color=auto smon
oracle   28052     1  0 Aug02 ?        00:00:14 asm_smon_+ASM
[oracle@oraclelab2 ~]$ 

Backup:
rman target /
run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
crosscheck backup;
crosscheck archivelog all;
DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-7';
backup as backupset incremental level 0 database format '/u01/backup/Fullback_%T_%U'
plus archivelog format '/u01/backup/Archive_%T_%U';
backup current controlfile format '/u01/backup/Controlback_%T_%U';
release channel ch1;
release channel ch2;
}

[oracle@oraclelab1 backup]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Aug 14 00:55:57 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DEVDB (DBID=1016989223)

RMAN> run {
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
2> 3> 4> crosscheck backup;
crosscheck archivelog all;
5> 6> DELETE noprompt archivelog all COMPLETED BEFORE 'SYSDATE-7';
backup as backupset incremental level 0 database format '/u01/backup/Fullback_%T_%U'
plus archivelog format '/u01/backup/Archive_%T_%U';
backup current controlfile format '/u01/backup/Controlback_%T_%U';
release channel ch1;
release channel ch2;
}7> 8> 9> 10> 11> 12>

using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=45 device type=DISK

allocated channel: ch2
channel ch2: SID=266 device type=DISK

crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Archive_20220809_0114nkpn_1_1_1 RECID=1 STAMP=1112265527
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Fullback_20220809_0314nkpo_3_1_1 RECID=2 STAMP=1112265528
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Fullback_20220809_0214nkpo_2_1_1 RECID=3 STAMP=1112265528
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Archive_20220809_0414nkq7_4_1_1 RECID=4 STAMP=1112265543
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Controlback_20220809_0514nkq9_5_1_1 RECID=5 STAMP=1112265546
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_09/o1_mf_s_1112265547_kh3tzmcg_.bkp RECID=6 STAMP=1112265547
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Archive_20220809_0814nkr3_8_1_1 RECID=7 STAMP=1112265571
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Archive_20220809_0714nkr3_7_1_1 RECID=8 STAMP=1112265571
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Fullback_20220809_0a14nkr4_10_1_1 RECID=9 STAMP=1112265572
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Fullback_20220809_0914nkr4_9_1_1 RECID=10 STAMP=1112265572
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Archive_20220809_0b14nkrj_11_1_1 RECID=11 STAMP=1112265587
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_09/o1_mf_s_1112265591_kh3v0z9l_.bkp RECID=13 STAMP=1112265591
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Controlback_20220809_0c14nkrl_12_1_1 RECID=12 STAMP=1112265590
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_09/o1_mf_s_1112265727_kh3v57jc_.bkp RECID=15 STAMP=1112265727
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Controlback_20220809_0e14nkvt_14_1_1 RECID=14 STAMP=1112265726
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_09/o1_mf_s_1112265744_kh3v5s0q_.bkp RECID=17 STAMP=1112265745
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Controlback_20220809_0g14nl0e_16_1_1 RECID=16 STAMP=1112265743
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_09/o1_mf_s_1112265762_kh3v6bdm_.bkp RECID=19 STAMP=1112265762
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Controlback_20220809_0i14nl10_18_1_1 RECID=18 STAMP=1112265761
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_09/o1_mf_s_1112265780_kh3v6wom_.bkp RECID=21 STAMP=1112265780
Crosschecked 11 objects

crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/backup/Controlback_20220809_0k14nl1i_20_1_1 RECID=20 STAMP=1112265779
Crosschecked 10 objects


validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_09/o1_mf_1_9_kh3tyxp3_.arc RECID=1 STAMP=1112265527
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_09/o1_mf_1_10_kh3tzhrn_.arc RECID=2 STAMP=1112265543
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_09/o1_mf_1_11_kh3v0c1y_.arc RECID=3 STAMP=1112265571
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_09/o1_mf_1_12_kh3v0voq_.arc RECID=4 STAMP=1112265587
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_09/o1_mf_1_13_kh531h0f_.arc RECID=5 STAMP=1112306567
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_10/o1_mf_1_14_kh6owtq9_.arc RECID=6 STAMP=1112358643
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_11/o1_mf_1_15_kh9o2l93_.arc RECID=7 STAMP=1112456107
validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_12/o1_mf_1_16_khf00w97_.arc RECID=8 STAMP=1112565621
Crosschecked 4 objects

validation succeeded for archived log
archived log file name=/u01/app/oracle/fast_recovery_area/DEVDB/archivelog/2022_08_13/o1_mf_1_17_khgrn9mq_.arc RECID=9 STAMP=1112623586
Crosschecked 5 objects




Starting backup at 14-AUG-22
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=14 RECID=6 STAMP=1112358643
input archived log thread=1 sequence=15 RECID=7 STAMP=1112456107
input archived log thread=1 sequence=16 RECID=8 STAMP=1112565621
input archived log thread=1 sequence=17 RECID=9 STAMP=1112623586
channel ch1: starting piece 1 at 14-AUG-22
channel ch2: starting archived log backup set
channel ch2: specifying archived log(s) in backup set
input archived log thread=1 sequence=9 RECID=1 STAMP=1112265527
input archived log thread=1 sequence=10 RECID=2 STAMP=1112265543
input archived log thread=1 sequence=11 RECID=3 STAMP=1112265571
input archived log thread=1 sequence=12 RECID=4 STAMP=1112265587
input archived log thread=1 sequence=13 RECID=5 STAMP=1112306567
channel ch2: starting piece 1 at 14-AUG-22
channel ch1: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Archive_20220814_0m153oh6_22_1_1 tag=TAG20220814T005606 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:07
channel ch1: starting archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=18 RECID=10 STAMP=1112662566
channel ch1: starting piece 1 at 14-AUG-22
channel ch2: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Archive_20220814_0n153oh6_23_1_1 tag=TAG20220814T005606 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:07
channel ch1: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Archive_20220814_0o153ohd_24_1_1 tag=TAG20220814T005606 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-AUG-22

Starting backup at 14-AUG-22
channel ch1: starting incremental level 0 datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf
channel ch1: starting piece 1 at 14-AUG-22
channel ch2: starting incremental level 0 datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf
channel ch2: starting piece 1 at 14-AUG-22
channel ch1: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Fullback_20220814_0p153ohe_25_1_1 tag=TAG20220814T005614 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:15
channel ch2: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Fullback_20220814_0q153ohe_26_1_1 tag=TAG20220814T005614 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:15
Finished backup at 14-AUG-22

Starting backup at 14-AUG-22
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=19 RECID=11 STAMP=1112662589
channel ch1: starting piece 1 at 14-AUG-22
channel ch1: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Archive_20220814_0r153ohu_27_1_1 tag=TAG20220814T005629 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-AUG-22

Starting backup at 14-AUG-22
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 14-AUG-22
channel ch1: finished piece 1 at 14-AUG-22
piece handle=/u01/backup/Controlback_20220814_0s153ohv_28_1_1 tag=TAG20220814T005631 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 14-AUG-22

Starting Control File and SPFILE Autobackup at 14-AUG-22
piece handle=/u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_14/o1_mf_s_1112662593_khhyq9gx_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 14-AUG-22

released channel: ch1

released channel: ch2

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab1 backup]$
[oracle@oraclelab1 backup]$ ll
total 2897660
-rw-r-----. 1 oracle oinstall 722199552 Aug 14 00:56 Archive_20220814_0m153oh6_22_1_1
-rw-r-----. 1 oracle oinstall 326240768 Aug 14 00:56 Archive_20220814_0n153oh6_23_1_1
-rw-r-----. 1 oracle oinstall 113453056 Aug 14 00:56 Archive_20220814_0o153ohd_24_1_1
-rw-r-----. 1 oracle oinstall      7168 Aug 14 00:56 Archive_20220814_0r153ohu_27_1_1
-rw-r-----. 1 oracle oinstall  10682368 Aug 14 00:56 Controlback_20220814_0s153ohv_28_1_1
-rw-r-----. 1 oracle oinstall 845447168 Aug 14 00:56 Fullback_20220814_0p153ohe_25_1_1
-rw-r-----. 1 oracle oinstall 949166080 Aug 14 00:56 Fullback_20220814_0q153ohe_26_1_1
[oracle@oraclelab1 backup]$ scp * pwd
pwd: No such file or directory
[oracle@oraclelab1 backup]$ pwd
/u01/backup
[oracle@oraclelab1 backup]$ scp * oracle@10.38.4.179:/u01/backup/
The authenticity of host '10.38.4.179 (10.38.4.179)' can't be established.
ECDSA key fingerprint is SHA256:4GqjlDbP33EKEI9AUSxXgPUPnaJwbAUY7I5Xr1lIVsU.
ECDSA key fingerprint is MD5:fc:f8:eb:34:c8:83:fd:5b:41:0b:5e:dc:d7:1a:90:1f.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added '10.38.4.179' (ECDSA) to the list of known hosts.
oracle@10.38.4.179's password:
Archive_20220814_0m153oh6_22_1_1                                                                                                                       100%  689MB 180.2MB/s   00:03
Archive_20220814_0n153oh6_23_1_1                                                                                                                       100%  311MB 187.2MB/s   00:01
Archive_20220814_0o153ohd_24_1_1                                                                                                                       100%  108MB 160.1MB/s   00:00
Archive_20220814_0r153ohu_27_1_1                                                                                                                       100% 7168    58.4KB/s   00:00
Controlback_20220814_0s153ohv_28_1_1                                                                                                                   100%   10MB 105.1MB/s   00:00
Fullback_20220814_0p153ohe_25_1_1                                                                                                                      100%  806MB 162.2MB/s   00:04
Fullback_20220814_0q153ohe_26_1_1                                                                                                                      100%  905MB 181.0MB/s   00:05
[oracle@oraclelab1 backup]$ scp /u01/app/oracle/fast_recovery_area/DEVDB/autobackup/2022_08_14/o1_mf_s_1112662593_khhyq9gx_.bkp oracle@10.38.4.179:/u01/backup/
oracle@10.38.4.179's password:
o1_mf_s_1112662593_khhyq9gx_.bkp                                                                                                                       100%   10MB  70.5MB/s   00:00
[oracle@oraclelab1 backup]$

[oracle@oraclelab2 ~]$ cd /u01/backup
[oracle@oraclelab2 backup]$ ll
total 2908124
-rw-r-----. 1 oracle oinstall 722199552 Aug 14 00:57 Archive_20220814_0m153oh6_22_1_1
-rw-r-----. 1 oracle oinstall 326240768 Aug 14 00:57 Archive_20220814_0n153oh6_23_1_1
-rw-r-----. 1 oracle oinstall 113453056 Aug 14 00:57 Archive_20220814_0o153ohd_24_1_1
-rw-r-----. 1 oracle oinstall      7168 Aug 14 00:57 Archive_20220814_0r153ohu_27_1_1
-rw-r-----. 1 oracle oinstall  10682368 Aug 14 00:57 Controlback_20220814_0s153ohv_28_1_1
-rw-r-----. 1 oracle oinstall 845447168 Aug 14 00:57 Fullback_20220814_0p153ohe_25_1_1
-rw-r-----. 1 oracle oinstall 949166080 Aug 14 00:58 Fullback_20220814_0q153ohe_26_1_1
-rw-r-----. 1 oracle oinstall  10715136 Aug 14 00:58 o1_mf_s_1112662593_khhyq9gx_.bkp
[oracle@oraclelab2 backup]$


[oracle@oraclelab2 ~]$ . oraenv
ORACLE_SID = [TESTCDB] ? +ASM
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oraclelab2 ~]$ asmcmd -p
ASMCMD [+] >
ASMCMD [+] > lsdg
State    Type    Rebal  Sector  Logical_Sector  Block       AU  Total_MB  Free_MB  Req_mir_free_MB  Usable_file_MB  Offline_disks  Voting_files  Name
MOUNTED  EXTERN  N         512             512   4096  4194304     20476    13780                0           13780              0             N  DATA/
MOUNTED  NORMAL  N         512             512   4096  1048576      3069     2910             1023             943              0             N  DGROUPA/
MOUNTED  EXTERN  N         512             512   4096  4194304      3068     2968                0            2968              0             N  OCR/
MOUNTED  EXTERN  N         512             512   4096  4194304     10236     8320                0            8320              0             N  RECO/
ASMCMD [+] >

Restore and Recover schenario:

sqlplus / as sysdba
startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';

rman target /
restore spfile from '/u01/backup/o1_mf_s_1112662593_khhyq9gx_.bkp';
restore controlfile from '/u01/backup/Controlback_20220814_0s153ohv_28_1_1';
alter database mount;
catalog start with '/u01/backup/';
run {
restore database;
recover database;
}
alter database open resetlogs;

sqlplus / as sysdba
select name, open_mode from v$database;

[oracle@oraclenode1 dbs]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
[oracle@oraclenode1 dbs]$ cat initDEVDB.ora
*.db_name=DEVDB
*.db_unique_name=DEVDB
*.cluster_database=false
*.audit_file_dest='/u01/app/oracle/admin/DEVDB/adump'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+RECO'
*.db_file_name_convert='/u01/app/oracle/oradata/DEVDB/datafile','+DATA'
*.log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','+DATA','/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog','+RECO'
*.control_files='+DATA/DEVDB/controlfile/control01.ctl','+RECO/DEVDB/controlfile/control02.ctl'
*.db_recovery_file_dest_size=8931M
*.db_recovery_file_dest='+RECO'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
[oracle@oraclenode1 dbs]$


[oracle@oraclelab2 dbs]$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
[oracle@oraclelab2 dbs]$ cat initDEVDB.ora
*.db_name=DEVDB
*.db_unique_name=DEVDB
*.cluster_database=false
*.audit_file_dest='/u01/app/oracle/admin/DEVDB/adump'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+RECO'
*.db_file_name_convert='/u01/app/oracle/oradata/DEVDB/datafile','+DATA'
*.log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','+DATA','/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog','+RECO'
*.control_files='+DATA/DEVDB/controlfile/control01.ctl','+RECO/DEVDB/controlfile/control02.ctl'
*.db_recovery_file_dest_size=8931M
*.db_recovery_file_dest='+RECO'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
[oracle@oraclelab2 dbs]$ . oraenv
ORACLE_SID = [TESTCDB] ? DEVDB
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oraclelab2 dbs]$
[oracle@oraclelab2 dbs]$ env |grep ORA
ORACLE_SID=DEVDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 14 01:05:29 2022
Version 19.14.0.0.0

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
SQL> exit
Disconnected
[oracle@oraclelab2 dbs]$ mkdir -p /u01/app/oracle/admin/DEVDB/adump
[oracle@oraclelab2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 14 01:06:12 2022
Version 19.14.0.0.0

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initDEVDB.ora';
ORACLE instance started.

Total System Global Area  264239920 bytes
Fixed Size                  8895280 bytes
Variable Size             213909504 bytes
Database Buffers           33554432 bytes
Redo Buffers                7880704 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
[oracle@oraclelab2 dbs]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Aug 14 01:06:31 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DEVDB (not mounted)

RMAN> restore controlfile from '/u01/backup/Controlback_20220814_0s153ohv_28_1_1';

Starting restore at 14-AUG-22
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=183 device type=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
output file name=+DATA/DEVDB/controlfile/control01.ctl
output file name=+RECO/DEVDB/controlfile/control02.ctl
Finished restore at 14-AUG-22

RMAN> alter database mount;

released channel: ORA_DISK_1
Statement processed

RMAN> catalog start with '/u01/backup/';

Starting implicit crosscheck backup at 14-AUG-22
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=187 device type=DISK
Crosschecked 27 objects
Finished implicit crosscheck backup at 14-AUG-22

Starting implicit crosscheck copy at 14-AUG-22
using channel ORA_DISK_1
Finished implicit crosscheck copy at 14-AUG-22

searching for all files in the recovery area
cataloging files...
no files cataloged

searching for all files that match the pattern /u01/backup/

List of Files Unknown to the Database
=====================================
File Name: /u01/backup/Controlback_20220814_0s153ohv_28_1_1
File Name: /u01/backup/o1_mf_s_1112662593_khhyq9gx_.bkp

Do you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /u01/backup/Controlback_20220814_0s153ohv_28_1_1
File Name: /u01/backup/o1_mf_s_1112662593_khhyq9gx_.bkp

RMAN> restore database;

Starting restore at 14-AUG-22
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/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf
channel ORA_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/Fullback_20220814_0q153ohe_26_1_1
channel ORA_DISK_1: piece handle=/u01/backup/Fullback_20220814_0q153ohe_26_1_1 tag=TAG20220814T005614
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf
channel ORA_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf
channel ORA_DISK_1: reading from backup piece /u01/backup/Fullback_20220814_0p153ohe_25_1_1
channel ORA_DISK_1: piece handle=/u01/backup/Fullback_20220814_0p153ohe_25_1_1 tag=TAG20220814T005614
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 14-AUG-22

RMAN> recover database;

Starting recover at 14-AUG-22
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=19
channel ORA_DISK_1: reading from backup piece /u01/backup/Archive_20220814_0r153ohu_27_1_1
channel ORA_DISK_1: piece handle=/u01/backup/Archive_20220814_0r153ohu_27_1_1 tag=TAG20220814T005629
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+RECO/DEVDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.292.1112663281 thread=1 sequence=19
channel default: deleting archived log(s)
archived log file name=+RECO/DEVDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.292.1112663281 RECID=12 STAMP=1112663281
unable to find archived log
archived log thread=1 sequence=20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 08/14/2022 01:08:03
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 20 and starting SCN of 2722305

RMAN> alter database open resetlogs;

Statement processed

RMAN> exit

Recovery Manager complete.
[oracle@oraclelab2 dbs]$


Errors1:
[oracle@oraclelab2 trace]$ tail -f /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
2022-08-14T01:07:27.403519+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_mz00_16155.trc:
ORA-01110: data file 1: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:07:27.572247+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_mz00_16155.trc:
ORA-01110: data file 3: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:07:27.670230+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_mz00_16155.trc:
ORA-01110: data file 4: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:07:27.770400+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_mz00_16155.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Checker run found 5 new persistent data failures
2022-08-14T01:07:39.491045+05:30
Full restore complete of datafile 7 +DATA/DEVDB/DATAFILE/users.283.1112663259.  Elapsed time: 0:00:00
  checkpoint is 2722290
  last deallocation scn is 2441149
2022-08-14T01:07:42.121448+05:30
Full restore complete of datafile 1 +DATA/DEVDB/DATAFILE/system.282.1112663259.  Elapsed time: 0:00:03
  checkpoint is 2722290
  last deallocation scn is 2433499
  Undo Optimization current scn is 2721488
2022-08-14T01:07:43.638061+05:30
Full restore complete of datafile 4 +DATA/DEVDB/DATAFILE/undotbs1.285.1112663263.  Elapsed time: 0:00:01
  checkpoint is 2722288
  last deallocation scn is 2720952
  Undo Optimization current scn is 2721488
2022-08-14T01:07:46.170576+05:30
Full restore complete of datafile 3 +DATA/DEVDB/DATAFILE/sysaux.284.1112663263.  Elapsed time: 0:00:04
  checkpoint is 2722288
  last deallocation scn is 2714914
2022-08-14T01:08:00.686801+05:30
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
 1 , 3 , 4 , 7
Completed: alter database recover datafile list
 1 , 3 , 4 , 7
alter database recover
 if needed start until cancel using backup controlfile
2022-08-14T01:08:00.712009+05:30
Media Recovery Start
 Started logmerger process
2022-08-14T01:08:00.884979+05:30
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: alter database recover
 if needed start until cancel using backup controlfile
...
2022-08-14T01:08:02.465885+05:30
alter database recover logfile '+RECO/DEVDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.292.1112663281'
2022-08-14T01:08:02.465992+05:30
Media Recovery Log +RECO/DEVDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.292.1112663281
ORA-279 signalled during: alter database recover logfile '+RECO/DEVDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.292.1112663281'...
alter database recover cancel
2022-08-14T01:08:03.004121+05:30
Media Recovery Canceled


Errors2:
[oracle@oraclelab2 trace]$ tail -f /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
2022-08-14T01:08:12.720788+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_ora_16122.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:08:12.721023+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_ora_16122.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Deleted Oracle managed file /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log
2022-08-14T01:08:16.999649+05:30
.... (PID:16122): Clearing online redo logfile 1 complete
.... (PID:16122): Clearing online redo logfile 2 complete
.... (PID:16122): Clearing online redo logfile 3 complete
Resetting resetlogs activation ID 1016972583 (0x3c9dc527)
Online log +DATA/DEVDB/ONLINELOG/group_1.286.1112663293: Thread 1 Group 1 was previously cleared
Online log +RECO/DEVDB/ONLINELOG/group_1.291.1112663293: Thread 1 Group 1 was previously cleared
Online log +DATA/DEVDB/ONLINELOG/group_2.288.1112663293: Thread 1 Group 2 was previously cleared
Online log +RECO/DEVDB/ONLINELOG/group_2.290.1112663293: Thread 1 Group 2 was previously cleared
Online log +DATA/DEVDB/ONLINELOG/group_3.287.1112663293: Thread 1 Group 3 was previously cleared
Online log +RECO/DEVDB/ONLINELOG/group_3.292.1112663293: Thread 1 Group 3 was previously cleared
2022-08-14T01:08:17.064416+05:30
Setting recovery target incarnation to 3
2022-08-14T01:08:17.125148+05:30

Errors3:
[oracle@oraclelab2 trace]$ tail -f /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/alert_DEVDB.log
2022-08-14T01:08:17.594349+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_dbw0_15986.trc:
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_temp_kh3nttq6_.tmp'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:08:17.595216+05:30
Errors in file /u01/app/oracle/diag/rdbms/devdb/DEVDB/trace/DEVDB_dbw0_15986.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_temp_kh3nttq6_.tmp'
2022-08-14T01:08:17.595336+05:30
File 201 not verified due to error ORA-01157
2022-08-14T01:08:17.599961+05:30
Dictionary check complete
Re-creating tempfile /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_temp_kh3nttq6_.tmp as +DATA/DEVDB/TEMPFILE/temp.289.1112663297
Database Characterset is AL32UTF8

[oracle@oraclelab2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 14 01:08:29 2022
Version 19.14.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
DEVDB     READ WRITE

SQL>
SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATA/DEVDB/DATAFILE/system.282.1112663259
+DATA/DEVDB/DATAFILE/sysaux.284.1112663263
+DATA/DEVDB/DATAFILE/undotbs1.285.1112663263
+DATA/DEVDB/DATAFILE/users.283.1112663259

SQL>
SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+DATA/DEVDB/controlfile/control01.ctl
+RECO/DEVDB/controlfile/control02.ctl

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/DEVDB/ONLINELOG/group_3.287.1112663293
+RECO/DEVDB/ONLINELOG/group_3.292.1112663293
+DATA/DEVDB/ONLINELOG/group_2.288.1112663293
+RECO/DEVDB/ONLINELOG/group_2.290.1112663293
+DATA/DEVDB/ONLINELOG/group_1.286.1112663293
+RECO/DEVDB/ONLINELOG/group_1.291.1112663293

6 rows selected.

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL>


RMAN Clone schenario:

sqlplus / as sysdba
startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initTESTDB.ora';

rman auxiliary /
duplicate target database to TESTDB backup location '/u01/backup' nofilenamecheck;

sqlplus / as sysdba
select name, open_mode from v$database;


[oracle@oraclenode1 dbs]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
[oracle@oraclenode1 dbs]$ cat initTESTDB.ora
*.db_name=TESTDB
*.db_unique_name=TESTDB
*.cluster_database=false
*.audit_file_dest='/u01/app/oracle/admin/TESTDB/adump'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+RECO'
*.db_file_name_convert='/u01/app/oracle/oradata/DEVDB/datafile','+DATA'
*.log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','+DATA','/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog','+RECO'
*.control_files='+DATA/TESTDB/controlfile/control01.ctl','+RECO/TESTDB/controlfile/control02.ctl'
*.db_recovery_file_dest_size=8931M
*.db_recovery_file_dest='+RECO'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
[oracle@oraclenode1 dbs]$

[oracle@oraclelab2 dbs]$ cd /u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
[oracle@oraclelab2 dbs]$ pwd
/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs
[oracle@oraclelab2 dbs]$ cat initTESTDB.ora
*.db_name=TESTDB
*.db_unique_name=TESTDB
*.cluster_database=false
*.audit_file_dest='/u01/app/oracle/admin/TESTDB/adump'
*.db_create_file_dest='+DATA'
*.db_create_online_log_dest_1='+DATA'
*.db_create_online_log_dest_2='+RECO'
*.db_file_name_convert='/u01/app/oracle/oradata/DEVDB/datafile','+DATA'
*.log_file_name_convert='/u01/app/oracle/oradata/DEVDB/onlinelog','+DATA','/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog','+RECO'
*.control_files='+DATA/TESTDB/controlfile/control01.ctl','+RECO/TESTDB/controlfile/control02.ctl'
*.db_recovery_file_dest_size=8931M
*.db_recovery_file_dest='+RECO'
*.log_archive_dest_1='LOCATION=USE_DB_RECOVERY_FILE_DEST'
[oracle@oraclelab2 dbs]$
[oracle@oraclelab2 dbs]$ mkdir -p /u01/app/oracle/admin/TESTDB/adump
[oracle@oraclelab2 dbs]$
[oracle@oraclelab2 dbs]$ . oraenv
ORACLE_SID = [DEVDB] ? TESTDB
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19.0.0.0/dbhome_1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oraclelab2 dbs]$
[oracle@oraclelab2 dbs]$ env |grep ORA
ORACLE_SID=TESTDB
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@oraclelab2 dbs]$
[oracle@oraclelab2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 14 01:18:19 2022
Version 19.14.0.0.0

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

Connected to an idle instance.

SQL> startup nomount pfile='/u01/app/oracle/product/19.0.0.0/dbhome_1/dbs/initTESTDB.ora';
ORACLE instance started.

Total System Global Area  264239920 bytes
Fixed Size                  8895280 bytes
Variable Size             213909504 bytes
Database Buffers           33554432 bytes
Redo Buffers                7880704 bytes
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0
[oracle@oraclelab2 dbs]$ rman auxiliary /

Recovery Manager: Release 19.0.0.0.0 - Production on Sun Aug 14 01:18:48 2022
Version 19.14.0.0.0

Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.

connected to auxiliary database: TESTDB (not mounted)

RMAN> duplicate target database to TESTDB backup location '/u01/backup' nofilenamecheck;

Starting Duplicate Db at 14-AUG-22
searching for database ID
found backup of database ID 1016989223

contents of Memory Script:
{
   sql clone "create spfile from memory";
}
executing Memory Script

sql statement: create spfile from memory

contents of Memory Script:
{
   shutdown clone immediate;
   startup clone nomount;
}
executing Memory Script

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area     264239920 bytes

Fixed Size                     8895280 bytes
Variable Size                213909504 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7880704 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''DEVDB'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   sql clone "alter system set  db_unique_name =
 ''TESTDB'' comment=
 ''Modified by RMAN duplicate'' scope=spfile";
   shutdown clone immediate;
   startup clone force nomount
   restore clone primary controlfile from  '/u01/backup/o1_mf_s_1112662593_khhyq9gx_.bkp';
   alter clone database mount;
}
executing Memory Script

sql statement: alter system set  db_name =  ''DEVDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

sql statement: alter system set  db_unique_name =  ''TESTDB'' comment= ''Modified by RMAN duplicate'' scope=spfile

Oracle instance shut down

Oracle instance started

Total System Global Area     264239920 bytes

Fixed Size                     8895280 bytes
Variable Size                213909504 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7880704 bytes

Starting restore at 14-AUG-22
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK

channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=+DATA/TESTDB/controlfile/control01.ctl
output file name=+RECO/TESTDB/controlfile/control02.ctl
Finished restore at 14-AUG-22

database mounted
released channel: ORA_AUX_DISK_1
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=23 device type=DISK
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_1_kh3ntkp7_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_1_kh3ntm6f_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_2_kh3ntkq3_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_2_kh3ntmn8_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (logfile) file name /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (datafile) file name /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf conflicts with a file used by the target database
RMAN-05158: WARNING: auxiliary (tempfile) file name /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_temp_kh3nttq6_.tmp conflicts with a file used by the target database

contents of Memory Script:
{
   set until scn  2722305;
   set newname for datafile  1 to
 "/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf";
   set newname for datafile  3 to
 "/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf";
   set newname for datafile  4 to
 "/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf";
   set newname for datafile  7 to
 "/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf";
   restore
   clone database
   ;
}
executing Memory Script

executing command: SET until clause

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 14-AUG-22
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00007 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Fullback_20220814_0q153ohe_26_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Fullback_20220814_0q153ohe_26_1_1 tag=TAG20220814T005614
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Fullback_20220814_0p153ohe_25_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Fullback_20220814_0p153ohe_25_1_1 tag=TAG20220814T005614
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
Finished restore at 14-AUG-22

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=1112664015 file name=+DATA/TESTDB/DATAFILE/system.291.1112664009
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=1112664015 file name=+DATA/TESTDB/DATAFILE/sysaux.293.1112664013
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=1112664015 file name=+DATA/TESTDB/DATAFILE/undotbs1.294.1112664013
datafile 7 switched to datafile copy
input datafile copy RECID=4 STAMP=1112664015 file name=+DATA/TESTDB/DATAFILE/users.292.1112664009

contents of Memory Script:
{
   set until scn  2722305;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script

executing command: SET until clause

Starting recover at 14-AUG-22
using channel ORA_AUX_DISK_1

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to default destination
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=19
channel ORA_AUX_DISK_1: reading from backup piece /u01/backup/Archive_20220814_0r153ohu_27_1_1
channel ORA_AUX_DISK_1: piece handle=/u01/backup/Archive_20220814_0r153ohu_27_1_1 tag=TAG20220814T005629
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=+RECO/TESTDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.285.1112664017 thread=1 sequence=19
channel clone_default: deleting archived log(s)
archived log file name=+RECO/TESTDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.285.1112664017 RECID=1 STAMP=1112664016
media recovery complete, elapsed time: 00:00:01
Finished recover at 14-AUG-22
Oracle instance started

Total System Global Area     264239920 bytes

Fixed Size                     8895280 bytes
Variable Size                213909504 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7880704 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name =
 ''TESTDB'' comment=
 ''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
}
executing Memory Script

sql statement: alter system set  db_name =  ''TESTDB'' comment= ''Reset to original value by RMAN'' scope=spfile

sql statement: alter system reset  db_unique_name scope=spfile
Oracle instance started

Total System Global Area     264239920 bytes

Fixed Size                     8895280 bytes
Variable Size                213909504 bytes
Database Buffers              33554432 bytes
Redo Buffers                   7880704 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TESTDB" RESETLOGS ARCHIVELOG
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP     1 ( '/u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_1_kh3ntkp7_.log', '/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_1_kh3ntm6f_.log' ) SIZE 200 M  REUSE,
  GROUP     2 ( '/u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_2_kh3ntkq3_.log', '/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_2_kh3ntmn8_.log' ) SIZE 200 M  REUSE,
  GROUP     3 ( '/u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log', '/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log' ) SIZE 200 M  REUSE
 DATAFILE
  '+DATA/TESTDB/DATAFILE/system.291.1112664009'
 CHARACTER SET AL32UTF8


contents of Memory Script:
{
   set newname for tempfile  1 to
 "/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_temp_kh3nttq6_.tmp";
   switch clone tempfile all;
   catalog clone datafilecopy  "+DATA/TESTDB/DATAFILE/sysaux.293.1112664013",
 "+DATA/TESTDB/DATAFILE/undotbs1.294.1112664013",
 "+DATA/TESTDB/DATAFILE/users.292.1112664009";
   switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/DEVDB/datafile/o1_mf_temp_kh3nttq6_.tmp in control file

cataloged datafile copy
datafile copy file name=+DATA/TESTDB/DATAFILE/sysaux.293.1112664013 RECID=1 STAMP=1112664043
cataloged datafile copy
datafile copy file name=+DATA/TESTDB/DATAFILE/undotbs1.294.1112664013 RECID=2 STAMP=1112664043
cataloged datafile copy
datafile copy file name=+DATA/TESTDB/DATAFILE/users.292.1112664009 RECID=3 STAMP=1112664043

datafile 3 switched to datafile copy
input datafile copy RECID=1 STAMP=1112664043 file name=+DATA/TESTDB/DATAFILE/sysaux.293.1112664013
datafile 4 switched to datafile copy
input datafile copy RECID=2 STAMP=1112664043 file name=+DATA/TESTDB/DATAFILE/undotbs1.294.1112664013
datafile 7 switched to datafile copy
input datafile copy RECID=3 STAMP=1112664043 file name=+DATA/TESTDB/DATAFILE/users.292.1112664009

contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script

database opened
Cannot remove created server parameter file
Finished Duplicate Db at 14-AUG-22

RMAN> exit


Recovery Manager complete.
[oracle@oraclelab2 dbs]$


Errors1:
[oracle@oraclelab2 trace]$ tail -f /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/alert_TESTDB.log
Completed: alter database mount
2022-08-14T01:20:09.095548+05:30
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_mz00_17728.trc:
ORA-01110: data file 1: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_system_kh3nqhcn_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:20:09.300456+05:30
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_mz00_17728.trc:
ORA-01110: data file 3: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_sysaux_kh3nrlj4_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:20:09.426619+05:30
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_mz00_17728.trc:
ORA-01110: data file 4: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_undotbs1_kh3nscnc_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:20:09.540599+05:30
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_mz00_17728.trc:
ORA-01110: data file 7: '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf'
ORA-01565: error in identifying file '/u01/app/oracle/oradata/DEVDB/datafile/o1_mf_users_kh3nsdqj_.dbf'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
2022-08-14T01:20:09.575694+05:30
Full restore complete of datafile 7 +DATA/TESTDB/DATAFILE/users.292.1112664009.  Elapsed time: 0:00:00
  checkpoint is 2722290
  last deallocation scn is 2441149
Checker run found 5 new persistent data failures
2022-08-14T01:20:12.131355+05:30
Full restore complete of datafile 1 +DATA/TESTDB/DATAFILE/system.291.1112664009.  Elapsed time: 0:00:02
  checkpoint is 2722290
  last deallocation scn is 2433499
  Undo Optimization current scn is 2721488
2022-08-14T01:20:13.501864+05:30
Full restore complete of datafile 4 +DATA/TESTDB/DATAFILE/undotbs1.294.1112664013.  Elapsed time: 0:00:01
  checkpoint is 2722288
  last deallocation scn is 2720952
  Undo Optimization current scn is 2721488
2022-08-14T01:20:15.538422+05:30
Full restore complete of datafile 3 +DATA/TESTDB/DATAFILE/sysaux.293.1112664013.  Elapsed time: 0:00:03
  checkpoint is 2722288
  last deallocation scn is 2714914
2022-08-14T01:20:15.708959+05:30
Switch of datafile 1 complete to datafile copy
  checkpoint is 2722290
Switch of datafile 3 complete to datafile copy
  checkpoint is 2722288
Switch of datafile 4 complete to datafile copy
  checkpoint is 2722288
Switch of datafile 7 complete to datafile copy
  checkpoint is 2722290
setnotrustfnames set to : 0
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
 1 , 3 , 4 , 7
Completed: alter database recover datafile list
 1 , 3 , 4 , 7
alter database recover
 if needed start until change 2722305 using backup controlfile
Media Recovery Start
 Started logmerger process
2022-08-14T01:20:16.217704+05:30
Parallel Media Recovery started with 2 slaves
ORA-279 signalled during: alter database recover
 if needed start until change 2722305 using backup controlfile
...
2022-08-14T01:20:17.728921+05:30
alter database recover logfile '+RECO/TESTDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.285.1112664017'
2022-08-14T01:20:17.729009+05:30
Media Recovery Log +RECO/TESTDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.285.1112664017
2022-08-14T01:20:17.866952+05:30
Incomplete Recovery applied until change 2722305 time 08/14/2022 00:56:29
2022-08-14T01:20:17.869551+05:30
Media Recovery Complete (TESTDB)
Completed: alter database recover logfile '+RECO/TESTDB/ARCHIVELOG/2022_08_14/thread_1_seq_19.285.1112664017'
2022-08-14T01:20:18.126958+05:30
zeroing database id of data file (1): +DATA/TESTDB/DATAFILE/system.291.1112664009
zeroing database id of data file (3): +DATA/TESTDB/DATAFILE/sysaux.293.1112664013
zeroing database id of data file (4): +DATA/TESTDB/DATAFILE/undotbs1.294.1112664013
zeroing database id of data file (7): +DATA/TESTDB/DATAFILE/users.292.1112664009
2022-08-14T01:20:19.214648+05:30

Errors2:
[oracle@oraclelab2 trace]$ tail -f /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/alert_TESTDB.log
2022-08-14T01:20:44.029639+05:30
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_ora_18024.trc:
ORA-00313: open failed for members of log group 3 of thread 1
ORA-00312: online log 3 thread 1: '/u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log'
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
Deleted Oracle managed file /u01/app/oracle/oradata/DEVDB/onlinelog/o1_mf_3_kh3ntkrc_.log
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/DEVDB/onlinelog/o1_mf_3_kh3ntn3n_.log
2022-08-14T01:20:47.848006+05:30
.... (PID:18024): Clearing online redo logfile 1 complete
.... (PID:18024): Clearing online redo logfile 2 complete
.... (PID:18024): Clearing online redo logfile 3 complete
Online log +DATA/TESTDB/ONLINELOG/group_1.295.1112664045: Thread 1 Group 1 was previously cleared
Online log +RECO/TESTDB/ONLINELOG/group_1.285.1112664045: Thread 1 Group 1 was previously cleared
Online log +DATA/TESTDB/ONLINELOG/group_2.296.1112664045: Thread 1 Group 2 was previously cleared
Online log +RECO/TESTDB/ONLINELOG/group_2.284.1112664045: Thread 1 Group 2 was previously cleared
Online log +DATA/TESTDB/ONLINELOG/group_3.297.1112664045: Thread 1 Group 3 was previously cleared
Online log +RECO/TESTDB/ONLINELOG/group_3.283.1112664045: Thread 1 Group 3 was previously cleared
2022-08-14T01:20:47.898639+05:30
Setting recovery target incarnation to 2
2022-08-14T01:20:47.933650+05:30
Smart fusion block transfer is disabled:

Errors3:
[oracle@oraclelab2 trace]$ tail -f /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/alert_TESTDB.log
2022-08-14T01:20:48.454928+05:30
Errors in file /u01/app/oracle/diag/rdbms/testdb/TESTDB/trace/TESTDB_dbw0_17945.trc:
ORA-01186: file 201 failed verification tests
ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: '+DATA'
2022-08-14T01:20:48.454989+05:30
File 201 not verified due to error ORA-01157
2022-08-14T01:20:48.460062+05:30
Dictionary check complete
Re-creating tempfile +DATA as +DATA/TESTDB/TEMPFILE/temp.298.1112664049
Database Characterset is AL32UTF8

[oracle@oraclelab2 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sun Aug 14 01:28:43 2022
Version 19.14.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.14.0.0.0

SQL> select name, open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
TESTDB    READ WRITE

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
+DATA/TESTDB/DATAFILE/system.291.1112664009
+DATA/TESTDB/DATAFILE/sysaux.293.1112664013
+DATA/TESTDB/DATAFILE/undotbs1.294.1112664013
+DATA/TESTDB/DATAFILE/users.292.1112664009

SQL> select name from v$controlfile;

NAME
--------------------------------------------------------------------------------
+DATA/TESTDB/controlfile/control01.ctl
+RECO/TESTDB/controlfile/control02.ctl

SQL> select member from v$logfile;

MEMBER
--------------------------------------------------------------------------------
+DATA/TESTDB/ONLINELOG/group_3.297.1112664045
+RECO/TESTDB/ONLINELOG/group_3.283.1112664045
+DATA/TESTDB/ONLINELOG/group_2.296.1112664045
+RECO/TESTDB/ONLINELOG/group_2.284.1112664045
+DATA/TESTDB/ONLINELOG/group_1.295.1112664045
+RECO/TESTDB/ONLINELOG/group_1.285.1112664045

6 rows selected.

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/19.0.0
                                                 .0/dbhome_1/dbs/spfileTESTDB.o
                                                 ra
SQL>

Regards,
Mallik
Posted by at

1 comment:

  1. RedundancyAugust 18, 2022 at 8:27 PM

    Amazing Blog. Thanks for providing such a good article.

    ReplyDelete

Subscribe to: Post Comments (Atom)

Automation Script | Archivelog Generation Hourly Monitoring

1. List out all the running databases and pic one database where we want to monitore the archive log generation from last 1 month. [oracle@o...