In addition to Weibo, there is also WeChat
Please pay attention
WeChat public account
Shulou
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.
Continue with the installation of the previous hadoop.First, install zookooper1. Decompress zookoope
"Every 5-10 years, there's a rare product, a really special, very unusual product that's the most un
© 2024 shulou.com SLNews company. All rights reserved.