topic Re: tar crashed oracle in Operating System - HP-UX

tar crashed oracle

CJENSEN_1 — Tue, 25 Feb 2003 22:59:10 GMT

I was doing a tar on my controlfiles and redo logs (as a test) while the database was running. It caused the database to crash. The alert log mentions a corrupt block relative... and so on. My question about TAR - does unix do something with the file during the TAR process that prevents Oracle from using the file? Just curious. We are using fbackup/frestore, but are looking at tar to do some incrementals.

Re: tar crashed oracle

Ross Zubritski — Tue, 25 Feb 2003 23:04:32 GMT

I appears that tar "locked" the control file. tar was never meant to be a "open file" backup solution.

Regards,

RZ

Re: tar crashed oracle

Patrick Wallek — Tue, 25 Feb 2003 23:16:27 GMT

As far as I know tar does not lock a file. It just reads it.

I was tar'ing up some files today and had a file change size while I was tar'ing it.

I would not really suspect tar. I suspect it may have just been a case of bad timing.

Re: tar crashed oracle

Ross Zubritski — Tue, 25 Feb 2003 23:18:38 GMT

Good info Patrick

Was the file that changed bin or ascii? I can see tar handling an ascii file on the fly, bin is another story.

Just my 2 cents.

RZ

Re: tar crashed oracle

Patrick Wallek — Tue, 25 Feb 2003 23:24:45 GMT

It was an binary file. In fact it was one of Measurewares data files in /var/opt/perf/datafiles/log*.

Re: tar crashed oracle

Ross Zubritski — Tue, 25 Feb 2003 23:26:26 GMT

Ah, the myteries of Oracle ;)~

Re: tar crashed oracle

Ross Zubritski — Tue, 25 Feb 2003 23:32:54 GMT

The plot thickens.. An oracle control file changes each time time SCN (transaction) number changes, this could be nanoseconds. The files in the perf directory changes based on the time you set for data collection, i.e. 5, 10.

Just my 2 cents once again,

Regards,

RZ

Re: tar crashed oracle

Patrick Wallek — Tue, 25 Feb 2003 23:38:34 GMT

That is true. I would still wonder if tar is the culprit here though.

I would be tempted to do a 'dd' on the disk that the LV is part of and see what happens. If it completes successfully, then maybe tar did do it. If not, you've got a disk going bad, which what I suspect.

Re: tar crashed oracle

Ross Zubritski — Tue, 25 Feb 2003 23:44:13 GMT

Excellent point sir.

Re: tar crashed oracle

Stan_17 — Wed, 26 Feb 2003 01:01:01 GMT

Hi,

Just curious, why would you want to backup redo logs when the databases are open. never backup online redologs during hotbackup, cuz you might restore the backed up redolog file on top of current redolog thereby losing all the redo's that are not yet archived or not being checkpointed and you end up in-complete recoveries.

do not tar controlfiles too...use 'alter database backup controlfile to backup_location;' also, have ascii version of it 'alter database backup controlfile to trace;'

Stan

Re: tar crashed oracle

A. Clay Stephenson — Wed, 26 Feb 2003 01:09:57 GMT

Assuming this was a tar reading these files, that should have not caused your problem. Tar and cpio do absolutely no file locking. I think this was a case of "I was running tar; Oracle crashed." The technical term for this is called "coincidence" rather than cause and effect.

Re: tar crashed oracle

Yogeeraj_1 — Wed, 26 Feb 2003 09:32:20 GMT

hi,

check the oracle alert.log. maybe you will have some clues about the crash there.

hope this helps!

Best Regards
Yogeeraj

Re: tar crashed oracle

John Jayaseelan — Wed, 26 Feb 2003 15:03:52 GMT

Hi,

I do not think tar will lock the file during the back or reason for the crash. Could be due to the oracle process. Better to check the log file for the further info.

John Jayaseelan

Re: tar crashed oracle

Steven E. Protter — Wed, 26 Feb 2003 16:10:40 GMT

tar should not have caused the problem, it does not lock the files.

Oracle may not have had the access level it wanted during the process, but this is probably an oracle problem.

You can not use fbackup for anything other than a cold, database down backup.

fbackup will try to lock the files on an open database, might hack oracle off and cause corruption. It will eventually fail to backup open database files resulting in error messages.

If you want to back up hot oracle databases, use rman. It comes with oracle and is a pretty useful and reliable tool.

You can also use omniback, over version 3.5 I think to get oracle 8.1.7 databaes. omniback also uses rman for oracle 8 backups.

If you choose this route, let me know, I can probably find and forward you a document on how to set up and use rman(I might have to mail it snail style it may only be here on paper)

If you mail, make the subject line relavent, I've been sick for two weeks and am nearly 100 emails behind schedule.
stevenprotter@juf.org
SEP

Re: tar crashed oracle

Raynald Boucher — Thu, 27 Feb 2003 12:19:18 GMT

Which was the exact tar command issued?

A bad tar command could cause Oracle to error. ex.:
tar -cvf control_file1 control_file2

would corrupt control_file1.

Re: tar crashed oracle

Colin Jensen — Thu, 27 Feb 2003 14:56:59 GMT

it was tav -cvf ... pls explain how this would corrupt it. Thanks.

Re: tar crashed oracle

Ian Lochray — Thu, 27 Feb 2003 15:09:59 GMT

In Raynald's example, control_file1 follows the "f" flag of the tar command so control_file1 would be the destination for the tar output. The example command would tar control_file2 into a tar image called control_file1, overwriting the control file.

Re: tar crashed oracle

TwoProc — Fri, 28 Feb 2003 23:36:47 GMT

The above posted message is right. The "c" in "cvf" means "create" and the "f" means "file" and the file you gave it was your control file. Basically, you turned your controlfile into a tarball. The correct syntax would have been "tar cvf /tmp/mynewtarfile.tar controlfile1 controlfile2". That would take both controlfile1 and controlfile2 and put them in the newlycreated file /tmp/mynewtarfile.tar.

Re: tar crashed oracle

Colin Jensen — Tue, 04 Mar 2003 14:18:08 GMT

It did create a .tar file, but also left the oracle files intact. Yes, the command entered was as in the last post.

Re: tar crashed oracle

CJENSEN_1 — Mon, 07 Mar 2005 15:01:31 GMT

Thanks