系統：redhat4

三臺計算機rac1,rac2,dg.

--其中rac為主庫，單實例為備庫

已在虛擬機里搭建好集群環境(rac1,rac2);

dg計算機里還沒有建任何數據庫（只安裝Oracle軟件）。

單實例環境部署請參考文檔‘linux下安裝Oracle10g(redhat4)’。

--將主庫設為強制歸檔

SQL>selectforce_loggingfromv$database;

FOR

---

NO

SQL>alterdatabaseforcelogging;

Databasealtered.

SQL>selectforce_loggingfromv$database;

FOR

---

YES

在rac的兩個節點上執行：

SQL>alterusersysidentifiedbyoracle;

Useraltered.

建密碼文件：

cd/u01/app/oracle/PRoduct/10.2.0/db_1/dbs--注意，一定要在該路徑下建密碼文件

[oracle@rac1dbs]$orapwdfile=orapwprod1passWord=oracleentries=3force=y

[oracle@rac2dbs]$orapwdfile=orapwprod2password=oracleentries=3force=y

在備庫上建密碼文件

cd/u01/app/oracle/product/10.2.0/db_1/dbs

[oracle@dgdbs]$orapwdfile=orapwsdyprodpassword=oracleentries=3

在任意一個節點上查詢日志情況：

SQL>selectgroup#,thread#,sequence#,bytes/1024/1024mb

2fromv$log;

GROUP#THREAD#SEQUENCE# MB

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

1 1 4 50

2 1 5 50

3 2 3 50

4 2 4 50

SQL>selectmemberfromv$logfile;

MEMBER

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

+DATA/prod/onlinelog/group_2.262.856078815

+REDOLOG/prod/onlinelog/group_2.258.856078819

+DATA/prod/onlinelog/group_1.261.856078807

+REDOLOG/prod/onlinelog/group_1.257.856078813

+DATA/prod/onlinelog/group_3.266.856079013

+REDOLOG/prod/onlinelog/group_3.259.856079015

+DATA/prod/onlinelog/group_4.267.856079017

+REDOLOG/prod/onlinelog/group_4.260.856079019

8rowsselected.

用下面這個公式決定standbyredologfilegroup的數量：

（每個節點日志組最大數+1）*節點數量

比如，這里每個節點都有兩組日志，有兩個節點，因此需要配置（2+1）*2=6組standbyredologfilegroup.

建立standbyredolog;

SQL>alterdatabaseaddstandbylogfilethread1group5'+DATA'size50m;

Databasealtered.

SQL>alterdatabaseaddstandbylogfilethread1group6'+DATA'size50m;

Databasealtered.

SQL>alterdatabaseaddstandbylogfilethread1group7'+DATA'size50m;

Databasealtered

SQL>alterdatabaseaddstandbylogfilethread2group8'+DATA'size50m;

Databasealtered.

SQL>alterdatabaseaddstandbylogfilethread2group9'+DATA'size50m;

Databasealtered.

SQL>alterdatabaseaddstandbylogfilethread2group10'+DATA'size50m;

Databasealtered.

在兩個節點上都查看一下建的standbylogfile:

SQL>selectgroup#,thread#,status

2fromv$standby_log;

GROUP#THREAD#STATUS

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

51UNASSIGNED

61UNASSIGNED

71UNASSIGNED

82UNASSIGNED

92UNASSIGNED

102UNASSIGNED

6rowsselected.

在rac1節點上創建pfile(由于它原本Pfile內容只有SPFILE='+DG1/prod/spfileprod.ora'這一句）

SQL>createpfile='/home/oracle/initprod1.ora'fromspfile;

Filecreated.

viinitprod.ora

添加如下內容：

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,sdyprod)'

LOG_ARCHIVE_DEST_1=

'LOCATION=+DATA/prod

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=prod'

LOG_ARCHIVE_DEST_2=

'SERVICE=sdyprodLGWRASYNC

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=sdyprod'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_MAX_PROCESSES=3

FAL_SERVER=sdyprod

prod1.FAL_CLIENT=prod1

