Oracle 11.2.0.1.0 create physical standby on Windows XP using RMAN

0. Summary

Oracle version: 32-bit Oracle Database 11.2.0.1.0

OS Version: 32-bit WinXP SP3

Primary database SID: primary

Slave database SID: standby

Advantage: Using RMAN to create a mongouard does not require the master database to go down, which is relatively simple to implement.

1. DBCA creates a master database with SID primary

2. Enable the archive mode of the master database

C: \> set oracle_sid = primary

C: \> sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Sunday June 17 15:09:39 2012

Copyright (c) 1982,201 0, Oracle. All rights reserved.


Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select log_mode from v $ database;

LOG_MODE
------------------------
NOARCHIVELOG

SQL> shutdown immediate;
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 313860096 bytes
Fixed Size 1374304 bytes
Variable Size 138413984 bytes
Database Buffers 167772160 bytes
Redo Buffers 6299648 bytes
The database has been loaded.
SQL> alter database archivelog;

The database has been changed.

SQL> select log_mode from v $ database;

LOG_MODE
------------------------
ARCHIVELOG

SQL> alter database open;

The database has been changed.

SQL>


3. Enable forced Logging

SQL> ALTER DATABASE FORCE LOGGING;

The database has been changed.

SQL>

1 2 3 4 5 6 Next Page