database switching into noarchivelog mode after restart [message #475528] |
Wed, 15 September 2010 08:26 |
shabeermiah
Messages: 3 Registered: August 2010 Location: Hyderabad
|
Junior Member |
|
|
Dear All,
Thanks for your consideration.
I'm trying to take the cold backups and trying to recover the db after intentional removal of my CRD files at OS level. And I shut abort the DB after I remove my CRD files at OS, when I startup the database after I restore the cold backup, the database is switching into NOARCHIVE mode automatically. And manually Im turning back into ARCHIVE-LOG mode, please help me to resolve this situation,
warm regards,
shabeer
|
|
|
|
Re: database switching into noarchivelog mode after restart [message #475530 is a reply to message #475529] |
Wed, 15 September 2010 08:41 |
shabeermiah
Messages: 3 Registered: August 2010 Location: Hyderabad
|
Junior Member |
|
|
Dear Mr Michel,
Thanks for your response,
CRD files are = my control, datafiles and redo log files, I'm removing these manually at OS level just for the sake of learning as Im a student.
No the database is originally in Archive log mode as I can recover the database after restoration, but it is switching into NOARCHIVELOG mode automatically when I restart after shutdown abort. please help me
thanks,
shabeer
|
|
|
|
Re: database switching into noarchivelog mode after restart [message #475541 is a reply to message #475535] |
Wed, 15 September 2010 09:08 |
shabeermiah
Messages: 3 Registered: August 2010 Location: Hyderabad
|
Junior Member |
|
|
Dear Michel,
thanks for your reply,
I have just done the shut immediate and whilst shuting down I have monitored the alert log file, and it is even saying that it is disabling the archivelog mode...
Im just wondering why is it doing like this, is there any parameter that I need to set in pfile to stop doing this???
please help me, please find the attachment
thanks,
shabeer
|
|
|
|
Re: database switching into noarchivelog mode after restart [message #475729 is a reply to message #475546] |
Fri, 17 September 2010 02:34 |
John Watson
Messages: 8960 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Shabeer, your database is not switching into noarchivelog mode. The line you highlighted in that screenshot (by the way, many forum users do not like to download files like that, which is probably why you haven't had a complete answer before) says that the archiving processes are being stopped. That is because you are shutting down the database. They will be started when you startup again.
[update: typo]
[Updated on: Fri, 17 September 2010 02:35] Report message to a moderator
|
|
|