- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Oracle DB fails to shutdown.
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
тАО02-02-2006 12:45 AM
тАО02-02-2006 12:45 AM
Re: Oracle DB fails to shutdown.
All you have to do is
1. Ensure that users of off the system
2. Listner is shutdown
3. Then shutdown the database.
if 1 & 2 fails or takes time you may get into problems.
To avoid better add the command: sleep 30 or 60 before shutting down the database.
Also can you ensure that switchlogs are done twice or 3 times before shutting down, so your db is 100% for shutdown or abort.
Chan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 01:00 AM
тАО02-02-2006 01:00 AM
Re: Oracle DB fails to shutdown.
Since you are using "/usr/bin/su oracle -c /home/oracle/8.1.7/bin/dbshut", how are you sure it is a immediate shutdown? Are you able to exec the following as root:
#/usr/bin/su oracle -c /home/oracle/8.1.7/bin/dbshut immediate
Or is the immediate the only mode that the dbshut script shuts down the db?
Best Regards,
Eric Antunes
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 02:30 AM
тАО02-02-2006 02:30 AM
Re: Oracle DB fails to shutdown.
Yogeeraj,
I have been checking your advice on the user of rman. From my reading of the docs it does not appear go give a consistent backup of an open database. Is there an option to force it to be consistent(similar to that with the exp command).
John.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 02:38 AM
тАО02-02-2006 02:38 AM
Re: Oracle DB fails to shutdown.
As per oracle, it is not recommended to go for hotbackup.
Only Cold backups works well with 8.x
Where if you have 9 and above you can go for hotbackup.
We have plenty of inst with both combinations.
As put in my prev ans to you we use sleep while shutting the DB.
It works well.
It is upto you to decide which backup you go for.
Chan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 02:41 AM
тАО02-02-2006 02:41 AM
Re: Oracle DB fails to shutdown.
you can recover to a point in time.
My backup script writes the commaand to
recover to a point in time (now) to the
backup directory. It then waits a few seconds
and forces a log rotation.
To recover I restore the files and run
the recovery script as part of the recovery.
This requires that the uncompressed archived
redo logs covering the period of the backup
be in the redo directory.
I have automated script to roll-back our
testing databases using this techniqure.
We also clone databases by restoring thme
to a new directory structure, recreating
the control files, and renaming the
database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 03:37 AM
тАО02-02-2006 03:37 AM
Re: Oracle DB fails to shutdown.
check your alert log as well as the bdump directory. Then You will either have to shutdown abort, or have a program kill all oracle connections and then to a shutdown immediate.
1. look at recent alert log entries.
2. Once backup shutdown immediate and look at logs.
Regards,
Simon
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 07:31 PM
тАО02-02-2006 07:31 PM
Re: Oracle DB fails to shutdown.
I am also looking at using rman.
Thanks everybody,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 11:35 PM
тАО02-02-2006 11:35 PM
Re: Oracle DB fails to shutdown.
I still believe RMAN is a much better option.
Good that you have started looking into it.
Read more at: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmrecov.htm#1008603
kind regards
yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-02-2006 11:40 PM
тАО02-02-2006 11:40 PM
Re: Oracle DB fails to shutdown.
The dbshut that ships with oracle is flawed. We always modify the shutdown to shutdown immediate and have avoided the issues you seem to encounter.
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
тАО02-02-2006 11:56 PM
тАО02-02-2006 11:56 PM
Re: Oracle DB fails to shutdown.
I am interested in rman. I did a trial backup to disk and it completed in just 8 minutes. I am still unsure about the recovery options but I will read further into the documentation.
Regards,
John.