prod2.FAL_CLIENT=prod2

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sdyprod/','+DATA/prod/datafile/','/u01/app/oracle/oradata/sdyprod/','+DATA/prod/tempfile/'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sdyprod/','+DATA/prod/onlinelog/','/u01/app/oracle/oradata/sdyprod/','+REDOLOG/prod/onlinelog/'

STANDBY_FILE_MANAGEMENT=AUTO

看以該pfile文件能否登陸成功，并創建spfile(rac里建spfile時，不指定位置的話，會默認放在本地磁盤上)

SQL>startupforcenomountpfile='/home/oracle/initprod1.ora';

ORACLEinstancestarted.

TotalSystemGlobalArea285212672bytes

FixedSize1218992bytes

VariableSize92276304bytes

DatabaseBuffers188743680bytes

RedoBuffers2973696bytes

SQL>createspfile='+DATA/prod/spfileprod.ora'frompfile='/home/oracle/initprod1.ora';

Filecreated

在打開rac1之前，先把rac2的實例關掉，因為現在spfile已經改變了。

在rac2上：shutdownimmediate;

在rac1上：startupforce;

在rac2上：startup;

/*

若rac2的庫沒關，rac1以修改后的spfile啟動，會報錯：

SQL>startupforce;

ORACLEinstancestarted.

TotalSystemGlobalArea285212672bytes

FixedSize1218992bytes

VariableSize92276304bytes

DatabaseBuffers188743680bytes

RedoBuffers2973696bytes

ORA-01105:mountisincompatiblewithmountsbyotherinstances

ORA-01677:standbyfilenameconvertparametersdifferfromotherinstance

*/

--若已經歸檔，這步可以隔過去了

（由于是rac環境，只能用rman備份了）

在rac1下做一個熱備份（由于rac默認備份放在ASM下，所以這里備份需要手工指定位置）：

RMAN>run{

2>allocatechannelc1typedisk;

3>allocatechannelc2typedisk;

4>backupfulldatabaseformat'/home/oracle/backup/%d_%s.bak';

5>}

--在rac1下的/home/oracle/backup可以看到備份集，rac2下的/home/oracle/backup下看不到。

--在任意一個節點上皆可

SQL>shutdownimmediate;

Databaseclosed.

Databasedismounted.

ORACLEinstanceshutdown.

SQL>startupmount;

ORACLEinstancestarted.

TotalSystemGlobalArea285212672bytes

FixedSize1218992bytes

VariableSize96470608bytes

DatabaseBuffers184549376bytes

RedoBuffers2973696bytes

Databasemounted.

SQL>alterdatabasecreatestandbycontrolfileas'/home/oracle/sdyprod_control01.ctl';

Databasealtered.

SQL>alterdatabaSEOpen;

Databasealtered.

將rac1下建的初始化參數文件遠程拷貝到備庫192.168.8.225上：

[oracle@rac1~]$

scpinitprod1.ora192.168.8.225:/u01/app/oracle/product/10.2.0/db_1/dbs/initsdyprod.ora

Theauthenticityofhost'192.168.8.225(192.168.8.225)'can'tbeestablished.

RSAkeyfingerprintis6d:1d:6b:1a:34:63:f2:f4:4c:15:0d:eb:60:e0:13:4d.

Areyousureyouwanttocontinueconnecting(yes/no)?yes

Warning:Permanentlyadded'192.168.8.225'(RSA)tothelistofknownhosts.

oracle@192.168.8.225'spassword:

initprod1.ora100%22142.2KB/s00:00

拷貝過來的initprod1.ora文件內容：

prod1.__db_cache_size=163577856

prod2.__db_cache_size=155189248

prod1.__java_pool_size=4194304

prod2.__java_pool_size=4194304

prod1.__large_pool_size=4194304

prod2.__large_pool_size=4194304

prod1.__shared_pool_size=109051904

prod2.__shared_pool_size=117440512

prod1.__streams_pool_size=0

prod2.__streams_pool_size=0

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

*.background_dump_dest='/u01/app/oracle/admin/prod/bdump'

