dataguard oracle

=use_db_recovery_file_dest valid_for= (standby_logfiles,standby_role) DB_UNIQUE_NAME= Standby '; Log_archive_dest_state_3=enable 1.1.5Open the Logical Standby Database Because the logical standby does not conform to the primary database transaction, you must specify the RESETLOGS clause when you first open it sql> ALTER DATABASE OPEN resetlogs; Apply Redo Data sql> ALTER DATABASE START LOGICAL STANDBY APPLY IMMEDIATE;

Tags: dgmgrl snapshotEnvironment Overview: Good Dataguard, build reference: http://blog.51cto.com/snowhill/1923591Source: db_name:db RACPreparation: DB_NAME:SBDB1 stand-alone 1 Enable DGMGRLRelated parameters: Dg_broker_startDg_broker_config_file1 Configuration:alter system set dg_broker_start=true scope=both;At this point the database will increase the Dmon process [[emailprotected] ~]$ ps -ef|grep -i _dmon|grep -v grep

The summary in this document is very comprehensive, but I have made some corrections to some of the errors (such as fal_server and fal_client instructions) or some ambiguous descriptions. to differentiate the network connection string and SID, list the information of the master and slave databases first. Master database: Version: Oracle 10.2.0.1.0ORACLE_SID = WENDINGDb_name = WENDINGDb_unique_name/instance_name = WENDINGGlobal_name/service_names = WEN

recovery catalog allocated Channel:ora_disk_1 Channel ora_disk_1:sid=62 device Type=disk Channel ora_disk_1:restoring control file channel Ora_disk_1:restore complete, elapsed time:00:00:02 output file name=+vg1/db7881dg/controlfile/current.447.868357987 output file name=+vg1/db7881dg/controlfile/current.507.868357987 finished restore at 07-jan-15 after the database can recover the control file, check the V$database Controlfile_type, is already the type we need. sql> ALTER DATABASE moun

Tags: oracle dataguard Daily Maintenance Command Summary1. Stop standbySelect process, status from V$managed_standby;---check if the repository is being restored in the application logALTER DATABASE recover managed standby database cancel;Shutdown immediate; 2. Switch to read-only mode-----switch from shutdown mode to read-only mode-------Startup Nomount;ALTER DATABASE mount standby database;ALTER DATABASE

Using Perl to monitor Oracle Dataguard scripts#!/usr/bin/perlusestrict;usewarnings;usedbi;#loadthe DBImodulemy $ZabbixServer = "192.168.3.24";my $ZabbixPort = "10051";my $HOSTNAME = "Ora2";my $SenderCMD = "/usr/local/ Zabbix/bin/zabbix_sender ";my $Primtns =" Test_st ";my $Stantns =" test "; my$ key= "Oracled.DG.Status";my $KEYContent 1 = "OK";my $KEYContent 2 = "Failed";my $LogVal =3;my $user = "Zabbix";

parametersalter system set standby_file_management=auto;Start recoveralter database recover managed standby database disconnect;Check the application of logsSQL> select status,blocks,process,sequence# from v$managed_standby;STATUS BLOCKS PROCESS SEQUENCE#------------ ---------- --------- ----------CONNECTED 0 ARCH 0CONNECTED 0 ARCH 0CONNECTED 0 ARCH 0CONNECTED 0 ARCH 0IDLE

Tags: Oracle logic dataguard CREATE TABLEIMPORTANT: Alter DATABASE guard none;-----------------------------------------------------DBA User Build Table-----------------------------------------------------Sql> CREATE TABLE Liang.testa as select * from Tab;Table created.-----------------------------------------------------DBA User under-----------------------------------------------------Sql> Conn Liang/liang

Tags: Oracle 11g dataguard Primary and Standby switchover1. Check the primary and standby environmentDG1 node:sql> archive log list;Database Log Mode Archive modeAutomatic Archival EnabledArchive destination/u01/oradata/tong/archiveOldest online log sequence 59Next log sequence to archive 61Current log Sequence 61Sql>DG2 node:sql> archive log list;Database Log Mode Archive modeAutomatic Archival EnabledArch

Tags: Oracle 11g dataguard three modes as well as real-time queries (real-time query) feature settingsBefore we discussed the "Linux Oracle 11g dataguard Physical standby configuration process,"But in the actual process will encounter different problems, first we discuss the Oracle