rman在rac或ASM环境做增量恢复时报错RMAN-06094 datafile 1 must be restored
现象rman先做了全量的resotore+recover操作，然后还原增量的控制文件，然后做增量的recover操作，结果报错了RMAN> recover databaStarting recover at 27-FEB-2 ... 阅读全文
标签： Oracle
rman全量+增量恢复报错ORA-01152: file 1 was not restored from a sufficiently old backup
现象rman在做完增量恢复操作后，执行“alter database open resetlogs;”，报错：ORA-01152: file 1 was not restored from a suf ... 阅读全文
Oracle创建控制文件时报错ORA-15173
现象创建控制文件时报错RMAN-00571: ==========================================================RMAN-00569: ===== ... 阅读全文
ORA-00904: "WM_CONCAT": invalid identifier错误解决
现象若在创建数据库的时候没有创建WMSYS用户，则在SQL或PL/SQL中有用到WM_CONCAT函数的时候就会报ORA-00904的错误。SYS@lhrsdb> SELECT WM_CONCA ... 阅读全文
ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA
现象在执行rman还原控制文件时，报错了，“ORA-15204: database version 11.2.0.4.0 is incompatible with diskgroup DATA”RM ... 阅读全文
RMAN-06100: no channel to restore a backup or copy of datafile
现象今天在还原一套rac库的时候，执行restore命令报错了：“RMAN-06100: no channel to restore a backup or copy of datafile”RMAN ... 阅读全文
dbca静默报错[FATAL] Error while restoring PDB backup piece
dbca静默建库报错[oracle@raclhr-21c-n2 ~]$ dbca -silent -createDatabase -templateName General_Purpose.dbc ... 阅读全文
数据库软件安装报错：dumpsga Error 1 all_no_orcl of makefile ins_rdbms.mk
INFO- Linking SGA Dump Utility (dumpsgaINFOrm -f /u01/app/oracle/product/21.3.0/dbhome_1/rdbms/li ... 阅读全文
grid跑root.sh报错：libcrs.so: cannot read file data
[root@raclhr-21c-n1 grid]# /u01/app/21.3.0/grid/root.sPerforming root user operation.The following ... 阅读全文
在Oracle中，如何查询密码输入错误的登陆用户？
DBA_PROFILEOracle用户的状态是由密码来决定的，而Oracle中的密码是由PROFILE来配置的。PROFILE是口令限制、资源限制的命令集合。当建立数据库时，Oracle会自动建立名 ... 阅读全文
