Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to read RMAN data into an Oracle Table?
Hi,
As far as my information,V$ views for RMAN are specific to Recovery
Catalog as I read.
If we are not using Recovery Catalog,our only source of information,
for getting RMAN Data, are the commands like:
RMAN>Report need backup.... etc
I will appreciate your comments.
W.Benvort
douglashawthorne_at_yahoo.com.au (Douglas Hawthorne) wrote in message news:<cf15dee4.0403011803.78f5ac1e_at_posting.google.com>...
> 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 Wed Mar 03 2004 - 00:15:07 CST
![]() |
![]() |