Backup.sh ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ echo -------------- Generando script copia archivos | tee -a /ora_exports/exports/_backup_cold.log su - oracle -c "sqlplus -s \"/ as sysdba\" @/oracle/scripts/backup_cold.sql" | tee -a /ora_exports/exports/_backup_cold.log echo -------------- shutdown oracle | tee -a /ora_exports/exports/_backup_cold.log caa_stop oracle_orcl | tee -a /ora_exports/exports/_backup_cold.log sleep 30 echo -------------- Ejecutando copia de archivos | tee -a /ora_exports/exports/_backup_cold.log chmod +x /tmp/copy1.ksh /tmp/copy1.ksh | tee -a /ora_exports/exports/_backup_cold.log sleep 10 echo -------------- startup oracle | tee -a /ora_exports/exports/_backup_cold.log caa_start oracle_orcl | tee -a /ora_exports/exports/_backup_cold.log +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ /oracle/scripts/backup_cold.sql: set feed off pages 0 head off echo off line 250 trimspool on spool /tmp/copy1.ksh select ' cp -p '||file_name|| ' /ora_indices/cold_backup/' from sys.dba_data_files; select ' cp -p '||name ||' /ora_indices/cold_backup/' from v$controlfile; select ' cp -p '||member ||' /ora_indices/cold_backup/' from v$logfile; select ' cp -p '||name ||' /ora_indices/cold_backup/' from v$tempfile; spool off exit -----Mensaje original----- De: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] En nombre de Powell, Mark D Enviado el: martes, 01 de noviembre de 2005 20:24 Para: oracle-l@xxxxxxxxxxxxx Asunto: 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Thomas Fox Sent: Tuesday, November 01, 2005 1:50 PM To: cemail_219@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx 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 --- "J. Dex" <cemail_219@xxxxxxxxxxx> wrote: > 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/ > > -- > //www.freelists.org/webpage/oracle-l > > > __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l