oracle support一次危机处理（之一）
天有不测风云，
IBM 的中端磁盘阵列这次又惹祸了。在微码升级的时候，
DS4800 发生故障。IBM工程师把阵列故障恢复后，拍拍屁股走人，留下了阵列上不一致的数据。
没办法，阵列上的数据又得我们来想办法抢救了。。。。
还好有oracle support的支持我们最终化解了这次危机。下文详细介绍了整个恢复的过程。
oracle工程师到达现场后，根据错误信息，
问题情况如下SR信息所示：（HP-UX PA-RISC (64-bit)+ORACLE 9.2.0.8.0.+filesystem+no archivelog mode+no backup)
** Customer's Management 24x7 contact name:***************
** Customer's Management 24x7 contact number: ****************
** Primary Customer contact name: *******************
** Current Customer 24x7 voice phone number: ********************
** Current Customer E-mail address: ********************
** Current Customer Pager/Fax number: *****************
### Characteristics of Problem ###
This is a critical production system
Database is down and will not start
Data corruption issue and media recovery failed to fix the problem
### Note:28814.1 did not help because: ###
It did not have the needed information.
### Other: Note:28814.1 did not help because: ###
Sys owned objects corrupted
### The corruption was detected on: ###
Data file.
### Other: The corruption was detected on: ###
system tablespace
### The corruption affected a segment of type: ###
Table.
### Other: The corruption affected a segment of type: ###
TRANSACTION MANAGED DATA BLOCK
### The affected segment belongs to: ###
Database Dictionary.
### Other: The affected segment belongs to: ###
Database dictionary
### What error(s) and message(s) are Oracle reporting? ###
09:52:24 SQL> recover database allow 1 corruption;
ORA-00283: recovery session canceled due to errors
ORA-10562: Error occurred while applying redo to data block (file# 1, block# 1490)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/oradata/yincang/rlv_system'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 201
ORA-00600:
相关文档：
Oracle中使用WMSYS.WM_CONCAT函数进行多行转列
原数据：
rank name
AA NAME1
AA NAME2
AA NAME3
BB NAME4
BB NAME5
SQL>select trim(t.rank) as rank,
&nbs ......
查询星期几:
select to_char(sysdate,'day') from dual;
查询几号:
select to_char(sysdate,'dd') from dual;
查询小时数:
select to_char(sysdate,'hh24') from dual;
查询时间:
select to_char(sysdate,'hh24:mi:ss') from dual;
查询日期时间:
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') from dual;
查 ......
/**
*
*/
package com.huawei.widget.util;
import java.math.BigDecimal;
/**
* @author tanjixuan
* @since 2008-12-20
*
*/
public final class DatabaseUtil
{
// oracle转义字符
public static final char ORACLE_ESCAPE_CHAR = '\\';
// orac ......
在SQL*Plus中：（1）如何添加删除数据库？（2）数据库就是表吗？？（3）如何创建表空间？（4）如何创建用户？（5）是不是一个表空间只能创建一个用户？（6）怎样从客户端访问数据库服务器的配置？
回答：
1、何添加删除数据库？没这种概念，不懂。
2、数据库=所有的oracle的数据文件+控制文件+日志文� ......
