Backup/Recovery Solution [message #75260] |
Sun, 01 September 2002 09:56 |
Lee Ming Soon
Messages: 6 Registered: August 2002
|
Junior Member |
|
|
Hi experts!!!!need help here....
I am given the responsibility to come out with the best solution for backup and recovery routine.
Core requuirements:
(1) High availability.
(2) Could not compromise any data lost.
(3) Database must be up 24 hours daily.
(4) Transactions insertion into database every seconds.
(5) Recovery must recover up to point of failure.
There is only one database server running 24 hours. And there is another backup server having the same hardware specs as the production database server.
My current database is set to NOARCHIVELOG.
I came across with these solutions:
(a) Imp/Exp
(b) RMAN
(c) Replication
Which method is best suites my environment described above? Please if possible attach with the requirement i need to do first to implement the method as well as simple step by step guide to set it up.
Thanks a lot!
|
|
|
|
Re: Backup/Recovery Solution [message #75280 is a reply to message #75260] |
Fri, 18 October 2002 07:01 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
None of tha above ( Except RMAN who can do it )
Set Ur master database in ARCHIVELOG
( Are U crazy to set it to NOARCHIVELOG ... u like to live in danger .. sure ! )
Use Ur second Server to build a standby database.
( using RMAN or manually ). continue to do HOT BACKUP frequently and after all structural changes.
And Ur data will be safe !
|
|
|