*.cluster_database_instances=2

*.cluster_database=true

*.compatible='10.2.0.1.0'

*.control_files='+DATA/prod/controlfile/current.260.856078805','+REDOLOG/prod/controlfile/current.256.856078805'

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

*.db_block_size=8192

*.db_create_file_dest='+DATA'

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='prod'

*.db_recovery_file_dest='+REDOLOG'

*.db_recovery_file_dest_size=2147483648

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

prod1.instance_number=1

prod2.instance_number=2

*.job_queue_processes=10

*.log_archive_dest_1='LOCATION=+DATA/prod'

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

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_listener='LISTENERS_PROD'

*.remote_login_passwordfile='exclusive'

*.sga_target=285212672

prod2.thread=2

prod1.thread=1

*.undo_management='AUTO'

prod2.undo_tablespace='UNDOTBS2'

prod1.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/u01/app/oracle/admin/prod/udump'

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,sdyprod)'

LOG_ARCHIVE_DEST_1=

'LOCATION=+DATA/prod/

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=prod'

LOG_ARCHIVE_DEST_2=

'SERVICE=sdyprodLGWRASYNC

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=sdyprod'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_MAX_PROCESSES=3

FAL_SERVER=sdyprod

prod1.FAL_CLIENT=prod1

prod2.FAL_CLIENT=prod2

DB_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sdyprod/','+DATA/prod/datafile/','/u01/app/oracle/oradata/sdyprod/','+DATA/prod/tempfile/'

LOG_FILE_NAME_CONVERT='/u01/app/oracle/oradata/sdyprod/','+DATA/prod/onlinelog/','/u01/app/oracle/oradata/sdyprod/','+REDOLOG/prod/onlinelog/'

STANDBY_FILE_MANAGEMENT=AUTO

相對于修改前的參數文件，修改后的initsdyprod.ora如下（改動的地方已用黃色陰影標出）：

prod1.__db_cache_size=163577856

prod2.__db_cache_size=155189248

prod1.__java_pool_size=4194304

prod2.__java_pool_size=4194304

prod1.__large_pool_size=4194304

prod2.__large_pool_size=4194304

prod1.__shared_pool_size=109051904

prod2.__shared_pool_size=117440512

prod1.__streams_pool_size=0

prod2.__streams_pool_size=0

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

*.background_dump_dest='/u01/app/oracle/admin/sdyprod/bdump'

#*.cluster_database_instances=2

#*.cluster_database=true

*.compatible='10.2.0.1.0'

*.control_files='/u01/app/oracle/admin/sdyprod/sdyprod_control01.ctl'

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

*.db_block_size=8192

*.db_create_file_dest='/u01/app/oracle/oradata'

*.db_domain=''

*.db_file_multiblock_read_count=16

*.db_name='prod'

*.db_recovery_file_dest=''

*.db_recovery_file_dest_size=2147483648

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

prod.instance_number=1

*.job_queue_processes=10

#*.log_archive_dest_1='LOCATION=+DATA/prod'

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

*.open_cursors=300

*.pga_aggregate_target=94371840

*.processes=150

*.remote_listener='LISTENERS_PROD'

*.remote_login_passwordfile='exclusive'

*.sga_target=285212672

sdyprod.thread=1

*.undo_management='AUTO'

sdyprod.undo_tablespace='UNDOTBS1'

*.user_dump_dest='/u01/app/oracle/admin/sdyprod/udump'

db_unique_name=sdyprod

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(prod,sdyprod)'

LOG_ARCHIVE_DEST_1=

'LOCATION=/arch/sdyprod

VALID_FOR=(ALL_LOGFILES,ALL_ROLES)

DB_UNIQUE_NAME=sdyprod'

LOG_ARCHIVE_DEST_2=

'SERVICE=prodLGWRASYNC

VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)

DB_UNIQUE_NAME=prod'

LOG_ARCHIVE_DEST_STATE_1=ENABLE

LOG_ARCHIVE_DEST_STATE_2=ENABLE

REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE

