SEO

I have inherited some 8.1.7.4 databases on Windows from a new company
acquired. We have had the servers crash recently during the hot backup
processing. This means doing the ALTER DATABASE END BACKUP after
getting back to the command prompt before opening the database.

My Question: Has anyone been successfully at using a DATABASE event
trigger to fix this sort of thing without DBA intervention?

Basically, I would add code similar to the below to resolve.


SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 12 11:16:24 2005

(c) Copyright 2000 Oracle Corporation. All rights reserved.

ERROR:
ORA-01033: ORACLE initialization or shutdown in progress


REM - --------------------------------------------------------- -
REM - Find hot backup datafiles that are active after crash -
REM - Also, create script to resolve issue after database mount -
REM - JAW - 03-03-2003 -
REM - --------------------------------------------------------- -

SELECT V1.FILE#, NAME
FROM V$BACKUP V1, V$DATAFILE V2
WHERE V1.STATUS = 'ACTIVE' AND V1.FILE# = V2.FILE# ;

set heading off
set feedback off
set linesize 150

SPOOL c:\temp\end_backup.sql

prompt set heading on
prompt set feedback on

SELECT 'ALTER DATABASE DATAFILE ''' || NAME || ''' END BACKUP;'
FROM V$BACKUP V1, V$DATAFILE V2
WHERE V1.STATUS = 'ACTIVE' AND V1.FILE# = V2.FILE# ;

spool off

@c:\temp\end_backup.sql

alter database open;

Hi!
Has anyone konws how to get info on 10g streams init.ora configuration
parameters.

How to read 298877.1 on metalink, 10g Streams Recommended Configuration.

MetaLink V2 - Error Message
Note entry 298877.1.cannot be displayed. Possible reasons are:
a.. The article is not classified as publicly accessible
("non-public")
b.. The article's content is being updated and it is temporarily
unavailable but will be made available again soon.
c.. The article has been deleted from this serve r.
d.. The article number does not exist (it was referenced
incorrectly).
If you still have questions about why you couldn't access this
article, please use the Feedback button at the bottom of the left-hand menu
bar.



where can get information about it.

thanks

Gilbert BERNARD

On 12 Jul 2005 08:29:39 -0700, "JAW" <jwilliam@aglresources.com>
wrote:

>My Question: Has anyone been successfully at using a DATABASE event
>trigger to fix this sort of thing without DBA intervention?
>
>Basically, I would add code similar to the below to resolve.

Obviously, setting up such code would be completely undesirable.
Servers don't crash, and databases don't crash either.
You are administrating pain killers to a patient with terminal cancer!


--
Sybrand Bakker, Senior Oracle DBA

On Tue, 12 Jul 2005 17:51:45 +0200, "dbagilbert"
<dba_gilbert_bernard@yahoo.com> wrote:

>where can get information about it.

At Metalink?
Why don't you hit the feedback button?
Why do you post this question several times a day?
This is a volunteer group, and this doesn't include doing your work.


--
Sybrand Bakker, Senior Oracle DBA

JAW wrote:
> I have inherited some 8.1.7.4 databases on Windows from a new company
> acquired. We have had the servers crash recently during the hot backup
> processing. This means doing the ALTER DATABASE END BACKUP after
> getting back to the command prompt before opening the database.
>
> My Question: Has anyone been successfully at using a DATABASE event
> trigger to fix this sort of thing without DBA intervention?
>
> Basically, I would add code similar to the below to resolve.
>
>
> SQL*Plus: Release 8.1.7.0.0 - Production on Tue Jul 12 11:16:24 2005
>
> (c) Copyright 2000 Oracle Corporation. All rights reserved.
>
> ERROR:
> ORA-01033: ORACLE initialization or shutdown in progress
>
>
> REM - --------------------------------------------------------- -
> REM - Find hot backup datafiles that are active after crash -
> REM - Also, create script to resolve issue after database mount -
> REM - JAW - 03-03-2003 -
> REM - --------------------------------------------------------- -
>
> SELECT V1.FILE#, NAME
> FROM V$BACKUP V1, V$DATAFILE V2
> WHERE V1.STATUS = 'ACTIVE' AND V1.FILE# = V2.FILE# ;
>
> set heading off
> set feedback off
> set linesize 150
>
> SPOOL c:\temp\end_backup.sql
>
> prompt set heading on
> prompt set feedback on
>
> SELECT 'ALTER DATABASE DATAFILE ''' || NAME || ''' END BACKUP;'
> FROM V$BACKUP V1, V$DATAFILE V2
> WHERE V1.STATUS = 'ACTIVE' AND V1.FILE# = V2.FILE# ;
>
> spool off
>
> @c:\temp\end_backup.sql
>
> alter database open;

This has "bad idea" written all over it.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)