#oracledataguard

[prashantnet-blog]

Enroll for Data guard training and learn to use Data guard for protecting the Database from any disaster. NetTech India provides the best Oracle Data guard training in Mumbai.

[butteryimpossiblemiracle-blog]

ORA-38706: Cannot turn on FLASHBACK DATABASE logging. ORA-38709: Recovery Area is not enabled. (#OracleDataguard)

Issue:

When trying to turn on the flash back in Oracle database, it gives the below error,

SQL> alter database flashback on;

alter database flashback on

*ERROR at line 1:

ORA-38706: Cannot turn on FLASHBACK DATABASE logging.

ORA-38709: Recovery Area is not enabled

  Resolution:

Make sure to set the “db_recovery_file_dest_size” parameter is set in the database. Also, you could set…

[prashantnet-blog]

Data Guard is used as a backup of main database to avoid any data loss due to data corruptions. NetTech India offers the best Data Guard course In Mumbai.