Show TOC

Syntax documentation-f mfback

This BRSPACE function lets you manage the flashback database feature.

Function options:

  • -a|-action: specifies the type of manage action for flashback database.

    Input syntax: -a|-action fbon|fboff|rpcreate|rpdrop|fbshow|rpshow

    • fbon switches on flashback database

    • fboff switches on flashback database

    • rpcreate creates restore point

    • rpdrop drops restore point

    • fbshow shows flashback status

    • rpshow shows restore points

    Default: none, since you must always specify the action

  • -f|-force: forces database shutdown for fbon and creates a guaranteed restore point if flashback database is not on (only for Oracle 10g)

    Default: do not shut down if SAP user still connected

  • -g|-guarantee: specifies guaranteed restore point

    Default: normal restore point

  • -p|-point <name>|last: specifies restore point:

    • <name>: specifies restore point name

    • last: drops or shows last restore point

    Default: none

  • -r|-retention <minutes>: specifies flashback retention time

    0 means unlimited retention time

    Default: 1440