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 文件