oracle如何切換模式,oracle怎么切換用戶
ORACLE如何切換到用戶需要的數(shù)據(jù)庫？
1、使用組合鍵“Win + R”打開運行對話框，在輸入框中輸入?regedit 并回車打開“注冊表編輯器”。
創(chuàng)新互聯(lián)專注于三原網(wǎng)站建設(shè)服務(wù)及定制，我們擁有豐富的企業(yè)做網(wǎng)站經(jīng)驗。 熱誠為您提供三原營銷型網(wǎng)站建設(shè)，三原網(wǎng)站制作、三原網(wǎng)頁設(shè)計、三原網(wǎng)站官網(wǎng)定制、成都小程序開發(fā)服務(wù)，打造三原網(wǎng)絡(luò)公司原創(chuàng)品牌,更為您提供三原網(wǎng)站排名全網(wǎng)營銷落地服務(wù)。
2、在“注冊表編輯器”對話框，依次展開 HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb10g_home1名稱為 ORACLE_SID 的數(shù)據(jù) orcl 即 Oracle數(shù)據(jù)庫的SID。
3、在遠程連接工具 XShell使用 root 用戶或者 oracle 用戶連接 Linux/Unix Oracle數(shù)據(jù)庫服務(wù)器。
4、輸入命令 su - oracle 切換到 oracle 用戶即可。
oracle數(shù)據(jù)庫如何切換模式
oracle dg 三大模式切換
1、最大性能模式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?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 、最大性能模式--切換到--最大高可用 ?(默認是最大性能模式---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、最大高可用--切換到--最保護能模式，DG最大保護模式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
3ORACLE數(shù)據(jù)庫日志有哪幾種模式，如何在不同模式中切換？
有兩種模式：
一：日志模式，日志模式的設(shè)置分為Archive
Mode和No
Archive
Mode。
二：自動歸檔模式：自動歸檔模式的設(shè)置分為：Enabled和Disabled
可用可用archive
log
list命令來查看數(shù)據(jù)庫的現(xiàn)行日志和自動歸檔模式的設(shè)置。
希望對你有幫助。
網(wǎng)站欄目：oracle如何切換模式,oracle怎么切換用戶
本文路徑：http://muchs.cn/article20/hcpgco.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供自適應(yīng)網(wǎng)站、品牌網(wǎng)站設(shè)計、、營銷型網(wǎng)站建設(shè)、全網(wǎng)營銷推廣、用戶體驗
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)
- 品牌網(wǎng)站制作怎么建設(shè)更高效 2021-08-27
- 周口品牌網(wǎng)站建設(shè)：在品牌網(wǎng)站制作的過程中有哪些值得注意的問題？ 2021-09-10
- 深圳品牌網(wǎng)站制作營銷重點 2021-09-28
- 企業(yè)官方品牌網(wǎng)站制作需要遵循的三大原則 2023-03-02
- 中小企業(yè)品牌網(wǎng)站制作與塑造 2021-12-06
- 品牌網(wǎng)站制作方案要怎么做 2021-08-28
- 保定品牌網(wǎng)站制作：如何做好一個成功的品牌網(wǎng)站？ 2021-08-27
- 品牌網(wǎng)站制作解決方案七步走 2021-12-19
- 品牌網(wǎng)站制作有哪些重要注意事項？ 2016-08-20
- 為什么高端品牌網(wǎng)站制作公司越來越少了 2016-11-12
- 品牌網(wǎng)站制作好后網(wǎng)站URL優(yōu)化有技巧 2022-08-12
- 品牌網(wǎng)站制作與普通網(wǎng)站制作的區(qū)別 2021-09-02