Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Standby errors
Hi
I would recommend that to use the 'alter system archive log current;'
since this command don't
return until the database has finished to archive the redo logfile.
Hemant K Chitale wrote:
>
> Rather than doing an ALTER SYSTEM SWITCH LOGFILE only,
> issue an ALTER SYSTEM ARCHIVE LOG NEXT
>
> I actually do an ARCHIVE LOG NEXT, SWITCH LOGFILE and also have a
> sleep in the backup-script, which then proceeds to copy all but the
> *last*
> archivelog out to tape !
>
> Hematn
> At 06:19 AM 14-03-03 -0800, you wrote:
>
>> Oracle 8.1.6 on Solaris 5.8.
>>
>> We have a read-only standby database for one of our production
>> databases.
>> Each night, the standby is shutdown and the previous days archive
>> logs from
>> production are applied. Then the database is brought backup in read-only
>> mode. To get the archive logs, a hot backup is done on the production
>> database. As the last step is the hot backup, a log switch is done
>> and then
>> the archive logs are ftp'd to the server where the standby is.
>>
>> After the hot backup completed yesterday, the log switch occurred,
>> and the
>> logs sent, but when an attempt was made to apply the archive logs we
>> got an
>> error:
>>
>> ORA-00332: archived log is too small - may be incompletely archived
>> ORA-00334: archived log: '/orabackup/archive/TBSPRD/arch1352.arc'
>> ORA-332 signalled during: ALTER DATABASE RECOVER
>>
>> In looking at the archive log, both on the production and standby
>> servers,
>> they are the same size - 16k (the block size for the db is 8k). The next
>> log is 8k in size and then there is another that is 16k before we see
>> any
>> that are normal sized. These would have been the first logs _after_
>> the hot
>> backup the night before.
>>
>> In the alert log for the production db, it appears the log 1353 was
>> archived
>> _before_ 1352.
>>
>> Has anyone seen this behavior before? Does anybody have any idea why it
>> happened in the first place? Is there something we can do to make
>> sure it
>> never happens again?
>>
>>
>> P.S. We are upgrading to 9.2 this weekend, if that makes any difference.
>>
>>
>> Terry Ball, DBA
>> Birch Telecom
>> Work: 816-300-1335
>> FAX: 816-300-1800
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.net
>> --
>> Author: Ball, Terry
>> INET: TBall_at_birch.com
>>
>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>> San Diego, California -- Mailing list and web hosting services
>> ---------------------------------------------------------------------
>> 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).
>
>
> Hemant K Chitale
> My personal web site is : http://hkchital.tripod.com
>
>
-- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856 mailto:peter.gram@MiracleAS.dk - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Peter Gram INET: peter.gram_at_miracleas.dk Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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 Mon Mar 17 2003 - 11:32:59 CST
![]() |
![]() |