OraFAQ Forum: Backup & Recovery » beginner question about backup

Home » RDBMS Server » Backup & Recovery » beginner question about backup

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

beginner question about backup [message #220671]

Wed, 21 February 2007 09:26

ilico
Messages: 1
Registered: February 2007

Junior Member

hi folks,

my boss asked me why I do all this complicated update procedure e.g. rman, etc. instead of simple issuing "tar -cf $ORACLE_BASE/oracle" once a day.
I am sorry, but I really could not answer this question.
could you please help me?
otherwise I am afraid I will lose my job.

thank you. Embarassed

Report message to a moderator

Re: beginner question about backup [message #220676 is a reply to message #220671]

Wed, 21 February 2007 09:35

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,

Tar.
Backing up and recovering Linux files using the tar command

First ask one question to your boss. your company DATA is important for him or not. if not you should go with TAR.

TAR just a backup utility for linux.( tape archive).

For Oracle Database you have to use proper backup and recovery procedure.

In two method for Oracle Backup.
1.hot backup. >>>> 24x7 DATABASE
2.cold backup. >>>> IF YOU HAVE DOWNTIME.

You option for backup and recovery.
1.RMAN ( recovery manager) server managed backup.
2.User Managed backup ( alter table begin backup ... end backp.)

NOTE> CREATE PROPER BACKUP SCRIPT FOR YOUR DATABASE.

hope this helps
regards
Taj

Report message to a moderator

Re: beginner question about backup [message #220677 is a reply to message #220671]

Wed, 21 February 2007 09:35

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> "tar -cf $ORACLE_BASE/oracle" once a day.
If your "boss" can afford to shutdown database every day
can afford to loose all data that was entered by end of day
can afford more downtime if your database is large

Report message to a moderator

Re: beginner question about backup [message #220817 is a reply to message #220671]

Thu, 22 February 2007 04:49

cbruhn2
Messages: 41
Registered: January 2007

Member

Hi Ilico,

your boss doesn't know anything about oracle and backup if he asks such questions. SIC! Mad

The short version is that rman is a program for backing up Oracle databases, including datafiles, archived logs, controlfiles, initialization files in a CONSISTENT manner.
Tar doesn't know anything about Oracle (like your boss Laughing

)
It doesn't know how to find all files necessary for a Oracle backup, and even worse , if you run tar on open database files, you would not be able to restore that datafile and have it and running. The read of the datafile will not be consistent with the database when you read it with tar.
Rman handle all this. AND is supported by Oracle, tar isn't.
Why?
Because the backup program was written by people who know how to backup Oracle databases. At least thats what they are being paid for Cool

.
best regards.
Carl Bruhn.
AND KEEP USING RMAN. Otherwise it might be your boss that will loose his job.

Report message to a moderator

Previous Topic:	RMAN Backup / Recovery
Next Topic:	RMAN backup of archive log generated during backup

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 02 20:05:29 CDT 2024