Home » RDBMS Server » Backup & Recovery » Backup and Recovery strategy
Backup and Recovery strategy [message #237297] Mon, 14 May 2007 02:05 Go to next message
kamragulshan
Messages: 66
Registered: May 2005
Location: Delhi
Member
Hi All

I have 2 databases on Oracle 10g on solaris 9. Both the databases are in noarchive log mode and the size of databases is more than 1.5 GB each.
Now i have to make the backup strategy for the database and give the report to the management.

What are the important steps i should keep in mind for making the backup plan.

What are the other third party softwares available for this like RAID, veritas or any other.

If possible then please provide me the good link that help me make the backup and recovery plan.

Thanks in advance
Re: Backup and Recovery strategy [message #237347 is a reply to message #237297] Mon, 14 May 2007 03:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> Both the databases are in noarchive log mode
If these databases are of any worth, first turn the archivelogging on.
>>If possible then please provide me the good link that help me make the backup and recovery plan.
Documentation.
http://www.oracle.com/pls/db102/portal.portal_db?selected=4
Read all topics on backup.
Re: Backup and Recovery strategy [message #239344 is a reply to message #237347] Tue, 22 May 2007 01:34 Go to previous messageGo to next message
atif_arl
Messages: 15
Registered: May 2007
Junior Member
Please tell me that after taking backups of control, data and redo file including password and spfile ,
what i have to done to restore them.
Re: Backup and Recovery strategy [message #239531 is a reply to message #239344] Tue, 22 May 2007 10:44 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
just simply restore it..
copy all files to the same location if u have cold backup.
Previous Topic: Loss due to media failure
Next Topic: Hotbackup
Goto Forum:
  


Current Time: Fri Dec 06 23:08:33 CST 2024