-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