Re: How to read RMAN data into an Oracle Table?

wolfgang_nl_at_hotmail.com (W.Benvort) wrote in message news:<9a0caaaf.0403010144.78e704fb_at_posting.google.com>...
> Hallo,
>
> With regards to RMAN, how should we store the data into a database
> table, from the commands which can run only on RMAN prompt without
> using Recovery Catalog?
>
> For Example:
>
> RMAN> Report need backup days 3;
>
>
> RMAN DATA:
>
> RMAN-03022: compiling command: report
> Report of files whose recovery needs more than 3 days of archived logs
> File Days Name
> ---- ----- -----------------------------------------------------
> 1 1203 D:\ORACLE\ORADATA\TEST\SYSTEM01.DBF
> 2 1203 D:\ORACLE\ORADATA\TEST\RBS01.DBF
> 3 1203 D:\ORACLE\ORADATA\TEST\USERS01.DBF
>
>
>
>
> Should it done via UTL_FILE?
>
> If so, could someone give simple example/code how to do that, in order
> to write this RMAN data into an Oracle Database table?
> I also set the utl_file_dir parameter to a particular directory in my
> database.
>
> Thanks
>
> W.Benvort

Wolfgang,

Since you are not using the RMAN catalog (or repository), the source of the data is the control file. This data is already available in the dynamic performance views over the control file. Please consult the Database Reference manual to find what views you want.

Douglas Hawthorne Received on Mon Mar 01 2004 - 20:03:47 CST