Home PC Games Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Snapshot DataGuard     - Hibernate Search 5.5 in the search results sorted (Linux)

- SSH configuration under Linux (Linux)

- CentOS system Amoeba + MySQL Master-slave configuration (Database)

- SteamOS installation under Ubuntu 14.04 (Linux)

- ThinkPad X201i installation notes Debian 7.5 (Linux)

- Sysdig: system troubleshooting tool (Linux)

- Android components save state series - Activity (Programming)

- Implement firewall function on a closed Linux machine (Linux)

- Linux remote wake the computer original code [C] (Linux)

- Linux Log File Browser --logrotate (Linux)

- Linux account management add relevant directives (Linux)

- Git version rollback (Linux)

- Tune in high resolution to 1280x800 in Fedora 14 (Linux)

- MySQL to recover the data through binlog (Database)

- Ceph Source Analysis: Network Module (Server)

- Linux System Getting Started Tutorial: How to change the default Java version in Linux (Linux)

- MySQL binlog group to submit XA (two-phase commit) (Database)

- Linux, Chrome browser font settings beautification (Linux)

- Linux command line to put on your coat GUI (Linux)

- Explore Android SQLite3 multithreading (Programming)

 
         
  Snapshot DataGuard
     
  Add Date : 2018-11-21      
         
         
         
  DataGuard is a snapshot function 11R2 can be used after a temporary return to the main test pattern from the test bad environment for LGWR ASYNC maximum performance mode.

First, set the snapshot standby

Close the log application process MRP
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
Close the standby database, start to MOUNT stage
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
Setting the quick reply area, but note that this does not require FLASHBACK DATABASE support, but in fact it should still FLASHBACK DATABASE
(Ensure that a fast recovery area has been configured. It is not necessary for
flashback database to be enabled.)

SQL> alter system set db_recovery_file_dest_size = 30g;

System altered.

SQL> alter system set db_recovery_file_dest = '/ home / oradba / flash_area';

System altered.
If you do not set will complain
ERROR at line 1:
ORA-38784: Can not create restore point 'SNAPSHOT_STANDBY_REQUIRED_04 / 24/2015
10:30:47 '.
ORA-38786: Recovery area is not enabled.

Perform the conversion
ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

Conversion operations may be slower, Oracle might create a log file to the standby database and if not, it is time-consuming

SQL> ALTER DATABASE CONVERT TO SNAPSHOT STANDBY;

Database altered.

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination / oradba / archive
Oldest online log sequence 1
Next log sequence to archive 1
Current log sequence 1

Upon completion of a completely new database

List of Database Incarnations
DB Key Inc Key DB Name DB ID STATUS Reset SCN Reset Time
------- ------- -------- ---------------- --- --------- ------------
1 1 TEST 2151380215 PARENT 1 17-SEP-11
2 2 TEST 2151380215 PARENT 995548 18-JUL-14
3 3 TEST 2151380215 PARENT 142690086 10-NOV-14
4 4 TEST 2151380215 CURRENT 168265840 24-APR-15

The final step is to open the database can be used
SQL> alter database open;

Database altered.

SQL> select DATABASE_ROLE from v $ database;

DATABASE_ROLE
----------------
SNAPSHOT STANDBY

note:
1, snapshot standby produce its own log file, but ALTER SYSTEM SWITCH LOGFILE not immediately archive will wait 5 minutes archive a log
2, snapshot standby does receive logs from the main library, while STANDBY LOGFILE will accept logs from the main library

SNAPSHOT STANDBY STANDBY archive log archiving and speed from the log archiving a run of 5 minutes, which means that if the test can cause a huge amount of log group you are finished, causing HANG,
But STANDBY LOG will accept, if not assigned to an archive in FLASH BACK AREA.
From the log view:
Fri Apr 24 11:05:43 2015
Archived Log entry 9 added for thread 1 sequence 807 ID 0x80d48cbc dest 1:
Fri Apr 24 11:07:36 2015
Thread 1 advanced to log sequence 4 (LGWR switch)
  Current log # 8 seq # 4 mem # 0: / oradba / data / test / redo04
Thread 1 advanced to log sequence 5 (LGWR switch)
  Current log # 9 seq # 5 mem # 0: / oradba / data / test / redo05
Thread 1 advanced to log sequence 6 (LGWR switch)
  Current log # 10 seq # 6 mem # 0: / oradba / data / test / redo06
Thread 1 advanced to log sequence 7 (LGWR switch)
  Current log # 11 seq # 7 mem # 0: / oradba / data / test / redo07
Thread 1 advanced to log sequence 8 (LGWR switch)
  Current log # 12 seq # 8 mem # 0: / oradba / data / test / redo08
Thread 1 advanced to log sequence 9 (LGWR switch)
  Current log # 13 seq # 9 mem # 0: / oradba / data / test / redo09
Thread 1 advanced to log sequence 10 (LGWR switch)
  Current log # 14 seq # 10 mem # 0: / oradba / data / test / redo10
Thread 1 advanced to log sequence 11 (LGWR switch)
  Current log # 15 seq # 11 mem # 0: / oradba / data / test / redo11
