Re: Getting default RMAN configuration value

From: Steve Howard <stevedhoward_at_gmail.com>
Date: 4 Jul 2006 22:54:42 -0700
Message-ID: <1152078882.237466.257200@v61g2000cwv.googlegroups.com>

graff3_at_hotmail.com wrote:
> Hi Jerome,
>
> No luck..I made sure the db was in catalog mode and queried the
> RMAN.RC_RMAN_CONFIGURATION...but its empty.
>
> Regards
>
> MG
> graff3_at_hotmail.com wrote:
> > Hi Jerome,
> >
> > I thought this table was only updated for non-default values....I will
> > check.
> >
> > Regards
> >
> > MB
> > Jerome Vitalis wrote:
> > > On Wed, 28 Jun 2006 21:13:11 -0700, graff3 wrote:
> > >
> > > > Hi guys,
> > > >
> > > > Is there an API or SQL script to get the default configuration values
> > > > displayed like in the 'show all' command in RMAN?
> > > >
> > > > Some documents point to the V_$RMAN_CONFIGURATION view. But the viiew
> > > > is only populated if you were to override the default configuration.
> > >
> > > If you're in CATALOG mode, you can maybe get it by querying
> > > RC_RMAN_CONFIGURATION (I haven't checked that).

If you trace an RMAN session, you will see that it executes the dbms_backup_restore.getparm function. When I ran it though, it only returned what is below. My guess is it is user callout that is based on the users environment, i.e, running from rman. It may be a place to research, though.

SQL> set serveroutput on size unlimited
SQL> declare
  2 l_parm varchar2(500);
  3 begin
  4 for i in 1..10000 loop

  5      select dbms_backup_restore.getparm(i)
  6        into l_parm
  7        from dual;
  8      if length(l_parm) > 0 then
  9        dbms_output.put_line(l_parm);
 10      end if;

 11 end loop;
 12 end;
 13 /
C:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\SPFILETEST10G2.ORA

%F
%F
%U

PL/SQL procedure successfully completed.

SQL> Regards,

Steve Received on Wed Jul 05 2006 - 00:54:42 CDT