Cold Backup To Tape

[azman]

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

[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.

[azman]

[QUOTE][i]Originally posted by rotem_fo [/i]
[B]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.

[/B][/QUOTE]

Dear rotem_fo,

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
:))

[kenneth]

For the files not under ORACLE_HOME

use


tar -rvf 'another_directory/files* ' /dev/nrmt0h


Goodluck
Get back if Problems Persists,
Kenneth

[marist89]

How long it takes depends on the hardware (tapes, disk, network) involved.