Re: switching to archive mode

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 15 Apr 1999 09:13:29 -0700
Message-ID: <37161029.228CAC57@us.oracle.com>

Left out one stage. Add the parameters log_archive_dest, log_archive_format, log_archive_dest to your init.ora before the startup exclusive. Also, it only needs to be done once, so don't modify the startup script to do this, just connect once and do it.

HTH. Pete

mjain_at_my-dejanews.com wrote:

> To start using ARCHIVELOG mode, simply change your database startup
> command script:
> SVRMGR> connect internal;
> SVRMGR> startup mount exclusive;
> SVRMGR> alter database archivelog;
> SVRMGR> archive log start;
> SVRMGR> alter database open;
>
> NOTE: ARCHIVELOG mode was introduced with Oracle V6 and is essential
> for database point-in-time recovery.
>
> Manoj Jain
> Chauncey Certified Oracle7 DBA
> Oracle Certified Professional - OCP DBA Oracle7 and Oracle8
> Tekmetrics Certified Master Oracle DBA
>
> In article <7f2vca$uej$1_at_nnrp1.dejanews.com>,
> erey4444_at_my-dejanews.com wrote:
> > Currently I am not using archiving. I have decide to switch to archiving.
> > Where can I find some documentation or help to make sure I can implement
> > everything correctly.
> >
> > -----------== Posted via Deja News, The Discussion Network ==----------
> > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
> >
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Thu Apr 15 1999 - 11:13:29 CDT