Home » RDBMS Server » Server Administration » Shutdown immediate taking more time to down database (Oracle 10.2.0.5.0 , SunOS 5.10)
Shutdown immediate taking more time to down database [message #619080] Thu, 17 July 2014 21:45 Go to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi ,

I wanted to take cold backup of one database for that i need to shutdown the database.
When i give shutdown immediate , it was taking time say 15 mins and above and not shutting down and
i found following in the alert log entry .
Completed checkpoint up to RBA [0x23edd.2.10], SCN: 1015641053 
Fri Jul 18 05:15:08 EEST 2014 
Shutting down instance (immediate) 
Fri Jul 18 05:15:08 EEST 2014 
Shutting down instance: further logons disabled 
License high water mark = 125 
Fri Jul 18 05:24:29 EEST 2014 
Instance shutdown cancelled 
Fri Jul 18 05:26:40 EEST 2014

I also found 20 active and 3 inactive users connected at that time when i issued shutdown immediate.

Since it was taking long time to down the database ,i issued shutdown abort to down the database and
it went down immediately.My concern is will i face any issue in starting the database because of using s
hutdown abort command ?

Regards,
Srini
Re: Shutdown immediate taking more time to down database [message #619087 is a reply to message #619080] Fri, 18 July 2014 00:36 Go to previous messageGo to next message
trantuananh24hg
Messages: 612
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Lost data in tx not commit
Maybe corrupt rollback segments
...
Re: Shutdown immediate taking more time to down database [message #619092 is a reply to message #619080] Fri, 18 July 2014 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

After a shutdown abort you cannot do a cold backup.
You can do a cold backup only after a clean shutdown (that is other than abort or kill processes).

Re: Shutdown immediate taking more time to down database [message #619097 is a reply to message #619092] Fri, 18 July 2014 00:59 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi trantuananh,
Thanks for your response.

Hi Michel,
Quote:
After a shutdown abort you cannot do a cold backup.

What kind of issue i will face if i do a cold backup after shutdown abort ?

Quote:
You can do a cold backup only after a clean shutdown (that is other than abort or kill processes).

I have already started copying all database files to target location after shutdown abort.

Regards,
Srini
Re: Shutdown immediate taking more time to down database [message #619101 is a reply to message #619097] Fri, 18 July 2014 01:10 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

And did you succeed to restart the database with coherent data (and did yo check the data)?
If so, you have been lucky but this is not guaranteed, it is the same than to copy the files when the database is open.

Re: Shutdown immediate taking more time to down database [message #619102 is a reply to message #619101] Fri, 18 July 2014 01:33 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Michel,
I have not restarted the database since database files are huge and is being copied to target location.

Regards,
Srini

[Updated on: Fri, 18 July 2014 02:01]

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619111 is a reply to message #619102] Fri, 18 July 2014 02:43 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you mau have some surprise when you will do it.
I advise you to immediately do it again, in the correct <ay this time.

Re: Shutdown immediate taking more time to down database [message #619124 is a reply to message #619111] Fri, 18 July 2014 04:24 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Michel,
Quote:
I advise you to immediately do it again, in the correct <ay this time.

I can't get this sentence.Can you rephrase it ?
Re: Shutdown immediate taking more time to down database [message #619126 is a reply to message #619124] Fri, 18 July 2014 04:47 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
He means redo the backup correctly. I.e. after a clean shutdown.

<ay = way
Re: Shutdown immediate taking more time to down database [message #619127 is a reply to message #619126] Fri, 18 July 2014 04:48 Go to previous messageGo to next message
cookiemonster
Messages: 11068
Registered: September 2008
Location: Rainy Manchester
Senior Member
And learn to use RMAN, then you won't need to shutdown the DB to back it up.
Re: Shutdown immediate taking more time to down database [message #619214 is a reply to message #619080] Sun, 20 July 2014 00:30 Go to previous messageGo to next message
GirishSharma
Messages: 22
Registered: March 2010
Junior Member
Below link may be of your interest :
http://askdba.org/weblog/2008/05/shutdown-immediate-hang-2/

Taking a cold backup after shutdown abort, is 100% wrong. Database with cold backup files can only be startedup, if last time it was clean shutdown.

Regards
Girish Sharma
Re: Shutdown immediate taking more time to down database [message #619227 is a reply to message #619214] Sun, 20 July 2014 09:35 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Hi Girish,
Quote:
Taking a cold backup after shutdown abort, is 100% wrong.

Can you explain why ?

Regards,
Srini
Re: Shutdown immediate taking more time to down database [message #619228 is a reply to message #619227] Sun, 20 July 2014 09:44 Go to previous messageGo to next message
trantuananh24hg
Messages: 612
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
What's problem with google and some keys such as "Oracle" + "shutdown" + "abort" + "risk"?
What's problem with Oracle document search tool?
What's your problem with keyboard?

Would you like a robot handles bread even the bread on silver plate?
Re: Shutdown immediate taking more time to down database [message #619230 is a reply to message #619227] Sun, 20 July 2014 09:49 Go to previous messageGo to next message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Did you read my answers?

Re: Shutdown immediate taking more time to down database [message #619241 is a reply to message #619227] Sun, 20 July 2014 22:07 Go to previous messageGo to next message
GirishSharma
Messages: 22
Registered: March 2010
Junior Member
Hi Srini,

I think you want to hear that what if I says shutdown abort, takes backup of datafile, controlfile and redo logs and tries to restore these files to another machine what will happen ?

If this is what you want to know then read below simple and plain answer by Thomas Kyte :
https://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1892210373157#1895657238815

I'll make it as short and simple as I can. There are two cases:

ARCHIVELOG MODE:
go ahead and backup the shutdown aborted instance. DO NOT BACKUP ONLINE REDO
logs. That is a HUGE mistake in archivelog mode.

NOARCHIVELOG MODE:
go ahead and backup the shutdown aborted instance IF AND ONLY IF you also
backup the online redo logs. You'll NEED them to perform instance recovery
if you ever restore these files.

short and sweet. Thats it. Yes, you can backup the shutdown aborted instance.

If you are still confused then you should read below link too : (Overview of Instance Recovery)
http://docs.oracle.com/cd/E11882_01/server.112/e25789/startup.htm#CNCPT1301

Read them, test them and tell us what you did and got i.e. create two test databases, one in archivelog mode and another in noarchivelog mode. Fire shutdown abort for both the databases, take backup of datafile, controlfiles and redo logs, restores them to other machine, now say startup and tell us what happened ? Don't ask me what WILL happen, do it yourself and learn what is this great IT tool i.e. Oracle db software...!!!

Regards
Girish Sharma
Re: Shutdown immediate taking more time to down database [message #619441 is a reply to message #619241] Tue, 22 July 2014 08:45 Go to previous messageGo to next message
Database admin
Messages: 365
Registered: September 2006
Location: india
Senior Member

Thank you Girish for your suggestion.
Hi Michel,
Quote:
So you mau have some surprise when you will do it.
I advise you to immediately do it again, in the correct <ay this time.

As you said , i had a surprise while starting up the database after taking cold backup as it got started without any issue.

Regards,
Srini
Re: Shutdown immediate taking more time to down database [message #619442 is a reply to message #619441] Tue, 22 July 2014 08:52 Go to previous message
Michel Cadot
Messages: 59405
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

I advise you to learn RMAN.

Previous Topic: How to verify a server
Next Topic: ORA-01012: not logged on
Goto Forum:
  


Current Time: Mon Oct 20 19:38:37 CDT 2014

Total time taken to generate the page: 0.08843 seconds