Re: 10g fash_recovery_area

On 6 May 2007 09:35:19 -0700, Mark D Powell <Mark.Powell_at_eds.com> wrote:

>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 --
>
>
>

Thanks for all the info.
JW Received on Sun May 06 2007 - 12:02:57 CDT