NW 7.3 Flashback Question

[Former Member]

Is flashback enable by default with the NW 7.3 installation on Oracle 11.2?

We are having problems managing disk space due to the flashback file creation and would like to disable it. I've looked for a SAP note that describes the way to disable flashback but did not find one.

Is there a prescribed method to be used to disable Oracle 11.2 Flashback? We want to make sure we don't cause any other problems for the database.

Thanks

[Former Member]

Many thanks to Michael and Diego for their replies.

After finding out that flashback is not installed we started going back through our installation screen shots and found that some installers had commented out the log_archive_dest setting in the init<SID>.ora file based upon a misunderstanding of a fix for another issue. With this commented out it it appears that oraflash becomes activated.

We are correcting our installation documents to avoid this error in the future. And will use the information provided by Diego to turn off FLASHBACK.

[Former Member]

Is flashback enable by default with the NW 7.3 installation on Oracle 11.2? 

No, flashback is disabled by default after installation. Did you use software downloaded directly from oracle? Or maybe you didn't install the software with the SAP delivered RUNINSTALLER?

Cheers Michael

[Former Member]

Hi John!!

Have you already checked [Note 966117 - Oracle Flashback Database technology|https://service.sap.com/sap/support/notes/966117] ??

Activate normal Flashback Logging

SQL> shutdown immediate

SQL> startup mount

SQL> ALTER DATABASE FLASHBACK ON;

SQL> ALTER DATABASE OPEN;

BRSPACE Action: brspace -fbon

Deactivate:

SQL> ALTER DATABASE FLASHBACK OFF;

BRSPACE Action: brspace -fboff

The following query determines whether Flashback Logging is active:

SQL> SELECT FLASHBACK_ON FROM V$DATABASE;

Cheers,

Diego.