部署Physical Dataguard 與雙節(jié)點Oracle RAC環(huán)境

發(fā)布時間：2020-07-25 02:57:07 來源：網(wǎng)絡閱讀：1780 作者：wangluochongzi 欄目：關系型數(shù)據(jù)庫

關于oracle rac 部署請訪問這里 http://worms.blog.51cto.com/969144/1416975

系統(tǒng)信息：

Primary端

RAC Primary	RACDG1（主機）	RACDG2（主機）	備注
Public IP	172.20.10. 11	172.20.10. 12
Virtual IP	10.0.0.11	10.0.0.12
Instance	racdg1	racdg2
DB name	RACDG
DATA file	+DATA2/racdg/datafile
Control file	+DATA2/racdg/controlfile +DATA1/racdg/controlfile/
Redo Log file	+DATA2/racdg/onlinelog/ db_recovery_file_dest
db_unique_name	racdg
service_names	racdg
Oracle_Version	11.2.0.1.0

Standby 端

Single instance standby	主機名	備注
IP	172.20.10.100
Oracle_version	11.2.0.1.0
Instance	racdg
DB name	RACDG
DB_unique_name	racdg_standy
service_names	racdg_standy
DATA file	/u01/oracle/racdg_standy/datafile/
Control file	/u01/app/oracle/controlfile1/ /u01/app/oracle/controlfile2/
Redo Log file	/u01/oracle/racdg_standy/onlinelog3/ /u01/oracle/racdg_standy/onlinelog/

結構圖

部署Physical Dataguard 與雙節(jié)點Oracle RAC環(huán)境

Standby 庫類型說明

1、 PhysicalStandby Databases

其特性：

Disaster recovery and high availability
Data protection
Reduction in primary database workload
Performance

2、 LogicalStandby Databases

其特性：

Protection against additional kinds of failure
Effcient use of resource
Workload distribution
Optimized of reporting add decision supportrequirements
Minimizing downtime on software upgrade

3、Snapshot StandbyDatabases

A snapshot standby database is a type of updatable standby databasethat provides full data protection for a primary database. A snapshot standbydatabase receives and archives, but does not apply, redo data from its primarydatabase. Redo data received from the primary database is applied when asnapshot standby database is converted back into a physical standby database,after discarding all local updates to the snapshot standby database

A snapshot standby database typically diverges from its primarydatabase over time because redo data from the primary database is not appliedas it is received. Local updates to the snapshot standby database will causeadditional divergence. The data in the primary database is fully protectedhowever, because a snapshot standby can be converted back into a physicalstandby database at any time, and the redo data received from the primary willthen be applied

這段話可以看出snapshot standby DB對主庫的數(shù)據(jù)完全保護，snapshot standby DB是通常對生產庫不能做業(yè)務的測試和開發(fā)是一種解脫。如下這段話：

Benefits of a SnapshotStandby Database

A snapshot standby database is a fullyupdatable standby database that provides disaster recovery and data protectionbenefits that are similar to those of a physical standby database. Snapshotstandby databases are best used in scenarios where the benefit of having atemporary, updatable snapshot of the primary database justifies the increasedtime to recover from primary database failures.

The benefits of using a snapshot standbydatabase include the following:

It provides an exact replica of aproduction database for development and testing purposes, while maintainingdata protection at all times.

It can be easily refreshed to containcurrent production data by converting to a physical standby andresynchronizing.

The ability to create a snapshot standby,test, resynchronize with production, and then again create a snapshot standbyand test, is a cycle that can be repeated as often as desired. The same processcan be used to easily create and regularly update a snapshot standby forreporting purposes where read/write access to data is required.

以上可說明，對生產庫的實時保護。將開發(fā)和測試的主庫，轉到備庫。備庫并將接受主庫的redlog但不apply，等測試完成后，再將snapshot standby DB切換回physical standby DB，恢復之前狀態(tài)。

這里配置是的physical standby database類型

準備配置環(huán)境：

配置 tnsname.ora，在tnsname.ora文件中添加如下內容，并把tnsname.ora文件復制到所有節(jié)點及standby DB中。

rac_dg1 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.11)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = racdg)

(INSTANCE_NAME = racdg1)

)

rac_dg2 =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.12)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = racdg)

(INSTANCE_NAME = racdg2)

)

racdg_standy =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.100)(PORT = 1521))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SID = racdg)

)

配置physical standby DB 監(jiān)聽：listener.ora

