Archive for ‘数据库’ Category
笔记本上安装的 oracle 9208数据库在演示RMAN备份时发现system01.dbf有一坏块，用dbv检查如下：
C:\Documents and Settings\bwen>dbv file=D:\ oracle \oradata\bright\system01.dbf blocksize=8192
DBVERIFY: Release 9.2.0.8.0 - Production on 星期二 11月 17 15:15:25 2009
Copyright (c) 1982, 2002, oracle Corporation. All rights reserved
DBVERIFY - 验证正在开始 : FILE = D:\ oracle \oradata\bright\system01.dbf
汇入的页23523 - 可能是介质损坏
***
Corrupt block relative dba: 0×00405be3 (file 1, block 23523)
Fractured block found during dbv:
Data in bad block [...]
一客户TSM备份失败，报如下错误：
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 07/08/2009 03:04:12
ORA-19502: write error on file “bk_9060_1_691642987″, blockno 1 (blocksize=512)
ORA-27030: skgfwrt: sbtwrite2 returned error
ORA-19511: Error received from media manager layer, error text:
ANS1312E (RC12) Server media mount not possible
在测试用RMAN的duplicate创建dataguard时报错：
[ oracle @ora10g dbs]$ rman target / auxiliary sys/ oracle @standby
Recovery Manager: Release 10.2.0.4.0 - Production on Fri Jul 3 11:11:42 2009
Copyright (c) 1982, 2007, oracle . All rights reserved.
connected to target database: DEMO (DBID=3435139725)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: [...]
一客户在用RMAN备份到NFS文件系统时报如下错误：
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on c2 channel at 06/29/2009 18:00:22
ORA-19504: failed to create file “/rman_backup/sunday_full_690832821″
ORA-27054: NFS file system where the file is created or resides is not mounted with correct options
Additional information: 5
一客户报RAC一节点的CRS无法启动，通过VPN远端连过去检查crs，如下：
# crsctl check crs
Failure 1 contacting CSS daemon
Cannot communicate with CRS
Cannot communicate with EVM
检查crs进程：
# ps -ef | grep css
root 6929 1 0 19:56 ? 00:00:00 /bin/sh /etc/init.d/init.cssd fatal
root 6960 6928 0 19:56 ? 00:00:00 /bin/sh /etc/init.d/init.cssd startcheck
root 6963 6929 0 19:56 [...]
一客户在用TSM备份 oracle 时经常报如下错误：
04/09/2009 07:45:43 PM
ANE4994S (Session: 836, Node: SZ-DB-SRV) TDPO LinuxAMD64
ANU0599 TDP for oracle : (12823): =>(SZ-DB-SRV)
ANU2602E The object /sz-db//c-3379378948-20090409-00 was not found on the TSM Server (SESSION: 836)
04/09/2009 09:11:17 PM
ANE4991I (Session: 837, Node: SZ-DB-SRV) TDPO LinuxAMD64
ANU0599 TDP for oracle : (12823): =>(SZ-DB-SRV)
ANU2535I File /sz-db//c-3379378948-20090409-00 = 56623104 bytes sent (SESSION: 837)
同事在测NBU调用RMAN进行备份时，出现如下错误：
Both single and double quotes(’ or ”) are accepted for a quoted-string.
Quotes are not required unless the string contains embedded white-space.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00552: syntax error in command line arguments
RMAN-01009: syntax error: found “dot”: expecting one of: “double-quoted-string, equal, identifier, single-quoted-string”
RMAN-01007: at line 2 column 1 file: command line arguments
Script [...]
客户数据库报如下错误：
Fri Feb 6 22:00:16 2009
Errors in file / oracle /admin/pnbrw/bdump/pnbrw2_j000_14187.trc:
ORA-12012: error on auto execute of job 8887
ORA-20000: ORA-20000: Content of the tablespace specified is not permanent or tablespace name is invalid
ORA-06512: at “SYS.PRVT_ADVISOR”, line 1624
ORA-06512: at “SYS.DBMS_ADVISOR”, line 186
ORA-06512: at “SYS.DBMS_SPACE”, line 1344
ORA-06512: at “SYS.DBMS_SPACE”, line 1560
Fri Feb 6 22:06:48 2009
前天一朋友打电话给我说他一客户的一张表的数据没了，叫我帮忙看看。
电话里简单了解了一下情况，大致是上午10:15左右开发人员发现一张基础表数据全没了，由于客户也不清楚数据库是归档还是非归档，于是吩咐他赶紧把应用停下来，因为一怕数据库是非归档，万一日志被覆盖就不好恢复了，二怕undo信息被覆盖，那样的话想用flashback都不行了。
