| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cold Backup Script
Thomas probably just got carried away in responding, but I want to point
out that you do not need to backup the tempfiles. Part of the purpose
of Oracle creating the feature was so you do not have to back them up.
The feature saves backup run time and disk space since the Oracle rdbms
will recreate them every time the instance starts.
HTH -- Mark D Powell --
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Thomas Fox
Sent: Tuesday, November 01, 2005 1:50 PM
To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
Subject: Re: Cold Backup Script
Well, I cannot send you an entire script, but if you go into SQL*Plus,
you can
use:
sqlplus -S '/ as sysdba' <<-ENDSQL
spool files2backup.txt
select name from v\$datafile;
select name from v\$controlfile;
select member from v\$logfile;
select name from v\$tempfile;
spool off
exit
ENDSQL
to get the files. Then use a while loop to copy each file to a
particular
location:
cat files2backup.txt | while read line ; do
cp $line /var/opt/backup
done
Tom
> Does anyone have a cold backup script for 9i that they would be
> willing to send to me that is in Korn shell and copies files/backups
> to disk and then compresses the files?
> I just need something that can be quickly setup and run a couple of
times.
> I would really appreciate it. The OS is AIX.
>
> _________________________________________________________________
> Express yourself instantly with MSN Messenger! Download today - it's
FREE!
> http://messenger.msn.click-url.com/go/onm00200471ave/direct/01/
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 01 2005 - 13:27:07 CST
 |
 |