Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Startup MOUNT 8.0.5 database with Failsafe 2.1.3 on NT4/SP4

Re: Startup MOUNT 8.0.5 database with Failsafe 2.1.3 on NT4/SP4

From: <hooch432_at_my-dejanews.com>
Date: Fri, 21 May 1999 15:28:38 GMT
Message-ID: <7i3u33$v22$1@nnrp1.deja.com>


In article <02958872B29C02EF.44FDAB2D5DF28024.E262DBCA9CE5BA62_at_library- proxy.airnews.net>,
  moros_at_hcal.com (Mike) wrote:
> The long way...remove it from the fail safe group and make standalone,
> then perform the database activities you like, then add back into fail
> safe group.
>
> The short way...it appears that you can take the database offline
> (your not 7x24), so when it's offline, edit the init<SID>.ora file to
> include the archive log parameters (true, destination, format) then go
> back online..
>
> On Wed, 19 May 1999 16:00:38 +0200, Lars Bo Vanting
> <Lars.Vanting_at_ex.siemens-sbs.ch> wrote:
>
> >I'm trying to switch my Failsafe Database (NT4/SP4, 8.0.5 and
Failsafe
> >2.1.3) from
> >NOARCHIVELOG to ARCHIVELOG mode. Normally all
> >startup/shutdown (take online/offline) operations
> >should be submitted from Failsafe Manager.
> >
> >BUT: How do I get my DB in a MOUNT state? This is
> >not possible from OFS Manager (no function for
> >this). When I try from SVRMGR30.EXE or Instance
> >Manager, I always get
> >"..end-of-communication-channel..." or "TNS Packet
> >writer failure" when trying SHUTDOWN IMMEDIATE.
> >
> >SHUTDOWN ABORT works, but then when starting (in MOUNT) it
> >either has performed failover or already started the DB (and opened
it)!
> >
> >WHAT IS THE IDEA HERE?
> >I've studied the "Oracle Fail Safe Concepts and
> >Administration" doc. etc. but found nothing on this
> >subject (general adm. of DB, eg. MOUNT state in
> >order to perform misc. tasks).
> >
> >Has anyone ideas on this? Thanks in advance!
> >
> >Kind regards
> >
> >Lars Bo
> >

>I am running the same setup with FailSafe and I am having trouble with
the Backup procedure. How are you doing a cold backup? I have had trouble with it failing over and it also gives me crash recovery errors in my alert log. I just find the system very unstable. Sometimes it shuts down fine and then comes up great and then it doesn't. I need to know the best way to shut down my services and database without failing over so I can do a backup to disk and then come up clean. I trying to do the cold backup through scripts first and then eventually move on to a utility. I have tried shutdown on the OracleServiceSID and that does a shutdown abort so I changed the ORA_SHUTDOWN registry item to TRUE and it still is giving crash recovery errors in the alert log. Even though it says shutdown immediate in the alert log. I am at my wits end and would appreciate any help.
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Fri May 21 1999 - 10:28:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US