Re: Archive mode

OK, so now it appears that you enabled archivelog mode without enabling automatic archiving.

It can happen, I suppose. But this thread makes it sound like you really don't know what you are doing when it comes to archiving. Confidence is not exactly stratospheric that you'd know what to do in the event of a recovery being required either.

Try an alter system archive log start, or an alter system archive log start to 'name of directory in here'. That should fix the immediate hang. And I suspect you may want to mount the database and issue an 'alter database noarchivelog' to put things back the way they were before going much further.

Once your immediate problem is sorted, and I do actually mean this in the most positive and helpful way possible, do yourself a big favour, and read up on archiving and backup and recovery strategies. Only because half a dozen people have mailed me to say that my document has helped them pass OCP exams, I point you in the vague and general direction of the Backup and Recovery page of my website. It's a 70-page PDF download, and it will at least hopefully stop this sort of confusion arising in the future. I'm sure there are infinitely better documents out there somewhere as well (and I'll happily link to them if someone tells me where they are).

Hope you get it sorted,
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------

"CME Systems" <support_at_cmesys.demon.co.uk> wrote in message
news:972554296.16975.0.nnrp-03.c2de4217_at_news.demon.co.uk...


> Thanks again. I have checked what you said and these lines were commented

> out so I have changed to archive = true but this will not have any affect

> until I restart the service. I am still waiting for srvmgr to sut down the

> service and it is just sat there. I really do not know what is happening

 and


> what is going on in the background but I am the only person with access to

> the database and the service will not shut down. Any ideas?

> Thanks in advance

> Andy

>

>