Home » RDBMS Server » Backup & Recovery » What is the ideal backup? (oracle 10gR2)
What is the ideal backup? (oracle 10gR2) [message #258517] Sun, 12 August 2007 23:12 Go to next message
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 #258521 is a reply to message #258517] Sun, 12 August 2007 23:38 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

According to me anyone you can follow. The more feature you will add , the more possibility you will get rid of failure.
And about "Advanced Replication" . It is obsolete. Use Oracle Streams for replication.
Re: What is the ideal backup? (oracle 10gR2) [message #258527 is a reply to message #258521] Mon, 13 August 2007 00:04 Go to previous messageGo to next message
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 #258530 is a reply to message #258517] Mon, 13 August 2007 00:11 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

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.
Re: What is the ideal backup? (oracle 10gR2) [message #258531 is a reply to message #258517] Mon, 13 August 2007 00:13 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
IMO,
STREAMS is NOT a backup strategy.
If this advice is viable/realistic, then those proposing it should be able to post a working exmaple in less than a day.
Otherwise with free advice, your get what you paid for it.

HAND!

Rhetorical question -
where is STREAMS discussed here?
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/index.htm#S

[Updated on: Mon, 13 August 2007 00:14] by Moderator

Report message to a moderator

Re: What is the ideal backup? (oracle 10gR2) [message #258533 is a reply to message #258517] Mon, 13 August 2007 00:16 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

STREAMS is NOT a backup strategy.


Who told here that STREAMS is a backup strategy.
Re: What is the ideal backup? (oracle 10gR2) [message #258535 is a reply to message #258517] Mon, 13 August 2007 00:26 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Arju said at Sun, 12 August 2007 21:38
in response to question about "What is the ideal backup?"
Use Oracle Streams for replication. 
Re: What is the ideal backup? (oracle 10gR2) [message #258537 is a reply to message #258517] Mon, 13 August 2007 00:31 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

I don't want to quarrel with you. Can you make one more review about questioner requirement?

a) use this secondary server as on-line replication of the primary server;


Concerning 3a/3b... what are your opinion?
I was reading this article below and replication may not work on every cases.
Re: What is the ideal backup? (oracle 10gR2) [message #258540 is a reply to message #258517] Mon, 13 August 2007 00:45 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
Arju,
Is STREAMS a viable backup stragegy or not?
Your post of Sun, 12 August 2007 22:11 encouraged OP into pursuing STREAMS as backup strategy.
If STREAMS is viable, then produce working solution.
If STREAMS is not viable then stop telling folks it is.
Re: What is the ideal backup? (oracle 10gR2) [message #258543 is a reply to message #258517] Mon, 13 August 2007 00:56 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Your post of Sun, 12 August 2007 22:11 encouraged OP into pursuing STREAMS as backup strategy.


Where you got this information?

Timezone is different from you than here.
Re: What is the ideal backup? (oracle 10gR2) [message #258553 is a reply to message #258517] Mon, 13 August 2007 01:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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 #258562 is a reply to message #258517] Mon, 13 August 2007 01:32 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

No Message Body

[Updated on: Mon, 13 August 2007 01:37]

Report message to a moderator

Re: What is the ideal backup? (oracle 10gR2) [message #258572 is a reply to message #258517] Mon, 13 August 2007 01:53 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
No Message Body
[Updated on: Sun, 12 August 2007 23:37]

Arju,
Is STREAMS a viable backup stragegy or not?
Your post of Sun, 12 August 2007 22:11 encouraged OP into pursuing STREAMS as backup strategy.
If STREAMS is viable, then produce working solution.
If STREAMS is not viable then stop telling folks it is.

Please tell us what you really mean.
Re: What is the ideal backup? (oracle 10gR2) [message #258578 is a reply to message #258572] Mon, 13 August 2007 02:01 Go to previous messageGo to next message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Hey men, this topic is now incomprehensible.
Some posts are emptied, some are modified, we don't understand what's inside.

I suggest OP restarts 2 new topics one for the backup part and one for the replication/standby part.

Regards
Michel
Re: What is the ideal backup? (oracle 10gR2) [message #258582 is a reply to message #258517] Mon, 13 August 2007 02:04 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Michel , I don't want to quarrel with Ana. But I don't understand what Ana trying to indicate. You review this topic and see where he is getting "Streams as backup strategy." I just answered in against questioner quote.
Re: What is the ideal backup? (oracle 10gR2) [message #258707 is a reply to message #258582] Mon, 13 August 2007 07:36 Go to previous messageGo to next message
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

Re: What is the ideal backup? (oracle 10gR2) [message #258835 is a reply to message #258707] Mon, 13 August 2007 11:40 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Hi Mson,

As you are new to Oracle I will recommened you to start from ORACLE BACKUPS (user managed and server managed) and when you used to it then keep trying for REPLICATIOn,STREAMS,DATAGUARD,RAC and what ever you want.


Start from here

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/toc.htm
Re: What is the ideal backup? (oracle 10gR2) [message #258840 is a reply to message #258835] Mon, 13 August 2007 11:46 Go to previous messageGo to next message
mson77
Messages: 208
Registered: August 2007
Location: Brazil
Senior Member
Hello DreamzZ,

Thank you very much.
I will follow your recommendation.
Sorry for any inconvenience here.
Regards,

mson77
Re: What is the ideal backup? (oracle 10gR2) [message #258842 is a reply to message #258840] Mon, 13 August 2007 11:47 Go to previous message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Oh No Problem Man.


These guys BLOOD is too hot Wink
Previous Topic: Automatic or Managed Recovery
Next Topic: wat is using backup controlfile option
Goto Forum:
  


Current Time: Sun Dec 11 02:01:11 CST 2016

Total time taken to generate the page: 0.08003 seconds