Backup/Recovery Solution [message #75259] |
Sun, 01 September 2002 09:51 |
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!
|
|
|
|
|