Heim  >  Artikel  >  Datenbank  >  oracle数据库备份

oracle数据库备份

WBOY
WBOYOriginal
2016-06-07 17:45:53949Durchsuche

oracle备份
我把"d:oracleoradata"里的数据库文件夹和"d:oracleadmin"中的数据库文件夹从机器a复制到机器b中对应的文件夹,然后改了listener.ora、tnsnames.ora文件
listener.ora文件为

# listener.ora network configuration file: d:oracleora92networkadminlistener.ora
# generated by oracle configuration tools.

listener =
  (description_list =
  (description =
  (address_list =
  (address = (protocol = ipc)(key = extproc0))
  )
  (address_list =
  (address = (protocol = tcp)(host = wangpei)(port = 1521))
  )
  )
  )

sid_list_listener =
  (sid_list =
  (sid_desc =
  (sid_name = plsextproc)
  (oracle_home = d:oracleora92)
  (program = extproc)
  )
  (sid_desc =
  (global_dbname = jiegou)
  (oracle_home = d:oracleora92)
  (sid_name = jiegou)
  )
  (sid_desc =
  (global_dbname = jiegou2)
  (oracle_home = d:oracleora92)
  (sid_name = jiegou2)
  )
  )


tnsnames.ora文件

# tnsnames.ora network configuration file: d:oracleora92networkadmintnsnames.ora
# generated by oracle configuration tools.

jiegou =
  (description =
  (address_list =
  (address = (protocol = tcp)(host = wangpei)(port = 1521))
  )
  (connect_data =
  (service_name = jiegou)
  )
  )

inst1_http =
  (description =
  (address_list =
  (address = (protocol = tcp)(host = wangpei)(port = 1521))
  )
  (connect_data =
  (server = shared)
  (service_name = modose)
  (presentation = http://hrservice)
  )
  )

extproc_connection_data =
  (description =
  (address_list =
  (address = (protocol = ipc)(key = extproc0))
  )
  (connect_data =
  (sid = plsextproc)
  (presentation = ro)
  )
  )

jiegou2 =
  (description =
  (address_list =
  (address = (protocol = tcp)(host = wangpei)(port = 1521))
  )
  (connect_data =
  (service_name = jiegou2)
  )
  )

其中jiegou2是我这边自己建的一个新数据库,应该不会有影响。
不过用plsql登录时报错ora-12500:tns:监听程序无法启动专用服务器进程
问题有两个:①按理说这种方法应该是没有问题的,估计是我没对应上oracle里的某个映射关系,不知道有没有人遇到我这种类似的问题,讨论讨论这种方法能不能做出来
②ora-12500这个错误我在网上也查了

Stellungnahme:
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn