数据库安装10204 patch set后发现vip服务down掉       # ./crs_stat -t   Name           Type           Target    State &n

一、安装环境配置   二、解压安装包,配置相应文件–参考database/response/db_install.rsp [oracle@addr soft]$ cd database/ [oracle@addr database]$ ls doc  install  readme.html  

        源网卡   目标网卡 public  eth2     eth0 private eth3     eth1   一、修改public private 1.停止数据库、集群 srvctl stop database -d orcl

oracle用户双节点执行 1节点 srvctl stop home -o /oracle/app/product/11.2.0/db_1 -s /oracle/soft/status.lst -n node1 2节点 srvctl stop home -o /oracle/app/product/11.2.0/db_1 -s /oracle/soft/status.l

环境 目标: 172.16.8.13  node1 172.16.8.14  node2   172.16.8.15 node1-vip 172.16.8.16 node2-vip   10.10.1.13      node1-priv 10.10.1.14      node2-

将数据文件拷贝到asm里 startup mount rman target / copy datafile '/oradata/bsrun/sysaux01.dbf' to '+DATA/BSRUN/sysaux01.dbf'; copy datafile '/oradata/bsrun/system01.dbf' to &

一、主库切换为备库 1.检查是否支持切换 SQL> select switchover_status from v$database;   SWITCHOVER_STATUS ——————– TO STANDBY   2.将主库切换为备

一、查看归档和闪回状态 SQL> select log_mode,open_mode,flashback_on from v$database;   LOG_MODE     OPEN_MODE            FLASHBACK_ON ——&#

一、主库配置 1.打开force logging SQL>select force_logging from v$database;   2.创建standby logfile 大小和日志文件一致 数量为:(maximum number of logfiles for each thread + 1) * maximum numb

1.10g中安装ogg,在跑脚本时出现以下错误 ,提示需要dbms_shared_pool包 SQL> @ddl_pin odc BEGIN dbms_shared_pool.keep('odc .DDLReplication', 'P'); END;         *

一、对磁盘进行分区 [root@test1 ~]# fdisk -l   Disk /dev/sda: 32.2 GB, 32212254720 bytes 255 heads, 63 sectors/track, 3916 cylinders Units = cylinders of 16065 * 512 = 8225280 bytes   &nbs

一、用rman进行全备 [oracle11203@localhost ~]$ rman target / RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/oracle11203/backup/rman_full_%U';   new RMAN configuration param

1.创建目录 查询已有目录:select * from dba_directories 创建并授权: create directory dump_dir AS '/tmp/' grant read,write on directory dump_dir to test;   2.导出数据 (1)按用户导出: exp