Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Standby Recovery Errors - Pls Help

Standby Recovery Errors - Pls Help

From: Calvin Lim <calvin-lim_at_mediaring.com>
Date: Sun, 02 Jul 2000 10:14:20 -0500
Message-Id: <10546.111072@fatcity.com>


Hi,

Our standby database often applies log changes successfully and then reports failure due to log corruption at some point later in time. It is intermittent, does anybody knows why this happens? How can i get around this? Pls help.

Regards,
Calvin

---

Oracle Server Manager Release 3.1.5.0.0 - Production

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production
With the Partitioning and Java options
PL/SQL Release 8.1.5.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> recover standby database;
ORA-00279: change 88965481 generated at 07/02/00 00:38:32 needed for thread 1
ORA-00289: suggestion : /opt/app/oracle/product/8.1.5/admin/mydb/arch/1_404.log
ORA-00280: change 88965481 for thread 1 is in sequence #404
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00283: recovery session canceled due to errors
ORA-00356: inconsistent lengths in change description
ORA-00353: log corruption near block 2568 change 88967441 time 07/02/00 00:40:07
ORA-00334: archived log: '/opt/app/oracle/product/8.1.5/admin/mydb/arch/1_404.log'


-----BEGIN PGP PUBLIC KEY BLOCK-----
Version: PGPfreeware 6.0.2i

mQENAziIKPcAAAEIAMOziD1YcgivJCdmdMaQftSrMhnL6uXjz9Fh6c2FjDbEwLb1
gHAYk8bdlaWLPspacuwo5mjzCc5uUvNualORP+tLxGNY9GiMdHMUfUdNLxv7EU4+
6WxaXwyzz5DZUQiwLsvg12+ZSLOuOL4BLu8oJH9MBSPa/9aaYGDpQ845L6JJP5t1
uDDsG26k6gnenOfT+ZaEgFTFpYQbfXN7X16dc726AcEuSG8NUjK3thA3ol9m8768
cCELkc82w55HNH5b4TeF9obapJrXgOLqnf2pi4mUodao5dFewW/U46zPcz2giRp4
gVPAmJFs+s8OjKY74D3aXH7QWg7bLrLOrBG3pkUABRG0L0NhbHZpbiBMaW0gU3dl
ZSBLaGlhbmcgPGNhbHZpbl9saW1AaG90bWFpbC5jb20+iQEVAwUQOIgo9y6yzqwR
t6ZFAQFrTAf+Lw6aI0wSfOooU1n9qw0zdL4o0U4ZH+XAgzn8BoVcv0U1bA0U1ckg
pDY5TVfR0hQg7DQyUvh1AKxeD9D6OTFpg/TE3BPD49iq/LS3uuUbfIGmhsE6AmM1
SiRwwmA5n5IZTWDYHrocBJegV5Hk3iHJeDjCKvX/CZCZH4CGJ/2y/THfa6I9eDfF
kmZ8f90cM4hZ9YiqLSslNf5hztJZzEfBuSs7Zz6tHRQFlCucn5mlKPNM+ig4FBdS
f6ISUMxQxZB2xbFwYDn+qjB6eF8HianPP7XCQUSQNJeWKQ9pkJ7QOZeEKvRYZHp2
tLNw34pJ8cHoOIGS7FAi+OX2IfyyOvehkw==
Received on Sun Jul 02 2000 - 10:14:20 CDT

Original text of this message

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