Re: Post script after RAC DB Startup

From: Andy Colvin <acolvin_at_enkitec.com>
Date: Tue, 22 Nov 2011 14:52:44 -0600 (CST)
Message-ID: <1c34dcac-b219-4055-9186-648421ffddea_at_NEWBART.ENKITEC.COM>

You could use srvctl to start the database in mount mode, then use sqlplus to start it up in restricted mode and perform your database maintenance. If you're using 11.2 GI, CRS should start automatically on bootup. Andy Colvin

5605 N MacArthur Blvd
Suite 600
Irving, TX 75038
andy.colvin_at_enkitec.com

• Original Message ----- From: kapil vaish <kapilvaish1_at_yahoo.com> To: andrew kerber <andrew.kerber_at_gmail.com> Cc: oracle-l_at_freelists.org Sent: Tue, 22 Nov 2011 13:52:37 -0600 (CST) 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.  

Thanks
Kapil

---

From: Andrew Kerber
To: kapilvaish1_at_yahoo.com
Cc: "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 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





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

Received on Tue Nov 22 2011 - 14:52:44 CST