How to archive log files when using RMAN backup

Source: Internet
Author: User
I went to a customer yesterday to deploy the RMAN backup. when running the shell script, I was prompted that I could not find the archive log, because the customer only performed the EXPDP logical export backup for the database, and each

I went to a customer yesterday to deploy the RMAN backup. when running the shell script, I was prompted that I could not find the archive log, because the customer only performed the EXPDP logical export backup for the database, and each

-Rw-r ----- 1 oracle oinstall 606 K Sep 24 ora10g-4175411955_20140924_859118422_297.arc

-Rw-r ----- 1 oracle oinstall 166 M Sep 24 :02 ora10g-4175411955_20140924_859118425_298.db

-Rw-r ----- 1 oracle oinstall 610 K Sep 24 ora10g-4175411955_20140924_859118562_299.arc

-Rw-r ----- 1 oracle oinstall 7.3 M Sep 24 :02 ora10g-c-4175411955-20140924-01.ctl

As you can see, the backups are all completed, and two log backup sets (arc), one Database Backup set (db), and the control file backup set (ctl) are generated ), note that because I have written the % s parameter in the script, we can find the order of RMAN backup from the time and sequence generated by the backup set generated above:

1. Back up the archive log files of existing databases that can be backed up

2. Back up the database

3. Switch the logs to back up the archived logs after full-Database Backup (even if you do not use RMAN> SQL "alter system archive log current"; to manually switch)

4. Backup of control files (including spfile, generated in the same backup set)

We can take a look at the detailed log output to have a deeper understanding of this sequence:

Starting backup at 24-914

Current log archived

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting compressed archive log backupset

Channel ORA_DISK_1: specifying archive log (s) in backup set

Input archive log thread = 1 sequence = 11 recid = 216 stamp = 859118422

Channel ORA_DISK_1: starting piece 1 at 24-914

Channel ORA_DISK_1: finished piece 1 at 24-914

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03

Finished backup at 24-914

Starting backup at 24-914

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting compressed full datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Input datafile fno = 00001 name =/u01/app/oracle/oradata/ora10g/system01.dbf

Input datafile fno = 00003 name =/u01/app/oracle/oradata/ora10g/sysaux01.dbf

Input datafile fno = 00002 name =/u01/app/oracle/oradata/ora10g/undotbs01.dbf

Input datafile fno = 00005 name =/u01/app/oracle/oradata/ora10g/example01.dbf

Input datafile fno = 00006 name =/u01/app/oracle/oradata/ora10g/zlm01.dbf

Input datafile fno = 00004 name =/u01/app/oracle/oradata/ora10g/users01.dbf

Channel ORA_DISK_1: starting piece 1 at 24-914

Channel ORA_DISK_1: finished piece 1 at 24-914

Channel ORA_DISK_1: backup set complete, elapsed time: 00:02:16

Finished backup at 24-914

Starting backup at 24-914

Current log archived

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting compressed archive log backupset

Channel ORA_DISK_1: specifying archive log (s) in backup set

Input archive log thread = 1 sequence = 12 recid = 217 stamp = 859118561

Channel ORA_DISK_1: starting piece 1 at 24-914

Channel ORA_DISK_1: finished piece 1 at 24-914

Channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

Finished backup at 24-914

Starting Control File and SPFILE Autobackup at 24-914

Finished Control File and SPFILE Autobackup at 24-914

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.