RMAN - BACKUP SPFILE | CONTROLFILE | DATAFILE | ARCHIVELOG

byShohanur Rahaman -
[oracle@dbserver ~]$ rman target /
 
Recovery Manager: Release 19.0.0.0.0 - Production on Tue Jul 30 19:17:40 2024
Version 19.22.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: MAXCDB (DBID=2565367265)

RMAN> backup database plus archivelog;

Starting backup at 16-APR-24
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=262 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=20 RECID=15 STAMP=1161788460
input archived log thread=1 sequence=37 RECID=32 STAMP=1166392813
input archived log thread=1 sequence=38 RECID=33 STAMP=1166446696
channel ORA_DISK_1: starting piece 1 at 16-APR-24
channel ORA_DISK_1: finished piece 1 at 16-APR-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_04_16/o1_mf_annnn_TAG20240416T125816_m1w8d93l_.bkp tag=TAG20240416T125816 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 16-APR-24


Starting backup at 16-APR-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00003 name=/u01/app/oracle/oradata/MAXCDB/sysaux01.dbf
input datafile file number=00001 name=/u01/app/oracle/oradata/MAXCDB/system01.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/MAXCDB/undotbs01.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/MAXCDB/users01.dbf
channel ORA_DISK_1: starting piece 1 at 16-APR-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/116630C96BC41A84E0637A38A8C02BAE/
input datafile file number=00006 name=/u01/app/oracle/oradata/MAXCDB/pdbseed/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/MAXCDB/pdbseed/system01.dbf
input datafile file number=00008 name=/u01/app/oracle/oradata/MAXCDB/pdbseed/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 16-APR-24
channel ORA_DISK_1: finished piece 1 at 16-APR-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/116609CFB2F51197E0637A38A8C0ACF5/backupset/2024_04_16/o1_mf_nnndf_FULL_DATABASE_BACKUP_m1wd1t6h_.bkp tag=FULL_DATABASE_BACKUP comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
Finished backup at 16-APR-24
 
RMAN> backup spfile;

Starting backup at 30-JUL-24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=278 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 30-JUL-24
channel ORA_DISK_1: finished piece 1 at 30-JUL-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_07_30/o1_mf_nnsnf_TAG20240730T191800_mbkt08s3_.bkp tag=TAG20240730T191800 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-JUL-24
 
RMAN> backup current controlfile;
 
Starting backup at 30-JUL-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_1: starting piece 1 at 30-JUL-24
channel ORA_DISK_1: finished piece 1 at 30-JUL-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_07_30/o1_mf_ncnnf_TAG20240730T191941_mbkt3goy_.bkp tag=TAG20240730T191941 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-JUL-24
 
RMAN> backup datafile '/u01/app/oracle/oradata/MAXCDB/users01.dbf';
 
Starting backup at 30-JUL-24
using channel ORA_DISK_1
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/MAXCDB/users01.dbf
channel ORA_DISK_1: starting piece 1 at 30-JUL-24
channel ORA_DISK_1: finished piece 1 at 30-JUL-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_07_30/o1_mf_nnndf_TAG20240730T192445_mbktdxjs_.bkp tag=TAG20240730T192445 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 30-JUL-24
 
RMAN> backup datafile 10,12; [It will back up using datafile ID]
 
Starting backup at 30-JUL-24
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00010 name=/u01/app/oracle/oradata/MAXCDB/maxpdb/sysaux01.dbf
input datafile file number=00012 name=/u01/app/oracle/oradata/MAXCDB/maxpdb/users01.dbf
channel ORA_DISK_1: starting piece 1 at 30-JUL-24
channel ORA_DISK_1: finished piece 1 at 30-JUL-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/1D333B82F449458AE0638938A8C087A0/backupset/2024_07_30/o1_mf_nnndf_TAG20240730T193031_mbktqqh4_.bkp tag=TAG20240730T193031 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
Finished backup at 30-JUL-24
 
RMAN> backup archivelog all;
 
Starting backup at 30-JUL-24
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=36 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=14 RECID=1 STAMP=1174330840
input archived log thread=1 sequence=15 RECID=2 STAMP=1174345723
input archived log thread=1 sequence=16 RECID=3 STAMP=1174552079
input archived log thread=1 sequence=28 RECID=15 STAMP=1175716512
input archived log thread=1 sequence=29 RECID=16 STAMP=1175717284
channel ORA_DISK_1: starting piece 1 at 30-JUL-24
piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/backupset/2024_07_30/o1_mf_annnn_TAG20240730T200804_mbkwy51l_.bkp tag=TAG20240730T200804 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 30-JUL-24


To list all existing backups use:

RMAN> list backup;

List of Backup Sets
===================
BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
14      Full    522.96M    DISK        00:00:02     15-APR-24
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20240415T211231
        Piece Name: /u01/app/oracle/fast_recovery_area/MAXCDB/116630C96BC41A84E0637A38A8C02BAE/backupset/2024_04_15/o1_mf_nnndf_TAG20240415T211231_m1tjyzr1_.bkp
  List of Datafiles in backup set 14
  Container ID: 3, PDB Name: MAXPDB
  File LV Type Ckp SCN    Ckp Time  Abs Fuz SCN Sparse Name
  ---- -- ---- ---------- --------- ----------- ------ ----
  9       Full 5317326    15-APR-24              NO    /u01/app/oracle/oradata/MAXCDB/maxpdb/system01.dbf
  10      Full 5317326    15-APR-24              NO    /u01/app/oracle/oradata/MAXCDB/maxpdb/sysaux01.dbf
  11      Full 5317326    15-APR-24              NO    /u01/app/oracle/oradata/MAXCDB/maxpdb/undotbs01.dbf
  12      Full 5317326    15-APR-24              NO    /u01/app/oracle/oradata/MAXCDB/maxpdb/users01.dbf

It will give you the list of tablespaces along with datafiles

RMAN> report schema;

Report of database schema for database with db_unique_name MAXCDB
List of Permanent Datafiles
===========================
File Size (MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    1100    SYSTEM                YES     /u01/app/oracle/oradata/MAXCDB/system01.dbf
3    950      SYSAUX                NO      /u01/app/oracle/oradata/MAXCDB/sysaux01.dbf
4    730      UNDOTBS1              YES     /u01/app/oracle/oradata/MAXCDB/undotbs01.dbf
5    430      PDB$SEED:SYSTEM     NO      /u01/app/oracle/oradata/MAXCDB/pdbseed/system01.dbf
6    470      PDB$SEED:SYSAUX      NO      /u01/app/oracle/oradata/MAXCDB/pdbseed/sysaux01.dbf
7    5          USERS                NO      /u01/app/oracle/oradata/MAXCDB/users01.dbf

It will take the backup and delete it from the archive log location

RMAN> backup archivelog all delete input; 
 
Starting backup at 30-JUL-24
current log archived
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=278 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=14 RECID=1 STAMP=1174330840
archived log file name=/u01/archive/1_29_1174318434.dbf RECID=16 STAMP=1175717284
archived log file name=/u01/archive/1_30_1174318434.dbf RECID=17 STAMP=1175717656
Finished backup at 30-JUL-24

Obsolete Backups

RMAN> report obsolete;

RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of obsolete backups and copies
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           14     15-APR-24
Backup Piece       14     15-APR-24          /u01/app/oracle/fast_recovery_area/MAXCDB/116630C96BC41A84E0637A38A8C02BAE/backupset/2024_04_15/o1_mf_nnndf_TAG20240415T211231_m1tjyzr1_.bkp
RMAN> delete obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
using channel ORA_DISK_1
Deleting the following obsolete backups and copies:
Type                 Key    Completion Time    Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set           14     15-APR-24
Backup Piece       14     15-APR-24          /u01/app/oracle/fast_recovery_area/MAXCDB/116630C96BC41A84E0637A38A8C02BAE/backupset/2024_04_15/o1_mf_nnndf_TAG20240415T211231_m1tjyzr1_.bkp
backup piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/autobackup/2024_04_15/o1_mf_s_1166389974_m1tjzqf1_.bkp RECID=17 STAMP=1166389975
Deleted 4 objects

Expired Backups

[oracle@dev ~]$ rman target /

Recovery Manager: Release 19.0.0.0.0 - Production on Mon Apr 15 22:10:54 2024
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
connected to target database: MAXCDB (DBID=2552047313)

RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=289 device type=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/116630C96BC41A84E0637A38A8C02BAE/backupset/2024_04_15/o1_mf_nnndf_TAG20240415T211300_m1tjzwwr_.bkp RECID=18 STAMP=1166389980
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/u01/app/oracle/fast_recovery_area/MAXCDB/autobackup/2024_04_15/o1_mf_s_1166389984_m1tk005n_.bkp RECID=19 STAMP=1166389984
Crosschecked 2 objects

RMAN> list expired backup;

specification does not match any backup in the repository

Tags

You may like these posts

Previous Post Next Post

نموذج الاتصال