Printable View
Dear All,
I need help on getting cold backup script to tape (tar command, if possible).
I am running ORACLE 7.3 on Digital (COMPAQ) UNIX 4.0D. My database is big because I am running a continuous batch processing of an electronic payment system. My transaction table has more that 50 million records and it is expanding at a rate of 7 to 8 million records per month.
I am planning to do my backup every nite.
Pls help.
Cheers
1. shutdown Oracle (use dbshut)
2. use: tar -cvf /$ORACLE_HOME/oradata /dev/nrmt0h
3. startup oracle.
you can add ">> report.log" at the end of the tar line to create a log file.
Dear rotem_fo,Quote:
Originally posted by rotem_fo
1. shutdown Oracle (use dbshut)
2. use: tar -cvf /$ORACLE_HOME/oradata /dev/nrmt0h
3. startup oracle.
you can add ">> report.log" at the end of the tar line to create a log file.
Thanks for the info. However, my db files are located at different places. How do I tar all this files at once and in your opinoin how long will the tar process if my db is about 23GB in size?.
Cheers
:))
For the files not under ORACLE_HOME
use
tar -rvf 'another_directory/files* ' /dev/nrmt0h
Goodluck
Get back if Problems Persists,
Kenneth
How long it takes depends on the hardware (tapes, disk, network) involved.