Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > Re: ufsdump out...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 3 Topic 6951 of 7280
Post > Topic >>

Re: ufsdump output from oracle

by wodenic <wodenic@[EMAIL PROTECTED] > Jun 17, 2008 at 09:57 PM

On Mon, 16 Jun 2008 09:48:59 -0700 (PDT), joel garry
<joel-garry@[EMAIL PROTECTED]
> wrote:

>On Jun 16, 12:01 am, VDK <vdk...@[EMAIL PROTECTED]
> wrote:
>> Hello,
>>
>> Recently we installed Oracle Enterprise Manager. We keep the processes
>> of this tool running (so we didn't stop them with emctl), but shutdown
>> the databases because we wanted to know what kind of messages were
>> generated and what the effect would be on ufsdump. Ufsdump didn't
>> complain.
>> During the last full backup however we received the following output.
>> 19570o(oracle)   10884o(oracle)    5627c(root)   25359o(oracle)
>>
>> Actually there were more lines, but the pattern is the same
>> <number><letter>(<user>). We checked the backup and all the Oracle
>> files we expected, were present on the tape. So it seems that the
>> output is informational and does not indicate a problem.
>> But we want to know were this output comes from and what it means.
>> Anyone any idea?
>> Oracle version: 10.2
>>
>> Thanks.
>>
>> Peter
>
>I'm not on Solaris, so I really don't know.  But I'd be willing to
>guess those are process ID's that have open files.  I think ufsdump
>just copies whatever is in the file, so if there is some buffer
>information that hasn't been written, you may not be backing up the
>correct information.  Would those files/processes be the em you didn't
>shut down?  Do you think restoring an improperly backed up file would
>be a good idea?  You might try seeing which open files correspond to
>processes listed.  Getting an incomplete log file may be a bit
>confusing on a restore, but other files may be more im****tant.
>
>It may also help to say the entire version of Oracle and the operating
>system you are on.
>
>Note that the Oracle DB itself has options to back up while it is
>open, you can alter tablespaces specifically for this, so it knows
>what to do when you restore/recover.  I wouldn't know about all this
>newfangled open source stuff.
>
>jg

Thats the output of:   fuser -c <filesystem>
Its very handy for finding process with open filehandle in a specified
filesystem.

The output you  see are indeed process ids
the format of the output is pid status(user)
so given the above output 

19570o(oracle)   10884o(oracle)    5627c(root)   25359o(oracle)

o - open files
c- current directory 

check the man page for more info..

Wodenics
 




 3 Posts in Topic:
ufsdump output from oracle
VDK <vdkamp@[EMAIL PRO  2008-06-16 00:01:40 
Re: ufsdump output from oracle
joel garry <joel-garry  2008-06-16 09:48:59 
Re: ufsdump output from oracle
wodenic <wodenic@[EMAI  2008-06-17 21:57:38 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:13:33 CST 2008.