Re: 10g fash_recovery_area

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_thread/thread/a5b581a96741c849/33874fc6e1b6e651#33874fc6e1b6e651 Received on Sun May 06 2007 - 09:20:31 CDT