Home » RDBMS Server » Backup & Recovery » Various Backup Methods (Oracle 10.2.0 RHEL 5)
Various Backup Methods [message #412132] Tue, 07 July 2009 22:33 Go to next message
linuxos
Messages: 31
Registered: April 2009
Member
Hi, what are the main difference between
1. Backup from OS
2. Backup using RMAN
3. Export all data with exp
4. Data Dump Export

I am not sure which should be used in certain situaion.

Report message to a moderator

Re: Various Backup Methods [message #412133 is a reply to message #412132] Tue, 07 July 2009 22:53 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
RMAN only viable Backup method.
Other are imposters

Report message to a moderator

Re: Various Backup Methods [message #412136 is a reply to message #412132] Tue, 07 July 2009 23:26 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
Do you mean RMAN can provide the fastest methods to do backup and recovery?

In what situation I must create Recovery Catalog for it?

Report message to a moderator

Re: Various Backup Methods [message #412139 is a reply to message #412132] Tue, 07 July 2009 23:33 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Do you mean RMAN can provide the fastest methods to do backup and recovery?
YES

>In what situation I must create Recovery Catalog for it?
Recovery Catalog should be 2nd separate DB.
Odds are you will not lose both Prod. DB & Recovery Catalog on separate system.

Report message to a moderator

Re: Various Backup Methods [message #412145 is a reply to message #412132] Wed, 08 July 2009 00:03 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
If for simple use, can I just use RMAN without Recovery Catalog?

Also, some administrators performs backup daily on OS level. Is the RMAN also used for recovery purpose (synchronized redo log, archived log)?

Report message to a moderator

Re: Various Backup Methods [message #412222 is a reply to message #412145] Wed, 08 July 2009 04:43 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
How bout reading some of the basics of RMAN:

* Backup and Recovery Advanced Users Guide
* Backup and Recovery Basics
* Backup and Recovery Reference

Report message to a moderator

Re: Various Backup Methods [message #412539 is a reply to message #412132] Thu, 09 July 2009 21:33 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
In my opinion, the OS level backup is required by company policy. DBA can't reject it.

The Data Dump or Export are on data level. Mostly the data are exported only specified schema.

The RMAN is good for recovery in case whole database (objects, data, control file, init file) is crashed. And all data (including system, sysaux) need to be recovered.

But I'm still thinking there are overlap situations between them.

Report message to a moderator

Re: Various Backup Methods [message #412541 is a reply to message #412132] Thu, 09 July 2009 22:37 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>In my opinion, the OS level backup is required by company policy. DBA can't reject it.
Please give example of how & what you'd do for OS level backup.

Above would be the equivalent for airline CEO telling pilot how to land crippled jet on the Hudson River.
Pointy Hair Boss should NOT be establishing implementation details; just uptime & recovery requirements.
Knowing how best to meet the requirements is why DBAs are well paid.

>The Data Dump or Export are on data level.
& imports are slower than molasses in January.

>The RMAN is good for recovery in case whole database is crashed.
In most cases a Oracle DB application is next to useless when any part is not available & therefore DB recovery is require.

>But I'm still thinking there are overlap situations between them.
So what else do you propose?

Report message to a moderator

Re: Various Backup Methods [message #412578 is a reply to message #412132] Fri, 10 July 2009 01:11 Go to previous messageGo to next message
linuxos
Messages: 31
Registered: April 2009
Member
Third party software backups whole oracle directory plus the data directory.

If their backup does not work, the backup from RMAN can be used to recover the data.

If the oracle software is corrupted, it will be reinstalled. And data from export can be imported into the database. I think the RMAN backup can be restored too, isn't it??

Report message to a moderator

Re: Various Backup Methods [message #412582 is a reply to message #412132] Fri, 10 July 2009 01:22 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
You are entitled to your delusions.
If they work, you are OK.
if not, you pay the price.

ENJOY!

Report message to a moderator

Previous Topic: problem restoring database
Next Topic: Trouble running RMAN script (merged)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 18 07:32:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.