Description:-
In this is the article we are going to see Enabling Flashback Database In Oracle 19c RAC Database
Step:-1 Before Changing the archivelog mode and Flashback Database check the status.
SQL> select log_mode,flashback_on from gv$database;
LOG_MODE FLASHBACK_ON
———— ——————
NOARCHIVELOG NO
NOARCHIVELOG NO
Step:-2 Stop the rac database service.
[oracle@rac1 ~]$ srvctl stop database -d oradbwr
Step:-3 Start the rac database in mount state.
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is running on node rac1
Instance oradbwr2 is running on node rac2
Step:-4 Enable archive log mode and Flashback database
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 08:57:51 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
Note:- Before Enable flashback first we need to enable archivelog dest and archivelog mode
SQL> alter system set log_archive_dest_1=’LOCATION=+DATA/’ scope=both sid=’*’;
System altered.
SQL> alter database archivelog;
Database altered.
SQL> alter system set db_recovery_file_dest_size=5G scope=both sid=’*’;
System altered.
SQL> alter system set db_recovery_file_dest=’+DATA’ scope=both sid=’*’;
System altered.
SQL> alter database flashback on;
Database altered.
Step:-5 Stop the rac database service.
[oracle@rac1 ~]$ srvctl stop database -d oradbwr
Step:-6 Restart the rac database
[oracle@rac1 ~]$ srvctl status database -d oradbwr
Instance oradbwr1 is running on node rac1
Instance oradbwr2 is running on node rac2
Step:-7 Check Archivelog and flashback Status
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 09:10:23 2019
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production
Version 19.3.0.0.0
SQL> select log_mode,flashback_on from gv$database;
LOG_MODE FLASHBACK_ON
———— ——————
ARCHIVELOG YES
ARCHIVELOG YES
Connect with me:-
Telegram App:https://t.me/oracledbwr
LinkedIn:https://www.linkedin.com/in/hariprasathdba
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page : https://www.facebook.com/dbahariprasath/?
Twitter : https://twitter.com/oracledbwr