Re: "Alter system switch logfile" hangs

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 04 Jun 2003 13:04:48 +0200
Message-ID: <3EDDD250.5010508@science-computing.de>

Steve Ashmore wrote:
> You database is probably still in Archivelog mode , but you have disabled
> automatic archiving.
> So after your 3rd switch the database hangs.
> To shut off archiving:
>
> shutdown immediate
> startup mount
> alter database noarchivelog;
> alter database open;
>
> Be sure you are certain that you do no want archiving as it limits your
> recovery options;
>
> select * from v$backup;
>
> Will show what is in backup mode;
>
> Stephen C. Ashmore
> Brainbench MVP for Oracle Administration
> http://www.brainbench.com
> Author of: 'So You Want to be an Oracle DBA?'

I hope this does not sound stupid, but surely the point of the OP was to be able to perform hot backups? Always thought that's only possible in ArchiveLog mode. But since you wrote an oracle book it must be my mistake :-)

Cheers

Holger Received on Wed Jun 04 2003 - 06:04:48 CDT