Re: Oracle Shutdown Fails

On 30 Jun 1998 06:45:04 GMT, Matthias Gresz <GreMa_at_t-online.de> wrote:
>Hi,
>
>for a cold backup use this:
>
>SHUTDOWN IMMEDIATE;
I don't understand how this will work if it is hanging on shutdown immediate.

>STARTUP RESTRICT; -- instance recovery
>ALTER SYSTEM SWITCH LOGFILE; -- number of log groups times to "empty"
> -- online logs
>ALTER SYSTEM SWITCH LOGFILE;
>ALTER SYSTEM SWITCH LOGFILE;
>ALTER SYSTEM SWITCH LOGFILE;
>ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
>SHUTDOWN;
>
>
>JHY schrieb:
>>
>> If the Oracle database did not shutdown with shutdown immediate then stopping
>> those Oracle NT services is the same as crashing your database, i.e. database
>> recovery will occur next time you start it up. This is not normally a big deal,
>> but you could run into problems if you are doing this prior to a cold backup and
>> need to restore from it later.
>>
>> hstack_at_att.com wrote:
>>
>> > Jean Wimmerlin wrote in message <6mae78$lb2$1_at_ubnnews.unisource.ch>...
>> > >When we give "SHUTDOWN IMMEDIATE", Oracle cancels all active transactions,
>> > >rollback and shutdown the database instance. But, sometime (not all the
>> > >time) it hangs and logs the following in the alert file : "Shutdown :
>> > >waiting for logins to complete". I have a backup script that shutdowns the
>> > >instance with immediate option:
>> > >ORADIM73 -SHUTDOWN -SID DMS -USRPWD ****** -SHUTTYPE SRVC, INST - SHUTMODE
>> > >i -PFILE D:\ORANT\DATABASE\DMS\INITDMS.ORA
>> > >
>> > >Does anybody have a clue what is wrong with doing so ?
>> > >
>> > >We are using Oracle Server 7.3.3.0.0 on Windows NT 4.0
>> > >
>> > >Thanks in advance,
>> > >
>> > >Jean Wimmerlin
>> > >
>> > >
>> >
>> > Jean,
>> >
>> > I wrote the following to do the same on ours and we have the same system. Nt
>> > 4.0 server Oracle 7.3.3. The problem could be with the NT services running
>> > so try to shutdown these first. See my example. I back up to another disk
>> > on the same machine then after its done write those files to tape. It takes
>> > less time and my db is not down as long.
>> >
>> > Hope it helps.
>> > Help me sometime...we are all in oracle hell
>> > hstack_at_att.com
>> >
>> > rem the following runs a script(shutdown.sql) to shutdown oracle
>> > E:\orant\bin\svrmgr23 @E:\orant\admin\shutdown.sql
>> > echo just finished shutdown.sql
>> >
>> > net stop OracleServiceORCL /y
>> > net stop OracleTNSListener /y
>> > echo oracle shut down
>> > del e:\orant\admin\backorcl.log
>> >
>> > echo Backup oracle, E: to F: > E:\orant\admin\backorcl.log
>> > echo Time Started >> E:\orant\admin\backorcl.log
>> > date /t >> E:\orant\admin\backorcl.log
>> > time /t >> E:\orant\admin\backorcl.log
>> >
>> > copy e:\orant\database\. f:\orant\backup 1>> E:\orant\admin\backorcl.log
>> >
>> > echo Time Completed >> E:\orant\admin\backorcl.log
>> > date /t >> E:\orant\admin\backorcl.log
>> > time /t >> E:\orant\admin\backorcl.log
>> >
>> > rem=================================================================
>> > rem the following runs a script(startup.sql) to start oracle
>> >
>> > net start OracleServiceORCL
>> > E:\orant\bin\svrmgr23 @E:\orant\admin\startup.sql
>> > net start OracleStartORCL
>> > net start OracleTNSListener
>> >
>> > Shutdown.sql is as follows
>> >
>> > connect internal
>> > shutdown immediate
>> > exit;
>> >
>> > Startup.sql is as follows:
>> >
>> > connect internal
>> > startup pfile=e:\orant\database\initorcl.ora
>> > exit;
>
>--
>
>Regards
>
>Matthias Gresz :-)
>
>GreMa_at_t-online.de
>
> /|
> / |
> /| |\
> /|| |\
> / O |\
> | |\ Galopping Horse beats Running Man.
> / |\
> / / |\
> / __/| |\
> \° / | |\
> \/_/ | |\
>

--
These opinions are my own and not necessarily those of Information Quest or Pebble In The Sky http://www.informationquest.com mailto:jgarry@nospameiq.com http://ourworld.compuserve.com/homepages/joel_garry Remove nospam to reply. mailto:joel_garry_at_compuserve.nospam.com "See your DBA?" I AM the @#%*& DBA! Received on Tue Jun 30 1998 - 13:55:36 CDT