Description:-
In this is the article we are going to see Disabling Flashback Database In Oracle 19c RAC Database
Step:-1 Before Changing the Flashback Database check the status.
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 09:12:22 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 flashback_on,instance_name from gv$database,gv$instance;
FLASHBACK_ON INSTANCE_NAME
—————— —————-
YES oradbwr1
YES oradbwr1
YES oradbwr2
YES oradbwr2
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 Disable Flashback rac database
Note: No Need to disable archivelog mode for disabling flashback
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 09:20:46 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> alter database flashback off;
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 Flashback Status.
[oracle@rac1 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 – Production on Thu Dec 26 09:26:47 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 flashback_on,instance_name from gv$database,gv$instance;
FLASHBACK_ON INSTANCE_NAME
—————— —————-
NO oradbwr1
NO oradbwr1
NO oradbwr2
NO oradbwr2
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