LOG_ARCHIVE_FORMAT=%t_%s_%r.arc

LOG_ARCHIVE_MAX_PROCESSES=3

FAL_SERVER=prod

FAL_CLIENT=sdyprod

DB_FILE_NAME_CONVERT='+DATA/prod/datafile/','/u01/app/oracle/oradata/sdyprod/','+DATA/prod/tempfile/','/u01/app/oracle/oradata/sdyprod/'

LOG_FILE_NAME_CONVERT='+DATA/prod/onlinelog/','/u01/app/oracle/oradata/sdyprod/','+REDOLOG/prod/onlinelog/','/u01/app/oracle/oradata/sdyprod/'

STANDBY_FILE_MANAGEMENT=AUTO

--建歸檔路徑：/arch/sdyprod

[root@dg~]#mkdir-p/arch/sdyprod

[root@dg~]#chownoracle:dba/arch/sdyprod

[oracle@dg~]$mkdir-p/u01/app/oracle/admin/sdyprod

[oracle@dg~]$mkdir-p/u01/app/oracle/oradata/sdyprod

[oracle@dgadmin]$cdsdyprod/

[oracle@dgsdyprod]$ls

[oracle@dgsdyprod]$mkdiradumpbdumpcdumpudump

--創建備份文件夾

[oracle@dg~]$cd/home/oracle

[oracle@dg~]$ls

Desktopinitsdyprod.orasoftware

[oracle@dg~]$mkdirbackup

[oracle@rac1backup]$scp*.bak192.168.8.225:/home/oracle/backup/

oracle@192.168.8.225'spassword:

PROD_1.bak100%362MB14.5MB/s00:25

PROD_2.bak100%257MB13.5MB/s00:19

PROD_3.bak100%15MB14.6MB/s00:01

PROD_4.bak100%96KB96.0KB/s00:00

[oracle@rac1backup]$cd/home/oracle

[oracle@rac1~]$scPSDyprod_control01.ctl192.168.8.225:/home/oracle/

oracle@192.168.8.225'spassword:

sdyprod_control01.ctl100%15MB7.3MB/s00:02

注意：拷貝的數據文件和控制文件必須得和原來的路徑一模一樣，否則會出錯。

--配監聽和tnsnames.ora

[oracle@rac1admin]$cd/u01/app/oracle/product/10.2.0/db_1/network/admin

[oracle@rac1admin]$ls

listener.orasamplesshrept.lsttnsnames.ora

在rac1，rac2的tnsnames.ora中添加如下內容：

sdyprod=

(DESCRipTION=

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

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=sdyprod)

(UR=A)

)

)

在備庫192.168.8.225中添加如下內容：

LISTENERS_PROD=

(ADDRESS_LIST=

(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))

)

PROD=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))

(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))

(LOAD_BALANCE=yes)

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=prod)

)

)

PROD2=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=rac2-vip)(PORT=1521))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=prod)

(INSTANCE_NAME=prod2)

)

)

PROD1=

(DESCRIPTION=

(ADDRESS=(PROTOCOL=TCP)(HOST=rac1-vip)(PORT=1521))

(CONNECT_DATA=

(SERVER=DEDICATED)

(SERVICE_NAME=prod)

(INSTANCE_NAME=prod1)

)

)

tnsping一下，看能否Ping通，如以tnspingprod1為例：

看到‘OK’字樣，表示ping通了。

在備庫lsnrctlstart

lsnrctlstatus

#vi/etc/hosts

#Donotremovethefollowingline,orvariousprograms

#thatrequirenetworkfunctionalitywillfail.

127.0.0.1localhost

192.168.8.225dg

192.168.8.220rac1

192.168.8.222rac1-vip

10.10.10.1rac1-priv

192.168.8.221rac2

192.168.8.223rac2-vip

10.10.10.2rac2-priv

--在備庫上：

SQL>startupnomount;

ORACLEinstancestarted.

TotalSystemGlobalArea285212672bytes

FixedSize1218992bytes

VariableSize92276304bytes

DatabaseBuffers188743680bytes

