ITPub博客

在RAC数据库其中一个实例创建standby controlfile失败，报如下错误：SQL> alter database create standby controlfile as '/home/oracle/standby01.ctl';*ERROR at line 1:ORA-00245:control file backup failed;targetis likely on local file system该错误是由于11gR2 RAC在备份控制时，每个实例都要能够写snapshot ...

今日重建DG遭遇RMAN-06100: no channel to restore a backup or copy of datafile错误，源端是一套RAC数据库，目标端是单实例，报错信息如下：Starting restore at 06-APR-16released channel: d1released channel: d2released channel: d3released channel: d4RMAN-00571: ========================================...

lsdg中的Usable_file_MB 为什么是负值?Negative Values of USABLE_FILE_MB Due to the relationship between FREE_MB, REQUIRED_MIRROR_FREE_MB, and USABLE_FILE_MB, USABLE_FILE_MB can go negative. Although this is not necessarily a critical situation, it does mean that: Depending on the value of FREE_MB, you may not be able to create new files. The next failure may result in files with reduced redundancy. If USABLE_FILE_MB becomes negative, it is strongly recommended that you a

1.AWR默认的采样间隔和历史快照保留时间默认是保留七天，采集间隔是1小时，这个信息可以从DBA_HIST_WR_CONTROL视图中获得。sys@ora10g> col SNAP_INTERVAL for a20sys@ora10g> col RETENTION for a20sys@ora10g> sel...

Oracle在11r1就开始支持snapshot data guard了，本次测试版本为11.2.0.31、取消DG端恢复模式SYS@jzh>select open_mode,database_role from v$database;OPEN_MODE            DATABASE_ROLE-------------------- ----------------READ ONLY WITH APPLY PHYSICAL STANDBYSYS@jzh>recover...

1、近日在redhat 5.8上安装Oracle 11.2.0.4 RAC时，在第二点节执行root.sh时遇到如下报错：ORA-15018: diskgroup cannot be createdORA-15072: command requires at least 3 regular failure groups, discovered only 0ORA-15080: synchronous I/O operation to a disk failed2、于是查看disk权限是否正确，结果没有任...

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...

搭建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 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...

近日在检查crsd.log文件时，发现大量的th_select_w_f_r: smwait error [1]错误，如下：2015-11-21 07:12:47.432: [  OCRSRV][1235589440]th_select_handler: Retrieved procctx from ht. constr = [-1338774512] retval lht [1] Wait for disconnect processing to complete on prev client.2015-11-21 07:12:47.444...

有些用户会对于归档日志的大小比在线日志小感到疑惑，对于这种情况：首先请检查您的归档日志文件是否压缩：SELECT to_char(first_time,'yyyy-mm-dd hh24:mi:ss'),blocks*block_size/1024/1024,compressed from v$archived_log;如果未压缩，那么这个问题可能和您的CPU个数有关。请查看您的CPU个数：show parameter CPU_...

1、节点2：创建测试表空间test，放在本地磁盘SQL> create tablespace test datafile '/home/oracle/test01.dbf' size 10m;Tablespace created.

<span style="color:#000000;font-size:14px;">在11g之前的版本中需要我们手动去清理trace文件，11g可以使用工具ADRCI清理，默认情况下由MMON后台进程进行自动清理过期的trace文件，这里涉及两个参数：</span><br /><span style="color:#000000;font-size:14px;"></span><span style="color:#000000;font-size:14px;">LONG...

<span style="color:#000000;font-size:14px;">当克隆一个数据库到另外一台机器上，具有相同的数据库名称或者如果一个新的数据库名称是通过重建的控制文件，</span><br /><span style="color:#000000;font-size:14px;">那么需要改变DBBID，特别是如果是新的数据库在相同的rman catalog是注册。</span><br /><span style=...

1、查看数据库角色SYS@jyp>select db_unique_name,database_role from v$database;DB_UNIQUE_NAME                 DATABASE_ROLE

<span style="color:#000000;">今日启动RAC</span><span style="color:#000000;">数据库，遇到报错</span><br /><span style="color:#000000;"></span><span style="color:#000000;">1、环境说明</span><br /><span style="color:#000000;">Oracle 11.2.0.4 两节点RAC</span><br /><span style="color:#000000;">Redhat ...

<span style="color:#000000;">某客户数据库在执行查询select &nbsp;* from&nbsp;</span><span style="color:#333333;font-family:Arial, Tahoma, Verdana;white-space:normal;background-color:#F7F7F7;"><span style="color:#000000;"><span style="color:#000000;">&nbsp;DBA_TAB_STATISTICS报如下错误：</span><span st...

1、创建cost目录(所有节点)[root@jzh1 ~]# mkdir -p /u01/app/11.2.0/grid/network/admin/cost2、创建ewallet.p12钱包[oracle@jzh1 ~]$ orapki wallet c...

<span style="color:#000000;">帮某客户恢复数据，只有数据文件与控制文件，归档已经全部删除，recover时报错，系统表空间数据文件system01.dbf 需要恢复，所以决定重建controlfile</span><br /><span style="color:#000000;"></span><span style="color:#000000;">CREATE CONTROLFILE REUSE DATABASE "JZH" RESETLOGS FOR...

1、创建测试表空间与用户SYS@TEST>create tablespace spa datafile '/u01/app/oracle/oradata/spa01.dbf' size 100M autoextend on;Tablespace created.