SID_LIST_LISTENER =

(SID_LIST =

(SID_DESC =

(GLOBAL_DBNAME = PLSExtProc)

(ORACLE_HOME = /u01/app/oracle/product/11.2.0/db_1)

(SID_NAME = PLSExtProc)

)

LISTENER =

(DESCRIPTION_LIST =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.10.100)(PORT = 1521))

)

ADR_BASE_LISTENER = /u01/app/oracle

Preparingthe Primary Database for Standby Database Creation

EnableForced Logging (Place the primary database in FORCE LOGGING mode.)
configure redotransport authentication
Configurethe Primary Database to Receive Redo Data
Set PrimaryDatabase Initialization Parameters
EnableArchiving

Creatinga Physical Standby Database

Create a Backup Copy of the Primary Database Datafiles
Create a Control File for the Standby Database
Copy Files from the Primary System to the Standby System
Prepare an Initialization Parameter File for the Standby Database
Start the Physical Standby Database
Verify the Physical Standby Database Is Performing Properly

Primarydatabase 配置：

1、開啟Force logging

SQL> ALTER DATABASE FORCE LOGGING;

執(zhí)行這條語句database 至少在mounted或者open狀態(tài)，而且也可能會花費很多時間來完成，因為enable forced logging要等待all unlogged write I/O 結束。

查看select force_logging from v$database;

2、Configure RedoTransport Authentication

Data Guard usesOracle Net sessions to transport redo data and control messages between themembers of a Data Guard configuration. These redo transport sessions areauthenticated using either the Secure Sockets Layer (SSL) protocol or a remotelogin password file. 這里使用password file。

在rac 節(jié)點1上創(chuàng)建 pwdfile

orapwdfile=/u01/app/oracle/product/11.2.0/db_1/dbs/orapwracdg1 password=FANfan1234entries=10 force=y

并將orapwracdg1復制到節(jié)點2和 standby DB 節(jié)點上并命名。

scp$ORACLE_HOME/dbs/orapwracdg1 oracle@racdg2:$ORACLE_HOME/dbs/orapwracdg2

scp$ORACLE_HOME/dbs/orapwracdg1 oracle@racdg2:$ORACLE_HOME/dbs/orapwracdg

3、Configure thePrimary Database to Receive Redo Data

這里在primary 主庫做switchoverto standby db 時，再配置。

4、Set Primary DatabaseInitialization Parameters

Primary DB initialization parameter：

SQL> show parameter pfile

NAME TYPE VALUE

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

spfile string +DATA1/racdg/spfileracdg.ora

SQL>

createpfile=’/home/oracle/primary_pfile.pfile’ fromspfile=’+DATA1/racdg/spfileracdg.ora’

編輯參數(shù)：

racdg2.__db_cache_size=276824064

racdg1.__db_cache_size=276824064

racdg2.__java_pool_size=4194304

racdg1.__java_pool_size=4194304

racdg2.__large_pool_size=4194304

racdg1.__large_pool_size=4194304

racdg2.__pga_aggregate_target=339738624

racdg1.__pga_aggregate_target=339738624

racdg2.__sga_target=503316480

racdg1.__sga_target=503316480

racdg2.__shared_io_pool_size=0

racdg1.__shared_io_pool_size=0

racdg2.__shared_pool_size=209715200

racdg1.__shared_pool_size=209715200

racdg2.__streams_pool_size=0

racdg1.__streams_pool_size=0

*.audit_file_dest='/u01/app/oracle/admin/racdg/adump'

*.audit_trail='db'

*.cluster_database=true

*.compatible='11.2.0.0.0'

*.control_files='+DATA2/racdg/controlfile/current.260.875118793','+DATA1/racdg/controlfile/current.256.875118799'

*.db_block_size=8192

*.db_create_file_dest='+DATA2'

*.db_domain=''

*.db_name='racdg'

*.db_recovery_file_dest='+DATA1'

*.db_recovery_file_dest_size=4070572032

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP)(SERVICE=racdgXDB)'

racdg1.instance_number=1

racdg2.instance_number=2

*.log_archive_format='%t_%s_%r.dbf'

*.memory_target=839909376

*.open_cursors=300

*.processes=150

*.remote_listener='scan.localdomain:1521'

*.remote_login_passwordfile='exclusive'

racdg2.thread=2

racdg1.thread=1

racdg2.undo_tablespace='UNDOTBS2'

