在单机上创建物理的Oracle9i standby数据库

核心提示： 然后关闭数据库实例SQL>SHUTDOWN备份数据库SQL>STARTUP MOUNTSQL>ALTER DATABASE ARCHIVELOG;SQL>ALTER DATABASE OPEN;SQL>SHUTDOWN IMMEDIATE备份1. Primar

然后关闭数据库实例

SQL>SHUTDOWN

备份数据库

SQL>STARTUP MOUNT

SQL>ALTER DATABASE ARCHIVELOG;

SQL>ALTER DATABASE OPEN;

SQL>SHUTDOWN IMMEDIATE

备份

1. Primary Database 需要做的准备工作：

1.1 激活 Forced Logging

SQL> ALTER DATABASE FORCE LOGGING;

1.2 设置本地归档目标

SQL> ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=D:\oracle\oradata\DEMO\Archive' SCOPE=BOTH;

此操作直接生效

2.创建物理的Standby数据库

2.1 标记出Primary数据库的数据文件

SQL> select name from v$datafile;

NAME

-----------------------------------------------------

D:\ORACLE\ORADATA\DEMO\SYSTEM01.DBF

D:\ORACLE\ORADATA\DEMO\UNDOTBS01.DBF

D:\ORACLE\ORADATA\DEMO\CWMLITE01.DBF

D:\ORACLE\ORADATA\DEMO\DRSYS01.DBF

D:\ORACLE\ORADATA\DEMO\EXAMPLE01.DBF

D:\ORACLE\ORADATA\DEMO\INDX01.DBF

D:\ORACLE\ORADATA\DEMO\ODM01.DBF

D:\ORACLE\ORADATA\DEMO\TOOLS01.DBF

D:\ORACLE\ORADATA\DEMO\USERS01.DBF

D:\ORACLE\ORADATA\DEMO\XDB01.DBF

D:\ORACLE\ORADATA\DEMO\OEM_REPOSITORY.DBF

11 rows selected.

SQL>

2.2 关闭Instance 拷贝数据文件到既定目的地

SQL> SHUTDOWN IMMEDIATE;

2.3 为Standby 数据库创建控制文件

SQL> ALTER DATABASE CREATE STANDBY CONTROLFILE

AS 'C:\DataGuard\Pstandby\DEMO\DEMOSTANDBY.CTL';