add controlfile for a asm database
sql> shutdown immediate;sql> startup nomount;$ rman nocatalogRMAN>connect targetRMAN>restore controlfile to '+ASM2/orcl/controlfile/newfile.name' from '+ASM/orcl/controlfile/controlfile.name';sql> alter system set controlfiles='+ASM/orcl/controlfile.name', '+ASM2/orcl/controlfile/newfile.name' scope=spfile;sql> alter database mount;sql> alter database open;Subject: How to duplicate a controlfile when ASM is involved Doc ID: Note:345180.1 Type: HOWT
solaris 10 下 oracle RAC (ASM) 10.2.0.3 实施 记录
test[@more@]test
关于 cursor_sharing 设置的一个小问题
cursor_sharing =similiar 时候,由于失去变量的长度信息 BDE 应用可能在使用TO_CHAR 函数时候输出为MEMO字段类型.因此慎重使用![@more@]cursor_sharing =similiar 时候,由于失去变量的长度信息 BDE 应用可能在使用TO_CHAR 函数时候输出为MEMO字段类型.因此慎重使用!