- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle Startup / Shutdown Script
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-21-2003 07:32 AM
тАО05-21-2003 07:32 AM
Re: Oracle Startup / Shutdown Script
his shutdowns sometimes "hangs". Shutting down Oracle using the oracle supplied dbshut normally should never hang if You FIRST modify the scripts as noted in a previous thread, by changing to "shutdown immediate" from just "shutdown". Out of the box oracle supplied dbshut script only has "shutdown". A "shutdown" without the immediate or abort option gives the appearance of Oracle hanging, because it is waiting for everyone to logout. I do not recommend "shutdown abort" as an accepted method for taking oracle down. If you have to do an abort, It would be wise to find out what is hanging your Oracle instance. The "hang" might be caused by a long transaction being rolled back or Archive log space is full.
On my system I do not have the luxury to have regular downtimes for backups. All our backup are hotbackups. . We schedule the backups during non peak times. Recovery and full restoral has not been a problem. You should automate Oracle shutdown/startup for OS System reboots. Which is why dbshut/dbstart is associated with /sbin/init.d /etc/rc.d etc.. I also think normal backups should be done without shutting down oracle. If the shuting down of oracle "cleans" things up, time would be better served finding out why unwanted processes/thread/client sessions "things" are hanging around.
I will get off my soap box now.
Good Luck
Rory
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-21-2003 07:45 AM
тАО05-21-2003 07:45 AM
Re: Oracle Startup / Shutdown Script
Thanks everyone for the replies. I'll be sure to assign points to all.
Gus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 12:57 AM
тАО05-26-2003 12:57 AM
Re: Oracle Startup / Shutdown Script
To your question about runnig online backups; use Oracle Recovery Manager (RMAN).
It lets you do online backup (full or incremental) and all kinds of recovery scenarioes.
Do not know if you have to use some software to connect to Omniback. We use Legato and this requires an rather expensive module for connectiong the RMAN to the Legato software (but it works well)
rgds
Andreas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-26-2003 03:21 AM
тАО05-26-2003 03:21 AM
Re: Oracle Startup / Shutdown Script
As Andreas said above, RMAN is the way to go!
BECAUSE
RMAN decreases the chance of you making a mistake.
do you regularly test your backups?
I was with a customer who wanted to know why their system was down for days -- yes, days. Why so long? Well, they had a problem, had to restore from backup. Never tested said backup. Discovered all of a sudden their script kicked off the copies BEFORE the alter tablespace begin backup. Whoops - System was fried. Support helped them scavenge what they could but basically, it was a rebuild of the entire big database. That would not happen with RMAN -- less for them to think about, less mistakes possible.
Consider the following also:
You have a single bad block in a 16gig datafile, you are using RMAN in 9i. What do you do? You do an in place recovery of just the bad block, you do not offline the datafile, you do not offline the tablespace, you do not do 16gig of IO to restore the file, you do not roll 16gig of data forward. You recover an individual 8k block.
What would have happened if you didn't use RMAN?
take tablespace offline, restore 16gig, roll it forward then bring it online.
Which gives you less downtime?
Which fully recovers the fastest?
Which would you prefer to do?
In the end -- if you know what you are doing fully, you TEST the backups on a recurring basis, you don't mind being down for a bad block -- the old fashioned way works but -- times are changing, there are more and more reasons to use it.
I would also recommend that you do your backup to disk first then send them to tape (of course if you can afford it!)
Good luck!
If you want more about RMAN, please let us know...
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-27-2003 12:21 PM
тАО05-27-2003 12:21 PM
Re: Oracle Startup / Shutdown Script
1. We put oracle in backup mode.
2. then broke the mirrors
3. took oracle out of backup
mode
4. fsck the the mirrors.
5. mount the mirrors in a
different sub directory.
6. backed them up.
Having said the above. RMAN is better. especially if you do not have mirroring.
Rory
- « Previous
-
- 1
- 2
- Next »