Re: Post script after RAC DB Startup

From: kapil vaish <kapilvaish1_at_yahoo.com>
Date: Tue, 22 Nov 2011 11:52:37 -0800 (PST)
Message-ID: <1321991557.5003.YahooMailNeo_at_web111726.mail.gq1.yahoo.com>

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.  
Thanks
Kapil

---

From: Andrew Kerber <andrew.kerber_at_gmail.com> To: kapilvaish1_at_yahoo.com
Cc: "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> 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 <kapilvaish1_at_yahoo.com> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Andrew W. Kerber

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


--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 22 2011 - 13:52:37 CST