RMAN Backup error: What to do if some archivelog is missing or datafile is offline during RMAN backup?

I always encounters the problem while my seminars that what DBA should do if some archivelog is missing during RMAN backup.
I think apart from crossing the fingers, one can at least make successful backup. backup should not be missed even if you miss some of the files. Nothing is important than successful backup. All future recovery depends upon the presence of backups.

RMAN> crosscheck archivelog all;

and then follwoing to delete expired archivelog.

RMAN> delete expired archive log;

Also refer to the skip inaccessible clause of the backup command. for example...

RMAN> backup archivelog all skip inaccessible delete input;
RMAN> change archivelog all validate;

because without it "skip inaccessible" will be needed any time You will start backup of archs.

Moreover, it can be done with following way also:

for the missing archive logs... u can do the following

connect target /
connect catalog rman/pwd@rmancatalog
run {
change archivelog from logseq = xxx until logseq =
yyy unavailable;
}

xxx and yyy are the logseg numbers, the one's you are missing.

RMAN> RUN
{
SET MAXCORRUPT FOR DATAFILE 1 TO 10;
BACKUP DATABASE
SKIP INACCESSIBLE
SKIP READONLY
SKIP OFFLINE;
}

To back up the database while skipping offline and read-only tablespaces, you can run the following command:

RMAN> BACKUP DATABASE
SKIP READONLY
SKIP OFFLINE;

Above discussion include other file types also if they are not available during backup and backup is generating exception.

Comments:

Hi, there is a syntax error for the command:
RMAN> delete expired archive log;

It should be something like:
RMAN> delete expired archivelog all;

Posted by guest on November 01, 2011 at 04:43 AM IST #

one table was drooped from our oracle database 11g.my flash back was not on that time .i restored the backup and i skipped the archive log of that day because the demand was to recover one days before. i was successful to restore and recover the backup.Now after that when ever i take a backup and when i issue this cammand .

rman >backup database plus archivelog;

it gives me error that one archive log is missing i understand this coz i moved these archive logs because i had to take to database one day old.

now if today i take backup it tellw me your 1 archhive log is missing . how can i contine. please guide.

Posted by guest on January 14, 2012 at 08:09 AM IST #

one table was drooped from our oracle database 11g.my flash back was not on that time .i restored the backup and i skipped the archive log of that day because the demand was to recover one days before. i was successful to restore and recover the backup.Now after that when ever i take a backup and when i issue this cammand .

rman >backup database plus archivelog;

it gives me error that one archive log is missing i understand this coz i moved these archive logs because i had to take to database one day old.

now if today i take backup it tellw me your 1 archhive log is missing . how can i contine. please guide.

Posted by guest on January 14, 2012 at 08:10 AM IST #

Good one!!!

Posted by jatin on September 14, 2013 at 05:21 AM IST #

Hi ,

I am currently facing a strange issue in my production site. I find the archive is not written ie. the archive go missing every day in two's or three. e.g

I saw that on 1 Jul my last archive backed up is xxxx002 but then on 2nd when my backup ran the first archive I see is xxxx005. This scenario is happening every day without fail. How do we address this issue.

Posted by guest on July 04, 2014 at 10:47 AM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

What I learned about Oracle

Search

Archives
« April 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  
       
Today