Re: ARCHIVE LOG MODE

From: Mark Bateman <batemam_at_bibip1.wgw.bt.co.uk>
Date: 1997/03/05
Message-ID: <331D4A69.4C2@bibip1.wgw.bt.co.uk>#1/1

To get an archived redo log (provided it is enabled), perform one of the following:-

• Connect as internal and then perform the following:- alter system switch logfile; archive log all;

Alternatively shutdown/restart the database.

The redo logs are only archived if there is a redo log switch.

Using the command 'archive log list' within sqldba/svrmgrl will show you where the archives should be going to, and if you have the archive log mode set.

Using SQLDBA (or SVRMRGL) you should see something like the following:-

oracle_sid01> sqldba mode=line
SQLDBA> connect internal
Connected.
SQLDBA> archive log list

Database log mode              ARCHIVELOG
Automatic archival             ENABLED
Archive destination            /u01/oracle/admin/sv01/arch/sv01_arch
Oldest online log sequence     407
Next log sequence to archive   409
Current log sequence           409

SQLDBA> Mark Bateman

David Turner wrote:
>
> I set archive logging to true altered the database and did the same,
> restarted the database, and performed some inserts to see if oracle created
> some ar*.log files. I haven't seen any and was wondering if I had to create
> the directory for oracle so that it can archive.
> > [snip]

-- 
Mark Bateman

-- 
Mark Bateman

Received on Wed Mar 05 1997 - 00:00:00 CST