ORACLE冷备脚本和listener主动监听配置

来源：互联网发布：淘宝店取名字大全编辑：程序博客网时间：2024/05/05 08:43

在该脚本执行前需要配置Listener主动监听,不然Oracle会报"ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务"错误:

本文Oracle安装与D盘,环境为windows 2K3 + Oracle10G R2 sid=orcl

打开D:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/listener.ora;

添加如下代码:    (SID_DESC =
                                (GLOBAL_DBNAME = ORCL)
                                   (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
                               (SID_NAME = ORCL)
                                 )

完整文件为:

# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = D:/oracle/product/10.2.0/db_1)
      (SID_NAME = ORCL)
   )
)

LISTENER =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = win2003)(PORT = 1521))
    )
)

冷备脚本:

set pagesize 0 linesize 32767 feedback off verify off trimspool on trimout off trimout on serveroutput on
define fil=d:/cdbk.sql
define log=d:/cdbk.log
spool &fil
prompt connect sys/Oracle@orcl as sysdba;
prompt shutdown immediate;
select 'host copy ' ||file_name||' D:'||substr(file_name,instr(file_name,'/',-1,1)) from dba_data_files;
prompt startup;
spool off
spool &log
@&fil;
spool off