RE: Archivelog

Thanx for the replies all.

Old files had indeed been moved, New log Switch had not yet took place ...

Other question concerning log-files :

Production database was shut down (at 2 AM), all files copied. On a second system (test) running a recovery of the production database. Seems to work, but it asks for archive log-files created after the shut down and copy of the production database.

How's that possible ?

Don't ask, trying to help someone without having access to the DB myself ...

> -----Original Message-----
> From: Weerd de E.C. Kirsten [SMTP:Kirsten.deWeerd_at_oranjewoud.nl]
> Sent: Tuesday, June 06, 2000 10:55 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Archivelog
>
> Maybe a silly thing I am missing here, but a bit inexperienced with this
> all
> :
>
> Looking at the log_mode in sys.v$database it says ARCHIVELOG
>
> When I do Archive log list i get the following :
>
> SVRMGR> archive log list;
> Database log mode Archive Mode
> Automatic archival Enabled
> Archive destination /oradata4/dbs_prod/dbarchlog/arch
> Oldest online log sequence 60178
> Next log sequence to archive 60182
> Current log sequence 60182
>
> So I go to Archive Destination directory and find the dir to be empty?
>
> What am I missing ?
>
> Thnx for any advise !
>
> Greets,
>
>
> Kirsten
> --
> Author: Weerd de E.C. Kirsten
> INET: Kirsten.deWeerd_at_Oranjewoud.nl
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Jun 06 2000 - 07:31:54 CDT