Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Snapshot DataGuard     - How to configure Ceph stored on CentOS 7.0 (Server)

- How to install Virtualbox 4.3.20 in Ubuntu 14.04 (Linux)

- Ubuntu update bug fixes Daquan (Linux)

- Ten minutes to find out the character set and character encoding (Linux)

- Linux and SELinux Exploration Program Manager (Linux)

- The mv command to move the directory two cases under Linux (Linux)

- Forgot Linux root password (Linux)

- Docker container plaintext password problem-solving way (Server)

- Node.js Getting the basics: Helloworld! (Linux)

- Linux-- sub-volume compression and decompression (Linux)

- MySQL Tutorial: Some optimized for I / O memory areas (Database)

- Use exp exported EXP-00091 error (Database)

- About MongoDB query method according to fuzzy field (Database)

- Php and MySQL command add to the environment variable method in Linux system (Linux)

- An example of troubleshooting of embedded Linux OpenWRT (Linux)

- C language keywords Comments (Programming)

- JavaScript property of checkbox.disabled (Programming)

- CentOS 6 compiling httpd-2.4.10 (Server)

- Grep how to find files based on file contents in UNIX (Linux)

- Apache Mina framework Practice (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:      
 
- Analysis of Java in the deep copy and shallow copy (Programming)
- Java Concurrency: synchronized (Programming)
- How to set up FTP server on Linux (Server)
- APR for Tomcat installation under Linux (Server)
- Elasticsearch Kibana installation notes (Linux)
- using Docker Kitematic on windows (Linux)
- RedHat Linux 7 build yum source server (Server)
- Prevent security threats caused Rootkit (Linux)
- Ubuntu Tutorial - Manually install Oracle Java JDK 8 (Linux)
- Postgres-X2 deployment steps (Database)
- Linux command to view the system status (Linux)
- Linux regex sed detailing (Linux)
- CentOS Linux firewall configuration and Close (Linux)
- mysqldump implement database logical backup (Database)
- How to modify the Emacs Major Mode Shortcuts (Linux)
- Linux Security trust with users (Linux)
- How to modify the Linux NIC eth1 to eth0 (Linux)
- OpenResty load balancing MySQL (Database)
- Role Object of registerNatives () method (Programming)
- Those functions under Linux you do not know the df command (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.