-
RMAN error missing .arc file
I run my crosscheck script
rman catalog rman/rman target / > $LOG_FILE 2>&1 <
CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
LIST BACKUP SUMMARY;
EOF
exit 0
Than I run my rman backup of archive files code
rman <
connect target /
connect catalog rman/rman
sql "alter system archive log current";
backup filesperset 5 archivelog until time 'sysdate-1/24'
format $FILE_DEST_ARCH
delete input ;
resync catalog;
EOT
I get the error below. The errror message is correct as the .arc file is not there but can someody suggest a RMAN command I can use to get rid of
the error?
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
ORA-19625: error identifying file /archive/ifdtest3/ifdtest3_2098_1_754908462.arc
SVR4 Error: 2: No such file or directory
RMAN> show all;
RMAN configuration parameters for database with db_unique_name IFDTEST3 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/ifdtest3/spfile_control_files/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11g/dbs/snapcf_ifdtest3.f'; # default
I am runing Oracle 11.1.0.7.0 version of the DB,
Thanks to all who answer
-
'skip inaccessible'
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
The skip innaccessible appeared to work thanks... can somebody explain
why my crosscheck script did not fix the issue? Or what do I need to add to
my crosscheck script to fix instead of changing the backup script.
Thanks
-
crosscheck archivelog all should also work. can you please post the log output from first block?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
-
ViJay, It appears that the crosscheck archive log all did fix my issue!! Also
I the skip clause is a good thing to know. Thanks.
INITIAL ERROR
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
ORA-19625: error identifying file /archive/ifdtest3/ifdtest3_2752_1_754908462.arc
SVR4 Error: 2: No such file or directory
RAN CROSS CHECK SCRIPT
rman catalog rman/rman target / > $LOG_FILE 2>&1 <
CROSSCHECK BACKUP DEVICE TYPE DISK;
CROSSCHECK ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED ARCHIVELOG ALL;
DELETE NOPROMPT EXPIRED BACKUP;
DELETE NOPROMPT OBSOLETE;
LIST BACKUP SUMMARY;
EOF
exit 0
CROSS CHECK OUTPUT FROM SCRIPT (ONLY INFO FOR PROBLEM .ARC file)
validation failed for archived log
archived log file name=/archive/ifdtest3/ifdtest3_2752_1_754908462.arc RECID=2755 STAMP=756824416
Key Thrd Seq S Low Time
------- ---- ------- - -------------------
10819 1 2752 X 07-18-2011 12:53:52
Name: /archive/ifdtest3/ifdtest3_2752_1_754908462.arc
deleted archived log
archived log file name=/archive/ifdtest3/ifdtest3_2752_1_754908462.arc RECID=2755 STAMP=756824416
RMAN SCRIPT
rman catalog rman/rman target / > $LOG_FILE 2>&1 <
show all;
backup filesperset 5 archivelog until time 'sysdate-0/24'
format '/backup/ifdtest3/arch/arch_%d_t%t_s%s_p%p'
delete input;
resync catalog;
EOF
exit 0
RMAN OUTPUT
Recovery Manager: Release 11.1.0.7.0 - Production on Tue Jul 19 09:28:17 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: IFDTEST3 (DBID=1448134763)
connected to recovery catalog database
RMAN>
RMAN configuration parameters for database with db_unique_name IFDTEST3 are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/ifdtest3/spfile_control_files/%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BZIP2'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11g/dbs/snapcf_ifdtest3.f'; # default
RMAN> 2> 3>
Starting backup at 07-19-2011 09:28:26
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=917 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=989 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=975 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=940 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=2900 RECID=2903 STAMP=756896422
channel ORA_DISK_1: starting piece 1 at 07-19-2011 09:28:36
channel ORA_DISK_2: starting archived log backup set
channel ORA_DISK_2: specifying archived log(s) in backup set
input archived log thread=1 sequence=2898 RECID=2901 STAMP=756892816
channel ORA_DISK_2: starting piece 1 at 07-19-2011 09:28:36
channel ORA_DISK_3: starting archived log backup set
channel ORA_DISK_3: specifying archived log(s) in backup set
input archived log thread=1 sequence=2899 RECID=2902 STAMP=756894611
channel ORA_DISK_3: starting piece 1 at 07-19-2011 09:28:36
channel ORA_DISK_4: starting archived log backup set
channel ORA_DISK_4: specifying archived log(s) in backup set
input archived log thread=1 sequence=2901 RECID=2904 STAMP=756896433
channel ORA_DISK_4: starting piece 1 at 07-19-2011 09:28:36
channel ORA_DISK_4: finished piece 1 at 07-19-2011 09:28:37
piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s241_p1 tag=TAG20110719T092834 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_4: deleting archived log(s)
archived log file name=/archive/ifdtest3/ifdtest3_2901_1_754908462.arc RECID=2904 STAMP=756896433
channel ORA_DISK_1: finished piece 1 at 07-19-2011 09:28:39
piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s238_p1 tag=TAG20110719T092834 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: deleting archived log(s)
archived log file name=/archive/ifdtest3/ifdtest3_2900_1_754908462.arc RECID=2903 STAMP=756896422
channel ORA_DISK_2: finished piece 1 at 07-19-2011 09:28:39
piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s239_p1 tag=TAG20110719T092834 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_2: deleting archived log(s)
archived log file name=/archive/ifdtest3/ifdtest3_2898_1_754908462.arc RECID=2901 STAMP=756892816
channel ORA_DISK_3: finished piece 1 at 07-19-2011 09:28:40
piece handle=/backup/ifdtest3/arch/arch_IFDTEST3_t756898116_s240_p1 tag=TAG20110719T092834 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_3: deleting archived log(s)
archived log file name=/archive/ifdtest3/ifdtest3_2899_1_754908462.arc RECID=2902 STAMP=756894611
Finished backup at 07-19-2011 09:28:40
Starting Control File Autobackup at 07-19-2011 09:28:40
piece handle=/backup/ifdtest3/spfile_control_files/c-1448134763-20110719-00 comment=NONE
Finished Control File Autobackup at 07-19-2011 09:28:48
RMAN>
starting full resync of recovery catalog
full resync complete
RMAN>
-
I didn't see any difference in the script which was through error and which was successful. could you you please high light?
Thanks,
Vijay Tummala
Try hard to get what you like OR you will be forced to like what you get.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|