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 recovery from tape with automatic channels

Re: RMAN recovery from tape with automatic channels

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 20 Mar 2007 14:33:27 -0700
Message-ID: <bf46380703201433s3138f009x851053bf9361c67a@mail.gmail.com>


I knew I should have included SHOW ALL

The default device is set to SBT

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 5 DAYS; CONFIGURE BACKUP OPTIMIZATION OFF; # default CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE'; CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 2; CONFIGURE DEVICE TYPE DISK PARALLELISM 1; # default CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' MAXOPENFILES 8; CONFIGURE MAXSETSIZE TO UNLIMITED; # default CONFIGURE SNAPSHOT CONTROLFILE NAME TO
'D:\ORACLE\ORA92\DATABASE\SNCFTL01.ORA'; # default

RMAN> On 3/20/07, Allen, Brandon <Brandon.Allen_at_oneneck.com> wrote:
>
> Not sure if this has anything to do with it, but is your default device
> type also 'SBT_TAPE'?
>
>
> RMAN> show default device type;
>
> RMAN configuration parameters are:
> CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
>
>
>
> Regards,
> Brandon
>
> Privileged/Confidential Information may be contained in this message or
> attachments hereto. Please advise immediately if you or your employer do not
> consent to Internet email for messages of this kind. Opinions, conclusions
> and other information in this message that do not relate to the official
> business of this company shall be understood as neither given nor endorsed
> by it.
>
>

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

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 20 2007 - 16:33:27 CDT

Original text of this message

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