Thread 1 advanced to log sequence 12 (LGWR switch)
  Current log # 1 seq # 12 mem # 0: /oradba/data/test/redo01.log
Thread 1 advanced to log sequence 13 (LGWR switch)
  Current log # 2 seq # 13 mem # 0: /oradba/data/test/redo02.log
Fri Apr 24 11:07:46 2015
Thread 1 can not allocate new log, sequence 14
Checkpoint not complete
  Current log # 2 seq # 13 mem # 0: /oradba/data/test/redo02.log
ORACLE Instance test - Can not allocate log, archival required
Thread 1 can not allocate new log, sequence 14
All online logs needed archiving
  Current log # 2 seq # 13 mem # 0: /oradba/data/test/redo02.log
Fri Apr 24 11:10:44 2015
Archived Log entry 10 added for thread 1 sequence 3 ID 0x81b3f444 dest 1:
Fri Apr 24 11:10:44 2015
Thread 1 advanced to log sequence 14 (LGWR switch)
  Current log # 3 seq # 14 mem # 0: /oradba/data/test/redo03.log
Fri Apr 24 11:15:44 2015
Archived Log entry 11 added for thread 1 sequence 4 ID 0x81b3f444 dest 1:
  
Note here 11:05:43 2015 conducted an archive, and then I switched a large number of observed ALTER SYSTEM switchlog HANG live,
Log observed:
Checkpoint not complete
  Current log # 2 seq # 13 mem # 0: /oradba/data/test/redo02.log
ORACLE Instance test - Can not allocate log, archival required
And wait until Fri Apr 24 11:10:44 2015 log archiving
Archived Log entry 10 added for thread 1 sequence 3 ID 0x81b3f444 dest 1
And Fri Apr 24 11:15:44 2015 there was a log archiving
Archived Log entry 11 added for thread 1 sequence 4 ID 0x81b3f444 dest 1:

For RFS process is not enough even STANDBY LOG will be accepted in the FLASHBACK AREA
It is possible to prove the following:
SQL> select COMPLETION_TIME, SEQUENCE #, NAME FROM v $ archived_log;

COMPLETION_TIME SEQUENCE # NAME
------------------- ---------- --------------------- ------------------------------------------------
2015-04-23 17:58:08 802 /oradba/archive/1_802_863273736.dbf
2015-04-23 18:06:16 803 /oradba/archive/1_803_863273736.dbf
2015-04-24 09:57:08 804 /oradba/archive/1_804_863273736.dbf
2015-04-24 10:31:07 805 /oradba/archive/1_805_863273736.dbf
2015-04-24 10:40:40 806 /oradba/archive/1_806_863273736.dbf
2015-04-24 10:55:42 1 /oradba/archive/1_1_877862036.dbf
2015-04-24 10:59:41 811 / home / oradba / flash_area / TESTDG1 / archivelog / 2015_04_24 / o1_mf_1_811_bmm
2015-04-24 11:00:42 2 /oradba/archive/1_2_877862036.dbf
2015-04-24 11:05:43 807 /oradba/archive/1_807_863273736.dbf
2015-04-24 11:10:44 3 /oradba/archive/1_3_877862036.dbf
2015-04-24 11:15:44 4 /oradba/archive/1_4_877862036.dbf
o1_mf_1_811_bmm is to accept over LOGFILE.
Anyway snapshot standby produce its own log file and snapshot standby does receive logs from the primary database is established

Second, return to standby mode

1, shutdown immediate;
2, startup mount;
3, ALTER DATABASE CONVERT TO PHYSICAL STANDBY;
4, shutdown immediate;
5, startup
6, ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
     
         
         
         
  More:      
 
- Linux Kernel 4.2 Installation Instructions (Linux)
- Do not enter password login ssh (Server)
- Configuring Android NDK development environment for Mac OS X (Linux)
- To install file manager Nautilus 3.12.2 under ubuntu (Linux)
- Ubuntu 14.04 set auto sleep time (Linux)
- Java application server WildFly (Server)
- Oracle Bug caused by the collection of AWR Snapshot fault (Database)
- Difference LVS three scheduling modes (Server)
- Git uses a standard process (Linux)
- Syncthing: Private Security Synchronization tool to synchronize files between computers / folder (Linux)
- JDK installation under CentOS (Linux)
- Installation and use of Linux Sniffer tool Tcpdump (Linux)
- Windows 7 hard disk to install Ubuntu 15.04 (Linux)
- Nginx + Tomcat static and dynamic load balancing and separation configuration essentials under Linux (Server)
- Analysis examples: Intrusion Response Linux platform Case (Linux)
- Install NetBeans IDE 8.0 on Ubuntu, Linux Mint, Elementary OS, and Debian (Linux)
- MongoDB Learning the notes (Database)
- HTTPS and SSH and use the difference between the way: Git User's Manual (Linux)
- PHP security Programming Advice (Programming)
- Performance issues under CentOS 6.5 VLAN devices (Linux)
     
           
     
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.