Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2008
    Posts
    7

    Question Unanswered: Can I re-create the Flash Recoevery Area (10G)

    Hello
    I've run into a problem that have resulted in my Flash Recovery Area (FRA) becoming corrupted. I was wondering if I could simply delete the FRA and re-create it once again in Enterprise Mgr?

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    ALWAYS
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version
    or post Oracle version to 4 decimal places

    The Flashback Recovery Area (FRA) is just a folder/directory on some disk volume.
    You can do with it what ever you desire, since it is your system.
    Oracle will likely complain about not finding "expected" files within the FRA.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    You can delete whatever files you wish (as Anacedent has said), but then you need to crosscheck your backups to let RMAN know that the files are no longer available. If you're using Enterprise Manager you can do this under the Maintenance tab, then select "Manage Current Backups".
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  4. #4
    Join Date
    Feb 2008
    Posts
    7
    Quote Originally Posted by anacedent View Post
    ALWAYS
    Post Operating System (OS) name & version for DB server system.
    Post results of
    SELECT * from v$version
    or post Oracle version to 4 decimal places

    The Flashback Recovery Area (FRA) is just a folder/directory on some disk volume.
    You can do with it what ever you desire, since it is your system.
    Oracle will likely complain about not finding "expected" files within the FRA.
    Apologies, the O/S is Windows Server 2003 release 3 and the Oracle version is Oracle Database 10g Release 10.2.0.1.0

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •