How to read RMAN data into an Oracle Table?

From: W.Benvort <wolfgang_nl_at_hotmail.com>
Date: 1 Mar 2004 01:44:19 -0800
Message-ID: <9a0caaaf.0403010144.78e704fb@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 Received on Mon Mar 01 2004 - 03:44:19 CST