Home » Server Options » Replication » Backup/Recovery Solution
Backup/Recovery Solution [message #75259] Sun, 01 September 2002 09:51 Go to next message
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 #75263 is a reply to message #75259] Fri, 06 September 2002 02:55 Go to previous messageGo to next message
K.senthilkumar
Messages: 6
Registered: May 2002
Junior Member
Don't set your database as noarchivelog mode.
set your database as archivelogmode.
this will solve your needs.
Re: Backup/Recovery Solution [message #75264 is a reply to message #75259] Fri, 06 September 2002 02:58 Go to previous message
K.senthilkumar
Messages: 6
Registered: May 2002
Junior Member
Don't set your database as noarchivelog mode.
set your database as archivelogmode.
this will solve your needs.
Previous Topic: Snapshot status invalid
Next Topic: ORA-23375
Goto Forum:
  


Current Time: Fri Apr 19 00:24:56 CDT 2024