rman备份archivelog时出现以下错误： RMANgt; backup archivelog all delete input; Starting backup at 14-APR-14 current log
rman备份archivelog时出现以下错误：
RMAN> backup archivelog all delete input;
Starting backup at 14-APR-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 04/14/2014 18:40:23
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /home/Oracle/PROD/1_2_844469007.dbf
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
--------------------------------------分割线 --------------------------------------
推荐阅读：
RMAN 配置归档日志删除策略
Oracle基础教程之通过RMAN复制数据库
RMAN备份策略制定参考内容
RMAN备份学习笔记
Oracle数据库备份加密 RMAN加密
--------------------------------------分割线 --------------------------------------
网上查了出错原因是由于操作系统下删除了这个归档日志，这个日志还没备份过，rman去备份的时候，找不到这个归档就出错了。可使用change archivelog all crosscheck命令来解决此问题，如下：
RMAN> change archivelog all crosscheck;
released channel: ORA_DISK_1
released channel: ORA_DISK_2
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=43 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=45 device type=DISK
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_16_827176743.dbf RECID=1 STAMP=844399662
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_17_827176743.dbf RECID=2 STAMP=844460245
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_18_827176743.dbf RECID=3 STAMP=844461320
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_19_827176743.dbf RECID=4 STAMP=844461426
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_20_827176743.dbf RECID=5 STAMP=844461580
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_21_827176743.dbf RECID=6 STAMP=844461592
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_22_827176743.dbf RECID=7 STAMP=844461696
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_23_827176743.dbf RECID=8 STAMP=844462037
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_24_827176743.dbf RECID=9 STAMP=844462165
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_25_827176743.dbf RECID=10 STAMP=844462279
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_26_827176743.dbf RECID=11 STAMP=844462409
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_27_827176743.dbf RECID=12 STAMP=844465108
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_28_827176743.dbf RECID=13 STAMP=844469010
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=19 STAMP=844537684
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844532679.dbf RECID=17 STAMP=844533553
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_3_844532679.dbf RECID=20 STAMP=844537685
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_4_844532679.dbf RECID=18 STAMP=844537684
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=23 STAMP=844605032
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844537684.dbf RECID=21 STAMP=844575254
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=24 STAMP=844605033
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844537684.dbf RECID=22 STAMP=844581004
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_3_844537684.dbf RECID=25 STAMP=844605034
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844469007.dbf RECID=14 STAMP=844530587
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_1_844605031.dbf RECID=26 STAMP=844670045
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_2_844605031.dbf RECID=27 STAMP=844797748
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_3_844605031.dbf RECID=28 STAMP=844841532
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_4_844605031.dbf RECID=29 STAMP=844847317
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_5_844605031.dbf RECID=30 STAMP=844855807
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_6_844605031.dbf RECID=31 STAMP=844855838
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_7_844605031.dbf RECID=32 STAMP=844886422
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_8_844605031.dbf RECID=33 STAMP=844886590
validation succeeded for archived log
archived log file name=/home/oracle/PROD/1_9_844605031.dbf RECID=34 STAMP=844886622
Crosschecked 33 objects
validation failed for archived log
archived log file name=/home/oracle/PROD/1_2_844469007.dbf RECID=15 STAMP=844530793
Crosschecked 1 objects
--再次执行archivelog的rman备份就成功了，如下：
RMAN> backup archivelog all delete input;
Starting backup at 14-APR-14
current log archived
using channel ORA_DISK_1
using channel ORA_DISK_2
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=16 RECID=1 STAMP=844399662
input archived log thread=1 sequence=17 RECID=2 STAMP=844460245
input archived log thread=1 sequence=18 RECID=3 STAMP=844461320
channel ORA_DISK_1: starting piece 1 at 14-APR-14
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=1 RECID=16 STAMP=844533450
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_2: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1bp5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/home/oracle/PROD/1_1_844532679.dbf RECID=16 STAMP=844533450
channel ORA_DISK_2: starting compressed archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=19 RECID=4 STAMP=844461426
input archived log thread=1 sequence=20 RECID=5 STAMP=844461580
input archived log thread=1 sequence=21 RECID=6 STAMP=844461592
input archived log thread=1 sequence=22 RECID=7 STAMP=844461696
input archived log thread=1 sequence=23 RECID=8 STAMP=844462037
input archived log thread=1 sequence=24 RECID=9 STAMP=844462165
input archived log thread=1 sequence=25 RECID=10 STAMP=844462279
channel ORA_DISK_2: starting piece 1 at 14-APR-14
channel ORA_DISK_1: finished piece 1 at 14-APR-14
piece handle=/home/oracle/backup/PROD_20140414_1ap5ntq0_1_1.bak tag=TAG20140414T190432 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
What Are the Limitations of Using Views in MySQL?May 14, 2025 am 12:10 AMMySQLviewshavelimitations:1)Theydon'tsupportallSQLoperations,restrictingdatamanipulationthroughviewswithjoinsorsubqueries.2)Theycanimpactperformance,especiallywithcomplexqueriesorlargedatasets.3)Viewsdon'tstoredata,potentiallyleadingtooutdatedinforma
Securing Your MySQL Database: Adding Users and Granting PrivilegesMay 14, 2025 am 12:09 AMProperusermanagementinMySQLiscrucialforenhancingsecurityandensuringefficientdatabaseoperation.1)UseCREATEUSERtoaddusers,specifyingconnectionsourcewith@'localhost'or@'%'.2)GrantspecificprivilegeswithGRANT,usingleastprivilegeprincipletominimizerisks.3)
What Factors Influence the Number of Triggers I Can Use in MySQL?May 14, 2025 am 12:08 AMMySQLdoesn'timposeahardlimitontriggers,butpracticalfactorsdeterminetheireffectiveuse:1)Serverconfigurationimpactstriggermanagement;2)Complextriggersincreasesystemload;3)Largertablesslowtriggerperformance;4)Highconcurrencycancausetriggercontention;5)M
MySQL: Is it safe to store BLOB?May 14, 2025 am 12:07 AMYes,it'ssafetostoreBLOBdatainMySQL,butconsiderthesefactors:1)StorageSpace:BLOBscanconsumesignificantspace,potentiallyincreasingcostsandslowingperformance.2)Performance:LargerrowsizesduetoBLOBsmayslowdownqueries.3)BackupandRecovery:Theseprocessescanbe
MySQL: Adding a user through a PHP web interfaceMay 14, 2025 am 12:04 AMAdding MySQL users through the PHP web interface can use MySQLi extensions. The steps are as follows: 1. Connect to the MySQL database and use the MySQLi extension. 2. Create a user, use the CREATEUSER statement, and use the PASSWORD() function to encrypt the password. 3. Prevent SQL injection and use the mysqli_real_escape_string() function to process user input. 4. Assign permissions to new users and use the GRANT statement.
MySQL: BLOB and other no-sql storage, what are the differences?May 13, 2025 am 12:14 AMMySQL'sBLOBissuitableforstoringbinarydatawithinarelationaldatabase,whileNoSQLoptionslikeMongoDB,Redis,andCassandraofferflexible,scalablesolutionsforunstructureddata.BLOBissimplerbutcanslowdownperformancewithlargedata;NoSQLprovidesbetterscalabilityand
MySQL Add User: Syntax, Options, and Security Best PracticesMay 13, 2025 am 12:12 AMToaddauserinMySQL,use:CREATEUSER'username'@'host'IDENTIFIEDBY'password';Here'showtodoitsecurely:1)Choosethehostcarefullytocontrolaccess.2)SetresourcelimitswithoptionslikeMAX_QUERIES_PER_HOUR.3)Usestrong,uniquepasswords.4)EnforceSSL/TLSconnectionswith
MySQL: How to avoid String Data Types common mistakes?May 13, 2025 am 12:09 AMToavoidcommonmistakeswithstringdatatypesinMySQL,understandstringtypenuances,choosetherighttype,andmanageencodingandcollationsettingseffectively.1)UseCHARforfixed-lengthstrings,VARCHARforvariable-length,andTEXT/BLOBforlargerdata.2)Setcorrectcharacters
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
SublimeText3 Chinese version
Chinese version, very easy to use
VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft
SecLists
SecLists is the ultimate security tester's companion. It is a collection of various types of lists that are frequently used during security assessments, all in one place. SecLists helps make security testing more efficient and productive by conveniently providing all the lists a security tester might need. List types include usernames, passwords, URLs, fuzzing payloads, sensitive data patterns, web shells, and more. The tester can simply pull this repository onto a new test machine and he will have access to every type of list he needs.
Notepad++7.3.1
Easy-to-use and free code editor
SAP NetWeaver Server Adapter for Eclipse
Integrate Eclipse with SAP NetWeaver application server.
