-
编辑 删除
恢复rm -f物理删除数据文件
1、在数据库open的时候，直接删除users表空间中的数据库文件；SYS@jzh>select name from v$dbfile;NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jzh/users01.dbf/u01/app/oracle/oradata/jzh/undotbs01.dbf/u01/app/oracle/oradata/jzh/sysaux01.d...
-
编辑 删除
ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST
搭建Data Guard时遇到ORA-16019: cannot use LOG_ARCHIVE_DEST_1 with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST错误环境是Oracle 11.2.0.3,错误如下：SQL> alter system set log_archive_dest_1='location=/u01/oracle/arch valid_for=(all_logfiles,all_roles) db_unique_name=jyp';alter system set log_archive_...
-
编辑 删除
安装Oracle软件报主机名错误
在安装Oracle 11.2.0.3 software时，报主机名错误，如下：这个错误是因为/etc/hosts文件中没有主机名信息，将主机名信息加入即可进行安装！[root@orc2 ~]# vi /etc/hosts# Do not remove the following line, or various programs# that require network functionality will fail.127.0.0.1 &nb...
