Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10g fash_recovery_area
On May 6, 10:20 am, dbaplusp..._at_hotmail.com wrote:
> On May 6, 10:09 am, JW <j..._at_abc.com> wrote:
>
>
>
>
>
> > On 6 May 2007 02:52:40 -0700, "Vladimir M. Zakharychev"
>
> > <vladimir.zakharyc..._at_gmail.com> wrote:
> > >On May 6, 8:02 am, JW <j..._at_abc.com> wrote:
> > >> Thanks for your quick reply.
> > >> Do you mean that I can configure the Archive Log to
> > >> flash_recovery_area, and RMAN to different disk/folder ?
> > >> I thought they have to be the same area. Sorry to ask that simple
> > >> question.
> > >> JW
>
> > >> On Sat, 05 May 2007 17:02:24 -0700, DA Morgan <damor..._at_psoug.org>
> > >> wrote:
>
> > >> >JW wrote:
> > >> >> I worked on Oracle 9i for a while under Window 2000 environment. I
> > >> >> just started working on 10g, and work like to clarify a confusion.
>
> > >> >> In Oracle 9i, it was recommanded that the Archive Log folder (disk)
> > >> >> should be doifferent from the folder (disk) for storing the RMAN
> > >> >> files. But in 10g, it looks like they are to be kept in
> > >> >> flash_recovery_area. Is this contradict what it should be defined
> > >> >> before ?
>
> > >> >> Also there is maximum size definition of the flash_recovery_area.
> > >> >> Should I defined the total size of the expected archived logs plus the
> > >> >> RMAN files ? Or should I just defined the disk size for the folder ?
>
> > >> >> Thanks for clarifying for me.
>
> > >> >> JW
>
> > >> >What you are looking as is the default installation if you do no
> > >> >customization during installation. Not a best practice for scalability
> > >> >and performance.
>
> > >> >The rule has never changed ... spread everything for maximum spindles.
>
> > >1) Please, do not top-post.
> > >2) RMAN backups do not have to be in the FRA, they just go there by
> > >default if you don't specify any other location. The same is true for
> > >archived logs. Note that you can define no FRA at all, and in this
> > >case everything is just like in pre-10g days.
>
> > >Hth,
> > > Vladimir M. Zakharychev
> > > N-Networks, makers of Dynamic PSP(tm)
> > > http://www.dynamicpsp.com
>
> > Sorry for the top-post, I hadn't paid attention to it.
> > I would like to keep FRA as it seems to be a good features to recover
> > error actions on tables.
> > Can I use the FRA to hold Archive Log files and use script block to
> > run RMAN Backup to different drives, instead of the default location
> > setting in 9i ? Will this affect Oracle's flash back feature ?
> > Thanks.
> > JW- Hide quoted text -
>
> > - Show quoted text -
>
> You may want to refer to this thread on same topic posted a few weeks
> ago in this forum- RMAN, FLASHBACK Database and Flashback Rceovery
> Area.
>
> http://groups.google.com/group/comp.databases.oracle.server/browse_th...- Hide quoted text -
>
> - Show quoted text -
Unless you are going to use the rman copy feature to backup your database files and want to be able in the event of a failure to switching the database from using the regular files to using the backup copies then let Oracle place the backups, archived redo logs, and flash back logs all together. Just provide the flashback area multiple spindals.
In the case where you want to be able to switch the entire database over to using the backup files as the database then I would lay the files out in a disk area designed to support this.
Backup pieces support compression and hence can if you use this feature take less space. Backup copies support applying the changes to the backup and switching the database to run using the backup, if desired. You can still just restore and recover.
Keeping everything in the flashback area will work. It is really a managmenet issue, How features do you plan to use and how do you want to manage them.
HTH -- Mark D Powell -- Received on Sun May 06 2007 - 11:35:19 CDT