Network Security Internet Technology Development Database Servers Mobile Phone Android Software Apple Software Computer Software News IT Information

In addition to Weibo, there is also WeChat

Please pay attention

WeChat public account

Shulou

How to understand the RMAN backup database plus archivelog delete all input command

2025-04-04 Update From: SLTechnology News&Howtos shulou NAV: SLTechnology News&Howtos > Servers >

Share

Shulou(Shulou.com)06/01 Report--

This article shows you how to understand the RMAN backup database plus archivelog delete all input command, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can learn something.

RMAN > run {

2 > backup as compressed backupset incremental level 1 database plus archivelog delete all input

3 >} / / RMAN backup script

Starting backup at 28-APR-10

# switching online logs (sql 'alter system archive log current';)

Log switch occurred in current log archived//

# back up all previous archive logs

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=33 recid=6 stamp=717527999 / / this is the log just archived

Channel ORA_DISK_1: starting piece 1 at 28-APR-10

Channel ORA_DISK_1: finished piece 1 at 28-APR-10

Piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172000_5xhvxkcy_.bkp tag=TAG20100428T172000 comment=NONE

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

Channel ORA_DISK_1: deleting archive log (s) / / Delete the entered archive log

Archivelog filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_33_5xhvxhjl_.arc recid=6 stamp=717527999

Finished backup at 28-APR-10

# backup data files

Starting backup at 28-APR-10

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

Input datafile fno=00005 name=/dev/rdcdb_data01

Input datafile fno=00006 name=/dev/rdcdb_data02

Input datafile fno=00007 name=/dev/rdcdb_data03

Input datafile fno=00008 name=/dev/rdcdb_data04

Input datafile fno=00009 name=/dev/rdcdb_data05

Input datafile fno=00010 name=/dev/rdcdb_data06

Input datafile fno=00011 name=/dev/rdcdb_data07

Input datafile fno=00012 name=/dev/rdcdb_data08

Input datafile fno=00013 name=/dev/rdcdb_data09

Input datafile fno=00014 name=/dev/rdcdb_data10

Input datafile fno=00015 name=/dev/rdcdb_data11

Input datafile fno=00016 name=/dev/rdcdb_data12

Input datafile fno=00017 name=/dev/rdcdb_data13

Input datafile fno=00018 name=/dev/rdcdb_data14

Input datafile fno=00019 name=/dev/rdcdb_data15

Input datafile fno=00020 name=/dev/rdcdb_data16

Input datafile fno=00021 name=/dev/rdcdb_data17

Input datafile fno=00022 name=/dev/rdcdb_data18

Input datafile fno=00001 name=/dev/rdcdb_system01

Input datafile fno=00023 name=/dev/rdcdb_data19

Input datafile fno=00003 name=/dev/rdcdb_sysaux01

Input datafile fno=00002 name=/dev/rdcdb_undotbs01

Input datafile fno=00004 name=/dev/rdcdb_user

Channel ORA_DISK_1: starting piece 1 at 28-APR-10

Channel ORA_DISK_1: finished piece 1 at 28-APR-10

Piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_nnnd1_TAG20100428T172003_5xhvxqn1_.bkp tag=TAG20100428T172003 comment=NONE

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

Channel ORA_DISK_1: starting compressed incremental level 1 datafile backupset

Channel ORA_DISK_1: specifying datafile (s) in backupset

# backup control files and SPFILE (AUTOBACKUP OFF)

Including current control file in backupset

Including current SPFILE in backupset

Channel ORA_DISK_1: starting piece 1 at 28-APR-10

Channel ORA_DISK_1: finished piece 1 at 28-APR-10

Piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_ncsn1_TAG20100428T172003_5xhvxv6b_.bkp tag=TAG20100428T172003 comment=NONE

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

Finished backup at 28-APR-10

Starting backup at 28-APR-10

# switch online logs again (sql 'alter system archive log current';)

Log switch occurred in current log archived//

# backup the archive logs generated during the backup command

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=34 recid=7 stamp=717528012//, this is the log that was just archived.

Channel ORA_DISK_1: starting piece 1 at 28-APR-10

Channel ORA_DISK_1: finished piece 1 at 28-APR-10

Piece handle=/u01/app/oracle/flash_recovery_area/YTHDB/backupset/2010_04_28/o1_mf_annnn_TAG20100428T172012_5xhvxy7k_.bkp tag=TAG20100428T172012 comment=NONE

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

Channel ORA_DISK_1: deleting archive log (s) / / Delete the entered archive log

Archivelog filename=/u01/app/oracle/flash_recovery_area/YTHDB/archivelog/2010_04_28/o1_mf_1_34_5xhvxwgz_.arc recid=7 stamp=717528012

Finished backup at 28-APR-10

The keyword all in the command has two meanings:

1. Represents all logs before the current archive log. So we should first add a crosscheck archivelog all; to the backup so as not to report an error when comparing the old archive.

two。 If there are multiple archive destinations, all archive destinations are represented, and all of them are deleted on all destinations when the archive log is deleted.

The above is how to understand RMAN backup database plus archivelog delete all input commands. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.

Views: 0

*The comments in the above article only represent the author's personal views and do not represent the views and positions of this website. If you have more insights, please feel free to contribute and share.

Share To

Servers

Wechat

© 2024 shulou.com SLNews company. All rights reserved.

12
Report