remark set sql*plus variables to manipulate output
set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
remark set sql*plus user variables used in this script
define dir = 'd:\oracle\oradata\xg\backup'
define fil = 'D:\oracle\oradata\xg\backup\closed_backup_commands.sql'
prompt *** spooling to &fil
remark create a command file with file backup commands
spool &fil
select 'host copy '|| name ||' &dir' from v$datafile order by 1;
select 'host copy '|| member ||' $dir' from v$logfile order by 1;
select 'host copy '|| name ||' &dir' from v$controlfile order by 1;
select 'host copy '|| name ||' &dir' from v$tempfile order by 1;
spool off;
remark shutdown the databse cleanly
shutdown immediate;
remark run the copy file commands from the operating system
@&fil
remark start te database again
startup;
set feedback off heading off verify off trimspool off
set pagesize 0 linesize 200
remark set sql*plus user variables used in this script
define dir = 'd:\oracle\oradata\xg\backup'
define fil = 'D:\oracle\oradata\xg\backup\closed_backup_commands.sql'
prompt *** spooling to &fil
remark create a command file with file backup commands
spool &fil
select 'host copy '|| name ||' &dir' from v$datafile order by 1;
select 'host copy '|| member ||' $dir' from v$logfile order by 1;
select 'host copy '|| name ||' &dir' from v$controlfile order by 1;
select 'host copy '|| name ||' &dir' from v$tempfile order by 1;
spool off;
remark shutdown the databse cleanly
shutdown immediate;
remark run the copy file commands from the operating system
@&fil
remark start te database again
startup;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10742223/viewspace-211658/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/10742223/viewspace-211658/