RedoBuffers2973696bytes

SQL>createspfilefrompfile;

Filecreated

-------在主庫通過rmanduplicatestandbydb

[oracle@rac1admin]$rmantarget/

RecoveryManager:Release10.2.0.1.0-ProductiononWedDec1207:35:042012

Copyright(c)1982,2005,Oracle.Allrightsreserved.

connectedtotargetdatabase:PROD(DBID=212879047)

RMAN>connectauxiliarysys/oracle@sdyprod;

connectedtoauxiliarydatabase:PROD(notmounted)

RMAN>duplicatetargetdatabaseforstandby

2>;

StartingDuplicateDbat26-AUG-14

usingtargetdatabasecontrolfileinsteadofrecoverycatalog

allocatedchannel:ORA_AUX_DISK_1

channelORA_AUX_DISK_1:sid=155devtype=DISK

contentsofMemoryScript:

{

restoreclonestandbycontrolfile;

sqlclone'alterdatabasemountstandbydatabase';

}

executingMemoryScript

Startingrestoreat26-AUG-14

usingchannelORA_AUX_DISK_1

channelORA_AUX_DISK_1:restoringcontrolfile

channelORA_AUX_DISK_1:copiedcontrolfilecopy

inputfilename=/home/oracle/sdyprod_control01.ctl

outputfilename=/u01/app/oracle/admin/sdyprod/sdyprod_control01.ctl

Finishedrestoreat26-AUG-14

sqlstatement:alterdatabasemountstandbydatabase

releasedchannel:ORA_AUX_DISK_1

contentsofMemoryScript:

{

setnewnamefortempfile1to

"/u01/app/oracle/oradata/sdyprod/temp.263.856078825";

switchclonetempfileall;

setnewnamefordatafile1to

"/u01/app/oracle/oradata/sdyprod/system.256.856078713";

setnewnamefordatafile2to

"/u01/app/oracle/oradata/sdyprod/undotbs1.258.856078719";

setnewnamefordatafile3to

"/u01/app/oracle/oradata/sdyprod/sysaux.257.856078715";

setnewnamefordatafile4to

"/u01/app/oracle/oradata/sdyprod/users.259.856078719";

setnewnamefordatafile5to

"/u01/app/oracle/oradata/sdyprod/example.264.856078831";

setnewnamefordatafile6to

"/u01/app/oracle/oradata/sdyprod/undotbs2.265.856078943";

restore

checkreadonly

clonedatabase

;

}

executingMemoryScript

executingcommand:SETNEWNAME

renamedtemporaryfile1to/u01/app/oracle/oradata/sdyprod/temp.263.856078825incontrolfile

executingcommand:SETNEWNAME

executingcommand:SETNEWNAME

executingcommand:SETNEWNAME

executingcommand:SETNEWNAME

executingcommand:SETNEWNAME

executingcommand:SETNEWNAME

Startingrestoreat26-AUG-14

allocatedchannel:ORA_AUX_DISK_1

channelORA_AUX_DISK_1:sid=155devtype=DISK

skippingdatafile2;alreadyrestoredtofile/u01/app/oracle/oradata/sdyprod/undotbs1.258.856078719

skippingdatafile3;alreadyrestoredtofile/u01/app/oracle/oradata/sdyprod/sysaux.257.856078715

skippingdatafile5;alreadyrestoredtofile/u01/app/oracle/oradata/sdyprod/example.264.856078831

skippingdatafile1;alreadyrestoredtofile/u01/app/oracle/oradata/sdyprod/system.256.856078713

skippingdatafile4;alreadyrestoredtofile/u01/app/oracle/oradata/sdyprod/users.259.856078719

skippingdatafile6;alreadyrestoredtofile/u01/app/oracle/oradata/sdyprod/undotbs2.265.856078943

restorenotdone;allfilesreadonly,offline,oralreadyrestored

Finishedrestoreat26-AUG-14

contentsofMemoryScript:

{

switchclonedatafileall;

}

executingMemoryScript

datafile1switchedtodatafilecopy