racdg1.undo_tablespace='UNDOTBS1'

添加參數(shù)：

*.db_unique_name=racdg

*.service_names=racdg

*.log_archive_config='dg_config=(racdg,racdg_standy)'

*.log_archive_dest_1=

'location=use_db_recovery_file_dest

valid_for=(all_logfiles,all_roles)

db_unique_name=racdg'

*.log_archive_dest_2=

'service=racdg_standy async

valid_for=(online_logfiles,primary_role)

db_unique_name=racdg_standy'

*.log_archive_dest_state_1=enable

*.log_archive_dest_state_2=enable

*.log_archive_max_processes=30

*.fal_server=racdg_standy

racdg1.fal_client=racdg1

racdg2.fal_client=racdg2

*.db_file_name_convert=

'/u01/oracle/racdg_standy/datafile/','+DATA2/racdg/datafile/',

'/u01/oracle/racdg_standy/tempfile/','+DATA2/racdg/tempfile/'

*.log_file_name_convert=

'/u01/oracle/racdg_standy/onlinelog/','+DATA1/racdg/onlinelog/',

'/u01/oracle/racdg_standy/onlinelog3/','+DATA2/racdg/onlinelog/'

*.standby_file_management=auto

注：

這里需要注意fal_server和fal_client的配置，db_unique_name的參數(shù)設置。

創(chuàng)建primary DB spfile:

關閉集群

[grid@racdg1 ~]$ srvctl stop database -d racdg

