Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: switching to archive mode

Re: switching to archive mode

From: <mjain_at_my-dejanews.com>
Date: Wed, 14 Apr 1999 22:29:55 GMT
Message-ID: <7f34sq$39o$1@nnrp1.dejanews.com>

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 Received on Wed Apr 14 1999 - 17:29:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US