Re: Catalog RMAN backups on Tape?

From: Marcin Przepiorowski <pioro1_at_gmail.com>
Date: Tue, 26 Jan 2010 09:34:18 +0000
Message-ID: <3f5690af1001260134q3a170ba1y14f7e9e0903de878_at_mail.gmail.com>

On Tue, Jan 26, 2010 at 7:23 AM, Morgan Wigge <morgan_at_wigge.nu> wrote:
> Hi,
>
> It's included information about how to use sys.dbms_backup_restore package
> to extract information from backupsets
>

Hi,

All required information about that package are in dbmsbkrs.sql I have used that solution in 8i when there was no catalog option but the basics are the same and you can use it in 10 or 11 as well.

I don't have this script now (I have to research my home archive file) but there is a high level plan:

1. allocate channel using with proper type

dbms_backup_restore.deviceAllocate

2. start restore conversation

dbms_backup_restore.restoreSetDatafile;

3. restore backup piece

dbms_backup_restore.restoreBackupPiece(done=>v_done, handle=>'backup_piece_file_name', params=>null);

I'm not sure now if there are all required commands but I will try to find and publish a whole solution.

regards,
Marcin Przepiorowski
http://oracleprof.blogspot.com/

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jan 26 2010 - 03:34:18 CST