[oracle@racdg1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production onTue Mar 17 18:18:09 2015

Connected to an idle instance.

SQL> createspfile='+DATA1/racdg/spfileracdg.ora' from pfile='/home/oracle/config.pfile';

File created.

啟動集群：

[grid@racdg1 ~]$ srvctl start database -dracdg

啟動后登陸兩個節(jié)點查看參數(shù)：

在Racdg1節(jié)點查詢參數(shù)：

SQL> show parameter fal

NAME TYPE VALUE

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

fal_client string racdg1

fal_server string racdg_standy

SQL> show parameter archive

NAME TYPE VALUE

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

archive_lag_target integer 0

log_archive_config string dg_config=(racdg,racdg_standy)

log_archive_dest string

log_archive_dest_1 string location=use_db_recovery_file_

dest

valid_for=(all_logfiles,all_

roles)

db_unique_name=racdg

log_archive_dest_10 string

log_archive_dest_11 string

log_archive_dest_12 string

NAME TYPE VALUE

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

log_archive_dest_13 string

log_archive_dest_14 string

log_archive_dest_15 string

log_archive_dest_16 string

log_archive_dest_17 string

log_archive_dest_18 string

log_archive_dest_19 string

log_archive_dest_2 string service=racdg_standy async

valid_for=(online_logfiles,p

rimary_role)

db_unique_name=racdg_standy

SQL> show parameter db_file_name_convert

NAME TYPE VALUE

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

db_file_name_convert string /u01/app/oracle/racdg_standy/d

atafile, +DATA1/racdg/datafile

/, /u01/app/oracle/racdg_stand

y/tempfile, +DATA1/racdg/tempf

ile/

SQL>

SQL> show parameterlog_file_name_convert

NAME TYPE VALUE

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

log_file_name_convert string /u01/app/oracle/racdg_standy/o

nlinelog, +DATA1/racdg/onlinel

og/, /u01/app/oracle/racdg_sta

ndy/onlinelog3, +DATA3/racdg/o

nlinelog/

SQL> show parameter control

NAME TYPE VALUE

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

control_file_record_keep_time integer 7

control_files string +DATA1/racdg/controlfile/curre

nt.296.874604041, +DATA3/racdg

/controlfile/current.426.87460

4051

control_management_pack_access string DIAGNOSTIC+TUNING

SQL>

在racdg2節(jié)點查看參數(shù):

SQL> show parameter fal

NAME TYPE VALUE

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

fal_client string racdg2

fal_server string racdg_standy

SQL> show parameter archive

NAME TYPE VALUE

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

archive_lag_target integer 0

log_archive_config string dg_config=(racdg,racdg_standy)

log_archive_dest string

log_archive_dest_1 string location=use_db_recovery_file_

dest

valid_for=(all_logfiles,all_

roles)

db_unique_name=racdg

log_archive_dest_10 string

log_archive_dest_11 string

log_archive_dest_12 string

NAME TYPE VALUE

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

log_archive_dest_13 string

log_archive_dest_14 string

log_archive_dest_15 string

log_archive_dest_16 string

log_archive_dest_17 string

log_archive_dest_18 string

log_archive_dest_19 string

log_archive_dest_2 string service=racdg_standy async

valid_for=(online_logfiles,p

rimary_role)

db_unique_name=racdg_standy

SQL> show parameter control

NAME TYPE VALUE

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

control_file_record_keep_time integer 7

control_files string +DATA1/racdg/controlfile/curre

nt.296.874604041,+DATA3/racdg

/controlfile/current.426.87460

4051

control_management_pack_access string DIAGNOSTIC+TUNING

SQL> show parameterlog_file_name_convert

NAME TYPE VALUE

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

log_file_name_convert string /u01/app/oracle/racdg_standy/o

nlinelog, +DATA1/racdg/onlinel

og/, /u01/app/oracle/racdg_sta

ndy/onlinelog3, +DATA3/racdg/o

nlinelog/

SQL> show parameter db_file_name_convert

NAME TYPE VALUE

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

db_file_name_convert string /u01/app/oracle/racdg_standy/d

atafile, +DATA1/racdg/datafile

/, /u01/app/oracle/racdg_stand

y/tempfile, +DATA1/racdg/tempf

ile/

SQL>

5、開啟RAC歸檔

略

PhysicalStandby Database 配置

1、創(chuàng)建primary DB 備份

Rman 備份primary DB

[oracle@racdg1db_backup]$ rman target /

Recovery Manager:Release 11.2.0.1.0 - Production on Tue Mar 17 18:58:43 2015

connected to targetdatabase: RACDG (DBID=1109864007)

RMAN> backup database format'/home/oracle/db_backup/racdbfull_%T_%t_%u_%s_%p';

Starting backup at17-MAR-15

using targetdatabase control file instead of recovery catalog

allocated channel:ORA_DISK_1

channel ORA_DISK_1:SID=32 instance=racdg1 device type=DISK

channel ORA_DISK_1:starting full datafile backup set

channel ORA_DISK_1:specifying datafile(s) in backup set

input datafile filenumber=00001 name=+DATA1/racdg/datafile/system.292.874603637

input datafile filenumber=00002 name=+DATA1/racdg/datafile/sysaux.293.874603643

input datafile filenumber=00003 name=+DATA1/racdg/datafile/undotbs1.294.874603645

input datafile filenumber=00005 name=+DATA1/racdg/datafile/undotbs2.300.874604699

input datafile filenumber=00004 name=+DATA1/racdg/datafile/users.295.874603647

channel ORA_DISK_1:starting piece 1 at 17-MAR-15

channel ORA_DISK_1:finished piece 1 at 17-MAR-15

piecehandle=/home/oracle/db_backup/racdbfull_20150317_874609135_01q22uff_1_1tag=TAG20150317T185854 comment=NONE

channel ORA_DISK_1:backup set complete, elapsed time: 00:02:45

channel ORA_DISK_1:starting full datafile backup set

channel ORA_DISK_1:specifying datafile(s) in backup set

including currentcontrol file in backup set

including currentSPFILE in backup set

channel ORA_DISK_1:starting piece 1 at 17-MAR-15

channel ORA_DISK_1:finished piece 1 at 17-MAR-15

piece handle=/home/oracle/db_backup/racdbfull_20150317_874609302_02q22ukm_2_1tag=TAG20150317T185854 comment=NONE

channel ORA_DISK_1:backup set complete, elapsed time: 00:00:16

Finished backup at17-MAR-15

RMAN>

2、為standby db創(chuàng)建controlfile

SQL> ALTER DATABASE CREATE STANDBYCONTROLFILE AS '/home/oracle/db_backup/racdg.ctl';

Database altered.

SQL> alter system switch logfile;

System altered.

SQL>

3、復制primaryDB備份文件到standbyDB上

[oracle@racdg1db_backup]$ ll

total 1074652

-rw-r--r-- 1 oracleasmadmin 2330 Mar 16 11:00backcuppfile.pfile

-rw-r----- 1 oracleasmadmin 1062264832 Mar 17 19:01 racdbfull_20150317_874609135_01q22uff_1_1

-rw-r----- 1 oracleasmadmin 18579456 Mar 17 19:02racdbfull_20150317_874609302_02q22ukm_2_1

-rw-r----- 1 oracleasmadmin 18497536 Mar 17 19:06racdg.ctl

-rw-r--r-- 1 oracleoinstall 1575 Mar 6 19:51 standby_db.pfile

[oracle@racdg1db_backup]$ scp racd* oracle@172.20.10.100:/home/oracle/db_backup/

oracle@172.20.10.100'spassword:

racdbfull_20150317_874609135_01q22uff_1_1 24% 203

4、創(chuàng)建standby initialization parameter

準備工作

相關目錄創(chuàng)建：

log_file=/u01/oracle/racdg_standy/onlinelog

db_file=/u01/oracle/racdg_standy/datafile

archive_log=/u01/oracle/racdg_standy/arch

設置文件目錄權限權限：

[root@localhost ~]# chown -Roracle:oinstall /u01/oracle/racdg_standy

[root@localhost ~]# chown 775/u01/oracle/racdg_standy

[root@localhost ~]# ls -ls/u01/oracle/racdg_standy/

total 16

4 drwxr-xr-x 2 oracle oinstall 4096 Feb 1500:54 arch

4 drwxr-xr-x 2 oracle oinstall 4096 Feb 1500:54 datafile

4 drwxr-xr-x 2 oracle oinstall 4096 Feb 1500:54 onlinelog

4 drwxr-xr-x 2 oracle oinstall 4096 Feb 1500:54 tempfile

復制primary DB parameter進行修改

去掉primary parameter中的內容如下：

*.cluster_database=TRUE

racdg1.instance_number=1

racdg2.instance_number=2

*.remote_listener='scan.localdomain:1521'

*.db_create_file_dest='+DATA1'

*.cluster_database=true

*.memory_target=842006528

*.db_recovery_file_dest='+DATA3'

*.db_recovery_file_dest_size=4070572032

添加修改參數(shù)：

*.pga_aggregate_target=339738624

*.sga_target=503316480

*.audit_file_dest='/u01/app/oracle/admin/racdg_standy/adump'

*.core_dump_dest='/u01/app/oracle/admin/racdg_standy/cdump'

*.audit_trail='db'

*.compatible='11.2.0.0.0'

*.control_files='/u01/app/oracle/controlfile1/control1.ctl',

'/u01/app/oracle/controlfile2/control2.ctl'

*.db_block_size=8192

*.db_domain=''

*.db_name='racdg'

*.diagnostic_dest='/u01/app/oracle'

*.dispatchers='(PROTOCOL=TCP)(SERVICE=racdgXDB)'

*.open_cursors=300

*.processes=150

*.remote_login_passwordfile='exclusive'

*.thread=1

*.undo_tablespace='UNDOTBS1'

*.db_unique_name='racdg_standy'

*.service_names='racdg_standy'

*.log_archive_config='dg_config=(racdg_standy,racdg)'

*.log_archive_dest_1='location=/u01/oracle/racdg_standy/arch/

valid_for=(all_logfiles,all_roles)

db_unique_name=racdg_standy'

*.log_archive_dest_2='service=rac_dg1 async

valid_for=(online_logfiles,primary_role)

db_unique_name=racdg'

*.log_archive_dest_state_1='enable'

*.log_archive_dest_state_2='enable'

*.log_archive_format='%t_%s_%r.dbf'

*.log_file_name_convert='+DATA1/racdg/onlinelog/','/u01/oracle/racdg_standy/onlinelog/',

'+DATA2/racdg/onlinelog/','/u01/oracle/racdg_standy/onlinelog3/'

*.db_file_name_convert='+DATA2/racdg/datafile/','/u01/oracle/racdg_standy/datafile/',

'+DATA2/racdg/tempfile/','/u01/oracle/racdg_standy/tempfile/'

*.log_archive_max_processes=30

*.standby_file_management='auto'

*.fal_client='racdg_standy'

*.fal_server='rac_dg1','rac_dg2'

Startup nomount;

注：1、這里配置的rac_dg1節(jié)點接收redo log

2、核實參數(shù)文件中的目錄

5、Create a serverparameter file for the standby database

Startup nomount

SQL> startup pfile='/home/oracle/db_backup/standby_0317.pfile' nomount;

ORACLE instance started.

Total System Global Area 217157632 bytes

Fixed Size 2211928 bytes

Variable Size 159387560 bytes

Database Buffers 50331648 bytes

Redo Buffers 5226496 bytes

創(chuàng)建spfile

SQL> create spfile='/u01/app/oracle/product/11.2.0/db_1/dbs/spfileracdg.ora'from pfile='/home/oracle/db_backup/standby_0317.pfile';

File created.

SQL>

查看相關參數(shù)是否生效

SQL> show parameter fal

NAME TYPE VALUE

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

fal_client string racdg_standy

fal_server string rac_dg1, rac_dg2

SQL> show parameter archive

NAME TYPE VALUE

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

archive_lag_target integer 0

log_archive_config string dg_config=(racdg_standy,racdg)

log_archive_dest string

log_archive_dest_1 string location=/u01/app/oracle/racdg

_standy/arch/

valid_for=(all_logfiles,all_

roles)

db_unique_name=racdg_standy

log_archive_dest_10 string

log_archive_dest_11 string

log_archive_dest_12 string

NAME TYPE VALUE

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

log_archive_dest_13 string

log_archive_dest_14 string

log_archive_dest_15 string

log_archive_dest_16 string

log_archive_dest_17 string

log_archive_dest_18 string

log_archive_dest_19 string

log_archive_dest_2 string service=rac_dg1 async

valid_for=(online_logfiles,pri

mary_role)

db_unique_name=racdg

6、Start the PhysicalStandby Database

使用rman 恢復primary DB備份到standby DB 庫上

在此執(zhí)行rman：

[oracle@standydb~]$ rman target sys/FANfan1234@rac_dg1 auxiliary /

Recovery Manager:Release 11.2.0.1.0 - Production on Tue Mar 17 20:22:42 2015

connected to targetdatabase: RACDG (DBID=1109864007)

connected toauxiliary database: RACDG (not mounted)

RMAN>

RMAN> duplicatetarget database for standby;

Starting DuplicateDb at 17-MAR-15

using targetdatabase control file instead of recovery catalog

allocated channel:ORA_AUX_DISK_1

channelORA_AUX_DISK_1: SID=18 device type=DISK

contents of MemoryScript:

{

restore clone standby controlfile;

}

executing MemoryScript

Starting restore at17-MAR-15

using channelORA_AUX_DISK_1

channelORA_AUX_DISK_1: restoring control file

channelORA_AUX_DISK_1: copied control file copy

input filename=/home/oracle/db_backup/racdg.ctl

output filename=/u01/app/oracle/controlfile1/control1.ctl

output filename=/u01/app/oracle/controlfile2/control2.ctl

Finished restore at17-MAR-15

contents of MemoryScript:

{

sql clone 'alter database mount standbydatabase';

}

executing MemoryScript

sql statement:alter database mount standby database

contents of MemoryScript:

{

set newname for tempfile 1 to

"/u01/app/oracle/racdg_standy/tempfile/temp.299.874604163";

switch clone tempfile all;

set newname for datafile 1 to

"/u01/app/oracle/racdg_standy/datafile/system.292.874603637";

set newname for datafile 2 to

"/u01/app/oracle/racdg_standy/datafile/sysaux.293.874603643";

set newname for datafile 3 to

"/u01/app/oracle/racdg_standy/datafile/undotbs1.294.874603645";

set newname for datafile 4 to

"/u01/app/oracle/racdg_standy/datafile/users.295.874603647";

set newname for datafile 5 to

"/u01/app/oracle/racdg_standy/datafile/undotbs2.300.874604699";

restore

clone database

;

}

executing MemoryScript

executing command:SET NEWNAME

renamed tempfile 1to /u01/app/oracle/racdg_standy/tempfile/temp.299.874604163 in control file

executing command:SET NEWNAME

Starting restore at17-MAR-15

using channelORA_AUX_DISK_1

channelORA_AUX_DISK_1: starting datafile backup set restore

channelORA_AUX_DISK_1: specifying datafile(s) to restore from backup set

channelORA_AUX_DISK_1: restoring datafile 00001 to/u01/app/oracle/racdg_standy/datafile/system.292.874603637

channelORA_AUX_DISK_1: restoring datafile 00002 to/u01/app/oracle/racdg_standy/datafile/sysaux.293.874603643

channelORA_AUX_DISK_1: restoring datafile 00003 to/u01/app/oracle/racdg_standy/datafile/undotbs1.294.874603645

channel ORA_AUX_DISK_1:restoring datafile 00004 to/u01/app/oracle/racdg_standy/datafile/users.295.874603647

channelORA_AUX_DISK_1: restoring datafile 00005 to/u01/app/oracle/racdg_standy/datafile/undotbs2.300.874604699

channelORA_AUX_DISK_1: reading from backup piece/home/oracle/db_backup/racdbfull_20150317_874609135_01q22uff_1_1

channelORA_AUX_DISK_1: piecehandle=/home/oracle/db_backup/racdbfull_20150317_874609135_01q22uff_1_1tag=TAG20150317T185854

channelORA_AUX_DISK_1: restored backup piece 1

channel ORA_AUX_DISK_1:restore complete, elapsed time: 00:04:25

Finished restore at17-MAR-15

contents of MemoryScript:

{

switch clone datafile all;

}

executing MemoryScript

datafile 1 switchedto datafile copy

input datafile copyRECID=1 STAMP=874614650 filename=/u01/app/oracle/racdg_standy/datafile/system.292.874603637

datafile 2 switchedto datafile copy

input datafile copyRECID=2 STAMP=874614651 filename=/u01/app/oracle/racdg_standy/datafile/sysaux.293.874603643

datafile 3 switchedto datafile copy

input datafile copyRECID=3 STAMP=874614651 filename=/u01/app/oracle/racdg_standy/datafile/undotbs1.294.874603645

datafile 4 switchedto datafile copy

input datafile copyRECID=4 STAMP=874614651 filename=/u01/app/oracle/racdg_standy/datafile/users.295.874603647

datafile 5 switchedto datafile copy

input datafile copyRECID=5 STAMP=874614651 filename=/u01/app/oracle/racdg_standy/datafile/undotbs2.300.874604699

Finished DuplicateDb at 17-MAR-15

RMAN>

查看standby DB實例狀態(tài)：

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS

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

racdg MOUNTED

SQL>

SQL> SELECT SWITCHOVER_STATUS FROMV$DATABASE;

SWITCHOVER_STATUS

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

RECOVERY NEEDED

查看log

SQL> select member from v$logfile;

MEMBER

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

/u01/app/oracle/racdg_standy/onlinelog/group_2.298.874604079

/u01/app/oracle/racdg_standy/onlinelog3/group_2.428.874604089

/u01/app/oracle/racdg_standy/onlinelog/group_1.297.874604065

/u01/app/oracle/racdg_standy/onlinelog3/group_1.427.874604073

/u01/app/oracle/racdg_standy/onlinelog/group_3.301.874604969

/u01/app/oracle/racdg_standy/onlinelog3/group_3.429.874604987

/u01/app/oracle/racdg_standy/onlinelog/group_4.302.874604999

/u01/app/oracle/racdg_standy/onlinelog3/group_4.431.874605055

8 rows selected.

SQL> select * from v$controlfile;

STATUS NAME IS_ BLOCK_SIZE FILE_SIZE_BLKS

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

/u01/app/oracle/controlfile1/control1.ctl NO 16384 1128

/u01/app/oracle/controlfile2/control2.ctl NO 16384 1128

SQL>

SQL> select name from v$datafile;

NAME

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

/u01/app/oracle/racdg_standy/datafile/system.292.874603637

/u01/app/oracle/racdg_standy/datafile/sysaux.293.874603643

/u01/app/oracle/racdg_standy/datafile/undotbs1.294.874603645

/u01/app/oracle/racdg_standy/datafile/users.295.874603647

/u01/app/oracle/racdg_standy/datafile/undotbs2.300.874604699

SQL>

7、配置standby DB接受redo log

Prepare the Standby Database to Receive RedoData

ALTERDATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 5

('/u01/app/oracle/racdg_standy/onlinelog/slog5_1.rdo','/u01/app/oracle/racdg_standy/onlinelog3/slog5_2.rdo')SIZE 50M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 GROUP 6

('/u01/app/oracle/racdg_standy/onlinelog/slog6_1.rdo','/u01/app/oracle/racdg_standy/onlinelog3/slog6_2.rdo')SIZE 50M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 GROUP 7

('/u01/app/oracle/racdg_standy/onlinelog/slog7_1.rdo','/u01/app/oracle/racdg_standy/onlinelog3/slog7_2.rdo')SIZE 50M;

ALTER DATABASE ADDSTANDBY LOGFILE THREAD 2 GROUP 8

('/u01/app/oracle/racdg_standy/onlinelog/slog8_1.rdo','/u01/app/oracle/racdg_standy/onlinelog3/slog8_2.rdo')SIZE 50M;