Shulou(Shulou.com)06/01 Report--

I. steps

1. Close Node two

two。 Configure related parameters

3. Close Node 1

4. Enable flashback

5. Open Node two

II. Operation process

[root@rac01] # su-oracleLast login: Thu Jan 4 10:33:31 CST 2018 on pts/2$ sqlplus / as sysdbaSQL*Plus: Release 12.1.0.2.0 Production on Fri Jan 5 18:52:55 2018Copyright (c) 1982, 2014, Oracle. All rights reserved.Connected to:Oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit ProductionWith the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP Advanced Analytics and Real Application Testing optionsSYS@orcl1 > SYS@orcl1 > show parameter recoveryNAME TYPE VALUE -db_recovery_file_dest stringdb_recovery_file_dest_size big integer 0recovery_parallelism integer 0SYS@orcl1 > show parameter flashbackNAME TYPE VALUE -- db_flashback_retention_target integer 1440SYS@orcl1 > alter system set db_recovery_file_dest_size=1g System altered.SYS@orcl1 > archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination + DATADGOldest online log sequence 121Next log sequence to archive 122Current log sequence 122SYS@orcl1 > alter system set db_recovery_file_dest='+datadg';System altered.SYS@orcl1 > alter system set db_flashback_retention_target=2880;System altered.SYS@orcl1 > shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SYS@orcl1 > startup mount ORACLE instance started.Total System Global Area 1241513984 bytesFixed Size 2923872 bytesVariable Size 620757664 bytesDatabase Buffers 603979776 bytesRedo Buffers 13852672 bytesDatabase mounted.SYS@orcl1 > alter database flashback on;Database altered.SYS@orcl1 > alter database open;Database altered.SYS@orcl1 > select flashback_on from v$database FLASHBACK_ON-YESSYS@orcl1 > show parameter recoveryNAME TYPE VALUE -db_recovery_file_dest string + datadgdb_recovery_file_dest_size big integer 1Grecovery_parallelism integer 0SYS@orcl1 > show parameter flashbackNAME TYPE VALUE -db_flashback_retention_target integer 2880SYS@orcl1 >

Summary:

Production environment ADG backup library flashback to solve logic errors. In the future, add a reserve database for disaster preparedness, one master and two backup, ha.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.