RE: restore archivelog all validate; gives RMAN-06025
Date: Thu, 8 Oct 2015 01:28:04 +0000
Message-ID: <2FE2AA1C5F8DEC478F58DF8DD32BA6370BB0ED_at_HKWPIPXMB03C.zone1.scb.net>
Oracle may retain archivelogs older than the retention window – it does a purge only if the FRA is running out of space. That can explain why some servers have older archivelogs – simply their FRAs are larger relative to the sizes of the backups and archivelogs.
You should be running a “CROSSCHECK BACKUP OF ARCHIVELOG ALL” {not “crosscheck archivelog all”} because you want to mark Expired the *backups* of archivelogs that are not available to restore from. Once you do a CROSSCHECK and find that some backups are marked EXPIRED, you might want to DELETE EXPIRED BACKUP OF ARCHIVELOG ALL
Hemant K Chitale
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Woody McKay
Sent: Thursday, October 08, 2015 7:56 AM
To: Andrew Kerber
Cc: ORACLE-L
Subject: Re: restore archivelog all validate; gives RMAN-06025
Hi Andrew,
This is a script I've inherited and won't be able to change till next spring - and I do appreciate any improvements. However, this script has been working fine in thousands of servers for several years. I'm thinking there must be something about this particular server.
Even though the "restore archivelog validate" is asking for the last 2 weeks, shouldn't it be able to run successfully even if there are only 2 days of backups?
Am I misunderstanding or missing something?
Thanks
On Wed, Oct 7, 2015 at 7:43 PM, Andrew Kerber <andrew.kerber_at_gmail.com<mailto:andrew.kerber_at_gmail.com>> wrote: I'm not sure I understand the problem. Everything seems to be working properly. You have a recovery window of 7 days and are asking for archive logs 14 days old, and they are gone as they should be. I don't actually see a problem here.
Sent from my iPad
On Oct 7, 2015, at 6:27 PM, Woody McKay <woody.mckay_at_gmail.com<mailto:woody.mckay_at_gmail.com>> wrote:
Hi, ( note, cross posted in Oracle community Database Backup and Recovery )
I'm not super-versed with RMAN but am trying to resolve an rman issue on a development server. The DB environment can be rebuilt if needed, but I'd like to try and resolve this with a crosscheck command, etc.
The weekly rman backup script looks like:
run {
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '%F';
configure retention policy to recovery window of 7 days;
allocate channel d1 type disk maxpiecesize=5G;
backup as compressed backupset incremental level 0 cumulative tag 'L0'database
plus archivelog delete all input;
restore database validate;
release channel d1;
delete noprompt obsolete;
restore database check logical validate;
backup validate database;
restore archivelog from time 'SYSDATE-14' validate;
host 'copy C:\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora C:\oradata\fast_recovery_area\';
host 'copy C:\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\sqlnet.ora C:\oradata\fast_recovery_area\';
host 'copy C:\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN\listener.ora C:\oradata\fast_recovery_area\';
host 'copy C:\oracle\product\12.1.0\dbhome_1\database\pwd*.ora C:\oradata\fast_recovery_area\';
}
list incarnation of database;
list backup summary;
list backup by file;
list recoverable backup of database;
report schema;
report need backup redundancy=3;
report need backup recovery window of 3 days;
The command "restore archivelog from time 'SYSDATE-14' validate;" is throwing the below error:
RMAN> restore archivelog from time 'SYSDATE-14' validate;
Starting restore at 07-OCT-15
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/07/2015 15:15:49
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of archived log for thread 1 with sequence 38 and starting SCN of 4330735 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 37 and starting SCN of 4324802 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 36 and starting SCN of 4311903 found to restore
RMAN-06025: no backup of archived log for thread 1 with sequence 35 and starting SCN of 4230358 found to restore
...
Note, that "RMAN> restore archivelog from time 'SYSDATE-1' validate;" does work successfully.
I did find and removed on obsolete backup set, but that didn't resolve the 06026 error.
I tried "crosscheck archivelog all;", but that does not resolve the 06026 error during the restore archivelog validate.
Is there a crosscheck command or other command that would sync the catalog and disk to resolve the 06026?
Thanks for all replies.
--
Sincerely,
WoodyMcKay
--
Sincerely,
WoodyMcKay
This email and any attachments are confidential and may also be privileged. If you are not the intended recipient, please delete all copies and notify the sender immediately. You may wish to refer to the incorporation details of Standard Chartered PLC, Standard Chartered Bank and their subsidiaries at https://www.sc.com/en/incorporation-details.html
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Oct 08 2015 - 03:28:04 CEST