script full backup offline dari sqlplus

set feedback off
set heading off
set verify off
set trimspool off
set pagesize 0
set linesize 200

define dir = '/..../.../..'
define fil = '/..../.../..'

prompt *** spooling to &fil

spool &fil
select 'host cp '|| name ||' &dir' from v$datafile order by 1;
select 'host cp '|| member ||' &dir' from v$logfile order by 1;
select 'host cp '|| name ||' &dir' from v$controlfile order by 1;
select 'host cp '|| name ||' &dir' from v$tempfile order by 1;
spool off;

shutdown immediate;
@fil
startup