RAC环境数据文件误建到本地文件系统处理

In this Document

APPLIES TO:

SYMPTOMS

user add datafile for RAC DataBase in the local node

SQL> alter tablespace system add datafile 'FRA' SIZE 250M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

then when he query DBA_DATA_FILES
ORA-01157: cannot identify/lock data file 66 - see DBWR trace file
ORA-01110: data file 66: '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/FRA' 

CHANGES

datafiles add to system Tablespace by mistake on the local Node instead of shared diskgroup

CAUSE

This is expected as it is RAC DB and it suppose to create the new Datafile on the shared disk no on the local node

when user add data file using SQL> alter tablespace system add datafile 'FRA' SIZE 250M AUTOEXTEND ON NEXT 50M MAXSIZE UNLIMITED;

its add the datafile in the default OMG location db_create_file_dest

SQL> show parameter db_create_file_dest

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_create_file_dest string

and when it is Null the default locaion $OH/dbs

多多淘宝客

安装环境: php5.2+mysql5.x 以上;Zend版本： Zend Optimizer 3.3.0 或以上版本最少配置 200M+20Mmysql;推荐配置：大于500M空间+大于50M数据库。 站长要求：网络建站初学者及更高级站长。网站管理要求：一天在线5小时左右(主要为了在线客服，邮件或电话服务可忽略)，管理时间30分钟左右(做提现审核及支付处理，适当增加文章发布等)。适合环境:单独建

0

查看详情

SOLUTION

- Open the DB in Mount state

- copy the created Datafile to the shared Disk Group

please note that the DB must be in the archive mode .

- using SQL PLUS rename the Datafile to the New location

- open the DB

- remove the old file