Re: How to enable Archivelog Mode?

From: Erwin Hattingh <itec_at_infra.demon.nl>
Date: Thu, 23 Jul 1998 15:10:43 +0200
Message-ID: <901199445.20717.0.rover.c29fe581@news.demon.nl>

Simply do the following :

1. Stop the Oracle instance involved
2. Backup the database !
3. change parameter file of the oracle instance involved # make sure log files are archived automaticly log_archive_start = true

    # When the database is used in ARCHIVELOG mode, Oracle must know the archived redo log

    # filename format and destination so that automatic or manual archiving creates

    # uniquely named archived redo log files in the proper location.     LOG_ARCHIVE_FORMAT = PDM1_%S.log # database in ARCHIVELOG mode,

# archived redo log filename format

    LOG_ARCHIVE_DEST = D:\ORADATA\PDM1\ARCHIVE # database ARCHIVELOG mode,

# archived redo log destination

4) startup sqldba mode-line (Unix) or svrmgr23 (Windows NT)
4) connect internal/password
4) startup nomount exclusive
5) alter database archivelog ;
6) shutdown;
7) startup the database normally



==========================================

All opinions expressed are mine and not the companies. Erwin Hattingh

HTM Infrastructuur     e-mail : itec_at_infra.demon.nl
Maanweg 94              (temporary)
2516 AA Den Haag    web : http://www.htm.net

Netherlands              phone: (31) 070-3848430
==========================================

mohdzaid wrote in message <6p6k05$2ek$1_at_nobel2.pacific.net.sg>...
>Hi,
>
>I'm want to implement On-Line Backup for our Oracle database. I understand
>that archivelog mode needs to be enable first. Would appreciate if anyone
>could give the how to's. Thanks in advance.
>
>
>
>Best Regards,
>Zaid
>Systems Engineer
>Siemens Medical Instruments
>Reply to : zaid.lazim_at_smi.siemens.com.sg
>
>
Received on Thu Jul 23 1998 - 08:10:43 CDT