WEB开发网
开发学院数据库Oracle Oracle 10g使用RMAN创建physical standby(二) 阅读

Oracle 10g使用RMAN创建physical standby(二)

 2008-11-11 12:59:44 来源:WEB开发网   
核心提示: 7.使用rman备份主库 [oracle@s1 ~]$ rman target /Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 29 19:52:37 2008Copyright (c) 1982, 2005,Or

7.使用rman备份主库

  [oracle@s1 ~]$ rman target /
  Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 29 19:52:37 2008
  Copyright (c) 1982, 2005, Oracle. All rights reserved.
  connected to target database: ORCL (DBID=1171867028)
  RMAN> backup full format='/u02/db_%U'
database include current controlfile for standby;
  ...................

8.归档主库当前日志

SQL> alter system archive log current;

System altered.

9.启动备库到nomount

sqlplus "/ as sysdba"
Connected to an idle instance.
SQL> startup nomount
  Total System Global Area 285212672 bytes
Fixed Size 1218992 bytes
Variable Size 96470608 bytes
Database Buffers 184549376 bytes
Redo Buffers 2973696 bytes

10.利用rman恢复备库

[oracle@s1 ~]$ rman target /
  Recovery Manager: Release 10.2.0.1.0 - Production on Thu May 29 19:53:21 2008
  Copyright (c) 1982, 2005, Oracle. All rights reserved.
  connected to target database: ORCL (DBID=1171867028)
  RMAN> connect auxiliary sys/a@dbstandby
  connected to auxiliary database: ORCL (DBID=1171867028, not mount)
  RMAN> duplicate target database for standby nofilenamecheck;
  .............................

如果第8步没有归档当前日志,duplicate时可能出现错误:

Tags:Oracle 使用 RMAN

编辑录入:爽爽 [复制链接] [打 印]
赞助商链接