On Apr 22, 6:15 pm, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
> 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.- Hide quoted text -
>
> - Show quoted text -
Before I set up a test system, I need some ground work to be done. I
did research on metalink did not find answers. Many people use flash
back database, they can perhpas provide their views.
Received on Sun Apr 22 2007 - 17:50:53 CDT
