-
RMAN - backup files expired
Hi, using Rman I have taken the production database complete backup with archivelogs by connecting to catalog database present on different machine.
But when I crosschecked the backup using the following command:
RMAN> crosscheck backup completed before 'sysdate-1';
It shows all the backup files as "Expired". As I have taken the backup yesterday, the above command should show me the files as "Available". The backup was run successfully, I have checked the backup files present on the disk.
Kind help is highly appreciated.
Regards,
-
What's the retention period you configured?
-
What time did you take the backup? The window you specified 'sysdate - 1' may actually fall before the time you took the backup.
What is the output of the following:
-
RMAN - backup files expired
Hi, the configuration for retention policy is as follows:
RMAN>configure retention policy to recovery window of 30 days.
and I have crosscheck the backup with
RMAN>crosscheck backup completed before 'sysdate';
previously i wrote 'sysdate-1' by mistake.
-
RMAN - backup files expired
Hi, can anyone help me in knowing the reason for why RMAN is showing the backup files as expired.
thanks,
-
Rman backup expired
Hi
Crosschecks update outdated RMAN repository information about backups whose repository records do not match their physical status. For example, if a user removes archived logs from disk with an operating system command, the repository still indicates that the logs are on disk, when in fact they are not.
If the backup is on disk, then the CROSSCHECK command determines whether the header of the file is valid. If the backup is on tape, then the command simply checks that the backup exists. The possible status values for backups are AVAILABLE, UNAVAILABLE, and EXPIRED.
you can list the backup details using the commands
list backup;
list backup summary;
or by quering
V$BACKUP_FILES
RC_DATAFILE_COPY or RC_ARCHIVED_LOG.
f the backup is no longer available, then RMAN marks it as EXPIRED.
gopu
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
|