rac把数据文件创建在不共享的地方(二)
会提示工具支持的哪些命令
commands:
--------
md_backup, md_restore
lsattr, setattr
cd, cp, du, find, help, ls, lsct, lsdg, lsof, mkalias
mkdir, pwd, rm, rmalias
chdg, chkdg, dropdg, iostat, lsdsk, lsod, mkdg, mount
offline, online, rebal, remap, umount
dsget, dsset, lsop, shutdown, spbackup, spcopy, spget
spmove, spset, startup
chtmpl, lstmpl, mktmpl, rmtmpl
chgrp, chmod, chown, groups, grpmod, lsgrp, lspwusr, lsusr
mkgrp, mkusr, orapwusr, passwd, rmgrp, rmusr
volcreate, voldelete, voldisable, volenable, volinfo
volresize, volset, volstat
ASMCMD> cp /tmp/rman.dbf +DATA/racdb/datafile/rman.dbf --开始拷贝
copying /tmp/rman.dbf -> +DATA/racdb/datafile/rman.dbf
ASMCMD> cd +DATA/racdb/datafile
ASMCMD> ls
SYSAUX.260.810947931
SYSTEM.259.810947895
TEST.268.811013157
UNDOTBS1.261.810947961
UNDOTBS2.263.810948005
USERS.264.810948015
rman.dbf
test.dbf
然后退出用sqlplus更改
[oracle@rac1 tmp]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 25 16:40:28 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL>
SQL>
SQL> ALTER DATABASE RENAME FILE '/tmp/rman.dbf' TO '+DATA/racdb/datafile/rman.dbf';
ALTER DATABASE RENAME FILE '/tmp/rman.dbf' TO '+DATA/racdb/datafile/rman.dbf'
*
ERROR at line 1:
ORA-01511: error in renaming log/data files
ORA-01121: cannot rename database file 7 - file is in use or recovery
ORA-01110: data file 7: '/tmp/rman.dbf'
SQL>
SQL>
SQL> alter datafile '/tmp/rman.dbf' offline; --这里是非归档模式，所以无法直接用offline
alter datafile '/tmp/rman.dbf' offline
*
ERROR at line 1:
ORA-00940: invalid ALTER command
SQL> alter database datafile '/tmp/rman.dbf' offline drop; --使用offline drop
Database altered.
SQL> ALTER DATABASE RENAME FILE '/tmp/rman.dbf' TO '+DATA/racdb/datafile/rman.dbf'; --此时再次更改
Database altered.
SQL>
SQL> alter database datafile '+DATA/racdb/datafile/rman.dbf' online; --直接online会报错（因为scn不是当前的）
alter database datafile '+DATA/racdb/datafile/rman.dbf' online
*
ERROR at line 1:
ORA-01113: file 7 needs media recovery
ORA-01110: data file 7: '+DATA/racdb/datafile/rman.dbf'
SQL> recover database datafile 7; --笔者记错命令
ORA-00274: illegal recovery option DATAFILE
SQL> recover datafile 7; --使用介质恢复
Media recovery complete.
SQL>
SQL>
SQL> alter database datafile '+DATA/racdb/datafile/rman.dbf' online; --这次online成功了
Database altered.
SQL>
SQL>
SQL>
SQL> select * from casd --查询数据成功
2 ;
ID NAME
---------- --------------------
1 cc
再到节点二查询：
[oracle@rac2 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 25 16:53:46 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
Wi