Oracle DataGuard建库
此处安装的是oracle10.2.0.1,安装过程我们基本上已经熟练了解,在此不细说。记住只安装数据库软件哦(这样可以简化后面的升级过
DataGuard原理在此不说了,这里只是说下我做的这个项目流程
一.在physical 主机创建数据库
操作系统:RedHat5.4
本项目安装一台primary,一台standby,所以要准备两台机器,命名为DG1、DG2
1、安装数据库软件
此处安装的是Oracle10.2.0.1,安装过程我们基本上已经熟练了解,,在此不细说。记住只安装数据库软件哦(这样可以简化后面的升级过程)
2、如果直接用10.2.0.1做dataguard,可能会出现一些bug,为了避免这些bug,我们要将数据库软件升级到10.2.0.5
3、建库:在DG1上用DBCA建库,DG2上面暂不建库
4、primary端设置
4.1、主库设置为force logging模式
1. SQL > alter database force logging;
2. create a Password file
[oracle@localhost dbs]$ orapwd file=/u01/app/oracle/product/10.2.0/db_1/dbs/orapworcl password=oracle
4.2、主库设置为归档模式
SQL > shutdown immediate;
SQL > startup mount;
SQL > alter database archivelog;
SQL > archive log list;
4.3、添加redo log file
1)添加新的standby redolog组,并为该组指定成员。
SQL > alter database add standby logfile group 4 (‘/u01/app/oracle/oradata/oradg/redo04.log’)size 50M;
SQL > alter database add standby logfile group 5 (‘/u01/app/oracle/oradata/oradg/redo05.log’) size 50M;
SQL > alter database add standby logfile group 6 (‘/u01/app/oracle/oradata/oradg/redo06.log’) size 50M;
SQL > alter database add standby logfile group 7 (‘/u01/app/oracle/oradata/oradg/redo07.log’) size 50M;
2)确定standby redo log file groups已经创建:
SQL> SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG;
4.4 、初始化参数
DB_NAME=testdb
DB_UNIQUE_NAME=testdb
LOG_ARCHIVE_CONFIG='DG_CONFIG=(testdb,testdbst)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/u01/oradata/arch/testdb
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=testdb’
LOG_ARCHIVE_DEST_2=
'SERVICE=boston LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=testdbst’
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=testdbst
FAL_CLIENT=testdb
STANDBY_FILE_MANAGEMENT=AUTO

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics

The data folder contains system and program data, such as software settings and installation packages. Each folder in the Data folder represents a different type of data storage folder, regardless of whether the Data file refers to the file name Data or the extension. Named data, they are all data files customized by the system or program. Data is a backup file for data storage. Generally, it can be opened with meidaplayer, notepad or word.

The solution to the garbled mysql load data: 1. Find the SQL statement with garbled characters; 2. Modify the statement to "LOAD DATA LOCAL INFILE "employee.txt" INTO TABLE EMPLOYEE character set utf8;".

The differences are: 1. xdata usually refers to independent variables, while data refers to the entire data set; 2. xdata is mainly used to establish data analysis models, while data is used for data analysis and statistics; 3. xdata is usually used for regression Analysis, variance analysis, predictive modeling, data can be analyzed using various statistical methods; 4. xdata usually requires data preprocessing, and data can contain complete original data.

Everyone and their aunt seem to be hopping aboard the AI train in search of inflated profit margins and marketing hype — just look at AMD's recent Ryzen rebrand as a prime example of this AI hype. A recent study conducted by RAND has found that this

A core business database, the version is MySQL8.34 Community Server Edition. Since its launch, the error log of this database server has increased very rapidly (as shown in the figure below), and can increase to more than 10 G in capacity every 24 hours. Because there was a fault alarm and normal access to the business had not been affected, the relevant personnel were not allowed to restart the MySQL service. In view of this situation, I had to set up an automatic scheduled task to clean these logs at a fixed time every night. For specific operations, execute "crontab -e" on the system command line and add the following text line: 0001***echo>/data/mysql8/data/mysql_db/mysql.log Save and exit edit mode

No, data in the vue component must be a function. Components in Vue are used for reuse. In order to prevent data reuse, they are defined as functions. The data data in the vue component should be isolated from each other and not affect each other. Every time the component is reused, the data data should be copied once. Later, when the data data in the component is changed in a reused place, other data will be copied. If the data data of reused local components is not affected, you need to return an object as the status of the component through the data function.

Shortly after the launch of the Humane Ai Pin, scathing reviews revealed that the AI gadget was anything but ready for the market, as most of the originally advertised features either didn't work properly or were simply missing, the battery life was

A concerning vulnerability has been revealed in modern computer systems, as per a new study. Federico Larroca at the University of the Republic in Montevideo, Uruguay, and his colleagues have developed an AI model that can reconstruct digital signals
