Re: FLASH Recovery Area, RMAN and FLASHBACK DATABAE

On Apr 22, 2:58 pm, dbaplusp..._at_hotmail.com wrote:
> I am using Oracle 10.1..0.4 (but could use Oracle 10.2 - latest
> version) in future ) on
> Windows 2000 Server. I am currently not using flashback database (have
> not set flash_recover_area). I am doing backup of database using RMAN/
> Nebackup on tape.
>
> I want to use flashback database, so need to set flash recovery area.
> However, I do
> not want to put any of RMAN backups in Flash recovery area. I want to
> continue to use my RMAN backup scripts, which directly write to tape.
>
> a. Can I Use flash_recovery_area only for storing flash back logs and
> not for RMAN backup. If yes, how?
> b. Do I need to backup flash recovery area at all? I will use
> flashback retention target to limit flashback logs.
> c. If I need to backup flash recovery area, how will I backup. Can I
> use my OS level backup (not RMAN) to backup the folder where
> flash_recovery_area is.
> d. If I loss some data in flash recovery area, will my database
> continue to work fine except I cannot flashback database?
>
> Really appreciate your response, I did read many articles on metalink
> on flashback database and flash recovery area but did not find answers
> to my question.

Why don't you setup a test system and test this out?

Let us know of any specific question you have as you proceed. Received on Sun Apr 22 2007 - 17:15:08 CDT