oracle如何切換 oracle如何切換用戶
oracle數(shù)據(jù)庫如何切換模式
oracle dg 三大模式切換
專注于為中小企業(yè)提供成都做網(wǎng)站、網(wǎng)站設(shè)計服務(wù),電腦端+手機(jī)端+微信端的三站合一,更高效的管理,為中小企業(yè)碧江免費(fèi)做網(wǎng)站提供優(yōu)質(zhì)的服務(wù)。我們立足成都，凝聚了一批互聯(lián)網(wǎng)行業(yè)人才，有力地推動了數(shù)千家企業(yè)的穩(wěn)健成長，幫助中小企業(yè)通過網(wǎng)站建設(shè)實(shí)現(xiàn)規(guī)模擴(kuò)充和轉(zhuǎn)變。
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ù)庫？
直接登錄相應(yīng)的用戶就可以了。
步驟：直接在命令行輸入sqlconn
username/password；即可完成切換.
解釋：每個用戶都只能默認(rèn)一個數(shù)據(jù)庫，不可能出現(xiàn)多個數(shù)據(jù)庫。所以直接切換到需要的用戶下即可完成操作。
redhat6切換oracle節(jié)點(diǎn)
redhat6切換oracle節(jié)點(diǎn)，兩個窗口，一個執(zhí)行root。sh，另一個緊接著刷屏。
Oracle數(shù)據(jù)庫系統(tǒng)是目前世界上流行的關(guān)系數(shù)據(jù)庫，管理系統(tǒng)，系統(tǒng)可移植性好、使用方便、功能強(qiáng)，適用于各類大、中、小、微機(jī)環(huán)境。它是一種高效率、可靠性好的、適應(yīng)高吞吐量的數(shù)據(jù)庫方案。
Oracle作為一個通用的數(shù)據(jù)庫系統(tǒng)，它具有完整的數(shù)據(jù)管理功能，作為一個關(guān)系數(shù)據(jù)庫，它有一個完備關(guān)系的產(chǎn)品，作為分布式數(shù)據(jù)，它實(shí)現(xiàn)了分布式處理功能。
我的Oracle中創(chuàng)建了多個數(shù)據(jù)庫，我應(yīng)該如何在數(shù)據(jù)庫之間進(jìn)行切換呢
1、在不退出sqlplus的情況下，直接在命令行輸入conn username/password；即可完成切換。
2、在退出sqlplus的情況下，windows下：set ORACLE_SID=db_name; linux下：export ORACLE_SID = db_name再登錄相應(yīng)的用戶即可完成切換。
3、創(chuàng)建用戶命令：create user usernamer identified by passwd；
4、給用戶賦權(quán)限：grant connect,resource,dba to username;
當(dāng)前標(biāo)題：oracle如何切換 oracle如何切換用戶
瀏覽地址：http://muchs.cn/article20/hgegco.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供自適應(yīng)網(wǎng)站、品牌網(wǎng)站建設(shè)、企業(yè)建站、網(wǎng)站排名、品牌網(wǎng)站設(shè)計、小程序開發(fā)
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請盡快告知，我們將會在第一時間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時需注明來源： 創(chuàng)新互聯(lián)
- 外貿(mào)網(wǎng)站建設(shè)注意哪些？ 2016-04-10
- 婁底網(wǎng)站建設(shè)_婁底企業(yè)外貿(mào)網(wǎng)站建設(shè)不可忽視的細(xì)節(jié) 2021-09-08
- 常州外貿(mào)網(wǎng)站建設(shè)：建設(shè)一個英文網(wǎng)站這幾點(diǎn)必須要注意！ 2021-09-27
- 談外貿(mào)網(wǎng)站建設(shè)用戶體驗(yàn)的幾個方面 2016-11-03
- 聊聊外貿(mào)網(wǎng)站建設(shè)的關(guān)鍵之處是什么 2016-09-10
- 網(wǎng)站建設(shè)公司模板，外貿(mào)網(wǎng)站建設(shè)公司 2022-11-22
- 外貿(mào)網(wǎng)站怎么做？這些外貿(mào)網(wǎng)站建設(shè)原則了解一下！ 2013-08-29
- 外貿(mào)網(wǎng)站建設(shè)時這些事項(xiàng)需要格外注意 2015-02-11
- 外貿(mào)網(wǎng)站建設(shè)頁面如何設(shè)計-成都制作網(wǎng)站 2023-02-21
- 外貿(mào)網(wǎng)站建設(shè)要注意的細(xì)節(jié) 2021-06-24
- 外貿(mào)網(wǎng)站建設(shè)的幾個重點(diǎn) 2016-03-14
- 大連外貿(mào)網(wǎng)站建設(shè)的注意事項(xiàng) 2022-07-12