Backup users tablespace from cdb and pdb oracle database
[oracle@orcl dbs]$ rman target /
Recovery Manager: Release 19.0.0.0.0 - Production on Wed May 21 12:53:49 2025
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: DB1 (DBID=1788905834)
RMAN> report schema ;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name DB1
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 900 SYSTEM YES /u01/app/oracle/oradata/DB1/system01.dbf
3 630 SYSAUX NO /u01/app/oracle/oradata/DB1/sysaux01.dbf
4 275 UNDOTBS1 YES /u01/app/oracle/oradata/DB1/undotbs01.dbf
5 270 PDB$SEED:SYSTEM NO /u01/app/oracle/oradata/DB1/pdbseed/system01.dbf
6 330 PDB$SEED:SYSAUX NO /u01/app/oracle/oradata/DB1/pdbseed/sysaux01.dbf
7 5 USERS NO /u01/app/oracle/oradata/DB1/users01.dbf
8 100 PDB$SEED:UNDOTBS1 NO /u01/app/oracle/oradata/DB1/pdbseed/undotbs01.dbf
9 270 PDB:SYSTEM NO /u01/app/oracle/oradata/DB1/pdb/system01.dbf
10 340 PDB:SYSAUX NO /u01/app/oracle/oradata/DB1/pdb/sysaux01.dbf
11 100 PDB:UNDOTBS1 NO /u01/app/oracle/oradata/DB1/pdb/undotbs01.dbf
12 5 PDB:USERS NO /u01/app/oracle/oradata/DB1/pdb/users01.dbf
16 270 DEMO1:SYSTEM NO /u01/app/oracle/oradata/demo1/system01.dbf
17 340 DEMO1:SYSAUX NO /u01/app/oracle/oradata/demo1/sysaux01.dbf
18 100 DEMO1:UNDOTBS1 NO /u01/app/oracle/oradata/demo1/undotbs01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 131 TEMP 32767 /u01/app/oracle/oradata/DB1/temp01.dbf
2 36 PDB$SEED:TEMP 32767 /u01/app/oracle/oradata/DB1/pdbseed/temp012025-03-06_12-16-29-897-PM.dbf
3 128 PDB:TEMP 32767 /u01/app/oracle/oradata/DB1/pdb/temp01.dbf
4 128 DEMO1:TEMP 32767 /u01/app/oracle/oradata/demo1/temp012025-03-06_12-16-29-897-PM.dbf
RMAN>
RMAN> backup tablespace pdb:users, users;
Starting backup at 21-MAY-25
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=42 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00012 name=/u01/app/oracle/oradata/DB1/pdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-MAY-25
channel ORA_DISK_1: finished piece 1 at 21-MAY-25
piece handle=/u01/app/oracle/fast_recovery_area/DB1/2FACECCE69615207E0630400040AB366/backupset/2025_05_21/o1_mf_nnndf_TAG20250521T125551_n2vmbqvv_.bkp tag=TAG20250521T125551 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00007 name=/u01/app/oracle/oradata/DB1/users01.dbf
channel ORA_DISK_1: starting piece 1 at 21-MAY-25
channel ORA_DISK_1: finished piece 1 at 21-MAY-25
piece handle=/u01/app/oracle/fast_recovery_area/DB1/backupset/2025_05_21/o1_mf_nnndf_TAG20250521T125551_n2vmbsgr_.bkp tag=TAG20250521T125551 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 21-MAY-25
Starting Control File and SPFILE Autobackup at 21-MAY-25
piece handle=/u01/app/oracle/fast_recovery_area/DB1/autobackup/2025_05_21/o1_mf_s_1201697756_n2vmbyk4_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 21-MAY-25
RMAN>
No comments:
Post a Comment