RE: Post script after RAC DB Startup

From: Sais, Gene <>
Date: Tue, 22 Nov 2011 20:56:58 +0000
Message-ID: <B77DE4A722899C4FAE7E961B32C6123556B676BF_at_VCP01XMAIL-BE10.Clerk.local>

I usually stop all of the instances (i.e. stop db) with srvctl and then start one instance with sqlplus and run my scripts.

-----Original Message-----
From: [] On Behalf Of CRISLER, JON A Sent: Tuesday, November 22, 2011 3:50 PM To:; Cc:
Subject: RE: Post script after RAC DB Startup

Srvctl has options to start a db in modes other than normal open. Example- srvctl start instance -d (dbname) -i (instancename) -o mount So check the -o open for what you want.

-----Original Message-----
From: [] On Behalf Of kapil vaish Sent: Tuesday, November 22, 2011 2:53 PM To:
Subject: Re: Post script after RAC DB Startup

Thanks Andrew. triiger is one option but it does not cover all the maintenance part. Is there any way that we can run script dring RAc startup ? These dbs are in archivelog and hot backups are run. we do cold backups at some specified windows.  

From: Andrew Kerber <> To:
Cc: "" <> Sent: Tuesday, November 22, 2011 11:29 AM Subject: Re: Post script after RAC DB Startup

You might be able to do something with a database trigger (on startup of database).  Though if you are backing them up, I dont see why you dont put them in archivelog mode and run hot backups. On Tue, Nov 22, 2011 at 1:10 PM, kapil vaish <> wrote:

> Hi Guys ,
> For some of our RAC envs, we do following during cold backup .
> 1. Shutdown DB
> 2. Take backup
> 3. startup DB in restricted mode
> 4. Do maintenace work like compile packages, pin packages,some
> index/table reorg etc and then 5. open DB to users ( in normal mode)
> These all DBs are in RAC environment and we don't register them in the
> CRS. So, even when the server is shutdown, the DB will not
> automatically start and open to users without doing maintenance work.
> Now there is a requirement to register all the dbs in CRS along with
> services .With this registration, an init.d script is created to start
> CRs (crsctl start crs) . CRS will then start up the database and open
> to users.  I will not be able to do my maintenace work. Are there any
> options to start the DB in restricted mode with RAC startup and then
> run scripts to do maintenance automatically before the DB is opened to users ?
> any pointers are appreciated ..
> thanks
> kapil
> --

Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'




Received on Tue Nov 22 2011 - 14:56:58 CST

Original text of this message