Archive logs? help?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 7 Mar 2003 14:11:45 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70364CF1F@lnewton.leeds.lfs.co.uk>

Hi James,

v$archived_log does indeed still show them, but you don't need to worry about that - the names are the same on tape, or wherever else you have archived the archives !

Just delete them from disc when you have at least a couple of archived copies and all will be well, come the day that you *really* do need them, Oracle will prompt you with the names of the logs it requires.

Cheers,
Norman.

PS. I have archived logs on disc for at least 4 days. Each night that disc area is copied off to tape, so my logs are around for a while, just in case .....

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: James [mailto:james_at_nothing.com]
Posted At: Friday, March 07, 2003 1:52 PM Posted To: server
Conversation: Archive logs? help?
Subject: Archive logs? help?

Hi there
If a hot backup is done and the archivelogs copied to a new location the archive logs remain on the server. Now these logs are no longer required on
the server so can be deleted from the server. (cause they are backed up and
to make space) but now how do you tell the server that they have been removed?

any sql plus query for example
SELECT NAME FROM V$ARCHIVED_LOG
still shows all the logs even if they have been deleted.

cheers
Thanks in advance! And thanks for all the previous help I have received! James! Received on Fri Mar 07 2003 - 08:11:45 CST