Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Standby errors
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
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: hkchital_at_singnet.com.sg 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 - 08:28:42 CST
![]() |
![]() |