Home » RDBMS Server » Backup & Recovery » How to display an archived redo log name from backup set/piece?
How to display an archived redo log name from backup set/piece? [message #230890] Fri, 13 April 2007 04:04 Go to next message
patrick_tahiri
Messages: 3
Registered: April 2007
Junior Member
Hi,

I receive this error:
RMAN-06059: expected archived log not found, lost of archived log compromises recoverability.
ORA-19625: error identifying file /u02/arch/ABX/ABXarch679701603993675.0001

How can I check with an rman command if this archive redo log has already been backuped (included in a backup set/piece)?

When I checked ABXarch679701603993675.0001 in /u02/arch/ABX, it was not there anymore. So the delete command from the rman has deleted it.

1. list backup of archivelog all completed after 'SYSDATE-1';
or
list backup tag 'TAGXXXXX';
or
list backup of archivelog all tag 'TAGXXX';

==> It shows/dislpays only the backup set, the sequence number, and the backup piece NOT the name of the archive redo log (format: ABXarch679701603993675.0001).

2. crosscheck backup of archivelog from sequence 67970;
or
crosscheck backup piece tag 'TAGXXXXX';
or
crosscheck backupset 2209107;
==> It shows/dislpays only the backup pieces NOT the name of the archive redo log (format: ABXarch679701603993675.0001).

3. list archivelog from sequence 67970;
==> Shows/Displays the name of the archived redo log but not ABXarch679701603993675.0001?! ==>> Means that this archive redo log was not backuped?

How based upon my archived redo log name could I check that it is well backuped and included in which backup set/piece? Or maybe not backed up?

Thank you in advance!

Best regards,

Patrick.
Re: How to display an archived redo log name from backup set/piece? [message #232413 is a reply to message #230890] Fri, 20 April 2007 07:41 Go to previous messageGo to next message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Hi,

RMAN> list backup of archivelog like '%ABXarch679701603993675.0001';
Re: How to display an archived redo log name from backup set/piece? [message #232414 is a reply to message #232413] Fri, 20 April 2007 07:43 Go to previous message
kamkan
Messages: 27
Registered: April 2007
Location: Chennai, INDIA
Junior Member
Once u identify the backup set, then crosscheck the backup set for physical existence.
Previous Topic: take a look a this
Next Topic: Recovering Tablespace in Maintenance from Production database backup
Goto Forum:
  


Current Time: Mon Dec 05 14:48:25 CST 2016

Total time taken to generate the page: 0.12947 seconds