RMAN archivelog backup question...

[sambavan]

I'm kind of lost at this point.

The scenario is the when you connect to RMAN, then open a channel for maintenance to the tape drive and if you issue

report obsolete orphan;

you would get a list of backupset and backuppiece.

Now I delete that by issuing

change backupset #s delete;

My first question at this is does it just list the backup of tablespace and datafiles and why not the archivelog backupset?

I went ahead and deleted those backupsets. Now I'm trying to find a way to list all my archive log backupsets and when ever I issue the

change archivelog until time 'SYSDATE-7' delete;

It says that it cannot find the backup. Infact I'm backing up the archivelogs every 6Hrs. I couldn't even list the archive log using the command like

list backupset of archivelog until time 'SYSDATE-7';


Any idea of how to get out of this hell :( Does RMAN delete the archivelog backupsets when you delete the tablespace backupsets? Is it a bug on 8.1.6.3?

Sam

[Edited by sambavan on 04-05-2001 at 06:54 PM]

[balaap]

The effect depends on the recovery catalog compatibility set
in your environment. Please check what is the compatibility
is set in your recovery catalog.

**If compatibility is 8.1.6 or higher then
Then change ... delete and backup ... delete input:

Delete backup sets, image copies, and archived logs
and remove their records from the recovery catalog

**If compatibility is 8.1.5 or lower Then
change ... delete and backup ... delete input :

Delete backup sets and image copies and remove the records from the catalog.Delete archived logs but change catalog records to status DELETED (and not remove them).

To set the your required compatibility:
RMAN> configure compatible = 8.1.5 or anyother value;
You can refer the oracle8.1.6 backup&recovery manual.

Regards,
A.P.BALASUBRAMANIAN

[sambavan]

Thanx for the information Balasubramanian. Say for example, that the compatibility had been set to 8.1.6, my questions are

1. When you delete the backupsets of data files, does oracle
take care of validating its backupset of archivelogs? I
presume that I have to do that manually.

2. When I issue "list backupset of archivelog until time 'SYSDATE-30'; "
it would lead to ORA-16511 and ORA-16512 on SQL statement
listTranslateArchivedLogBackup. The same thing comes when
I issue "crosscheck backup" Any idea of why?


Appreciate any ideas/suggestions.

Sam