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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RMAN without a repository and a total site loss

Re: RMAN without a repository and a total site loss

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 17 Apr 2007 22:47:23 -0700
Message-ID: <bf46380704172247k429bf686p6eed1ce6356c68d8@mail.gmail.com>


On 4/17/07, GovindanK <gkatteri_at_fastmail.fm> wrote:
>
> Lot of ideas have been given about this thread. Autobackup is one good
> concept. It is preferred you put the dbid as part of the media handle or
> wherever you can plug that in.
>

The default media handle is %F, which includes the DBID. You must include %F in any custom filespec, or an error will be raised.

RMAN> configure controlfile autobackup format for device type sbt to '/tmp/ctl_auto_%d.ctl';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of configure command at 04/17/2007 22:46:43 RMAN-06492: controlfile autobackup format "/tmp/ctl_auto_%d.ctl" must specify a "%F" format specifier

RMAN>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Apr 18 2007 - 00:47:23 CDT

Original text of this message

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