Hot backup is only available in archive log mode
"Holger Baer" <holger.baer_at_science-computing.de> wrote in message
news:3EDDD250.5010508_at_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 - 14:54:20 CDT
