数据库冷备份需要备份的文件

host mkdir -p /oracle/oradata/db01bak

set line 200
set pagesize 2000
select 'cp ' || name || ' /oracle/oradata/db01bak' from v$datafile
union all
select 'cp ' || name || ' /oracle/oradata/db01bak' from v$tempfile
union all
select 'cp ' || member || ' /oracle/oradata/db01bak' from v$logfile
union all
select 'cp ' || name || ' /oracle/oradata/db01bak' from v$controlfile
union all
select 'cp ' || value || ' /oracle/oradata/db01bak' from v$parameter where name='spfile'
union all
select 'cp /oracle/app/oracle/product/11.2.0/dbs/orapwdb01' || ' /oracle/oradata/db01bak' from dual
union all
select 'cp /oracle/app/oracle/product/11.2.0/network/admin/listener.ora' || ' /oracle/oradata/db01bak' from dual
union all
select 'cp /oracle/app/oracle/product/11.2.0/network/admin/tnsnames.ora' || ' /oracle/oradata/db01bak' from dual;

--06.密码文件：
/oracle/app/oracle/product/11.2.0/dbs/orapwdb01
--07.监听配置文件：
--/oracle/app/oracle/product/11.2.0/network/admin/listener.ora
--/oracle/app/oracle/product/11.2.0/network/admin/tnsnames.ora

02.关库
03.拷文件
04.启动