【RMAN】使用RMAN duplicate複制同機資料庫遇到的問題

<b>1 參數檔案中的 db_name為修改</b>

oracle@yangdb1:/home/oracle&gt;export oracle_sid=orcl

oracle@yangdb1:/home/oracle&gt;rman target /

recovery manager: release 10.2.0.1.0 - production on wed aug 17 18:25:58 2011

copyright (c) 1982, 2005, oracle.  all rights reserved.

connected to target database: orcl (dbid=1286259285)

rman&gt; connect auxiliary sys/yang@yqldb

connected to auxiliary database: orcl (not mounted)

rman&gt; exit                                         

原因：執行個體名稱和yqldb不符，修改inityqldb.ora檔案中的db_name=‘yqldb’

修改後正常：

connected to auxiliary database: yqldb (not mounted)

<b>2 監聽方面的問題：</b>

# listener.ora network configuration file: /opt/oracle/10.2.0/orcl/network/admin/listener.ora

# generated by oracle configuration tools.

sid_list_listener =

  (sid_list =

    (sid_desc =

      (sid_name = plsextproc)

      (oracle_home = /opt/oracle/10.2.0/orcl)

      (program = extproc)

    )

      (global_name = plsextproc)

      (sid_name = yqldb)

  )

listener =

  (description_list =

    (description =

      (address = (protocol = ipc)(key = extproc1))

      (address = (protocol = tcp)(host = 127.0.0.1 )(port = 1521))

oracle@yangdb1:/opt/oracle/10.2.0/orcl/network/admin&gt;lsnrctl status

lsnrctl for linux: version 10.2.0.1.0 - production on 17-aug-2011 17:38:44

copyright (c) 1991, 2005, oracle.  all rights reserved.

connecting to (description=(address=(protocol=ipc)(key=extproc1)))

tns-12541: tns:no listener

 tns-12560: tns:protocol adapter error

  tns-00511: no listener

   linux error: 111: connection refused

connecting to (description=(address=(protocol=tcp)(host=127.0.0.1)(port=1521)))

修改 (global_name = plsextproc)為 (global_name = yqldb)

問題解決

oracle@yangdb1:/opt/oracle/10.2.0/orcl/dbs&gt;lsnrctl status

lsnrctl for linux: version 10.2.0.1.0 - production on 17-aug-2011 17:43:01

status of the listener

------------------------

alias                     listener

version                   tnslsnr for linux: version 10.2.0.1.0 - production

start date                17-aug-2011 17:42:30

uptime                    0 days 0 hr. 0 min. 31 sec

trace level               off

security                  on: local os authentication

snmp                      off

listener parameter file   /opt/oracle/10.2.0/orcl/network/admin/listener.ora

listener log file         /opt/oracle/10.2.0/orcl/network/log/listener.log

listening endpoints summary...

  (description=(address=(protocol=ipc)(key=extproc1)))

  (description=(address=(protocol=tcp)(host=127.0.0.1)(port=1521)))

services summary...

service "plsextproc" has 1 instance(s).

  instance "plsextproc", status unknown, has 1 handler(s) for this service...

service "yqldb" has 1 instance(s).

  instance "yqldb", status unknown, has 1 handler(s) for this service...

the command completed successfully