- Introduction:
- A valid RMAN full backup.
| Hostname | orcl.oraeasy.com |
|---|---|
| Database Name | ORCL |
| PDB Name | ORCLPDB |
| Database Version | 19c (19.27) |
| Hostname | uat.oraeasy.com |
|---|---|
| Database Version | 19c (19.27) |
On source, We have two PDB's ORCLPDB & TESTPDB. We will restore only ORCLPDB on target machine.
1. First take some precheck so that data can be verified post restoration.
SQL> DEF
DEFINE _DATE = "15-SEP-25" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcldc" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1927000000" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0" (CHAR)
DEFINE _O_RELEASE = "1927000000" (CHAR)
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 TESTPDB READ WRITE NO
SQL> select name from v$datafile where con_id=3;
NAME
--------------------------------------------------
/u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf
/u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf
/u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf
/u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
/u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf
/u01/app/oracle/oradata/ORCL/orclpdb/OGGPDB01.dbf
/u01/app/oracle/oradata/ORCL/orclpdb/audit_data01.dbf
7 rows selected.
SQL> select name from v$tempfile where con_id=3;
NAME
--------------------------------------------------
/u01/app/oracle/oradata/ORCL/orclpdb/temp01.dbf
SQL> alter session set container=ORCLPDB;
Session altered.
SQL> select sum(BYTES)/1024/1024/1024 as "Size(GB)" from dba_data_files;
Size(GB)
----------
2.43359375
SQL> select sum(BYTES)/1024/1024/1024 as "Size(GB)" from dba_segments;
Size(GB)
----------
1.11358643
SQL> select status,count(*) from dba_objects group by status;
STATUS COUNT(*)
------- ----------
VALID 73176
INVALID 12
SQL> select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE
from dba_users where oracle_maintained='N';
USERNAME ACCOUNT_STATUS EXPIRY_DA PROFILE
---------- ----------------- --------- --------------------
PDBADMIN OPEN 21-JUL-25 DEFAULT
C##CLONE OPEN DEFAULT
CDBTEST OPEN DEFAULT
TESTAUDIT OPEN 19-FEB-26 DEFAULT
C##TEST OPEN DEFAULT
TEST OPEN 26-NOV-25 DEFAULT
C##OGG OPEN DEFAULT
OGG OPEN 29-NOV-25 DEFAULT
8 rows selected.
SQL> select count(*) from test.COMPANY;
COUNT(*)
----------
7
SQL>
[oracle@orcl rman]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Sep 15 11:47:16 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1718803653)
RMAN> report schema;
report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCLDC
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1343 SYSTEM YES /u01/app/oracle/oradata/ORCL/system01.dbf
3 1195 SYSAUX NO /u01/app/oracle/oradata/ORCL/sysaux01.dbf
4 87 UNDOTBS1 YES /u01/app/oracle/oradata/ORCL/undotbs01.dbf
5 650 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
6 450 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
7 3 USERS NO /u01/app/oracle/oradata/ORCL/users01.dbf
8 230 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
9 685 ORCLPDB:SYSTEM YES /u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf
10 533 ORCLPDB:SYSAUX NO /u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf
11 228 ORCLPDB:UNDOTBS1 YES /u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf
12 10 ORCLPDB:USERS NO /u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
15 2 ORCLPDB:USERS NO /u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf
18 3 OGG NO /u01/app/oracle/oradata/ORCL/OGGCDB01.dbf
19 10 ORCLPDB:OGG NO /u01/app/oracle/oradata/ORCL/orclpdb/OGGPDB01.dbf
21 1024 ORCLPDB:AUDIT_DATA NO /u01/app/oracle/oradata/ORCL/orclpdb/audit_data01.dbf
22 10 USERS NO /u01/app/oracle/oradata/ORCL/users02.dbf
23 685 TESTPDB:SYSTEM YES /u01/app/oracle/oradata/ORCL/testpdb/system01.dbf
24 533 TESTPDB:SYSAUX NO /u01/app/oracle/oradata/ORCL/testpdb/sysaux01.dbf
25 228 TESTPDB:UNDOTBS1 YES /u01/app/oracle/oradata/ORCL/testpdb/undotbs01.dbf
26 10 TESTPDB:USERS NO /u01/app/oracle/oradata/ORCL/testpdb/users01.dbf
27 2 TESTPDB:USERS NO /u01/app/oracle/oradata/ORCL/testpdb/users02.dbf
28 10 TESTPDB:OGG NO /u01/app/oracle/oradata/ORCL/testpdb/OGGPDB01.dbf
29 1024 TESTPDB:AUDIT_DATA NO /u01/app/oracle/oradata/ORCL/testpdb/audit_data01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 201 TEMP 32767 /u01/app/oracle/oradata/ORCL/temp01.dbf
2 202 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/ORCL/pdbseed/temp012025-01-22_00-17-43-687-AM.dbf
3 202 ORCLPDB:TEMP 32767 /u01/app/oracle/oradata/ORCL/orclpdb/temp01.dbf
4 202 TESTPDB:TEMP 32767 /u01/app/oracle/oradata/ORCL/testpdb/temp01.dbf
RMAN> run
{
allocate channel ch1 device type disk;
allocate channel ch2 device type disk;
backup as compressed backupset database format '/u01/app/oracle/rman/Fullback_%T_%U';
backup as compressed backupset archivelog all format '/u01/app/oracle/rman/Archive_%T_%U';
backup current controlfile format '/u01/app/oracle/rman/Controlback_%T_%U';
release channel ch1;
release channel ch2;
} run
2> {
3> allocate channel ch1 device type disk;
4> allocate channel ch2 device type disk;
5> backup as compressed backupset database format '/u01/app/oracle/rman/Fullback_%T_%U';
6> backup as compressed backupset archivelog all format '/u01/app/oracle/rman/Archive_%T_%U';
7> backup current controlfile format '/u01/app/oracle/rman/Controlback_%T_%U';
8> release channel ch1;
9> release channel ch2;
10>
}
using target database control file instead of recovery catalog
allocated channel: ch1
channel ch1: SID=302 device type=DISK
allocated channel: ch2
channel ch2: SID=66 device type=DISK
Starting backup at 15-SEP-25
channel ch1: starting compressed full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00009 name=/u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf
input datafile file number=00010 name=/u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf
input datafile file number=00011 name=/u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf
channel ch1: starting piece 1 at 15-SEP-25
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00023 name=/u01/app/oracle/oradata/ORCL/testpdb/system01.dbf
input datafile file number=00024 name=/u01/app/oracle/oradata/ORCL/testpdb/sysaux01.dbf
input datafile file number=00025 name=/u01/app/oracle/oradata/ORCL/testpdb/undotbs01.dbf
channel ch2: starting piece 1 at 15-SEP-25
channel ch1: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5m43nta5_182_1_1 tag=TAG20250915T114924 comment=NONE
channel ch1: backup set complete, elapsed time: 00:02:25
channel ch1: starting compressed full datafile backup set
channel ch1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/ORCL/system01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/ORCL/users01.dbf
input datafile file number=00018 name=/u01/app/oracle/oradata/ORCL/OGGCDB01.dbf
channel ch1: starting piece 1 at 15-SEP-25
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5n43nta5_183_1_1 tag=TAG20250915T114924 comment=NONE
channel ch2: backup set complete, elapsed time: 00:02:26
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/ORCL/sysaux01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/ORCL/undotbs01.dbf
input datafile file number=00022 name=/u01/app/oracle/oradata/ORCL/users02.dbf
channel ch2: starting piece 1 at 15-SEP-25
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5p43nten_185_1_1 tag=TAG20250915T114924 comment=NONE
channel ch2: backup set complete, elapsed time: 00:01:05
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00021 name=/u01/app/oracle/oradata/ORCL/orclpdb/audit_data01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
input datafile file number=00019 name=/u01/app/oracle/oradata/ORCL/orclpdb/OGGPDB01.dbf
input datafile file number=00015 name=/u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf
channel ch2: starting piece 1 at 15-SEP-25
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5q43ntgq_186_1_1 tag=TAG20250915T114924 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:01
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00029 name=/u01/app/oracle/oradata/ORCL/testpdb/audit_data01.dbf
input datafile file number=00026 name=/u01/app/oracle/oradata/ORCL/testpdb/users01.dbf
input datafile file number=00028 name=/u01/app/oracle/oradata/ORCL/testpdb/OGGPDB01.dbf
input datafile file number=00027 name=/u01/app/oracle/oradata/ORCL/testpdb/users02.dbf
channel ch2: starting piece 1 at 15-SEP-25
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5r43ntgr_187_1_1 tag=TAG20250915T114924 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:01
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00006 name=/u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
channel ch2: starting piece 1 at 15-SEP-25
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5s43ntgt_188_1_1 tag=TAG20250915T114924 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:35
channel ch2: starting compressed full datafile backup set
channel ch2: specifying datafile(s) in backup set
input datafile file number=00005 name=/u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
channel ch2: starting piece 1 at 15-SEP-25
channel ch1: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5o43nten_184_1_1 tag=TAG20250915T114924 comment=NONE
channel ch1: backup set complete, elapsed time: 00:02:40
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Fullback_20250915_5t43nti0_189_1_1 tag=TAG20250915T114924 comment=NONE
channel ch2: backup set complete, elapsed time: 00:01:25
Finished backup at 15-SEP-25
Starting backup at 15-SEP-25
current log archived
channel ch1: starting compressed archived log backup set
channel ch1: specifying archived log(s) in backup set
input archived log thread=1 sequence=761 RECID=907 STAMP=1211886893
input archived log thread=1 sequence=762 RECID=908 STAMP=1211887793
input archived log thread=1 sequence=763 RECID=909 STAMP=1211888691
channel ch1: starting piece 1 at 15-SEP-25
channel ch2: starting compressed archived log backup set
channel ch2: specifying archived log(s) in backup set
input archived log thread=1 sequence=764 RECID=910 STAMP=1211888760
input archived log thread=1 sequence=765 RECID=911 STAMP=1211888823
input archived log thread=1 sequence=766 RECID=912 STAMP=1211888824
input archived log thread=1 sequence=767 RECID=913 STAMP=1211888828
channel ch2: starting piece 1 at 15-SEP-25
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Archive_20250915_5v43ntkp_191_1_1 tag=TAG20250915T115504 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:03
channel ch2: starting compressed archived log backup set
channel ch2: specifying archived log(s) in backup set
input archived log thread=1 sequence=768 RECID=914 STAMP=1211889304
channel ch2: starting piece 1 at 15-SEP-25
channel ch1: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Archive_20250915_5u43ntkp_190_1_1 tag=TAG20250915T115504 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:04
channel ch2: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Archive_20250915_6043ntks_192_1_1 tag=TAG20250915T115504 comment=NONE
channel ch2: backup set complete, elapsed time: 00:00:01
Finished backup at 15-SEP-25
Starting backup at 15-SEP-25
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 15-SEP-25
channel ch1: finished piece 1 at 15-SEP-25
piece handle=/u01/app/oracle/rman/Controlback_20250915_6143ntku_193_1_1 tag=TAG20250915T115510 comment=NONE
channel ch1: backup set complete, elapsed time: 00:00:01
Finished backup at 15-SEP-25
Starting Control File and SPFILE Autobackup at 15-SEP-25
piece handle=/u01/app/oracle/fast_recovery_area/ORCLDC/autobackup/2025_09_15/o1_mf_s_1211889314_ndhdbc89_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 15-SEP-25
released channel: ch1
released channel: ch2
RMAN> exit
SQL> create pfile='/u01/app/oracle/rman/pfile.ora' from spfile;
File created.
[oracle@orcl rman]$ scp * oracle@192.168.1.30:/home/oracle/rman
The authenticity of host '192.168.1.30 (192.168.1.30)' can't be established.
ED25519 key fingerprint is SHA256:u4/mMv+QalzEK9glLrODTQ8fSwZgtxo3dxg/vMO0L9s.
This key is not known by any other names
Are you sure you want to continue connecting (yes/no/[fingerprint])? yes
Warning: Permanently added '192.168.1.30' (ED25519) to the list of known hosts.
oracle@192.168.1.30's password:
Archive_20250915_5u43ntkp_190_1_1 100% 14MB 20.4MB/s 00:00
Archive_20250915_5v43ntkp_191_1_1 100% 6989KB 14.7MB/s 00:00
Archive_20250915_6043ntks_192_1_1 100% 252KB 4.3MB/s 00:00
Controlback_20250915_6143ntku_193_1_1 100% 19MB 27.2MB/s 00:00
Fullback_20250915_5m43nta5_182_1_1 100% 490MB 15.0MB/s 00:32
Fullback_20250915_5n43nta5_183_1_1 100% 503MB 8.7MB/s 00:57
Fullback_20250915_5o43nten_184_1_1 100% 614MB 10.2MB/s 00:59
Fullback_20250915_5p43nten_185_1_1 100% 148MB 8.5MB/s 00:17
Fullback_20250915_5q43ntgq_186_1_1 100% 1072KB 2.2MB/s 00:00
Fullback_20250915_5r43ntgr_187_1_1 100% 1072KB 10.2MB/s 00:00
Fullback_20250915_5s43ntgt_188_1_1 100% 140MB 8.8MB/s 00:15
Fullback_20250915_5t43nti0_189_1_1 100% 420MB 8.2MB/s 00:51
pfile.ora 100% 1739 5.9KB/s 00:00
[oracle@orcl rman]$
[oracle@uat rman]$ cat pfile.ora
orcldc.__data_transfer_cache_size=0
orcldc.__db_cache_size=62914560
orcldc.__inmemory_ext_roarea=0
orcldc.__inmemory_ext_rwarea=0
orcldc.__java_pool_size=8388608
orcldc.__large_pool_size=4194304
orcldc.__oracle_base='/u01/app/oracle'#ORACLE_BASE set from environment
orcldc.__pga_aggregate_target=104857600
orcldc.__sga_target=524288000
orcldc.__shared_io_pool_size=20971520
orcldc.__shared_pool_size=301989888
orcldc.__streams_pool_size=109051904
orcldc.__unified_pga_pool_size=0
*.archive_lag_target=900
*.audit_file_dest='/u01/app/oracle/admin/orcldc/adump'
*.audit_trail='DB','EXTENDED'
*.compatible='19.0.0'
*.control_files='/u01/app/oracle/oradata/orcldc/control01.ctl','/u01/app/oracle/fast_recovery_area/orcldc/control02.ctl'
*.db_block_size=8192
*.db_name='orcl'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=8192m
*.db_unique_name='ORCLDC'
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=orcldcXDB)'
*.enable_goldengate_replication=TRUE
*.enable_pluggable_database=true
*.log_archive_format='%t_%s_%r.arc'
*.log_archive_max_processes=30
*.nls_language='AMERICAN'
*.nls_territory='AMERICA'
*.open_cursors=300
*.PGA_AGGREGATE_TARGET=100M
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.SGA_TARGET=500M
*.standby_file_management='AUTO'
*.streams_pool_size=104857600
*.undo_tablespace='UNDOTBS1'
[oracle@uat rman]$ mkdir -p /u01/app/oracle/admin/orcldc/adump
[oracle@uat rman]$ mkdir -p /u01/app/oracle/oradata/orcldc/
[oracle@uat rman]$ mkdir -p /u01/app/oracle/fast_recovery_area/orcldc/
[oracle@uat rman]$ mkdir -p /u01/app/oracle/oradata/orcldc/pdbseed
[oracle@uat rman]$ mkdir -p /u01/app/oracle/oradata/orcldc/orclpdb
[oracle@uat rman]$
[oracle@uat ~]$ . oraenv
ORACLE_SID = [oracle] ? orcldc
ORACLE_HOME = [/home/oracle] ? /u01/app/oracle/product/19c/dbhome_1
The Oracle base has been set to /u01/app/oracle
[oracle@uat ~]$
[oracle@uat ~]$
[oracle@uat ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Sep 15 14:19:12 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2024, Oracle. All rights reserved.
Connected to an idle instance.
SQL> def
DEFINE _DATE = "15-SEP-25" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcldc" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1927000000" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "" (CHAR)
DEFINE _O_RELEASE = "" (CHAR)
SQL> startup nomount pfile='/home/oracle/rman/pfile.ora';
ORACLE instance started.
Total System Global Area 524284552 bytes
Fixed Size 9179784 bytes
Variable Size 423624704 bytes
Database Buffers 83886080 bytes
Redo Buffers 7593984 bytes
SQL>
[oracle@uat ~]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Mon Sep 15 14:20:53 2025
Version 19.27.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (not mounted)
RMAN> restore controlfile from '/home/oracle/rman/Controlback_20250915_6143ntku_193_1_1';
restore controlfile from '/home/oracle/rman/Controlback_20250915_6143ntku_193_1_1';
Starting restore at 15-SEP-25
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=21 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output file name=/u01/app/oracle/oradata/orcldc/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/orcldc/control02.ctl
Finished restore at 15-SEP-25
RMAN>
RMAN> alter database mount;
alter database mount;
released channel: ORA_DISK_1
Statement processed
RMAN> report schema;
report schema;
Starting implicit crosscheck backup at 15-SEP-25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=33 device type=DISK
Crosschecked 12 objects
Finished implicit crosscheck backup at 15-SEP-25
Starting implicit crosscheck copy at 15-SEP-25
using channel ORA_DISK_1
Finished implicit crosscheck copy at 15-SEP-25
searching for all files in the recovery area
cataloging files...
no files cataloged
RMAN-06139: warning: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name ORCLDC
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 0 SYSTEM *** /u01/app/oracle/oradata/ORCL/system01.dbf
3 0 SYSAUX *** /u01/app/oracle/oradata/ORCL/sysaux01.dbf
4 0 UNDOTBS1 *** /u01/app/oracle/oradata/ORCL/undotbs01.dbf
5 0 PDB$SEED:SYSTEM *** /u01/app/oracle/oradata/ORCL/pdbseed/system01.dbf
6 0 PDB$SEED:SYSAUX *** /u01/app/oracle/oradata/ORCL/pdbseed/sysaux01.dbf
7 0 USERS *** /u01/app/oracle/oradata/ORCL/users01.dbf
8 0 PDB$SEED:UNDOTBS1 *** /u01/app/oracle/oradata/ORCL/pdbseed/undotbs01.dbf
9 0 ORCLPDB:SYSTEM *** /u01/app/oracle/oradata/ORCL/orclpdb/system01.dbf
10 0 ORCLPDB:SYSAUX *** /u01/app/oracle/oradata/ORCL/orclpdb/sysaux01.dbf
11 0 ORCLPDB:UNDOTBS1 *** /u01/app/oracle/oradata/ORCL/orclpdb/undotbs01.dbf
12 0 ORCLPDB:USERS *** /u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
15 0 ORCLPDB:USERS *** /u01/app/oracle/oradata/ORCL/orclpdb/users02.dbf
18 0 OGG *** /u01/app/oracle/oradata/ORCL/OGGCDB01.dbf
19 0 ORCLPDB:OGG *** /u01/app/oracle/oradata/ORCL/orclpdb/OGGPDB01.dbf
21 0 ORCLPDB:AUDIT_DATA *** /u01/app/oracle/oradata/ORCL/orclpdb/audit_data01.dbf
22 0 USERS *** /u01/app/oracle/oradata/ORCL/users02.dbf
23 0 TESTPDB:SYSTEM *** /u01/app/oracle/oradata/ORCL/testpdb/system01.dbf
24 0 TESTPDB:SYSAUX *** /u01/app/oracle/oradata/ORCL/testpdb/sysaux01.dbf
25 0 TESTPDB:UNDOTBS1 *** /u01/app/oracle/oradata/ORCL/testpdb/undotbs01.dbf
26 0 TESTPDB:USERS *** /u01/app/oracle/oradata/ORCL/testpdb/users01.dbf
27 0 TESTPDB:USERS *** /u01/app/oracle/oradata/ORCL/testpdb/users02.dbf
28 0 TESTPDB:OGG *** /u01/app/oracle/oradata/ORCL/testpdb/OGGPDB01.dbf
29 0 TESTPDB:AUDIT_DATA *** /u01/app/oracle/oradata/ORCL/testpdb/audit_data01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 20 TEMP 32767 /u01/app/oracle/oradata/ORCL/temp01.dbf
2 36 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/ORCL/pdbseed/temp012025-01-22_00-17-43-687-AM.dbf
3 174 ORCLPDB:TEMP 32767 /u01/app/oracle/oradata/ORCL/orclpdb/temp01.dbf
4 202 TESTPDB:TEMP 32767 /u01/app/oracle/oradata/ORCL/testpdb/temp01.dbf
RMAN> catalog start with '/home/oracle/rman';
catalog start with '/home/oracle/rman';
searching for all files that match the pattern /home/oracle/rman
List of Files Unknown to the Database
=====================================
File Name: /home/oracle/rman/Archive_20250915_5u43ntkp_190_1_1
File Name: /home/oracle/rman/Archive_20250915_5v43ntkp_191_1_1
File Name: /home/oracle/rman/Archive_20250915_6043ntks_192_1_1
File Name: /home/oracle/rman/Controlback_20250915_6143ntku_193_1_1
File Name: /home/oracle/rman/Fullback_20250915_5m43nta5_182_1_1
File Name: /home/oracle/rman/Fullback_20250915_5n43nta5_183_1_1
File Name: /home/oracle/rman/Fullback_20250915_5o43nten_184_1_1
File Name: /home/oracle/rman/Fullback_20250915_5p43nten_185_1_1
File Name: /home/oracle/rman/Fullback_20250915_5q43ntgq_186_1_1
File Name: /home/oracle/rman/Fullback_20250915_5r43ntgr_187_1_1
File Name: /home/oracle/rman/Fullback_20250915_5s43ntgt_188_1_1
File Name: /home/oracle/rman/Fullback_20250915_5t43nti0_189_1_1
File Name: /home/oracle/rman/pfile.ora
File Name: /home/oracle/rmanrestore.log
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /home/oracle/rman/Archive_20250915_5u43ntkp_190_1_1
File Name: /home/oracle/rman/Archive_20250915_5v43ntkp_191_1_1
File Name: /home/oracle/rman/Archive_20250915_6043ntks_192_1_1
File Name: /home/oracle/rman/Controlback_20250915_6143ntku_193_1_1
File Name: /home/oracle/rman/Fullback_20250915_5m43nta5_182_1_1
File Name: /home/oracle/rman/Fullback_20250915_5n43nta5_183_1_1
File Name: /home/oracle/rman/Fullback_20250915_5o43nten_184_1_1
File Name: /home/oracle/rman/Fullback_20250915_5p43nten_185_1_1
File Name: /home/oracle/rman/Fullback_20250915_5q43ntgq_186_1_1
File Name: /home/oracle/rman/Fullback_20250915_5r43ntgr_187_1_1
File Name: /home/oracle/rman/Fullback_20250915_5s43ntgt_188_1_1
File Name: /home/oracle/rman/Fullback_20250915_5t43nti0_189_1_1
List of Files Which Were Not Cataloged
=======================================
File Name: /home/oracle/rman/pfile.ora
RMAN-07517: Reason: The file header is corrupted
File Name: /home/oracle/rmanrestore.log
RMAN-07517: Reason: The file header is corrupted
RMAN>
Syntax:
RESTORE DATABASE ROOT; -- restore root container
RESTORE DATABASE "PDB$SEED"; -- restore PDBSEED
RESTORE PLUGGABLE DATABASE ORCLPDB; -- restore PDB ORCLPDB
RECOVER DATABASE SKIP FOREVER TABLESPACE -- recover Database and below will be skipped during recovery.
TESTPDB:SYSTEM,
TESTPDB:SYSAUX,
TESTPDB:UNDOTBS1,
TESTPDB:USERS,
TESTPDB:OGG,
TESTPDB:AUDIT_DATA,
TESTPDB:TEMP;
RMAN> RUN
2> {
3> ALLOCATE CHANNEL c1 DEVICE TYPE disk;
4> ALLOCATE CHANNEL c2 DEVICE TYPE disk;
5> set newname for datafile 1 to '/u01/app/oracle/oradata/orcldc/system01.dbf';
6> set newname for datafile 3 to '/u01/app/oracle/oradata/orcldc/sysaux01.dbf';
7> set newname for datafile 4 to '/u01/app/oracle/oradata/orcldc/undotbs01.dbf';
8> set newname for datafile 5 to '/u01/app/oracle/oradata/orcldc/pdbseed/system01.dbf';
9> set newname for datafile 6 to '/u01/app/oracle/oradata/orcldc/pdbseed/sysaux01.dbf';
10> set newname for datafile 7 to '/u01/app/oracle/oradata/orcldc/users01.dbf';
11> set newname for datafile 8 to '/u01/app/oracle/oradata/orcldc/pdbseed/undotbs01.dbf';
12> set newname for datafile 9 to '/u01/app/oracle/oradata/orcldc/orclpdb/system01.dbf';
13> set newname for datafile 10 to '/u01/app/oracle/oradata/orcldc/orclpdb/sysaux01.dbf';
14> set newname for datafile 11 to '/u01/app/oracle/oradata/orcldc/orclpdb/undotbs01.dbf';
15> set newname for datafile 12 to '/u01/app/oracle/oradata/orcldc/orclpdb/users01.dbf';
16> set newname for datafile 15 to '/u01/app/oracle/oradata/orcldc/orclpdb/users02.dbf';
17> set newname for datafile 18 to '/u01/app/oracle/oradata/orcldc/oggcdb01.dbf';
18> set newname for datafile 19 to '/u01/app/oracle/oradata/orcldc/orclpdb/oggpdb01.dbf';
19> set newname for datafile 21 to '/u01/app/oracle/oradata/orcldc/orclpdb/audit_data01.dbf';
20> set newname for datafile 22 to '/u01/app/oracle/oradata/orcldc/users02.dbf';
21> set newname for tempfile 1 to '/u01/app/oracle/oradata/orcldc/temp01.dbf';
22> set newname for tempfile 2 to '/u01/app/oracle/oradata/orcldc/pdbseed/temp01.dbf';
23> set newname for tempfile 3 to '/u01/app/oracle/oradata/orcldc/orclpdb/temp01.dbf';
24> RESTORE DATABASE ROOT;
25> RESTORE DATABASE "PDB$SEED";
26> RESTORE PLUGGABLE DATABASE ORCLPDB;
27> switch datafile all;
28> switch tempfile all;
29> RECOVER DATABASE SKIP FOREVER TABLESPACE
30> TESTPDB:SYSTEM,
31> TESTPDB:SYSAUX,
32> TESTPDB:UNDOTBS1,
33> TESTPDB:USERS,
34> TESTPDB:OGG,
35> TESTPDB:AUDIT_DATA,
36> TESTPDB:TEMP;
37> release channel c1;
38> release channel c2;
39> }
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=20 device type=DISK
allocated channel: c2
channel c2: SID=273 device type=DISK
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 15-SEP-25
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00001 to /u01/app/oracle/oradata/orcldc/system01.dbf
channel c1: restoring datafile 00007 to /u01/app/oracle/oradata/orcldc/users01.dbf
channel c1: restoring datafile 00018 to /u01/app/oracle/oradata/orcldc/oggcdb01.dbf
channel c1: reading from backup piece /home/oracle/rman/Fullback_20250915_5o43nten_184_1_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00003 to /u01/app/oracle/oradata/orcldc/sysaux01.dbf
channel c2: restoring datafile 00004 to /u01/app/oracle/oradata/orcldc/undotbs01.dbf
channel c2: restoring datafile 00022 to /u01/app/oracle/oradata/orcldc/users02.dbf
channel c2: reading from backup piece /home/oracle/rman/Fullback_20250915_5p43nten_185_1_1
channel c2: piece handle=/home/oracle/rman/Fullback_20250915_5p43nten_185_1_1 tag=TAG20250915T114924
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:01:07
channel c1: piece handle=/home/oracle/rman/Fullback_20250915_5o43nten_184_1_1 tag=TAG20250915T114924
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:57
Finished restore at 15-SEP-25
Starting restore at 15-SEP-25
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00005 to /u01/app/oracle/oradata/orcldc/pdbseed/system01.dbf
channel c1: reading from backup piece /home/oracle/rman/Fullback_20250915_5t43nti0_189_1_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00006 to /u01/app/oracle/oradata/orcldc/pdbseed/sysaux01.dbf
channel c2: restoring datafile 00008 to /u01/app/oracle/oradata/orcldc/pdbseed/undotbs01.dbf
channel c2: reading from backup piece /home/oracle/rman/Fullback_20250915_5s43ntgt_188_1_1
channel c2: piece handle=/home/oracle/rman/Fullback_20250915_5s43ntgt_188_1_1 tag=TAG20250915T114924
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:45
channel c1: piece handle=/home/oracle/rman/Fullback_20250915_5t43nti0_189_1_1 tag=TAG20250915T114924
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:25
Finished restore at 15-SEP-25
Starting restore at 15-SEP-25
channel c1: starting datafile backup set restore
channel c1: specifying datafile(s) to restore from backup set
channel c1: restoring datafile 00009 to /u01/app/oracle/oradata/orcldc/orclpdb/system01.dbf
channel c1: restoring datafile 00010 to /u01/app/oracle/oradata/orcldc/orclpdb/sysaux01.dbf
channel c1: restoring datafile 00011 to /u01/app/oracle/oradata/orcldc/orclpdb/undotbs01.dbf
channel c1: reading from backup piece /home/oracle/rman/Fullback_20250915_5m43nta5_182_1_1
channel c2: starting datafile backup set restore
channel c2: specifying datafile(s) to restore from backup set
channel c2: restoring datafile 00012 to /u01/app/oracle/oradata/orcldc/orclpdb/users01.dbf
channel c2: restoring datafile 00015 to /u01/app/oracle/oradata/orcldc/orclpdb/users02.dbf
channel c2: restoring datafile 00019 to /u01/app/oracle/oradata/orcldc/orclpdb/oggpdb01.dbf
channel c2: restoring datafile 00021 to /u01/app/oracle/oradata/orcldc/orclpdb/audit_data01.dbf
channel c2: reading from backup piece /home/oracle/rman/Fullback_20250915_5q43ntgq_186_1_1
channel c2: piece handle=/home/oracle/rman/Fullback_20250915_5q43ntgq_186_1_1 tag=TAG20250915T114924
channel c2: restored backup piece 1
channel c2: restore complete, elapsed time: 00:00:45
channel c1: piece handle=/home/oracle/rman/Fullback_20250915_5m43nta5_182_1_1 tag=TAG20250915T114924
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:01:45
Finished restore at 15-SEP-25
datafile 1 switched to datafile copy
input datafile copy RECID=20 STAMP=1211902964 file name=/u01/app/oracle/oradata/orcldc/system01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=21 STAMP=1211902964 file name=/u01/app/oracle/oradata/orcldc/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=22 STAMP=1211902965 file name=/u01/app/oracle/oradata/orcldc/undotbs01.dbf
datafile 7 switched to datafile copy
input datafile copy RECID=23 STAMP=1211902965 file name=/u01/app/oracle/oradata/orcldc/users01.dbf
datafile 18 switched to datafile copy
input datafile copy RECID=24 STAMP=1211902965 file name=/u01/app/oracle/oradata/orcldc/oggcdb01.dbf
datafile 22 switched to datafile copy
input datafile copy RECID=25 STAMP=1211902965 file name=/u01/app/oracle/oradata/orcldc/users02.dbf
datafile 5 switched to datafile copy
input datafile copy RECID=26 STAMP=1211902965 file name=/u01/app/oracle/oradata/orcldc/pdbseed/system01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=27 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/pdbseed/sysaux01.dbf
datafile 8 switched to datafile copy
input datafile copy RECID=28 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/pdbseed/undotbs01.dbf
datafile 9 switched to datafile copy
input datafile copy RECID=29 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/system01.dbf
datafile 10 switched to datafile copy
input datafile copy RECID=30 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/sysaux01.dbf
datafile 11 switched to datafile copy
input datafile copy RECID=31 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/undotbs01.dbf
datafile 12 switched to datafile copy
input datafile copy RECID=32 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/users01.dbf
datafile 15 switched to datafile copy
input datafile copy RECID=33 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/users02.dbf
datafile 19 switched to datafile copy
input datafile copy RECID=34 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/oggpdb01.dbf
datafile 21 switched to datafile copy
input datafile copy RECID=35 STAMP=1211902966 file name=/u01/app/oracle/oradata/orcldc/orclpdb/audit_data01.dbf
renamed tempfile 1 to /u01/app/oracle/oradata/orcldc/temp01.dbf in control file
renamed tempfile 2 to /u01/app/oracle/oradata/orcldc/pdbseed/temp01.dbf in control file
renamed tempfile 3 to /u01/app/oracle/oradata/orcldc/orclpdb/temp01.dbf in control file
Starting recover at 15-SEP-25
Executing: alter database datafile 23, 24, 25, 26, 27, 28, 29 offline drop
starting media recovery
channel c1: starting archived log restore to default destination
channel c1: restoring archived log
archived log thread=1 sequence=768
channel c1: reading from backup piece /home/oracle/rman/Archive_20250915_6043ntks_192_1_1
channel c1: piece handle=/home/oracle/rman/Archive_20250915_6043ntks_192_1_1 tag=TAG20250915T115504
channel c1: restored backup piece 1
channel c1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/fast_recovery_area/ORCLDC/archivelog/2025_09_15/o1_mf_1_768_ndhso3hb_.arc thread=1 sequence=768
channel default: deleting archived log(s)
archived log file name=/u01/app/oracle/fast_recovery_area/ORCLDC/archivelog/2025_09_15/o1_mf_1_768_ndhso3hb_.arc RECID=915 STAMP=1211902971
unable to find archived log
archived log thread=1 sequence=769
RMAN Command Id : 2025-09-15T15:37:31
RMAN Command Id : 2025-09-15T15:37:31
RMAN Command Id : 2025-09-15T15:37:31
released channel: c1
released channel: c2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/15/2025 15:42:54
RMAN-06054: media recovery requesting unknown archived log for thread 1 with sequence 769 and starting SCN of 9617168
RMAN Client Diagnostic Trace file : /u01/app/oracle/diag/clients/user_oracle/RMAN_3062585620_110/trace/ora_rman_17406_0.trc
RMAN Server Diagnostic Trace file : /u01/app/oracle/diag/rdbms/orcldc/orcldc/trace/orcldc_ora_17414.trc
RMAN> exit;
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 ORCLPDB MOUNTED
4 TESTPDB MOUNTED
SQL>
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
ORCL MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-00344: unable to re-create online log
'/u01/app/oracle/oradata/ORCL/redo01.log'
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1
SQL> select member from v$logfile;
MEMBER
-------------------------------------------
/u01/app/oracle/oradata/orcl/redo03.log
/u01/app/oracle/oradata/orcl/redo02.log
/u01/app/oracle/oradata/orcl/redo01.log
7 rows selected.
SQL> alter database rename file '/u01/app/oracle/oradata/orcl/redo01.log' to '/u01/app/oracle/oradata/orcldc/redo01.log';
Database altered.
SQL> alter database rename file '/u01/app/oracle/oradata/orcl/redo02.log' to '/u01/app/oracle/oradata/orcldc/redo02.log';
Database altered.
SQL> alter database rename file '/u01/app/oracle/oradata/orcl/redo03.log' to '/u01/app/oracle/oradata/orcldc/redo03.log';
Database altered.
SQL> select member from v$logfile;
MEMBER
---------------------------------------------
/u01/app/oracle/oradata/orcldc/redo03.log
/u01/app/oracle/oradata/orcldc/redo02.log
/u01/app/oracle/oradata/orcldc/redo01.log
SQL> alter database open RESETLOGS;
alter database open RESETLOGS
*
ERROR at line 1:
ORA-00392: log 1 of thread 1 is being cleared, operation not allowed
ORA-00312: online log 1 thread 1: '/u01/app/oracle/oradata/orcldc/redo01.log'
SQL> ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;
Database altered.
SQL> alter database open RESETLOGS;
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 TESTPDB MOUNTED
SQL> alter pluggable database TESTPDB open;
alter pluggable database TESTPDB open
*
ERROR at line 1:
ORA-01147: SYSTEM tablespace file 23 is offline
RMAN> report schema;
report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCLDC
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 1343 SYSTEM YES /u01/app/oracle/oradata/orcldc/system01.dbf
3 1195 SYSAUX NO /u01/app/oracle/oradata/orcldc/sysaux01.dbf
4 87 UNDOTBS1 YES /u01/app/oracle/oradata/orcldc/undotbs01.dbf
5 650 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/orcldc/pdbseed/system01.dbf
6 450 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/orcldc/pdbseed/sysaux01.dbf
7 3 USERS NO /u01/app/oracle/oradata/orcldc/users01.dbf
8 230 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/orcldc/pdbseed/undotbs01.dbf
9 685 ORCLPDB:SYSTEM YES /u01/app/oracle/oradata/orcldc/orclpdb/system01.dbf
10 533 ORCLPDB:SYSAUX NO /u01/app/oracle/oradata/orcldc/orclpdb/sysaux01.dbf
11 228 ORCLPDB:UNDOTBS1 YES /u01/app/oracle/oradata/orcldc/orclpdb/undotbs01.dbf
12 10 ORCLPDB:USERS NO /u01/app/oracle/oradata/orcldc/orclpdb/users01.dbf
15 2 ORCLPDB:USERS NO /u01/app/oracle/oradata/orcldc/orclpdb/users02.dbf
18 3 OGG NO /u01/app/oracle/oradata/orcldc/oggcdb01.dbf
19 10 ORCLPDB:OGG NO /u01/app/oracle/oradata/orcldc/orclpdb/oggpdb01.dbf
21 1024 ORCLPDB:AUDIT_DATA NO /u01/app/oracle/oradata/orcldc/orclpdb/audit_data01.dbf
22 10 USERS NO /u01/app/oracle/oradata/orcldc/users02.dbf
23 0 TESTPDB:SYSTEM NO /u01/app/oracle/oradata/ORCL/testpdb/system01.dbf
24 0 TESTPDB:SYSAUX NO /u01/app/oracle/oradata/ORCL/testpdb/sysaux01.dbf
25 0 TESTPDB:UNDOTBS1 NO /u01/app/oracle/oradata/ORCL/testpdb/undotbs01.dbf
26 0 TESTPDB:USERS NO /u01/app/oracle/oradata/ORCL/testpdb/users01.dbf
27 0 TESTPDB:USERS NO /u01/app/oracle/oradata/ORCL/testpdb/users02.dbf
28 0 TESTPDB:OGG NO /u01/app/oracle/oradata/ORCL/testpdb/OGGPDB01.dbf
29 0 TESTPDB:AUDIT_DATA NO /u01/app/oracle/oradata/ORCL/testpdb/audit_data01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 35 TEMP 32767 /u01/app/oracle/oradata/orcldc/temp01.dbf
2 36 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/orcldc/pdbseed/temp01.dbf
3 174 ORCLPDB:TEMP 32767 /u01/app/oracle/oradata/orcldc/orclpdb/temp01.dbf
4 202 TESTPDB:TEMP 32767 /u01/app/oracle/oradata/ORCL/testpdb/temp01.dbf
RMAN>
SQL> def
DEFINE _DATE = "15-SEP-25" (CHAR)
DEFINE _CONNECT_IDENTIFIER = "orcldc" (CHAR)
DEFINE _USER = "SYS" (CHAR)
DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR)
DEFINE _SQLPLUS_RELEASE = "1927000000" (CHAR)
DEFINE _EDITOR = "vi" (CHAR)
DEFINE _O_VERSION = "Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.27.0.0.0" (CHAR)
DEFINE _O_RELEASE = "1927000000" (CHAR)
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 TESTPDB MOUNTED
SQL> select name from v$datafile where con_id=3;
NAME
------------------------------------------------------------
/u01/app/oracle/oradata/orcldc/orclpdb/system01.dbf
/u01/app/oracle/oradata/orcldc/orclpdb/sysaux01.dbf
/u01/app/oracle/oradata/orcldc/orclpdb/undotbs01.dbf
/u01/app/oracle/oradata/orcldc/orclpdb/users01.dbf
/u01/app/oracle/oradata/orcldc/orclpdb/users02.dbf
/u01/app/oracle/oradata/orcldc/orclpdb/oggpdb01.dbf
/u01/app/oracle/oradata/orcldc/orclpdb/audit_data01.dbf
7 rows selected.
SQL> select name from v$tempfile where con_id=3;
NAME
------------------------------------------------------------
/u01/app/oracle/oradata/orcldc/orclpdb/temp01.dbf
SQL> alter session set container=ORCLPDB;
Session altered.
SQL> select sum(BYTES)/1024/1024/1024 as "Size(GB)" from dba_data_files;
Size(GB)
----------
2.43359375
SQL> select sum(BYTES)/1024/1024/1024 as "Size(GB)" from dba_segments;
Size(GB)
----------
1.11358643
SQL> select status,count(*) from dba_objects group by status;
STATUS COUNT(*)
------- ----------
VALID 73176
INVALID 12
SQL> select USERNAME,ACCOUNT_STATUS,EXPIRY_DATE,PROFILE from dba_users where oracle_maintained='N';
USERNAME ACCOUNT_STATUS EXPIRY_DA PROFILE
------------------------------ -------------------------------- --------- --------------------
PDBADMIN OPEN 21-JUL-25 DEFAULT
C##CLONE OPEN DEFAULT
CDBTEST OPEN DEFAULT
TESTAUDIT OPEN 19-FEB-26 DEFAULT
C##TEST OPEN DEFAULT
TEST OPEN 26-NOV-25 DEFAULT
C##OGG OPEN DEFAULT
OGG OPEN 29-NOV-25 DEFAULT
8 rows selected.
SQL> select count(*) from test.COMPANY;
COUNT(*)
----------
7
In this way, we have restored a single PDB from full database backup on the target machine.
If you want to convert your Non-CDB into CDB database then please do visit below:
Thank you for reading!
I hope this content has been helpful to you. Your feedback and suggestions are always welcome — feel free to leave a comment or reach out with any queries.
Abhishek Shrivastava
Comments
Post a Comment