ITPub博客

利用rman在同一台机器上主库online搭建standby

原创 Linux操作系统 作者:paulyibinyi 时间:2007-12-19 15:33:26 0 删除 编辑

1.用oradmin新建一个实例名test
C:\Documents and Settings\Paul Yi>oradim -new -sid test

2.准备参数文件 d:\inittest.ora文件
*.background_dump_dest='D:\oracle\admin\test\bdump'
*.compatible='9.2.0.0.0'
*.control_files='D:\oracle\oradata\test\control01.ctl','D:\oracle\oradata\test\control02.ctl','D:\oracle\oradata\test\control03.ctl'
*.core_dump_dest='D:\oracle\admin\test\cdump'
*.db_name='paul'
*.lock_name_space='test'
*.db_file_name_convert='d:\oracle\oradata\paul','d:\oracle\oradata\test'
*.log_file_name_convert='d:\oracle\oradata\paul','d:\oracle\oradata\test'
*.fal_server=paul
*.fal_client=test
*.standby_archive_dest='location=e:\archtest'
*.standby_file_management=auto
*.log_archive_format='%t_%s.dbf'
*.log_archive_start=TRUE
*.user_dump_dest='D:\oracle\admin\test\udump'

3.生成密码文件
C:\Documents and Settings\Paul Yi>orapwd file=d:\oracle\ora92\database\pwdtest.o
ra password=abcdefg entries=10

4.配置listener.ora和tnsnames.ora文件
.配置网络

配置主备库的listener.ora,tnsnames.ora。修改完lisner.ora后注意重启监听。

Listener.ora

LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.163)(PORT = 1521))
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = d:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = paul)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = paul)
)
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = d:\oracle\ora92)
(SID_NAME = test)
)
)

tnsnames.ora

paul =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.163)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = paul)
)
)


test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.163)(PORT = 1521))
)
(CONNECT_DATA =
(SID = test)
)
)

7.使用rman备份主库


C:\Documents and Settings\Paul Yi>rman target /

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PAUL (DBID=1605165889)

RMAN> backup full database;

Starting backup at 19-DEC-07
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=13 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=D:\ORACLE\ORADATA\PAUL\SYSTEM01.DBF
input datafile fno=00002 name=D:\ORACLE\ORADATA\PAUL\UNDOTBS01.DBF
input datafile fno=00003 name=D:\ORACLE\ORADATA\PAUL\INDX01.DBF
input datafile fno=00005 name=D:\ORACLE\ORADATA\PAUL\USERS01.DBF
input datafile fno=00004 name=D:\ORACLE\ORADATA\PAUL\TOOLS01.DBF
input datafile fno=00006 name=D:\TEST01_P.DBF
input datafile fno=00007 name=D:\TEST02_P.DBF
input datafile fno=00008 name=D:\TEST03_P.ORA
channel ORA_DISK_1: starting piece 1 at 19-DEC-07
channel ORA_DISK_1: finished piece 1 at 19-DEC-07
piece handle=D:\BACKUP\1SJ40FFL_1_1 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
Finished backup at 19-DEC-07

Starting Control File and SPFILE Autobackup at 19-DEC-07
piece handle=D:\BACKUP\C-1605165889-20071219-03 comment=NONE
Finished Control File and SPFILE Autobackup at 19-DEC-07

8.生成备库控制文件
SQL> alter database create standby controlfile as 'd:\control01.ctl' reuse;

Database altered.

复制两份,放到 d:\oracle\oradata\test\下面,并改名为control02.ctl,control03.ctl


9.启动备库到nomount状态
C:\Documents and Settings\Paul Yi>sqlplus /nolog

SQL*Plus: Release 9.2.0.4.0 - Production on Wed Dec 19 14:25:05 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> conn /@test as sysdba
Connected to an idle instance.
SQL> startup nomount pfile='d:\inittest.ora';
ORACLE instance started.

Total System Global Area  101785252 bytes
Fixed Size                   454308 bytes
Variable Size              75497472 bytes
Database Buffers           25165824 bytes
Redo Buffers                 667648 bytes
启动到备库
SQL> alter database mount standby database;

Database altered.

11.利用rman恢复出备库
C:\Documents and Settings\Paul Yi>rman target /@test

Recovery Manager: Release 9.2.0.4.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: PAUL (DBID=1605165889)

RMAN> restore database;

Starting restore at 19-DEC-07

using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
skipping datafile 1; already restored to file D:\ORACLE\ORADATA\TEST\SYSTEM01.DB
F
skipping datafile 2; already restored to file D:\ORACLE\ORADATA\TEST\UNDOTBS01.D
BF
skipping datafile 3; already restored to file D:\ORACLE\ORADATA\TEST\INDX01.DBF
skipping datafile 4; already restored to file D:\ORACLE\ORADATA\TEST\TOOLS01.DBF

skipping datafile 5; already restored to file D:\ORACLE\ORADATA\TEST\USERS01.DBF

skipping datafile 8; already restored to file D:\TEST03_P.ORA
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00006 to D:\TEST01_P.DBF
restoring datafile 00007 to D:\TEST02_P.DBF
channel ORA_DISK_1: restored backup piece 1
piece handle=D:\BACKUP\1SJ40FFL_1_1 tag=TAG20071219T141933 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 19-DEC-07

13.将备库置于自动恢复状态
SQL> conn /@test as sysdba
Connected.

SQL> alter database recover managed standby database disconnect from session;

Database altered.
SQL> select process,status from v$managed_standby;

PROCESS STATUS
------- ------------
ARCH CONNECTED
ARCH CONNECTED
MRP0 WAIT_FOR_LOG
RFS RECEIVING

 完成

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/7199859/viewspace-883/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
oracle 10g ocm oracle 10g/11g/12c ocp aix 6.1 administrator,ogg expert,ITSS 技术交流群 201703254 微信公众号 paulyibin 探讨技术,开心工作 电话 13719354869 ,深入研究数据库和开始研究big data

注册时间:2007-12-11

  • 博文量
    905
  • 访问量
    6484734