Oracle 10 Gb physical volume uard Creation

Hello everyone!

Today, I sorted out the steps for creating a physical volume uard for Oracle10g according to the official documents:

1.1 enable force logging Mode

Use the following statement to enable the force logging mode for the master database after the database is created successfully.

SQL> ALTER DATABASE FORCE LOGGING;

This statement takes a long time to complete, because it needs to wait for the direct path write I/O for the unrecorded logs to complete.

1.2 create a password file

If there is no password file, create it. Each database must use the same password file in the replicuard architecture, and the password of the SYS user must be the same to ensure that redo data is transmitted successfully in each system.

1.3 configure backup redo log

Backup redo logs are required for both the maximum protection mode and the maximum available mode, and lgwr async transmission mode is recommended for all databases. Restore uard from archiving and redo logs is better than recovering from backup redo logs and redoing application data.

When creating a backup database, you should plan the backup redo log and create the redo log group and log members. To improve availability, refer to the reuse method of online redo logs to reuse backup redo logs.

Perform the following steps to configure the backup redo log.

The first step is to ensure that the log files of the master and slave databases are of the same size.

Step 2 determine the appropriate number of redo log groups

Step 3: verify the relevant database parameters and settings

Step 4 Create a standby redo log Group

Step 5 verify that the standby redo log group is successfully created

1.4 set master database initialization parameters

1.5 enable archive Mode

2. Instructions for creating a physical standby Database

2.1 create a backup copy of the data file in the master database

2.2 create a slave Database Control File

2.3 prepare the backup database initialization parameters

2.4 copy files from the master database to the slave Database

2.5 set the environment required by the standby Database

Step 1 create a Windows-based service

Step 2 create a password file

Step 3 configure master and slave database listening

Step 4 create a network service name

Step 5: Create the backup database service parameter file

2.6 start the physical standby Database

Step 1 start the physical standby Database

Step 2 start redo Application

Step 3: test whether the archive is uploaded to the slave Database

2.7 verify that the physical standby database is running properly

Step 1 confirm existing archived redo logs

Step 2 force switch the current online redo log

Step 3 verify that new redo data is archived on the slave Database

Step 4 verify that the newly archived log has been applied

3. Steps after creation

1 2 3 Next Page