Link to home
Start Free TrialLog in
Avatar of hayub
hayub

asked on

Database Backup

I'm interested in taking the backups for the databases/tables which one has already created. I know the import and export capailities of Oracle Databse, but is there any other possible way....what is the role of Backup Manager tool which comes with the installation of Oracle 7 and how to turn on/off the Support Recovery Option in the database and how to control different modes like ARCHIVELOG and NOARCHIVELOG.....?
Avatar of Mark Geerlings
Mark Geerlings
Flag of United States of America image

If you can shut down the database, simply copy all of the database files (data, log, control and init) to another disk or back them up to tape, and you have a backup.

You should use archivelog mode.  This gives you the ability to recover up through the last successful commit prior to a disk crash, when there is a disk crash.  This assumes of course that you have the "archive_log_dest" set to a directory on a disk that does not have any Oracle tablespaces on it.  You also need to manage this "archive_log_dest" to back those files up to tape periodically, then delete them from disk to insure that this directory/drive always has some free space.

If you use archivelog mode, you can do hot backups (using Backup Manager, or Oracle Enterprise Manager, or third-party tools) without needing to shut the database down for a backup.
Avatar of tbcox
tbcox

You might want to look over your backup and recovery options as described in my white paper on the subject, which you will find at

http://www.geocities.com/tbcox23/bu_reco_wp_12.pdf

Or in MS Word format at

http://www.geocities.com/tbcox23/bu_reco_whitepaper_1_2.doc

This includes a script for creating a cold backup on Windows NT.  You can modify it for Unix.

Good luck.
 -Tom
ADMINISTRATION WILL BE CONTACTING YOU.  THIS IS BEING POSTED IN ALL YOUR OPEN QUESTIONS TODAY.

This question appears to have been abandoned. Your options are:
 
1. Accept a Comment As Answer (use the button next to the Expert's name).
2. Close the question if the information was not useful to you. You must tell the participants why you wish to do this, and allow for Expert response.
3. Ask Community Support to help split points between participating experts, or just comment here with details and we'll respond with the process.
4. Delete the question. Again, you must tell the other participants why you wish to do this.

For special handling needs, please post a zero point question in the link below, include the question QID/link.
https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
 
Please click this Help Desk link for Member Guidelines, Member Agreement and the Question/Answer process:  Click you Member Profile to view your question history and keep them all current with updates as the collaboration effort continues.
https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp

To view your open questions, please click the following link(s) and keep them all current with updates.
https://www.experts-exchange.com/questions/Q.11756459.html
https://www.experts-exchange.com/questions/Q.11966818.html
https://www.experts-exchange.com/questions/Q.20002985.html
https://www.experts-exchange.com/questions/Q.20080116.html
https://www.experts-exchange.com/questions/Q.20117054.html
https://www.experts-exchange.com/questions/Q.20136568.html
https://www.experts-exchange.com/questions/Q.20141808.html
https://www.experts-exchange.com/questions/Q.20170683.html
https://www.experts-exchange.com/questions/Q.20177412.html
https://www.experts-exchange.com/questions/Q.20192197.html
https://www.experts-exchange.com/questions/Q.20211088.html
https://www.experts-exchange.com/questions/Q.20244652.html
https://www.experts-exchange.com/questions/Q.20245681.html
https://www.experts-exchange.com/questions/Q.20250442.html
https://www.experts-exchange.com/questions/Q.20259920.html
https://www.experts-exchange.com/questions/Q.20263344.html
https://www.experts-exchange.com/questions/Q.20272565.html
LOCKED AWAITING ACCEPTANCE
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20254380
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20170530
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20156898
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20073456
https://www.experts-exchange.com/jsp/qShow.jsp?ta=oracle&qid=20015528


PLEASE DO NOT AWARD THE POINTS TO ME.  
 
------------>  EXPERTS:
 
Please leave any comments regarding this question here on closing recommendations if this item remains inactive another three days.
 
Thank you everyone.
 
Moondancer
Moderator @ Experts Exchange


P.S.  For year 2000 questions, special attention is needed to ensure the first correct response is awarded, since they are not in the comment date order, but rather in Member ID order.
My request has been ignored, even though Asker logged in 3/8/02 and Administration contacted them.

Is the Proposed Answer correct so I can close this?

Moondancer - EE Moderator
Zero response at all?  Is anyone still here?
Moondancer - EE Moderator
No, my answer really doesn't cover the ground of the question he asked.  You can close the question if you like, but don't give me the points -- I haven't earned them.

 -Tom
ASKER CERTIFIED SOLUTION
Avatar of Moondancer
Moondancer

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial