GoldenGate 学习系列6–抽取Physical Standby

本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger 的Oracle技术博客 本文链接地址: GoldenGate 学习系列6–抽取Physical Standby 之前从未测试过ogg抽取Physical standby或ADG的情况，今天测试了一下，由于最近一个项目是9208的升级

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客

本文链接地址: GoldenGate 学习系列6–抽取Physical Standby

之前从未测试过ogg抽取Physical standby或ADG的情况，今天测试了一下，由于最近一个项目是9208的升级，需要利用OGG。因此下午利用一个vm搭建了DG顺便测试了OGG，如下是简单的步骤，供参考！

1. 主库

[ora9@killdb killdb]$ sqlplus "/as sysdba"SQL*Plus: Release 9.2.0.8.0 - Production on Mon Dec 8 22:44:32 2014<div>本文来源gaodai.ma#com搞#代!码网_</div>Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.Connected to an idle instance.SQL> startup mountORACLE instance started.Total System Global Area  252776884 bytesFixed Size                   450996 bytesVariable Size             201326592 bytesDatabase Buffers           50331648 bytesRedo Buffers                 667648 bytesDatabase mounted.SQL> alter database archivelog;Database altered.SQL> alter database force logging;Database altered.

SQL> alter database add supplemental log data;Database altered.SQL> alter system set log_archive_dest_1='location=/home/ora9/arch_p';System altered.SQL> alter database open;Database altered.SQL> alter system set log_archive_start=true scope=spfile;System altered.SQL> alter system set log_archive_dest_2='SERVICE=std9 MANDATORY REOPEN=60';System altered.SQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area  252776884 bytesFixed Size                   450996 bytesVariable Size             201326592 bytesDatabase Buffers           50331648 bytesRedo Buffers                 667648 bytesDatabase mounted.Database opened.

2. 备份主库以及控制文件

[ora9@killdb killdb]$ rman target /Recovery Manager: Release 9.2.0.8.0 - ProductionCopyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.connected to target database: KILLDB (DBID=801221485)RMAN> backup database format='/home/ora9/killdb_full.bak';Starting backup at 08-DEC-14using target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=17 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current SPFILE in backupsetincluding current controlfile in backupsetinput datafile fno=00001 name=/home/ora9/oradata/killdb/system01.dbfinput datafile fno=00011 name=/home/ora9/oradata/killdb/jwdb01.dbfinput datafile fno=00002 name=/home/ora9/oradata/killdb/undotbs01.dbfinput datafile fno=00004 name=/home/ora9/oradata/killdb/example01.dbfinput datafile fno=00009 name=/home/ora9/oradata/killdb/xdb01.dbfinput datafile fno=00005 name=/home/ora9/oradata/killdb/indx01.dbfinput datafile fno=00006 name=/home/ora9/oradata/killdb/odm01.dbfinput datafile fno=00008 name=/home/ora9/oradata/killdb/users01.dbfinput datafile fno=00003 name=/home/ora9/oradata/killdb/drsys01.dbfinput datafile fno=00010 name=/home/ora9/oradata/killdb/cwmlite01.dbfinput datafile fno=00007 name=/home/ora9/oradata/killdb/tools01.dbfchannel ORA_DISK_1: starting piece 1 at 08-DEC-14channel ORA_DISK_1: finished piece 1 at 08-DEC-14piece handle=/home/ora9/killdb_full.bak comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:01:06Finished backup at 08-DEC-14RMAN> backup current controlfile ;Starting backup at 08-DEC-14using target database controlfile instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: sid=12 devtype=DISKchannel ORA_DISK_1: starting full datafile backupsetchannel ORA_DISK_1: specifying datafile(s) in backupsetincluding current controlfile in backupsetchannel ORA_DISK_1: starting piece 1 at 08-DEC-14channel ORA_DISK_1: finished piece 1 at 08-DEC-14piece handle=/home/ora9/product/9.2/dbs/03ppmf95_1_1 comment=NONEchannel ORA_DISK_1: backup set complete, elapsed time: 00:00:01Finished backup at 08-DEC-14

喜欢 (0)赏

[搞代码]

分享 (0)