OraFAQ Forum: Server Administration » Shutdown immediate taking more time to down database

Home » RDBMS Server » Server Administration » Shutdown immediate taking more time to down database (Oracle 10.2.0.5.0 , SunOS 5.10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Shutdown immediate taking more time to down database [message #619080]

Thu, 17 July 2014 21:45

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

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619087 is a reply to message #619080]

Fri, 18 July 2014 00:36

trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam

Senior Member

Lost data in tx not commit
Maybe corrupt rollback segments
...

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619092 is a reply to message #619080]

Fri, 18 July 2014 00:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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).

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619097 is a reply to message #619092]

Fri, 18 July 2014 00:59

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

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619101 is a reply to message #619097]

Fri, 18 July 2014 01:10

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619102 is a reply to message #619101]

Fri, 18 July 2014 01:33

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

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619124 is a reply to message #619111]

Fri, 18 July 2014 04:24

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 ?

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619126 is a reply to message #619124]

Fri, 18 July 2014 04:47

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

He means redo the backup correctly. I.e. after a clean shutdown.

<ay = way

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619127 is a reply to message #619126]

Fri, 18 July 2014 04:48

cookiemonster
Messages: 13965
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.

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619214 is a reply to message #619080]

Sun, 20 July 2014 00:30

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

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619227 is a reply to message #619214]

Sun, 20 July 2014 09:35

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

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619228 is a reply to message #619227]

Sun, 20 July 2014 09:44

trantuananh24hg
Messages: 744
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?

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619230 is a reply to message #619227]

Sun, 20 July 2014 09:49

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Did you read my answers?

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619241 is a reply to message #619227]

Sun, 20 July 2014 22:07

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

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619441 is a reply to message #619241]

Tue, 22 July 2014 08:45

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

Report message to a moderator

Re: Shutdown immediate taking more time to down database [message #619442 is a reply to message #619441]

Tue, 22 July 2014 08:52

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I advise you to learn RMAN.

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 22 17:11:46 CST 2025