RE: Post script after RAC DB Startup
Date: Tue, 22 Nov 2011 20:49:35 +0000
Message-ID: <9F15274DDC89C24387BE933E68BE3FD3134041_at_MISOUT7MSGUSR9D.ITServices.sbc.com>
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: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of kapil vaish
Sent: Tuesday, November 22, 2011 2:53 PM
To: andrew.kerber_at_gmail.com
Cc: oracle-l_at_freelists.org
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 <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 -- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 22 2011 - 14:49:35 CST