Re: Archive logs? help?

From: Sigrid Ehrenreich <Sigrid.Ehrenreich_at_carus-it.com>
Date: Fri, 07 Mar 2003 19:59:02 +0100
Message-ID: <3E68EBF6.2010406@carus-it.com>

No, please do several log switches (alter database archive log current) after backing up your datafiles and before backing up the archivelogs (and controlfiles, too!).

I had the case, that the database was backuped online and the archivelogs immediately afterwards.
The next day the machine was lost and we had to restore the database from our backup. We then found out, that the redo information that was written during the online backup was still in the online redo logs and not in the archivelogs. But the redo logs were lost. So after restoring the backup, the server was still asking for the SCN in the redo log that was lost.

We solved this problem by restoring the backup from the night before and rolling forward with the archivelogs of this night, just to the point before we had made that unrestorable backup.

Yours Sigrid

James schrieb:

> 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 - 12:59:02 CST