rman备份archivelog出现ORA-19625-MySQL 튜토리얼-php.cn

집

데이터 베이스

MySQL 튜토리얼

rman备份archivelog出现ORA-19625

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:48 PM

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)

본 웹사이트의 성명

본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.

핫 AI 도구

뜨거운 도구

뜨거운 주제

Gmail 이메일의 로그인 입구는 어디에 있나요?

7467

Cakephp 튜토리얼

1376

Steam의 계정 이름 형식은 무엇입니까?

Win11 활성화 키 영구

NYT 연결 힌트와 답변

Related knowledge

Alter Table 문을 사용하여 MySQL에서 테이블을 어떻게 변경합니까? Mar 19, 2025 pm 03:51 PM

이 기사는 MySQL의 Alter Table 문을 사용하여 열 추가/드롭 테이블/열 변경 및 열 데이터 유형 변경을 포함하여 테이블을 수정하는 것에 대해 설명합니다.

MySQL 연결에 대한 SSL/TLS 암호화를 어떻게 구성합니까? Mar 18, 2025 pm 12:01 PM

기사는 인증서 생성 및 확인을 포함하여 MySQL에 대한 SSL/TLS 암호화 구성에 대해 설명합니다. 주요 문제는 자체 서명 인증서의 보안 영향을 사용하는 것입니다. [문자 수 : 159]

인기있는 MySQL GUI 도구는 무엇입니까 (예 : MySQL Workbench, Phpmyadmin)? Mar 21, 2025 pm 06:28 PM

기사는 MySQL Workbench 및 Phpmyadmin과 같은 인기있는 MySQL GUI 도구에 대해 논의하여 초보자 및 고급 사용자를위한 기능과 적합성을 비교합니다. [159 자].

MySQL에서 큰 데이터 세트를 어떻게 처리합니까? Mar 21, 2025 pm 12:15 PM

기사는 MySQL에서 파티셔닝, 샤딩, 인덱싱 및 쿼리 최적화를 포함하여 대규모 데이터 세트를 처리하기위한 전략에 대해 설명합니다.

InnoDB 전체 텍스트 검색 기능을 설명하십시오. Apr 02, 2025 pm 06:09 PM

InnoDB의 전체 텍스트 검색 기능은 매우 강력하여 데이터베이스 쿼리 효율성과 대량의 텍스트 데이터를 처리 할 수있는 능력을 크게 향상시킬 수 있습니다. 1) InnoDB는 기본 및 고급 검색 쿼리를 지원하는 역 색인화를 통해 전체 텍스트 검색을 구현합니다. 2) 매치 및 키워드를 사용하여 검색, 부울 모드 및 문구 검색을 지원합니다. 3) 최적화 방법에는 워드 세분화 기술 사용, 인덱스의 주기적 재건 및 캐시 크기 조정, 성능과 정확도를 향상시키는 것이 포함됩니다.