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: Archive logs? help?

Re: Archive logs? help?

From: James <james_at_nothing.com>
Date: Fri, 7 Mar 2003 16:41:13 +0200
Message-ID: <1047048075.664622@ftp.adept.co.za>


Thanks
And just to confirm if I take a hot backup of the datafiles and the babkup files at the time and directly after the backup(that was 100% successful) I only have to restore the archive logs that I have just backed up and the datafiles. Is this true?

cheers
James

"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message news:E2F6A70FE45242488C865C3BC1245DA70364CF1F_at_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:41:13 CST

Original text of this message

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