Re: ArchiveLog Mode not Enabling

You're missing a few steps...
1. Invoke Server Manager and connect as internal. 2. Make sure the database is mounted but not open. SVRMGR> STARTUP MOUNT
3. Change the Archive mode to ARCHIVELOG mode. SVRMGR> ALTER DATABASE ARCHIVELOG;
4 Open the database for users.
SVRMGR> ALTER DATABASE OPEN;
5. Shut down the database and perform a full backup. SVRMGR> SHUTDOWN NORMAL NOTE: After the database mode has been changed from NOARCHIVELOG mode to ARCHIVELOG, you must back up all of the database files and the control file. Your previous backup is logically not usable anymore, since it was taken while the database was in NOARCHIVELOG mode. The new backup you will take after putting the database into ARCHIVELOG mode is the backup that all your future archived redo log files will apply against.

This info was stolen from "ORACLE7: Backup and Recovery Volume One- Student Guide".

Good Luck,
Satar
In article <70gc96$h5m$1_at_nrchh52.us.nortel.com>,   peacockm_at_nt.com (Margaret Peacock) wrote:
> Archivelog Mode is set to TRUE in the init.ora file, yet it does not enable at
s
> tartup (archive log list has been checked). Are there any other places where
thi
> s parameter must be set? Thanks for all feedback.
>
> --
> -----------------------------------------------------------------------------
> Margaret Peacock ESN: 655-8559
> Intranet Web Master EXTERNAL: (408) 565-8559
> Nortel - Mission Park peacockm_at_nt.com
> ----------------------------------------------------------------------------
>

--
Oracle DBA/UNIX System Admin
Advanced Enterprise Solutions
(949) 756-0588
Oracle Re-Seller

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Oct 20 1998 - 17:56:56 CDT