Home » RDBMS Server » Backup & Recovery » Why did rman complain about archivelog not available based on the current retention policy (11.2.0.4 SE, Windows Server 2012)
|
Re: Why did rman complain about archivelog not available based on the current retention policy [message #651813 is a reply to message #651795] |
Wed, 25 May 2016 10:17  |
Frank Naude
Messages: 4596 Registered: April 1998
|
Senior Member |
|
|
The 'restore archivelog all validate' command doesn't recognise deleted backups.
This falls into the category of "what were they thinking"! However, it's nothing to be too concerned about.
You can generate a command to check only what you need to check from sqlplus with:
select 'restore validate archivelog from scn '||min_first_change#||' until scn '||max_next_change#
from v$backup_archivelog_summary;
Remember to also check:
RMAN> RESTORE SPFILE VALIDATE;
RMAN> RESTORE CONTROLFILE VALIDATE;
RMAN> RESTORE DATABASE VALIDATE;
PS: I've just noticed the line "using target database control file instead of recovery catalog".
Connecting to both the target database and recovery catalog should resolve the problem as well.
Good luck!
Frank
|
|
|
Goto Forum:
Current Time: Mon Jun 02 14:57:40 CDT 2025
|