RE: Begin backup fails sporadically

Hi,

I'm leaning towards parallel execution, now. I just haven't proven it yet. I now think it is merely a procedural problem with operations. I just haven't figured out what that "procedural problem" is...yet.

Thanks,
Kip Bryant

|Hi,

|You're problem might be that your backup software is doing things
|in parallel. We use Omniback here and it happened here also.

|Hth,

|Jeroen

|-----Oorspronkelijk bericht-----
|Van: Peter Gram [mailto:peter.gram_at_miracleas.dk]
|Verzonden: vrijdag 26 april 2002 10:03
|Aan: Multiple recipients of list ORACLE-L
|Onderwerp: Re: Begin backup fails sporadically

|Hi Kip

|When you next time have this problem check the v$backup table to verify
|that the file is not in backup mode, if this is tha case you
|proberly have to log a iTAR with support.

|Kip.Bryant_at_Vishay.com wrote:

|>Version is 8.0.6.3.0
|>
|>I have several databases using the exact same set of generic backup
|scripts.
|>The script that puts all tablespaces into backup mode is generated
|>automatically and done correctly. Same is true for the script which takes
|all
|>the tablespaces out of backup mode. The problem I am facing is that when
|this
|>script is invoked, one (and only one) of these databases occasionally has
|>problems. Some tablespaces are successfully put into backup mode and some
|say
|>
|>ORA-01146: cannot start online backup - file 15 is already in backup
|>ORA-01110: data file 15: '< datafile name >'
|>
|>The only things that would make sense to me is if two of these scripts were
|>running in parallel or if the prior day had some weird problem. Neither of
|>these seem to be the case. The only thing that seems to straighten things
|out
|>is to runs these scripts manually.
|>
|>Ideas?
|>
|>Regards,
|>Kip Bryant
|>

|--

|/regards

|Peter Gram

|Mobil : +45 2527 7107
|Fax : +45 4466 8856

|Miracle A/S
|Kratvej 2
|2760 Måløv
|http://miracleas.dk

|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Peter Gram
| INET: peter.gram_at_miracleas.dk

|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing Lists
|--------------------------------------------------------------------
|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).
|--
|Please see the official ORACLE-L FAQ: http://www.orafaq.com
|--
|Author: Jeroen van Sluisdam
| INET: jeroen.van.sluisdam_at_vrijuit.nl

|Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
|San Diego, California -- Public Internet access / Mailing Lists
|--------------------------------------------------------------------
|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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Kip.Bryant_at_Vishay.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).