Hi friends..

One of my colleagues needed to turn archiving off whilst he did a large import.

He set log_archive_start to false and bounced the server.

when the system restarted the database hung..

Does anybody know the corect procedure for turning archive mode off (safely) whilst a large import is taking place.
And then restarting arhive mode after the import has been done.

Also..

does anybody know why the database would have hung (what technically happened?) if the archiving was simply set to false and the database was bounced

Many Thanks

Suresh