在该脚本执行前需要配置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