dbTalk Databases Forums  

Rman configuration

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss Rman configuration in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
exec@chicagorsvp.com
 
Posts: n/a

Default Rman configuration - 08-28-2008 , 12:08 PM






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;


Reply With Quote
  #2  
Old   
joel garry
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:31 PM






On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) com wrote:
Quote:
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/uniont...1b28bloat.html


Reply With Quote
  #3  
Old   
joel garry
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:31 PM



On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) com wrote:
Quote:
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/uniont...1b28bloat.html


Reply With Quote
  #4  
Old   
joel garry
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:31 PM



On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) com wrote:
Quote:
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/uniont...1b28bloat.html


Reply With Quote
  #5  
Old   
joel garry
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:31 PM



On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) com wrote:
Quote:
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/uniont...1b28bloat.html


Reply With Quote
  #6  
Old   
exec@chicagorsvp.com
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:36 PM



On Aug 28, 1:31*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Quote:
On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) 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/uniont...b28bloat.html- Hide quoted text -

- Show quoted text -
I should have mentioned the version we are on. Sorry.......10g R2....



Reply With Quote
  #7  
Old   
exec@chicagorsvp.com
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:36 PM



On Aug 28, 1:31*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Quote:
On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) 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/uniont...b28bloat.html- Hide quoted text -

- Show quoted text -
I should have mentioned the version we are on. Sorry.......10g R2....



Reply With Quote
  #8  
Old   
exec@chicagorsvp.com
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:36 PM



On Aug 28, 1:31*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Quote:
On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) 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/uniont...b28bloat.html- Hide quoted text -

- Show quoted text -
I should have mentioned the version we are on. Sorry.......10g R2....



Reply With Quote
  #9  
Old   
exec@chicagorsvp.com
 
Posts: n/a

Default Re: Rman configuration - 08-28-2008 , 01:36 PM



On Aug 28, 1:31*pm, joel garry <joel-ga... (AT) home (DOT) com> wrote:
Quote:
On Aug 28, 10:08*am, e... (AT) chicagorsvp (DOT) 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/uniont...b28bloat.html- Hide quoted text -

- Show quoted text -
I should have mentioned the version we are on. Sorry.......10g R2....



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.