RMAN连接与oracle连接模式的关系

RMAN连接与oracle连接模式的关系

 

总结： 1、   RMAN远程连接只能用于专有服务器连接 2、   RMAN本地连接数据库，可以不使用口令文件与TNSNAMES.ORA文件

 

实验（一）

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