How to check retention policy ?

 

[oracle@orcl 2025_05_21]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat May 24 12:41:22 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>

RMAN> show retention policy ;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name DB1 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

RMAN>

RMAN>

How to check controlfile autobackup is ON in oracle database using rman?

 First login as oracle (software owner) and connect to rman 

[oracle@orcl ~]$

[oracle@orcl ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Sat May 24 12:28:45 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> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters for database with db_unique_name DB1 are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP ON; # default

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default

CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/19.0.0/dbhome_1/dbs/snapcf_db1.f'; # default

RMAN>

Backup Controlfile in oracle database

 

SQL>

SQL>

SQL> select name from v$controlfile;

NAME

--------------------------------------------------------------------------------

/u01/app/oracle/oradata/DB1/control01.ctl

/u01/app/oracle/fast_recovery_area/DB1/control02.ctl

/u01/app/oracle/oradata/DB1/control03.ctl

SQL>

SQL>

SQL> alter database backup controlfile to trace ;

Database altered.

SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

2025-05-24T08:23:47.505162+00:00

alter database backup controlfile to trace

2025-05-24T08:23:47.508044+00:00

Backup controlfile written to trace file /u01/app/oracle/diag/rdbms/db1/db1/trace/db1_ora_11837.trc

Completed: alter database backup controlfile to trace

2025-05-24T08:23:49.290103+00:00

How to backup users tablespace from cdb and pdb oracle database ?

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>