- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Shutdown oracle before BC
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2006 11:19 PM
тАО05-10-2006 11:19 PM
Shutdown oracle before BC
I'm working on a script that will shutdown oracle before doing a bussiness copy.
(We have to be absolutely sure that oracle is down after running the script)
What I had in mind is the following:
-- Start Timer
alter system checkpoint; -- writes dirty buffer to datafiles + updates controlfile
shutdown immediate; -- kill and rollback ongoing transactions +
shutdown database
If Timeout then
shutdown abort; -- Kills everything here and now (No rollback of ongoing transactions)
startup restrict; -- Recover database and starup in restricted mode (only SYSDBA:s allowed)
shutdown normal; -- Wait for all users to logout (Nobody is connected as we are in restriced mode) and then shutdown database cleanly.
end if;
Should this work?
Anyone already having a similar script? :-)
Any other hints or tricks?
Thanks in advance,
Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-10-2006 11:47 PM
тАО05-10-2006 11:47 PM
Re: Shutdown oracle before BC
Yes it will work.
You can use dbshut as well, if you modify its shutdown from shutdown to shutdown immediate.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 12:04 AM
тАО05-11-2006 12:04 AM
Re: Shutdown oracle before BC
(In'Shallah!)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 12:27 AM
тАО05-11-2006 12:27 AM
Re: Shutdown oracle before BC
Have a script which will logout all applications users using the database before shutting down the database.
I remember we used to kill all client connections - processes showing LOCAL=NO as well.
Regards,
Ninad
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 03:19 AM
тАО05-11-2006 03:19 AM
Re: Shutdown oracle before BC
requires the database be in archive log
mode, which you want on any critical database
anyway.
For each tablespace,
- Mark the tablespace as being backed up,
- Copy the tablespace,
- Unmark the tablespace
Save a copy of the control file to trace.
Take a timestamp, wait two seconds, and
force a logfile switch.
Save any logfiles from the start of the
backup until after the forced logfile
switch.
Recovery is:
- Restore files to a new location.
- Modify the backed up control file to
reflect the new locations.
- Startup the database and recover until
the time of the timestamp.
- Shutdown the database and rename it.
- Restart resetting logs.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 03:40 AM
тАО05-11-2006 03:40 AM
Re: Shutdown oracle before BC
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 07:16 AM
тАО05-11-2006 07:16 AM
Re: Shutdown oracle before BC
(business warehouse application)
Thanks for all answers!
//Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-11-2006 09:07 PM
тАО05-11-2006 09:07 PM
Re: Shutdown oracle before BC
being in noarchivelog mode -- is a 100% surefire way to LOSE data
Archiving is very CPU deintensive -- it involves copying a file from one disk to
another disk. You need sufficient devices to avoid contention here.
consider this:
You want to make it so that when LGWR is writing to a device, ARCH is *not* reading that device. So, you would have log group 1 on dev1 (mirrored to dev3). Log group 2 on dev2 (mirrored to dev4). Log group 3 on dev1/dev3, log group 4 on dev2/dev4 and so
on.
Well, LGWR writes to dev1/dev3. Arch is reading dev2/dev4 and writing to dev5. Arch finishes and waits. LGWR not writes to dev2/dev4, Arch reads dev1/dev3 and writes to dev5. No contention, there you go -- smooth operation, no degradation.
think well, in some cases noarchivelog is indeed essential... but can you afford to make this compromise?
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2006 06:36 AM
тАО05-12-2006 06:36 AM
Re: Shutdown oracle before BC
(I'll forward it to the DBA)
Unfortunatly I'm just the consultant setting up the bussiness copy :-)
I've tried to convince my customer to switch to archivelog mode and
the least I can say is that's been very controversial...
//Michael
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2006 10:56 PM
тАО05-14-2006 10:56 PM