oracle怎么切換模式,oracle怎么切換用戶
3ORACLE數(shù)據(jù)庫日志有哪幾種模式，如何在不同模式中切換？
有兩種模式：
我們提供的服務(wù)有：成都網(wǎng)站設(shè)計(jì)、網(wǎng)站制作、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、永濟(jì)ssl等。為千余家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的永濟(jì)網(wǎng)站制作公司
一：日志模式，日志模式的設(shè)置分為Archive
Mode和No
Archive
Mode。
二：自動(dòng)歸檔模式：自動(dòng)歸檔模式的設(shè)置分為：Enabled和Disabled
可用可用archive
log
list命令來查看數(shù)據(jù)庫的現(xiàn)行日志和自動(dòng)歸檔模式的設(shè)置。
希望對(duì)你有幫助。
如何將oracle數(shù)據(jù)庫 設(shè)置為歸檔模式
修改oracle為歸檔模式\x0d\x0a1，查看是否為歸檔模式\x0d\x0aSQL archive log list;\x0d\x0aDatabase log mode No Archive Mode\x0d\x0aAutomatic archival Disabled\x0d\x0aArchive destination USE_DB_RECOVERY_FILE_DEST\x0d\x0aOldest online log sequence 31\x0d\x0aCurrent log sequence 33\x0d\x0a2，關(guān)閉數(shù)據(jù)庫\x0d\x0aSQL shutdown immediate;\x0d\x0aDatabase closed.\x0d\x0aDatabase dismounted.\x0d\x0aORACLE instance shut down.\x0d\x0a3，啟動(dòng)數(shù)據(jù)庫到mount模式\x0d\x0aSQL startup mount;\x0d\x0aORACLE instance started.\x0d\x0a\x0d\x0aTotal System Global Area 1224736768 bytes\x0d\x0aFixed Size 2020384 bytes\x0d\x0aVariable Size 318770144 bytes\x0d\x0aDatabase Buffers 889192448 bytes\x0d\x0aRedo Buffers 14753792 bytes\x0d\x0aDatabase mounted.\x0d\x0a4，修改數(shù)據(jù)庫為歸檔模式\x0d\x0aSQL alter database archivelog;\x0d\x0a\x0d\x0aDatabase altered.\x0d\x0a5，打開數(shù)據(jù)庫庫\x0d\x0aSQL alter database open;\x0d\x0aSQL SELECT NAME,created,log_mode FROM v$database;\x0d\x0aNAME CREATED LOG_MODE\x0d\x0a--------- --------- ------------\x0d\x0aORCL 04-JUN-12 ARCHIVELOG\x0d\x0a\x0d\x0aDatabase altered.\x0d\x0a6，查看歸檔日志的路徑和目錄\x0d\x0aSQL show parameter db_recovery_file_dest;\x0d\x0a\x0d\x0aNAME TYPE VALUE\x0d\x0a------------------------------------ ----------- ------------------------------\x0d\x0adb_recovery_file_dest string /data/app/oracle/flash_recovery_area\x0d\x0adb_recovery_file_dest_size big integer 2G\x0d\x0a\x0d\x0a修改方法：\x0d\x0aSQL alter system set db_recovery_file_dest_size=20g;\x0d\x0aSQL alter system set db_recovery_file_dest='/app/arc';
oracle數(shù)據(jù)庫如何切換模式
oracle dg 三大模式切換
1、最大性能模式MAXIMUM PERFORMANCE --默認(rèn)模式，最大性能模式特點(diǎn)。
192.168.1.181
SQL?select?database_role,protection_mode,protection_level?from?v$database;
DATABASE_ROLE??PROTECTION_MODE???PROTECTION_LEVEL
----------------?--------------------?--------------------
PRIMARY?????MAXIMUM?PERFORMANCE?MAXIMUM?PERFORMANCE
SQL?col?dest_name?for?a25
SQL?select?dest_name,status?from?v$archive_dest_status;
DEST_NAME?????????STATUS
-------------------------?---------
LOG_ARCHIVE_DEST_1????VALID
LOG_ARCHIVE_DEST_2????VALID
SQL?show?parameter?log_archive
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_config??????????string???dg_config=(orcl,db01)
log_archive_dest_1??????????string???location=/home/oracle/arch_orc
l?valid_for=(all_logfiles,all_
roles)?db_unique_name=orcl
log_archive_dest_2??????????string???service=db_db01?LGWR?ASYNC?val
id_for=(online_logfiles,primar
y_roles)?db_unique_name=db01
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???31
Next?log?sequence?to?archive??33
Current?log?sequence??????33
192.168.1.183
SQL?select?database_role,protection_mode,protection_level?from?v$database;
DATABASE_ROLE??PROTECTION_MODE???PROTECTION_LEVEL
----------------?--------------------?--------------------
PHYSICAL?STANDBY?MAXIMUM?PERFORMANCE?MAXIMUM?PERFORMANCE
SQL?col?dest_name?for?a25
SQL?select?dest_name,status?from?v$archive_dest_status;
DEST_NAME?????????STATUS
-------------------------?---------
LOG_ARCHIVE_DEST_1????VALID
LOG_ARCHIVE_DEST_2????VALID
SQL?show?parameter?log_archive
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_config??????????string???dg_config=(db01,orcl)
log_archive_dest_1??????????string???location=/home/oracle/arch_db0
1?valid_for=(all_logfiles,all_
roles)?db_unique_name=db01
log_archive_dest_2??????????string???service=db_orcl?LGWR?ASYNC?val
id_for=(online_logfiles,primar
y_roles)?db_unique_name=orcl
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???31
Next?log?sequence?to?archive??33
Current?log?sequence??????33
192.168.1.181
SQL?alter?system?switch?logfile;
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???32
Next?log?sequence?to?archive??34
Current?log?sequence??????34
192.168.1.183
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_db01
Oldest?online?log?sequence???32
Next?log?sequence?to?archive??0
Current?log?sequence??????34
2 、最大性能模式--切換到--最大高可用 ?(默認(rèn)是最大性能模式---MAXIMUM PERFORMANCE)。
192.168.1.181
SQL?select?DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL?from?v$database;?
DATABASE_ROLE??PROTECTION_MODE???PROTECTION_LEVEL
----------------?--------------------?--------------------
PRIMARY?????MAXIMUM?PERFORMANCE?MAXIMUM?PERFORMANCE
SQL?show?parameter?log_archive_dest_2
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_dest_2??????????string???service=db_db01?LGWR?ASYNC?val
id_for=(online_logfiles,primar
y_roles)?db_unique_name=db01
192.168.1.181
SQL?shutdown?immediate
192.168.1.183
SQL?alter?database?recover?managed?standby?database?cancel;
SQL?shutdown?immediate
192.168.1.181
SQL?startup?mount;
SQL?alter?database?set?standby?database?to?maximize?availability;
SQL?alter?system?set?log_archive_dest_2='service=db_db01?LGWR?SYNC?valid_for=(online_logfiles,primary_roles)?db_unique_name=db01'?scope=spfile;
192.168.1.183
SQL?startup?nomount
SQL?alter?database?mount?standby?database;
SQL?alter?system?set?log_archive_dest_2='service=db_orcl?LGWR?SYNC?valid_for=(online_logfiles,primary_roles)?db_unique_name=orcl'?scope=spfile;
SQL?shutdown?immediate
SQL?startup?nomount
SQL?alter?database?mount?standby?database;
192.168.1.181
SQL?startup
SQL?col?dest_name?for?a25
SQL?select?dest_name,status?from?v$archive_dest_status;
DEST_NAME?????????STATUS
-------------------------?---------
LOG_ARCHIVE_DEST_1????VALID
LOG_ARCHIVE_DEST_2????VALID
SQL?show?parameter?log_archive_dest_2
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_dest_2??????????string???service=db_db01?LGWR?SYNC?vali
d_for=(online_logfiles,primary
_roles)?db_unique_name=db01
SQL?select?database_role,protection_level,protection_mode?from?v$database;
DATABASE_ROLE??PROTECTION_LEVEL???PROTECTION_MODE
----------------?--------------------?--------------------
PRIMARY?????MAXIMUM?AVAILABILITY?MAXIMUM?AVAILABILITY
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???34
Next?log?sequence?to?archive??36
Current?log?sequence??????36
192.168.1.183
SQL?col?dest_name?for?a25
SQL?select?dest_name,status?from?v$archive_dest_status;
DEST_NAME?????????STATUS
-------------------------?---------
LOG_ARCHIVE_DEST_1????VALID
LOG_ARCHIVE_DEST_2????VALID
SQL?show?parameter?log_archive_dest_2
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_dest_2??????????string???service=db_orcl?LGWR?SYNC?vali
d_for=(online_logfiles,primary
_roles)?db_unique_name=orcl
SQL?select?database_role,protection_level,protection_mode?from?v$database;
DATABASE_ROLE??PROTECTION_LEVEL???PROTECTION_MODE
----------------?--------------------?--------------------
PHYSICAL?STANDBY?MAXIMUM?AVAILABILITY?MAXIMUM?AVAILABILITY
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_db01
Oldest?online?log?sequence???35
Next?log?sequence?to?archive??0
Current?log?sequence??????36
192.168.1.181
SQL?alter?system?switch?logfile;
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???35
Next?log?sequence?to?archive??37
Current?log?sequence??????37
192.168.1.183
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_db01
Oldest?online?log?sequence???36
Next?log?sequence?to?archive??0
Current?log?sequence??????37
3、最大高可用--切換到--最保護(hù)能模式，DG最大保護(hù)模式Maximum protection。
192.168.1.181
SQL?shutdown?immediate
192.168.1.183
SQL?shutdown?immediate
192.168.1.181
SQL?alter?database?set?standby?database?to?maximize?protection;
SQL?shutdown?immediate
192.168.1.183
SQL?startup?nomount
SQL?alter?database?mount?standby?database;
192.168.1.181
SQL?startup
SQL?col?dest_name?for?a25
SQL?select?dest_name,status?from?v$archive_dest_status;
DEST_NAME?????????STATUS
-------------------------?---------
LOG_ARCHIVE_DEST_1????VALID
LOG_ARCHIVE_DEST_2????VALID
SQL?show?parameter?log_archive_dest_2
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_dest_2??????????string???service=db_db01?LGWR?SYNC?vali
d_for=(online_logfiles,primary
_roles)?db_unique_name=db01
SQL?select?database_role,protection_level,protection_mode?from?v$database;
DATABASE_ROLE??PROTECTION_LEVEL???PROTECTION_MODE
----------------?--------------------?--------------------
PRIMARY?????MAXIMUM?PROTECTION??MAXIMUM?PROTECTION
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???37
Next?log?sequence?to?archive??39
Current?log?sequence??????39
192.168.1.183
SQL?col?dest_name?for?a25
SQL?select?dest_name,status?from?v$archive_dest_status;
DEST_NAME?????????STATUS
-------------------------?---------
LOG_ARCHIVE_DEST_1????VALID
LOG_ARCHIVE_DEST_2????VALID
SQL?show?parameter?log_archive_dest_2
NAME?????????????????TYPE????VALUE
------------------------------------?-----------?---------------------------
log_archive_dest_2??????????string???service=db_db01?LGWR?SYNC?vali
d_for=(online_logfiles,primary
_roles)?db_unique_name=db01
SQL?select?database_role,protection_level,protection_mode?from?v$database;
DATABASE_ROLE??PROTECTION_LEVEL???PROTECTION_MODE
----------------?--------------------?--------------------
PRIMARY?????MAXIMUM?PROTECTION??MAXIMUM?PROTECTION
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_db01
Oldest?online?log?sequence???37
Next?log?sequence?to?archive??0
Current?log?sequence??????39
192.168.1.181
SQL?alter?system?switch?logfile;
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_orcl
Oldest?online?log?sequence???38
Next?log?sequence?to?archive??40
Current?log?sequence??????40
192.168.1.183
SQL?archive?log?list
Database?log?mode???????Archive?Mode
Automatic?archival???????Enabled
Archive?destination??????/home/oracle/arch_db01
Oldest?online?log?sequence???37
Next?log?sequence?to?archive??0
Current?log?sequence??????40
oracle數(shù)據(jù)庫切換問題
你這個(gè)屬于主、備機(jī)切換
1.?察看主庫狀態(tài)
select?switchover_status?from?v$database;
收集主庫上的臨時(shí)表空間的情況，原因是備庫激活后臨時(shí)文件可能丟失，需要手工建上去：
col?file_name?format?a40
select?file_name,tablespace_name,bytes/1024/1024?from?dba_temp_files;
FILE_NAME????????????????????????????????TABLESPACE_NAME??????BYTES/1024/1024
----------------------------------------?--------------------?---------------
/data/oradata/alihr/temp01.dbf???????????TEMP????????????????????????????2048
2.切換主庫到standby
alter?database?commit?to?switchover?to?physical?standby;
或：
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PHYSICAL?STANDBY?WITH?SESSION?SHUTDOWN;
shutdown?immediate;
startup?nomount;
alter?database?mount?standby?database;
3.驗(yàn)證要被切換的standby是否接收到switch?to?通知
SELECT?SWITCHOVER_STATUS?FROM?V$DATABASE;?
以前的狀態(tài)就是SESSIONS?ACTIVE,現(xiàn)在就變?yōu)門O?PRIMARY
4.切換物理standby到主用模式，檢查redo?log是否創(chuàng)建好
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PRIMARY;
shutdown?immediate;
startup;
5.?standby數(shù)據(jù)庫切換成主庫后，檢查是否需要、對(duì)臨時(shí)表空間增加臨時(shí)文件:
先檢查臨時(shí)文件是否丟失：
col?file_name?format?a60
select?file_name,tablespace_name?from?dba_temp_files;
把結(jié)果前面原主庫上的臨時(shí)文件進(jìn)行對(duì)比，如有丟失則使用如下命令增加：
alter?tablespace?temp?add?tempfile?'/data/oradata/alihr/temp02.dbf'?size?2048M?reuse;
正常情況下，如果db_file_name_convert參數(shù)設(shè)置正確的話，11g會(huì)自動(dòng)建立temp?file
6.在新的standby機(jī)器上
alter?system?set?log_archive_dest_state_2='defer';
alter?database?recover?managed?standby?database?disconnect?from?session;
7.檢查主備庫中fal參數(shù)
fal_server服務(wù)名是在standby機(jī)器的tnsnames中，指向主庫，fal_client是在主庫上的tnsnames中，指向standby。
fal參數(shù)只在standby機(jī)器上生效，所以在standby機(jī)器上fal_server指向主庫，fal_client機(jī)器指向備庫.
而主庫上的fal參數(shù)雖然不生效，但為了避免主庫切換成standby時(shí)，我們還要修改fal參數(shù)，所以現(xiàn)在就設(shè)置好，
讓fal_server指向現(xiàn)在的standby數(shù)據(jù)庫，fal_client指向自己。
8.在新的主庫
alter?system?set?log_archive_dest_state_2='enable';
alter?system?archive?log?current;?
然后到備庫上檢查備庫機(jī)器上日志是否正常的傳過來了。
9.檢查和調(diào)整主備庫兩臺(tái)機(jī)器中的crontab中的數(shù)據(jù)庫備份腳本和刪除歸檔腳本。
=================oracle11g的最大保護(hù)和最大可用模式下的切換==================
如果主庫是意外宕機(jī)的,則直接把備庫切換成主庫：
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?CANCEL;
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?FINISH;
shutdown?immediate;
connect?/?as?sysdba;
startup?mount;
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PRIMARY;
shutdown?immediate;
connect?/?as?sysdba;
startup?mount;
ALTER?DATABASE?SET?STANDBY?DATABASE?TO?MAXIMIZE?AVAILABILITY;
alter?database?open;
注意：上面操作中是手工的把數(shù)據(jù)庫重新置成MAXIMIZE?AVAILABILITY，否則數(shù)據(jù)庫起來后是最大性能模式。
檢查數(shù)據(jù)庫的角色：
select?database_role?from?v$database;
原有主庫啟動(dòng)后，如果不是硬盤壞，主庫上的數(shù)據(jù)還存在，則把主庫轉(zhuǎn)換成standby就可以了：
主庫上：
startup?mount;
recover?automatic?database;
ALTER?DATABASE?CONVERT?TO?PHYSICAL?STANDBY;
shutdown?immediate;
注意千萬不要把主庫打開了，否則會(huì)導(dǎo)致主庫的SCN發(fā)生變化，無法轉(zhuǎn)換成standby數(shù)據(jù)庫了。
在把原先的主庫轉(zhuǎn)化為standby時(shí)，有時(shí)可能報(bào)如下錯(cuò)誤：
SQL?alter?database?recover?managed?standby?database?finish;
alter?database?recover?managed?standby?database?finish
*
ERROR?at?line?1:
ORA-00283:?recovery?session?canceled?due?to?errors
ORA-19909:?datafile?1?belongs?to?an?orphan?incarnation
ORA-01110:?data?file?1:?'/opt/oracle/oradata/oratest/system01.dbf'
這里把到rman中：
list?incarnation?of?database;
reset?database?to?incarnation?1;
recover?database;
reset?database?to?incarnation?2;
=========================================================
failover在物理standby的切換
1.檢查standby看是否使用了standby?log
2.有standby?log,執(zhí)行下面的命令
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?CANCEL;
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?FINISH;
2.1?沒有standby?log則不執(zhí)行上面的
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?FINISH?SKIP?STANDBY?LOGFILE;
3.?切換
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PRIMARY;
3.1?如果上面3步驟失敗,則
ALTER?DATABASE?ACTIVATE?STANDBY?DATABASE;
4.?重啟db
shutdown?immediate
startup
switchover的方法：
主庫和物理standby的切換
1.察看主庫狀態(tài)
SELECT?SWITCHOVER_STATUS?FROM?V$DATABASE;
2.切換
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PHYSICAL?STANDBY;
3.原主庫
shutdown?immediate;
startup?nomount
alter?database?mount?standby?database;
4.驗(yàn)證要被切換的standby是否接收到switch?to?通知
SELECT?SWITCHOVER_STATUS?FROM?V$DATABASE;?
增加online?redo日志
5.切換物理standby到主
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PRIMARY;
shutdown?immediate;
startup;
6.在新的standby機(jī)器（也就是老的主庫）
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?DISCONNECT?FROM?SESSION;
7.在新的主庫
alter?system?archive?log?current;?
========active?standby?database===========
當(dāng):
alter?database?activate?standby?database;
原來的主庫只能通過閃回轉(zhuǎn)化成standby?database，但要求數(shù)據(jù)庫的flashback打開。
在新主庫上：
select?to_char(standby_became_primary_scn)?from?v$database;
在舊主庫上：
SHUTDOWN?IMMEDIATE;
STARTUP?MOUNT;
FLASHBACK?DATABASE?TO?SCN?standby_became_primary_scn;
ALTER?DATABASE?CONVERT?TO?PHYSICAL?STANDBY;
select?max(sequence#)?from?v$log_history?where?RESETLOGS_TIME=(select?max(RESETLOGS_TIME)?from?v$log_history);?
實(shí)例恢復(fù)：
recover?managed?standby?database?disconnect?using?current?logfile;
=================lgwr設(shè)置====================================
alter?system?set?log_archive_dest_3?=?'location=/disk3/arch/bopscha?reopen=2?MAX_FAILURE=3';
alter?system?set?log_archive_dest_state_3?=?alternate;
alter?system?set?log_archive_dest_1?=?'location=/disk2/arch/bopscha?alternate=log_archive_dest_3?reopen=60?MAX_FAILURE=5'?;
*.log_archive_dest_2='SERVICE=DTMRT?LGWR?ASYNC??VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)?DB_UNIQUE_NAME=DTMRT';
alter?database?add?standby?logfile?group?4?('/oracle/u02/ORA10GDG/STANDBYRD01.LOG')?size?200M;
select?group#,thread#,sequence#,archived,status?from?v$standby_log;
alter?database?set?standby?database?to?maximize?{availability?|?performance?|?protection};
select?protection_mode?from?v$database;
ORA-19527:
LOG_FILE_NAME_CONVERT='/u02/oracle/oradata/oract/','/u02/oracle/oradata/oract/'
alter?system?set?log_archive_dest_2='SERVICE=bopsteststb?lgwr?sync?affirm';
select?frequency,?duration?from?v$redo_dest_resp_histogram?where?dest_id=2?and?frequency1;
SQL?ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?CANCEL;
SQL?ALTER?DATABASE?OPEN;
SQL?ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?USING?CURRENT?LOGFILE?DISCONNECT;?
alter?database?convert?to?snapshot?standby;
alter?database?convert?to?physical?standby;
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?USING?CURRENT?LOGFILE?DISCONNECT;
alter?database?commit?to?switchover?to?physical?standby;
alter?database?activate?standby?database?finish?apply;
alter?database?recover?managed?standby?database?finish;?
舊主庫轉(zhuǎn)換成standby的步驟：
在新主庫上：
select?to_char(standby_became_primary_scn)?from?v$database;
在舊主庫上：
SHUTDOWN?IMMEDIATE;
STARTUP?MOUNT;
FLASHBACK?DATABASE?TO?SCN?standby_became_primary_scn;
ALTER?DATABASE?CONVERT?TO?PHYSICAL?STANDBY;
ALTER?DATABASE?COMMIT?TO?SWITCHOVER?TO?PRIMARY?WITH?SESSION?SHUTDOWN;
ALTER?DATABASE?RECOVER?MANAGED?STANDBY?DATABASE?FINISH?FORCE;
當(dāng)前標(biāo)題：oracle怎么切換模式,oracle怎么切換用戶
分享路徑：http://muchs.cn/article46/phihhg.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供、網(wǎng)站導(dǎo)航、營銷型網(wǎng)站建設(shè)、小程序開發(fā)、全網(wǎng)營銷推廣、網(wǎng)站收錄
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來源： 創(chuàng)新互聯(lián)
- 建站公司線上推廣現(xiàn)況及其將來推廣發(fā)展趨勢(shì) 2016-11-15
- 建站公司打鐵還需自身硬，那么建站公司應(yīng)該具備什么能力? 2021-04-17
- 成都建站公司介紹常見建站的常識(shí) 2023-03-26
- 網(wǎng)站開發(fā)公司-企業(yè)做網(wǎng)站如何選擇建站公司 2016-11-12
- 建站公司優(yōu)化自己網(wǎng)站的優(yōu)勢(shì) 2023-03-06
- 微信建站要怎么選擇建站公司 2021-05-02
- 成都網(wǎng)站建設(shè)應(yīng)該如何選擇建站公司 2020-01-14
- 建網(wǎng)站找外地建站公司和本地網(wǎng)站建設(shè)公司哪個(gè)靠譜？ 2016-09-29
- 建站公司給你做的網(wǎng)站顏色搭配正確嗎？四條檢驗(yàn)法則！ 2023-02-26
- 成都網(wǎng)站建設(shè)選擇高端建站公司應(yīng)該避免什么陷阱？ 2022-05-25
- 北京建站公司_高端網(wǎng)站建設(shè) 2021-04-15
- 上海建站公司是最方便快捷制作 2020-05-25