Home » RDBMS Server » Backup & Recovery » Disaster recovery set up
Disaster recovery set up [message #510981] Wed, 08 June 2011 15:34 Go to next message
patdev
Messages: 73
Registered: August 2008
Member
Hi all,

I have production server running 10.2.0.4 on Linux 64 bit. with NOARVHIVELOG. Now we got another server and need to develop disaster recovery process.

what is the best way to approach this matter? Please guide.. I am confuse about imp/export everday...

thanks
Re: Disaster recovery set up [message #510982 is a reply to message #510981] Wed, 08 June 2011 16:19 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
If you are concerned about losing data, your first step is to enable archivelog mode. Your second step is to understand that an export is not a backup.
Re: Disaster recovery set up [message #511004 is a reply to message #510982] Thu, 09 June 2011 01:02 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In one line all is said... /forum/fa/2115/0/

@OP, read
Database Backup and Recovery Basics

Regards
Michel
Re: Disaster recovery set up [message #511064 is a reply to message #511004] Thu, 09 June 2011 06:25 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
I understand that export is not a valid backup option but how can i get the data to new server and keep it realtime as the production server database?

Please guide.

thank
Re: Disaster recovery set up [message #511065 is a reply to message #511064] Thu, 09 June 2011 06:29 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Paraphrasing John Watson,
to achieve any of it, you first need the database in archivelog mode.
Then look into Oracle Dataguard.
Re: Disaster recovery set up [message #511067 is a reply to message #511064] Thu, 09 June 2011 06:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Use a standby database or Data Guard.
Or use disk array replication like EMC SRDF.

Regards
Michel

[Updated on: Thu, 09 June 2011 06:31]

Report message to a moderator

Re: Disaster recovery set up [message #511088 is a reply to message #511067] Thu, 09 June 2011 10:33 Go to previous messageGo to next message
patdev
Messages: 73
Registered: August 2008
Member
ok,

i agree that data guard will be good option after reading on it. also, after making the production database to archivelog mode. do i need to change anything on the production system?? Please i am new to that so forgive me asking questions.

thanks
Re: Disaster recovery set up [message #511089 is a reply to message #511088] Thu, 09 June 2011 10:39 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>do i need to change anything on the production system??
yes & it is documented in the Fine Manuals that you now need to READ!
Re: Disaster recovery set up [message #511095 is a reply to message #511088] Thu, 09 June 2011 10:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Please i am new to that so forgive me asking questions.

There is no problem to ask but you should first have the courtesy to click on the links we provide you and read them.

Regards
Michel
icon7.gif  Re: Disaster recovery set up [message #519491 is a reply to message #510981] Sat, 13 August 2011 01:26 Go to previous messageGo to next message
rbt007
Messages: 1
Registered: August 2011
Location: mumbai
Junior Member

First tell me,

1) What is Disaster recovery?
2) If no RMAN then, last option is IBM flash technology, but you will not recover point in time. There is some gap between them Shocked .

Re: Disaster recovery set up [message #519493 is a reply to message #519491] Sat, 13 August 2011 02:29 Go to previous message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
last option is IBM flash technology

Very bad option as the last one, you can use a simple OS copy and you can recover point in time.
So if you can't do it with the product you mentioned, you should better just forget it.

Regards
Michel
Previous Topic: Hello
Next Topic: unable to see tablespace name
Goto Forum:
  


Current Time: Sun Nov 24 07:19:35 CST 2024