Backup Archive log files

We know that archive logs are very important files of a database when it comes to recovery.

Let’s see how we can take backup of archive log files.

Step 1: Connect to RMAN

[oracle@localhost ~]$ rman target /

Recovery Manager: Release 12.2.0.1.0 - Production on Mon Jan 7 11:23:15 2019

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

connected to target database: DEMO (DBID=3740643610)

Step 2: Take a backup using the following script

RMAN> run {
allocate channel a1 device type disk format '/u02/bkp/arc/%U';
backup archivelog all delete all input;
}2> 3> 4> 

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

Starting backup at 07-JAN-19
current log archived
channel a1: starting archived log backup set
channel a1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2 RECID=1 STAMP=996799562
input archived log thread=1 sequence=3 RECID=2 STAMP=996801121
input archived log thread=1 sequence=4 RECID=3 STAMP=996923594
input archived log thread=1 sequence=5 RECID=4 STAMP=996924355
channel a1: starting piece 1 at 07-JAN-19
channel a1: finished piece 1 at 07-JAN-19
piece handle=/u02/bkp/arc/0ntmnmu4_1_1 tag=TAG20190107T112555 comment=NONE
channel a1: backup set complete, elapsed time: 00:00:16
channel a1: deleting archived log(s)
archived log file name=/u02/arc/demo/1_2_996573275.dbf RECID=1 STAMP=996799562
archived log file name=/u02/arc/demo/1_3_996573275.dbf RECID=2 STAMP=996801121
archived log file name=/u02/arc/demo/1_4_996573275.dbf RECID=3 STAMP=996923594
archived log file name=/u02/arc/demo/1_5_996573275.dbf RECID=4 STAMP=996924355
Finished backup at 07-JAN-19

Starting Control File and SPFILE Autobackup at 07-JAN-19
piece handle=/u02/fast_recovery_area/demo/DEMO/autobackup/2019_01_07/o1_mf_s_996924373_g35tj2f8_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 07-JAN-19
[released channel: a1

RMAN>

To know the difference between delete input and delete all input

Step 3: List backup of archive log

RMAN> list backup of archivelog all;


List of Backup Sets
===================


BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
21      328.04M    DISK        00:00:14     07-JAN-19      
        BP Key: 21   Status: AVAILABLE  Compressed: NO  Tag: TAG20190107T112555
        Piece Name: /u02/bkp/arc/0ntmnmu4_1_1

  List of Archived Logs in backup set 21
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    2       1429465    03-JAN-19 1558802    06-JAN-19
  1    3       1558802    06-JAN-19 1605403    06-JAN-19
  1    4       1605403    06-JAN-19 1715179    07-JAN-19
  1    5       1715179    07-JAN-19 1716817    07-JAN-19

RMAN>

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp