Home » RDBMS Server » Backup & Recovery » beginner question about backup
beginner question about backup [message #220671] Wed, 21 February 2007 09:26 Go to next message
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
Re: beginner question about backup [message #220676 is a reply to message #220671] Wed, 21 February 2007 09:35 Go to previous messageGo to next message
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


Re: beginner question about backup [message #220677 is a reply to message #220671] Wed, 21 February 2007 09:35 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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

Re: beginner question about backup [message #220817 is a reply to message #220671] Thu, 22 February 2007 04:49 Go to previous message
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.
Previous Topic: RMAN Backup / Recovery
Next Topic: RMAN backup of archive log generated during backup
Goto Forum:
  


Current Time: Wed Dec 07 10:47:04 CST 2016

Total time taken to generate the page: 0.06850 seconds