| Shutdown immediate taking more time to down database [message #619080] |
Thu, 17 July 2014 21:45  |
|
|
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 #619097 is a reply to message #619092] |
Fri, 18 July 2014 00:59  |
|
|
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 #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
|
|
|
|
| Re: Shutdown immediate taking more time to down database [message #619441 is a reply to message #619241] |
Tue, 22 July 2014 08:45 |
|
|
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
|
|
|
|
|
|
] 
Search
Help
Members
Register
Login
Home
