-
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
-
Answer
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.
-
Re: Answer
[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
:))
-
tar
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|