Re: restore archivelog all validate; gives RMAN-06025
Date: Thu, 08 Oct 2015 10:12:28 +1000
Message-ID: <5615B4EC.5070200_at_tpg.com.au>
Right. That means that you will be able to restore archived logs only up to the last level 1 taken before the weekly script ran previously.
Cheers,
Tony
On 08/10/15 10:05, Woody McKay wrote:
> Hi Tony,
>
> This script is the weekly level 0 backup. There is also a weekday level 1 that runs during the week.
>
> Just looked at the weekday level 1 and it does have a "delete noprompt obsolete"
>
> No kind of duplicate or refresh or restore. Just weekend full level 0 and weekday incremental level 1.
>
>
>
> On Wed, Oct 7, 2015 at 8:00 PM, De DBA <dedba_at_tpg.com.au <mailto:dedba_at_tpg.com.au>> wrote:
>
> You say 2 days of backups - Do you run another script against this database during the week that also has a "delete obsolete" in it? A duplicate database or "refresh" script perhaps?
>
> Cheers,
> Tony
>
>
> On 08/10/15 09:55, Woody McKay wrote:
>> 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
>
>
>
>
> --
> Sincerely,
>
> WoodyMcKay
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 08 2015 - 02:12:28 CEST