Step 1: Create controlfile script
Alter database backup controlfile to trace;
Step 2: Get udump location
show parameter user_dump_dest
Step 3: Create shell script to make gzips of all dbf files.
Sqlplus ‘/ as sysdba’
Set head off;
Set line 200;
Spool cold_bkp.sh
select 'gzip -c ' || name || ' > /nfs/bld/d2/ABDB/abdbdb/bkup/’||name||'.gz' from v$datafile order by 1;
select 'gzip -c ' || MEMBER || ' > /nfs/bld/d2/ABDB/abdbdb/bkup/'||MEMBER||'.gz' from v$logfile order by 1;
select 'gzip -c ' || name || ' > /nfs/bld/d2/ABDB/abdbdb/bkup/'||name||'.gz' from v$controlfile order by 1;
select 'gzip -c ' || name || ' > /nfs/bld/d2/ABDB/abdbdb/bkup/'||name||'.gz' from v$tempfile order by 1;
spool off;
No comments:
Post a Comment