RESTORE TAPE BACKUP on unix

[Luis G. Reyes]

I want to test if my database backup on tape is reliable. Can someboy help guide me in the restoration of this backup?

[Torsten.]

Only if you tell us how you did this backup (commands/tools?) ...

;-)

[Luis G. Reyes]

echo "PLEASE MAKE SURE YOUR DATABASE IS DOWN, BEFORE PERFORMING THIS"
date
if [ X$1 != X ]; then
DBNAME=$1
export DBNAME
else
echo "The database name must be passed as a parameter"
exit
fi

# The database must be up for this to work
#
ERRCHK=`ps -fu oracle | grep $DBNAME |grep -c ora_`
if [ "$ERRCHK" != "0" ]; then
echo "Timestamp : `date` :THE DATABASE IS RUNNING, PLEASE SHUTDOWN THE DB BEFORE COLD BACKUP"
exit
fi

echo "COPYING SYSTEM FILE ................"


cp /u01/oracle/9.2/admin/philindo/pfile/initphilindo.ora /u05/backup/system/.
cp /u01/oracle/9.2/dbs/orapwphilindo /u05/backup/system/.
cp /u01/oracle/9.2/dbs/spfilephilindo.ora /u05/backup/system/.
cp /u01/oracle/9.2/oradata/philindo/system01.dbf /u05/backup/system/.
cp /u01/oracle/9.2/oradata/philindo/redo/redo*.log /u05/backup/system/.
cp /u01/oracle/9.2/network/admin/listener.ora /u05/backup/system/.
cp /u01/oracle/9.2/network/admin/tnsnames.ora /u05/backup/system/.
cp /u01/oracle/9.2/network/admin/snmp*.ora /u05/backup/system/.
cp /u01/oracle/9.2/network/admin/sqlnet.ora /u05/backup/system/.
cp /u04/oracle/9.2/oradata/philindo/control*.ctl /u05/backup/system/.

echo "SYSTEM FILES ALREADY COPIED"
echo ""
echo "NOW COPYING ATM TABLE SPACE.................."


cp /u04/oracle/9.2/oradata/philindo/atm/atm*.dbf /u05/backup/atm/.


echo "NOW COPYING FGWIPA TABLE SPACE.................."

cp /u04/oracle/9.2/oradata/philindo/fgwipa/fgwipa*.dbf /u05/backup/fgwipa/.

echo "NOW COPYING FGWIPC TABLE SPACE.................."


cp /u04/oracle/9.2/oradata/philindo/fgwipc/fgwipc*.dbf /u05/backup/fgwipc/.

echo "NOW COPYING FGWIPT TABLE SPACE.................."



cp /u04/oracle/9.2/oradata/philindo/fgwipt/fgwipt*.dbf /u05/backup/fgwipt/.


echo "NOW COPYING GENDB TABLE SPACE.................."



cp /u04/oracle/9.2/oradata/philindo/gendb/gendb*.dbf /u05/backup/gendb/.

echo "NOW COPYING GLIPC TABLE SPACE.................."



cp /u04/oracle/9.2/oradata/philindo/glipc/glipc*.dbf /u05/backup/glipc/.

echo "NOW COPYING QUALITY TABLE SPACE.................."



cp /u04/oracle/9.2/oradata/philindo/quality/quality*.dbf /u05/backup/quality/.

echo "NOW COPYING RAWMAT TABLE SPACE.................."



cp /u04/oracle/9.2/oradata/philindo/rawmat/rawmat*.dbf /u05/backup/rawmat/.

echo "NOW COPYING STORESIPA TABLE SPACE.................."


cp /u04/oracle/9.2/oradata/philindo/storesipa/storesipa*.dbf /u05/backup/storesipa/.

echo "NOW COPYING STORESIPC TABLE SPACE.................."


cp /u04/oracle/9.2/oradata/philindo/storesipc/storesipc*.dbf /u05/backup/storesipc/.


echo "NOW COPYING STORESIPT TABLE SPACE.................."


cp /u04/oracle/9.2/oradata/philindo/storesipt/storesipt*.dbf /u05/backup/storesipt/.

echo "NOW COPYING STORESPP TABLE SPACE.................."


cp /u04/oracle/9.2/oradata/philindo/storespp/storespp*.dbf /u05/backup/storespp/.


echo "NOW PUTTING INTO TAPE.................."

tar cv /u05/backup/.

echo "THANKS"
date

[Luis G. Reyes]

i just use tar command.