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.
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: 25046
Registered: January 2009
Location: SoCal
Senior Member
RMAN only viable Backup method.
Other are imposters
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?
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: 25046
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.

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)?
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
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.
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: 25046
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?
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??
Re: Various Backup Methods [message #412582 is a reply to message #412132] Fri, 10 July 2009 01:22 Go to previous message
BlackSwan
Messages: 25046
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!
Previous Topic: problem restoring database
Next Topic: Trouble running RMAN script (merged)
Goto Forum:
  


Current Time: Thu Dec 08 16:11:00 CST 2016

Total time taken to generate the page: 0.10731 seconds