Results 1 to 4 of 4

Thread: Flashback point

  1. #1
    Join Date
    Jun 2010
    Posts
    81

    Unanswered: Flashback point

    Hi,

    I've been asked at the weekend to create a flashback restore point
    prior to some changes which will be performed later in the day.

    What are the steps involved to perform a flashback restore point,
    so should anything go wrong I can use this as my back out.

    Much appreciated

  2. #2
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    I suggest that you read up as much as you can between now & the weekend, & if possible practice beforehand what you will be doing.

    This site gives a good grounding for you:

    Implementing and Using Oracle`s Restore Point Functionality
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  3. #3
    Join Date
    Jun 2010
    Posts
    81

    Flashback database

    Hi,

    thanks for that link and your swift reply but I would have thought you would use something like
    'flashback database <timestamp>' to create a kind of restore point for the database.
    And then should you need to roll back the database you can flashback database to <timestamp>.

    Maybe I have mis read but nothing in that document does what I require.

    If you have the SQL syntax that would be much appreciated

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    This link explains flashback database clearly:

    Flashback Database: A Primer | Oracle FAQ

    However, I suggest that you read the Oracle documentation on Flashback so that you are aware of all the options available to you when using it.
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

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