Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to read RMAN data into an Oracle Table?

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

From: W.Benvort <wolfgang_nl_at_hotmail.com>
Date: 2 Mar 2004 22:15:07 -0800
Message-ID: <9a0caaaf.0403022215.2fbde6c4@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US