Пример работал под Windows.
Делаем батник, ну или ручками в командной строке.
sqlplus /nolog @selfile.txt
Создаем файлик selfile.txt
@@users_info
CONNECT &DBA_USER/&DBA_USER_PASSWORD@&NET_SERVICE_NAME as sysdba
set serveroutput on
set trimspool on
set line 500
set head off
set feed off
spool backup.cmd
declare
copy_cmnd constant varchar2(30) := 'ocopy';
copy_dest constant varchar2(30) := 'C:\BACKUP\';
dbname varchar2(30);
logmode varchar2(30);
begin
select name, log_mode
into dbname, logmode
from sys.v_$database;
dbms_output.put_line('spool backup.'||dbname||'.'||
to_char(sysdate, 'ddMonyy')||'.log');
-- Control files:
for c1 in (select name
from v$controlfile)
loop
dbms_output.put_line('host '||copy_cmnd||' '||c1.name||' '||copy_dest);
end loop;
-- Datafiles:
for c1 in (select name
from v$datafile
order by name)
loop
dbms_output.put_line('host '||copy_cmnd||' '||c1.name||' '||copy_dest);
end loop;
-- Tempfiles
for c1 in (select name
from v$tempfile
order by name)
loop
dbms_output.put_line('host '||copy_cmnd||' '||c1.name||' '||copy_dest);
end loop;
-- Redo Log files
for c1 in (select member
from v$logfile
order by member)
loop
dbms_output.put_line('host '||copy_cmnd||' '||c1.member||' '||copy_dest);
end loop;
dbms_output.put_line('spool off');
end;
/
spool off
set head on
set feed on
set serveroutput off
shutdown immediate;
-- Unremark/uncomment the following line to run the backup script
@backup.cmd;
startup force;
exit;
Создаем файлик users_info.sql
--------------------------------------
-- ПАРАМЕТРЫ ДЛЯ СОЕДИНЕНИЯ С БАЗОЙ
--------------------------------------
DEFINE DBA_USER = sys
DEFINE DBA_USER_PASSWORD = a
DEFINE NET_SERVICE_NAME = vpahomov
У меня получился файл backup.cmd
spool backup.VPAHOMOV.08Сен06.log
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\CONTROL01.CTL C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\CONTROL02.CTL C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\CONTROL03.CTL C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\CWMLITE01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\DBWEB.ORA C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\DRSYS01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\EXAMPLE01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\INDX01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\ODM01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\SYSTEM01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\TOOLS01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\UNDOTBS01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\USERS01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\XDB01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\TEMP01.DBF C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\REDO01.LOG C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\REDO02.LOG C:\BACKUP\
host ocopy C:\ORACLE9\ORA92\ORADATA\VPAHOMOV\REDO03.LOG C:\BACKUP\
spool off