inputdatafilecopyrecid=4stamp=856594930filename=/u01/app/oracle/oradata/sdyprod/system.256.856078713

datafile2switchedtodatafilecopy

inputdatafilecopyrecid=5stamp=856594930filename=/u01/app/oracle/oradata/sdyprod/undotbs1.258.856078719

datafile3switchedtodatafilecopy

inputdatafilecopyrecid=6stamp=856594930filename=/u01/app/oracle/oradata/sdyprod/sysaux.257.856078715

datafile4switchedtodatafilecopy

inputdatafilecopyrecid=7stamp=856594930filename=/u01/app/oracle/oradata/sdyprod/users.259.856078719

datafile5switchedtodatafilecopy

inputdatafilecopyrecid=8stamp=856594930filename=/u01/app/oracle/oradata/sdyprod/example.264.856078831

datafile6switchedtodatafilecopy

inputdatafilecopyrecid=9stamp=856594930filename=/u01/app/oracle/oradata/sdyprod/undotbs2.265.856078943

FinishedDuplicateDbat26-AUG-14

RMAN>

SQL>alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;

查看報警日志或者v$archived_log，看是否同步歸檔日志。

在主庫上scott用戶下的表t插入一條數據:

SQL>insertintotvalues(3);

1rowcreated.

SQL>commit;

Commitcomplete.

在備庫上查看一下：

SQL>select*fromt；

select*fromt

*

ERRORatline1:

ORA-01219:databasenotopen:queriesallowedonfixedtables/viewsonly

由于，在readonly下查看，會導致應用日志的延遲，于是決定，在備庫切換成主庫后再查看。

在主庫上關掉其他實例，只剩一個實例以切換到備庫：

進rac2：

SQL>shutdownimmediate;

Databaseclosed.

Databasedismounted.

ORACLEinstanceshutdown.

進rac1：

SQL>selectswitchover_statusfromv$database;

SWITCHOVER_STATUS

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

SESSIONSACTIVE--表示有活動的會話，需要kill掉

SQL>selectsid,serial#,usernamefromv$sessionwhereusernameisnotnull;

SIDSERIAL#USERNAME

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

1248SYS

1313SYS

1329SYS

15117SYS

1529SYS

SQL>selectdistinctsidfromv$mystat;

SID

----------

124

SQL>altersystemkillsession'131,3';

Systemaltered.

SQL>altersystemkillsession'132,9';

Systemaltered.

SQL>altersystemkillsession'151,17';

Systemaltered.

SQL>altersystemkillsession'152,9';

Systemaltered.

SQL>alterdatabasecommittoswitchovertophysicalstandbywithsessionshutdown;

Databasealtered.

SQL>selectstatusfromv$instance;

STATUS

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

STARTED

SQL>shutdownimmediate;

ORA-01507:databasenotmounted

ORACLEinstanceshutdown.

SQL>startupmount;

ORACLEinstancestarted.

TotalSystemGlobalArea285212672bytes

FixedSize1218992bytes

VariableSize100664912bytes

DatabaseBuffers180355072bytes

RedoBuffers2973696bytes

--必須得先關庫，再startupmount，而不是alterdatabasemount;否則報錯

Databasemounted.

進備庫：

SQL>alterdatabasecommittoswitchovertoprimarywithsessionshutdown;

alterdatabasecommittoswitchovertoprimarywithsessionshutdown

*

ERRORatline1:

ORA-16139:mediarecoveryrequired

SQL>alterdatabaserecovermanagedstandbydatabasedisconnectfromsession;

Databasealtered.

SQL>alterdatabasecommittoswitchovertoprimarywithsessionshutdown;

Databasealtered.

SQL>alterdatabaseopen;

SQL>selectopen_mode

2fromv$database;

OPEN_MODE

----------

READWRITE

SQL>select*

2fromscott.t;

ID

----------

3

1

2

--備庫切換為主庫后，看到了之前的主庫插入的數據3。

--原來的主庫（即切換角色后的備庫），應用日志：

alter database recover managed standby database disconnect from session