set newname for
|
345
|
0
|
Script

13 字
|
1 分钟内
RMAN set newname脚本: windows: set linesize 500 set pagesize 500 col file_name for a60 select 'set newname for datafile '||file_id||' to ''D:\Ora11gData…
RMAN从ASM复制归档日志脚本
|
287
|
0
|
Script

16 字
|
1 分钟内
从ASM磁盘Copy归档日志至文件系统: SQL> set linesize 200 pagesize 200 SQL> col name for a80 SQL> select 'copy archivelog '''||name||''' to '…
DBCA建库发现不了ASM磁盘组
|
247
|
0
|
Oracle

88 字
|
4 分钟
Asmdiskgroup cannot be discovered 一、现象 二、解决方法 一、检查磁盘权限 [root@racnode01 ~]# ll /dev/asm* brw-rw---- 1 grid asmadmin 8, 16 Jan 5 16:43 /dev/asm-diskb brw-rw---- 1 grid asmadmin …
Can’t locate Env.pm in @INC
|
377
|
0
|
Oracle

14 字
|
1 分钟内
Oracle11g RAC卸载grid报错: [root@racnode01 ~]# /opt/app/11.2.0/grid/crs/install/rootcrs.pl -deconfig -force Can't locate Env.pm in @INC (@INC contains: /usr/local/lib64/perl5…
ORA-01180: can not create datafile 1
|
267
|
0
|
Oracle

19 字
|
1 分钟内
RMAN恢复报错ORA-01180: can not create datafile 1 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ==…
Centos7.4安装Oracle11g
|
335
|
0
|
Oracle

556 字
|
15 分钟
Centos7.4安装Oracle11g 一、环境规划 HostName IP DB Name Version Oracle Home Oracle Base server01 192.168.1.113 oradb Oracle11g 11.2.0.4 /opt/app/oracle/product/11.2.0/db_1 /opt/app/or…
Oracle11g RAC迁移至单机
|
261
|
0
|
Oracle

1121 字
|
42 分钟
Oracle11g RAC迁移到单机 一、环境 1.RAC环境(源库) HostName Public IP Private IP VIP Scan IP DB Name Rac01 192.168.1.21 10.0.0.21 192.168.1.23 192.168.1.25 mydb Rac02 192.168.1.22 10.0.0.22 …
ORA-00349: failure obtaining block size for ‘+dat
|
469
|
0
|
Oracle

93 字
|
4 分钟
一、故障现象 RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: ============…