asked on

RMAN backup question

I tried to do a backup with this result.

RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/22/2007 15:02:07
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability
ORA-19625: error identifying file /ubackup/90b01043_1_1817487.arc
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
I don't know why RMAN wants that particular file but so far it looks like i can recover/restore from that backup. What do i need to do to keep that message from happening every time i make a backup?

rdannels

It look like you remove your archive logs too fast for RMAN, you should keep
several days worth for a backup.

Robert

xoxomos

ASKER

I ran in noarchivelog then switched. I did not remove any from the time i switched to archivelog.

vamsi_uk

Check this link which has the same problem and solution:

http://www.lazydba.com/oracle/0__112849.html

ASKER CERTIFIED SOLUTION

Keyurkumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

xoxomos

ASKER

RMAN> crosscheck backup;

using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=552 devtype=DISK
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ubackup/flash_recovery_area/BB60/autobackup/2007_08_21/o1_mf_s_631202215_3dpndr38_.bkp recid=24 stamp=631202216
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ubackup/flash_recovery_area/BB60/autobackup/2007_08_21/o1_mf_s_631202401_3dpqpcgq_.bkp recid=26 stamp=631205595
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ubackup/flash_recovery_area/19iq1dmk_1_1 recid=27 stamp=631289557
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/ubackup/flash_recovery_area/BB60/autobackup/2007_08_22/o1_mf_s_631292515_3dsdlmqf_.bkp recid=28 stamp=631292515
Crosschecked 4 objects

xoxomos

ASKER

When i crosscheck archivelog all, i get a bunch of:

archive log filename=/ubackup/90b01043_1_1818405.arc recid=1991 stamp=628879490
validation failed for archived log
archive log filename=/ubackup/90b01043_1_1818406.arc recid=1992 stamp=628879502
validation failed for archived log
archive log filename=/ubackup/90b01043_1_1818407.arc recid=1993 stamp=628879513
validation failed for archived log
archive log filename=/ubackup/90b01043_1_1818408.arc recid=1994 stamp=628879524
validation failed for archived log
archive log filename=/ubackup/90b01043_1_1818409.arc recid=1995 stamp=628879537
^C
user interrupt received

xoxomos

ASKER

I've been taking the machine in and out of archivelog mode while trying to set up to run archivelog.
Maybe what happened is i went into RMAN and deleted the backups, but should have also deleted the archivelogs in RMAN rather than just deleteing them from os?????

xoxomos

ASKER

I've just asked my boss to subscribe to LazyDBA. Don't have subscription yet.

xoxomos

ASKER

Maybe this is a different question, but is there any way to just get rid of the /ubackup files in RMAN? I deleted them from the os command line without taking care of it in RMAN first.
They are not needed.

xoxomos

ASKER

Thanks,
running crosscheck plus deleting, i got rid of that problem.