oracle 切換數(shù)據(jù)庫(kù)

直接登錄相應(yīng)的用戶就可以了。

10年積累的成都做網(wǎng)站、網(wǎng)站建設(shè)經(jīng)驗(yàn)，可以快速應(yīng)對(duì)客戶對(duì)網(wǎng)站的新想法和需求。提供各種問(wèn)題對(duì)應(yīng)的解決方案。讓選擇我們的客戶得到更好、更有力的網(wǎng)絡(luò)服務(wù)。我雖然不認(rèn)識(shí)你，你也不認(rèn)識(shí)我。但先做網(wǎng)站設(shè)計(jì)后付款的網(wǎng)站建設(shè)流程，更有鹿寨免費(fèi)網(wǎng)站建設(shè)讓你可以放心的選擇與我們合作。

步驟：直接在命令行輸入sqlconn username/password；即可完成切換.

解釋：每個(gè)用戶都只能默認(rèn)一個(gè)數(shù)據(jù)庫(kù)，不可能出現(xiàn)多個(gè)數(shù)據(jù)庫(kù)。所以直接切換到需要的用戶下即可完成操作。

我的Oracle中創(chuàng)建了多個(gè)數(shù)據(jù)庫(kù)，我應(yīng)該如何在數(shù)據(jù)庫(kù)之間進(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;

ORACLE如何切換到用戶需要的數(shù)據(jù)庫(kù)？

直接登錄相應(yīng)的用戶就可以了。

步驟：直接在命令行輸入sqlconn

username/password；即可完成切換.

解釋：每個(gè)用戶都只能默認(rèn)一個(gè)數(shù)據(jù)庫(kù)，不可能出現(xiàn)多個(gè)數(shù)據(jù)庫(kù)。所以直接切換到需要的用戶下即可完成操作。

如何將一個(gè)oracle數(shù)據(jù)庫(kù)復(fù)制成一個(gè)新的數(shù)據(jù)庫(kù)

1、在數(shù)據(jù)庫(kù)服務(wù)器的開(kāi)始菜單中找到Datebase Configuration Assistant。

2、在創(chuàng)建畫面第一步選擇：創(chuàng)建新數(shù)據(jù)庫(kù)，點(diǎn)擊下一步。

3、根據(jù)需求選擇自己的數(shù)據(jù)庫(kù)類型(一般默認(rèn))后，跳轉(zhuǎn)到全局?jǐn)?shù)據(jù)庫(kù)名這個(gè)畫面時(shí)，重點(diǎn)來(lái)了：新建數(shù)據(jù)庫(kù)名稱不能和已經(jīng)存在的任何一個(gè)數(shù)據(jù)庫(kù)名稱相同。

4、在管理帳戶密碼界面，可以與別的數(shù)據(jù)庫(kù)管理帳戶密碼相同也可以不同，需注意的是，Oracle數(shù)據(jù)庫(kù)默認(rèn)是區(qū)分密碼大小寫的。

5、跳轉(zhuǎn)到Oracle內(nèi)存分配大小頁(yè)面，這里建議將Oracle內(nèi)存調(diào)整為物理主機(jī)內(nèi)存的70%。

6、點(diǎn)擊完成后，等待數(shù)據(jù)庫(kù)創(chuàng)建完成。

7、數(shù)據(jù)庫(kù)創(chuàng)建完成后，用sqlplus?語(yǔ)句連接數(shù)據(jù)庫(kù)，在同一服務(wù)器上建立多個(gè)Oracle數(shù)據(jù)庫(kù)操作完成。

oracle數(shù)據(jù)庫(kù)如何切換模式

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

分享標(biāo)題：怎么切oracle數(shù)據(jù)庫(kù),數(shù)據(jù)庫(kù)切庫(kù)
網(wǎng)頁(yè)路徑：http://chinadenli.net/article27/dseeejj.html

成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供用戶體驗(yàn)、、建站公司、響應(yīng)式網(wǎng)站、企業(yè)網(wǎng)站制作、網(wǎng)站設(shè)計(jì)公司

廣告

聲明：本網(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í)需注明來(lái)源： 創(chuàng)新互聯(lián)