Oracle-L: RE: where does omniback generates log of backup ?

From: Nelson, Allan <anelson_at_midf.com>
Date: Thu, 31 Jul 2003 11:34:27 -0800
Message-ID: <F001.005C805E.20030731113427@fatcity.com>

So ya wanna do a little omniback eh?

Omnidb -rpt -last gets you all yesterday's backup sessions.

What you will see here depends on how your shop decided to setup backups. Filesystem is one way. Basically omniback backs you up mount point by mount point. Host based is the other way. Backup the whole machine in one "session". Sessions will look like 2003/07/31-1 and the trailing digit will increment for sessions.

And now that you have your sessions

Omnidb -filesystem {your fqdn:/your-dir 'your label'} -session {from previous command} -listdir {your-dir} gets you a list of files

Here's an example for this one:
Omnidb -filesystem mshpx.corp.fred.com:/d01 'prod-daily' -session 2003/01/16-3 -listdir /d01/prod would work if your daily backup was called prod-daily and you wanted to look at a subdirectory named prod of a mount point named /d01 you were backing up.

Omnidb -session {see above} -detail gets the list of filesystems backed up

Omnidb -filesystem {see above} gets you the list of all sessions that contain the filesystem

Omnidb -session {see above} -media shows the tapes in that session

Omnidb -session {see above} -report warning gets the whole list of errors for that session

Omnidb -filesystem {see abov} -session {see above} -catalog shows ls -lR listing of files

That 'your label' thing is easiest to get from xomni or the windows variant. It will be basically whatever you decided to name your backup 'prod-daily' is one from our shop. Note the quotes are required. There is quite a bit more to the omnidb command but if you are using the filesystem method of backup this will get you enough to answer your questions or perhaps script a solution that checks the backups against the database (this is what we did). Nicely enough you don't even have to be root to execute this command.

Actually you wont loose your ability to recover if you loose that db. You could import the tapes, but you really, really wouldn't want to unless you have an exceptionally boring life. A good backup scheme will backup the omnidb daily too.

Allan

-----Original Message-----
Sent: Thursday, July 31, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L

Without a platform, version or other info, it's hard to say. On an HP/UX 11.0 machine running Omniback II vA.04.10, at least, you can look thru "man omniintro" to find the location of log files. However, those logs don't generally contain what was backed up. That's stored in the Omniback database. You really need to RTFM before messing with this stuff. You lose your recovery if you lose that DB.

"xomni" has a GUI with a friendlier interface than most of the command-line utils.

Rich Jesse                           System/Database Administrator 
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

-----Original Message-----
Sent: Thursday, July 31, 2003 12:44 PM
To: Multiple recipients of list ORACLE-L
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).

This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nelson, Allan
INET: anelson_at_midf.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------