Re: Table recovery from RMAN backup

er 9i). I heard some positive comments about Robert Freeman's book. Thanks Sami Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity

Re: Table recovery from RMAN backup

m this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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

Re: Configuring Veritas Netbackup Question

ssful after sbtwrite sbtinfo successful file osmtab01.dbf is on volume 520102 sbtopen for input successful file was created by this program; seed=3079447437, bufsize=16384, bufcount=100 sbtread successful, read 100 buffers sbtclose successful after sbtread sbtremove successful *** The SBT API test was

RE: 10046 level 8 trace - help required with 'direct path

Hi John, don't know other than what you have speculated on. We would have to have more info to investigate further. Andy Rivenes [EMAIL PROTECTED] At 10:39 AM 10/30/2003 -0800, you wrote: Tim, As you have seen, this is due to writes to and reads from the TEMPORARY tablespace of that user.

Re: RMAN: SVR4 Error: 27: File too large

d I assume that you don't have any datafiles larger the 2GB as well. Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

Re: 10046 level 8 trace - help required with 'direct path

Looks sort spillage to disk due to the where clause. Andy Rivenes [EMAIL PROTECTED] At 06:44 AM 10/30/2003 -0800, Tim Onions wrote: Gurus I've applied many of the things I've learnt from this list over the years and today I tried a 10046 trace for the first time on a reported "sl

RE: full recovery

ore than one backup piece in # the backup set (which only happens if the RMAN command set limit kbytes is used), then # repeat the restorebackuppiece statement for each backup piece in the backup set. END; / After you have successfully restored the control file, you can mount the database and per

RE: download metalink articles - save target as

And easier way is to use a Netscape browser and the "Save Frame As..." option. Andy Rivenes At 04:24 AM 9/23/2003 -0800, Boivin, Patrice J wrote: The grueling method is... grab the header, copy paste it into notepad.exe. That strips the weird formatting out of it. Grab the body tex

Re: How to find the session holding the library cache pin.

u may also send the HELP command for other information (like subscribing). Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: strange library cache lock/ping wait event

You can try this script and see if it works for your situation. We had an elusive problem like this that we were able to gain more information about using this query: -- FILE: libcache_lock.sql -- -- AUTHOR: Andy Rivenes -- -- DATE: 01/22/2003 -- -- DESCRIPTION: -- Query to

Re: Oracle E-Business Suit 11 i /Oracle Financials upgrade to

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). Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official OR

Re: Script to check for errors

ts something to run "often", but only email when an error is found. I've got something that does a bit of that and runs twice a day, but always sends out. Thanks. Maks. Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Auth

Re: v$sqlarea & v$session

ring from a senior moment. The question is at the every bottom. So exactly how do I join V$SQLAREA to V$SESSION? Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services--

RE: ``SQL*Net message to client`` Wait event with no SQL*Net

asn't the only one laboring under that misapprehension :) Jay Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: access to oracle $ tables in 9.2.0

ROTECTED] We have enough youth. How about a fountain of intelligence? Andy Rivenes Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andy Rivenes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: RMAN Reporting?

some trending analysis and was expecting that I could get this info out of the RMAN tables but it's looking like that's just wishful thinking. -w Andy Rivenes [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Rivenes INET: [EMAIL PROTE