Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Rman configuration

 
   Database Help (Home) -> Oracle RSS
Next:  Computer Oracle Topics  
Author Message
exec

External


Since: Aug 28, 2008
Posts: 6



(Msg. 1) Posted: Thu Aug 28, 2008 10:08 am
Post subject: Rman configuration
Archived from groups: comp>databases>oracle>misc (more info?)

I'm really just curious. when you define default parameters from
within RMAN like we have below, does RMAN remember it? Where does it
store that info so that it remains persistent?

We're thinking to use our control file rather than a recovery
catalog. We also want to know if we can code default parameters for
Change Tracking File, Filesperset and/or Filesperpiece.

We're setting up some new backup procedures and want to know if our
setup is good. We have a 80GB database & about 20 datafiles.

### Default, but coded for safety ###
CONFIGURE DEFAULT DEVICE TYPE TO DISK;

### Keep backups for 14 days ###
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;

### Backup control file at end of backup routine ###
CONFIGURE CONTROLFILE AUTOBACKUP ON;

### Naming convention for control file ###
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/../
cf_%F;

### Compress backupset and number of channels to allocate ###
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
PARALLELISM 10;

### Configures filename formatting ###
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/NI00/backup/ora_df%d_
%s_%p';

### No limit to size of backup set ###
CONFIGURE MAXSETSIZE TO UNLIMITED;

 >> Stay informed about: Rman configuration 
Back to top
Login to vote
joel garry

External


Since: Dec 20, 2007
Posts: 379



(Msg. 2) Posted: Thu Aug 28, 2008 11:31 am
Post subject: Re: Rman configuration [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Aug 28, 10:08 am, e... DeleteThis @chicagorsvp.com wrote:
> I'm really just curious.  when you define default parameters from
> within RMAN like we have below, does RMAN remember it?  Where does it
> store that info so that it remains persistent?
>
> We're thinking to use our control file rather than a recovery
> catalog.  We also want to know if we can code default parameters for
> Change Tracking File, Filesperset and/or Filesperpiece.
>
> We're setting up some new backup procedures and want to know if our
> setup is good.  We have a 80GB database & about 20 datafiles.
>
> ### Default, but coded for safety ###
> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
>
> ### Keep backups for 14 days ###
> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
>
> ### Backup control file at end of backup routine ###
> CONFIGURE CONTROLFILE AUTOBACKUP ON;
>
> ### Naming convention for control file ###
> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/../
> cf_%F;
>
> ### Compress backupset and number of channels to allocate ###
> CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
> PARALLELISM 10;
>
> ### Configures filename formatting ###
> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/NI00/backup/ora_df%d_
> %s_%p';
>
> ### No limit to size of backup set ###
> CONFIGURE MAXSETSIZE TO UNLIMITED;

That stuff is in the control file, as you've surely seen in the docs.
Also see the recent other threads about this, and some benefits may
accrue from having smaller things to search through during a recovery.

Do an alter database backup controlfile to trace to see what is kept,
and be aware all the other stuff in the controlfile won't be exposed
with that, so be real sure you understand how to keep that information
and what you can inform the controlfile about with RMAN commands.

There are version-specific issues, too.

I'd recommend the Hart & Freeman RMAN book, as well as a deep
understanding of the backup docs.

jg
--
@home.com is bogus.
http://www.signonsandiego.com/uniontrib/20080828/news_1b28bloat.html

 >> Stay informed about: Rman configuration 
Back to top
Login to vote
exec

External


Since: Aug 28, 2008
Posts: 6



(Msg. 3) Posted: Thu Aug 28, 2008 11:36 am
Post subject: Re: Rman configuration [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Aug 28, 1:31 pm, joel garry <joel-ga... DeleteThis @home.com> wrote:
> On Aug 28, 10:08 am, e... DeleteThis @chicagorsvp.com wrote:
>
>
>
>
>
> > I'm really just curious.  when you define default parameters from
> > within RMAN like we have below, does RMAN remember it?  Where does it
> > store that info so that it remains persistent?
>
> > We're thinking to use our control file rather than a recovery
> > catalog.  We also want to know if we can code default parameters for
> > Change Tracking File, Filesperset and/or Filesperpiece.
>
> > We're setting up some new backup procedures and want to know if our
> > setup is good.  We have a 80GB database & about 20 datafiles.
>
> > ### Default, but coded for safety ###
> > CONFIGURE DEFAULT DEVICE TYPE TO DISK;
>
> > ### Keep backups for 14 days ###
> > CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
>
> > ### Backup control file at end of backup routine ###
> > CONFIGURE CONTROLFILE AUTOBACKUP ON;
>
> > ### Naming convention for control file ###
> > CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/../
> > cf_%F;
>
> > ### Compress backupset and number of channels to allocate ###
> > CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
> > PARALLELISM 10;
>
> > ### Configures filename formatting ###
> > CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/NI00/backup/ora_df%d_
> > %s_%p';
>
> > ### No limit to size of backup set ###
> > CONFIGURE MAXSETSIZE TO UNLIMITED;
>
> That stuff is in the control file, as you've surely seen in the docs.
> Also see the recent other threads about this, and some benefits may
> accrue from having smaller things to search through during a recovery.
>
> Do an alter database backup controlfile to trace to see what is kept,
> and be aware all the other stuff in the controlfile won't be exposed
> with that, so be real sure you understand how to keep that information
> and what you can inform the controlfile about with RMAN commands.
>
> There are version-specific issues, too.
>
> I'd recommend the Hart & Freeman RMAN book, as well as a deep
> understanding of the backup docs.
>
> jg
> --
> @home.com is bogus.http://www.signonsandiego.com/uniontrib/20080828/news_1b28bloat.html- Hide quoted text -
>
> - Show quoted text -

I should have mentioned the version we are on. Sorry.......10g R2....
 >> Stay informed about: Rman configuration 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> Oracle All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]