| What is the ideal backup? (oracle 10gR2) [message #258517] |
Sun, 12 August 2007 23:12  |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello ALL,
The thread above: The ideal backup... how one can implement an ideal backup mechanism against maximum malware precaution.
I was thinking about this issue on oracle 10g environment. Then I listed some options that I would like to expose here and discuss together.
1) Using RMAN... backup "as copy"... datafiles,archivelog files, controlfiles and spfile/pfile... daily basis;
2) Using RMAN... implement automatic moving window of N-days... with full backup of last N-days plus incremental backups from the last N-days until now;
3) Besides RMAN backup (one of two modes above)... besides redundant retention policy... create a secondary server as backup server... and now I may have two additional possibilities:
a) use this secondary server as on-line replication of the primary server;
b) use this secondary server as a backup data repository and let it start on scenery when the primary fails and a dba recover the backup data and place this secondary on production mode.
Concerning 3a/3b... what are your opinion?
I was reading this article below and replication may not work on every cases.
http://www.orafaq.com/faq/what_questions_should_one_ask_before_implementing_advanced_replication
Thanks in advance for you attention.
mson77
|
|
|
|
|
|
| Re: What is the ideal backup? (oracle 10gR2) [message #258527 is a reply to message #258521] |
Mon, 13 August 2007 00:04  |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello Arju,
Thank you. I will try+follow your recommendation.
I will create an environment with 02 oracle 10gR2 servers configured with oracle streams and I will try to setup bi-directional data replication.
Before starting I will need to google to search for some initial directions, tips and documentations.
May I create 2 servers streams... with one running under windows and the other one running under linux(fedora7)? Also... do the both databases must be the same 10gr2 version?
Thank you again for your kind attention,
Regards,
mson77
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: What is the ideal backup? (oracle 10gR2) [message #258553 is a reply to message #258517] |
Mon, 13 August 2007 01:12 |
 |
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
|
Senior Member |
|
|
Re: What is the ideal backup? (oracle 10gR2) [message #258530 is a reply to message #258517 ] Sun, 12 August 2007 22:11
Arju
Messages: 257
Registered: June 2007
Location: Dhaka,Bangladesh. Senior Member add to buddy list
ignore all messages by this user
May I create 2 servers streams... with one running under windows and the other one running under linux(fedora7)?
Yes.
Also... do the both databases must be the same 10gr2 version?
Yes.
[Updated on: Mon, 13 August 2007 01:12] by Moderator Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: What is the ideal backup? (oracle 10gR2) [message #258707 is a reply to message #258582] |
Mon, 13 August 2007 07:36 |
mson77
Messages: 208
Registered: August 2007
Location: Brazil
|
Senior Member |
|
|
Hello ALL,
First of all I would not like to create such misunderstanding. I guess that the fault is mine. So, excuse me please.
As I said before, I am starting studying oracle and my concepts is not clear as it should be. I will try to not do such concepts mistake further.
Regarding this topic name... and the content of my first message I did confusion about backup concept and high availability concept. I guess that these 2 topics (backup/high availability) are neighbors but each one lives in its own home.
Conceptually I understand that streams is not a backup strategy. Why not? Because streams does not guarantee to recover some past state... I would not have necessary data to go back and provide such scenery. And... I understand that backed up data may allow me to provide this scenery depending on the backup strategy.
Also I understand that backups (and recovery) are made to bring system to such state before some accident/crash. And now... a streams solution may allow to still provide service using secondary server... while the main one (crashed one) is being fixed.
Well... further let's see from the good point of view. I guess this post... to the further readers may help to distinguish better between backup and high availability concepts.
As I wrote... I am studying oracle world... and please allow me to post my further doubts here in this thread.
Thanks for reading,
mson77
============= edited by mson77
And one may implement backup strategy on the main server and also on the secondary server... and both two server communication via streams. Is it possible? Or streams scenery replicates also RMAN tasks?
[Updated on: Mon, 13 August 2007 07:52] Report message to a moderator |
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
