RMAN連線與oracle連線模式的關係

RMAN 連線與 oracle 連線模式的關係

 

 

實驗（一）

tnsnames.ora 配置

 

TEST =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dg-pp)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

     # (SERVER = shared)

      (SERVICE_NAME = test)

    )

  )

 

TEST_rman =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = dg-pp)(PORT = 1521))

    (CONNECT_DATA =

     # (SERVER = DEDICATED)

       (SERVER = shared)

      (SERVICE_NAME = test)

    )

  )

 

 rman 登陸結果

 

[ora@dg-pp ~]$ rman target sys/oracle@ test

 

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 6 19:13:34 2012

 

Copyright (c) 1982, 2005, Oracle.   All rights reserved.

 

connected to target database: TEST (DBID=2078000993)

 

RMAN> exit

 

 

Recovery Manager complete.

[ora@dg-pp ~]$ rman target sys/oracle@ test_rman

 

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 6 19:13:37 2012

 

Copyright (c) 1982, 2005, Oracle.   All rights reserved.

 

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-12520: TNS:listener could not find available handler for requested type of server

 

 

實驗（二）

[ora@dg-pp dbs]$ cp orapwtest orapwtest_bk （修改口令檔案）

[ora@dg-pp admin]$ cp tnsnames.ora tnsnames.ora_bak （修改 tnsnames.ora 檔案）

[ora@dg-pp admin]$ rman target /

 

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Apr 6 19:15:58 2012

 

Copyright (c) 1982, 2005, Oracle.   All rights reserved.

 

connected to target database: TEST (DBID=2078000993)

 

RMAN>

 

 

總結：

實驗（一）

說明： rman 遠端登陸只能應用於專有伺服器連線模式

實驗（二）

說明： rman 本地連線資料庫連線，可以不使用口令檔案和 tnsnames.ora 檔案