data guard oracle 11g step by step

Use JDBC to modify the Oracle sequence step in batches Scenario After the data migration is complete, you need to reset the sequence in the database ,. Method Three Common Methods Delete-recreate In this way, Simple Sequence reconstruction will affect the business logic processing and cannot adapt to the inconsistency of original sequence Parameter rules. However

The data guard provides the following three kinds of protection modes: 1 Maximum protection mode (Maximum Protection) "Maximum protection" here means that the maximum protection data is not lost, that is, at least one standby and primary maintain real-time synchronization, but this is costly, because as long as a transaction is committed, not only to write to t

Oracle Data Guard (iv) Failover 1. check for missing logs in the Standby database. Run the following command to check for missing logs: SQL> select thread #, log_sequence #, high_sequence # from v $ archive_gap; copy the missing log file from the primary database to the log directory specified by the standby database, and run the following command to register it

　　To delete an archive file of the master database in the Maximum Availability and Maximum Performance modes of Oracle Data Guard, the archive file must be deleted after the backup database is applied. 　　For Maximum Protection mode, logs in this mode are written to the master database and the slave database at the same time. Therefore, in this mode, there is no l

/* Step 2: create a temporary tablespace */Create temporary tablespace user_tempTempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf'Size 50 mAutoextend onNext 50 m maxsize 20480 mExtent management local; /* Step 2: create a data table space */Create tablespace user_dataLoggingDatafile 'd: \

/* Step 2: create a temporary tablespace */Create temporary tablespace user_tempTempfile 'd: \ oracle \ oradata \ Oracle9i \ user_temp.dbf'Size 50 mAutoextend onNext 50 m maxsize 20480 mExtent management local; /* Step 2: create a data table space */Create tablespace user_dataLoggingDatafile 'd: \

Data Guard offers two main services:1 Redo Transport service: The Primay end of the redo log transmission to one or more standby destinations.2 Redo Application Service: The redo log which is transmitted from the Primay end is applied to the standby end.This article first discusses the redo transport services. 1, the use of ARCN transmission redo logby default, the redo log is transferred using ARCN, but o

Step 1: Create a tablespace and assign permissions to users in the oracle database Log on to the oracle database as an administrator 1. Create a temporary tablespace Select name from v $ tempfile; find the temporary tablespace of the current database, mainly using the storage path in it; Obtain a record/opt/oracle/ora

To test the creation of a data guard environment on the same server. The main library is in a normal state and there are available backups, and the force logging and associated initialization parameters for the main library are set below: sql> ALTER DATABASE force logging; Database altered. To modify the initialization parameters of the main library: Sql> alter system set Log_archive_config = ' dg_conf

permissions that are directly assigned to a user or role): Select*fromdba_sys_privs;select*fromuser_sys_ Privs;6, view roles (view only roles owned by logged-in users) Select*fromrole_sys_privs;7, view user object permissions:select* Fromdba_tab_privs;select*fromall_tab_privs;select*fromuser_tab_privs ; 8. View all roles: select*fromdba_roles;9, view roles owned by user or role:select*fromdba_role_privs; SELECTNBSP;*NBSP;FROMNBSP;USER_ROLE_PRIVS;10, see which users have SYSDBA or Sysoper system

the public network. 5. In some systems, such as Solaris), you need to specify the default gateway for the VIP. 6. Make sure that the partition information is visible on all nodes when partitioning a hard disk. 7. You must specify the correct permissions and owner for the OCR and vote devices. 8. Specify the host name for public IP, private IP, and VIP. The host name cannot contain uppercase letters and underscores (_), but can contain minus signs -) 9. If the configuration fails, delete al

/* 1th step: Create temporary table space/*Create temporary tablespace user_tempTempfile ' D:\oracle\oradata\Oracle9i\user_temp.dbf 'Size 50mAutoextend onNext 50m maxsize 20480mExtent management Local; /* 2nd step: Create a datasheet space/*Create Tablespace User_dataLoggingDataFile ' D:\oracle\oradata\Oracle9i\user_d

Oracle View trace file step 1. Get current trace file generation path sql> select Tracefile from v$process where addr in (select Paddr from V$se Ssion where SID in (select SID from V$mystat)); Tracefile www.2cto.com ----------------------------------------------------------------------- --------------------------------------------------------f:\oracle\administr

Step tutorial on installing Oracle 12c Release Database in win10, win1012c Install Oracle 12c Release Database in win10 In general, download and decompress the package and go to the official website. Double-click to start installation. Click OK to skip Select the first database to create a database. Select Desktop Create a n

editing$ vim protocols Normal mode input /icmp find string ICMP Normal mode Enter to n find the next ICMP Normal mode input ？tcp up lookup string TCP Normal mode input N to find the last occurrence of TCP 3. Advanced Search Enter \* a word in normal mode to find where the cursor is located Normal mode input \# Ibid, but \* forward (up) to find, #则是向后 (bottom) find Normal mode g\* \* , but partially matches the word Normal mode g\# \# , but partiall

Test conditions:Suppose a company is headquartered in Beijing, Xinjiang has its subordinate branch. In this test, the computer in Xinjiang for the local computer, that is, the IP address is: 192.168.1.100Beijing's headquarters has a centralized database whose SID is SIDBJ, username: userbj, Password: bj123, the IP address of Beijing is: 192.168.1.101.In the local (Xinjiang) branch also has a database, its SID is Sidxj, User: USERXJ, Password: xj123, Xinjiang's IP address is: 192.168.1.100.The

Author Lighthouse Big DataThis document is transferred from the public Lighthouse Big Data (Dtbigdata), reprinted to be authorized If you are interested in a variety of scientific topics in data classes, you are in the right place. This article will introduce you to 42 steps to become a good data scientist. Deep mastery of

After a few hours, finally the process steps based on the sequence of steps to get it done.Specific as follows:1. Get a type of process step data from a database ...But this data has the possibility of a dead loop, because the time to add is not very good judgment, but it is certainly impossible to make the next step f

messages for the database's system.Parameter name Background_dump_dest.Y User trace file pathUser_demp_destFile name The background process trace file path is initialized to Background_dump_dest.File name System global Zone, is a memory area shared by all user processes, that is, the data resources in the SGA can be used by multiple users, the SGA mainly includes high-speed data flooding, shared pools, VC

(1) Turn off Oracle services and background processes echo $ORACLE _home | grep ORA as SYSDBA Select from V$instance; Ps–ef |grep Ora_Ps–ef |grep Ora_ can see the background process is goneLsnrctl Status View Listener state(2) Stop Oracle's Listener(3) Delete subdirectories and files under the $oracle_home directory cd $ORACLE _home pwd