<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[咸鱼]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/dbafish</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; dbafish]]></copyright><item><title><![CDATA[Opatch及PSU下载地址]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/78578288</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/78578288</guid><author>dbafish</author><pubDate>Sun, 19 Nov 2017 23:25:53 +0800</pubDate><description><![CDATA[Opatch：
Patch 6880880
https://updates.oracle.com/download/6880880.html



补丁下载地址：
Assistant: Download Reference for Oracle Database/GI PSU, SPU(CPU), Bundle Patches, Patchsets and Base Releases]]></description><category></category></item><item><title><![CDATA[hp ux修改网络配置]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/53117382</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/53117382</guid><author>dbafish</author><pubDate>Thu, 10 Nov 2016 16:51:56 +0800</pubDate><description><![CDATA[一、配置文件

1、/etc/rc.config.d/netconf

2、/etc/hosts

二、启动文件

1、/sbin/init.d/net start|stop

2、/sbin/init.d/hostname start

三、修改配置文件netconf(vi /etc/rc.config.d/netconf)

1、修改主机名Hostname

 ]]></description><category></category></item><item><title><![CDATA[oracle 11g 静默安装]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/53084552</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/53084552</guid><author>dbafish</author><pubDate>Tue, 08 Nov 2016 17:19:35 +0800</pubDate><description><![CDATA[两种方式：GUI和静默安装
查看使用情况： watch du -sh
查看当前用户：whoami
非日志文件模式登录：sqlplus /nolog;


静默安装流程：
xhost+
ect/hosts映射设置
建组和用户oracle
修改.bash_profile（上述操作与GUI安装一样）
-----------------------------------------]]></description><category></category></item><item><title><![CDATA[部署Oracle Data Guard]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50514055</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50514055</guid><author>dbafish</author><pubDate>Wed, 13 Jan 2016 23:40:12 +0800</pubDate><description><![CDATA[环境 
 




Oracle DB
11.2.0.4


Linux
ol6.5


主库
PROD1


备库 
PROD2





配置网络（两台都配置）# vi /etc/hosts
192.168.56.10   prod1.us.oracle.com     prod1
192.168.56.11   prod2.us.oracle]]></description><category></category></item><item><title><![CDATA[关于RMAN迁移的一则实验 单server 一份备份恢复两个库]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50452511</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50452511</guid><author>dbafish</author><pubDate>Sun, 03 Jan 2016 20:55:29 +0800</pubDate><description><![CDATA[此前已经恢复过一个库
现在进行第二个库的恢复


切换一个没有用的实例名并登陆rman
$ export ORACLE_SID=PROD10
$ rman target /

Recovery Manager: Release 11.2.0.4.0 - Production on Sun Jan 3 20:47:27 2016


Copyright (c) 1982, 2011, Or]]></description><category></category></item><item><title><![CDATA[oracle数据库文件系统迁移到ASM]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50445483</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50445483</guid><author>dbafish</author><pubDate>Fri, 01 Jan 2016 18:41:03 +0800</pubDate><description><![CDATA[查看ASM磁盘组
SQL> select name,state from  v$asm_diskgroup;
登陆RMAN执行镜像全备到ASM磁盘组
$rman target /
RMAN> backup as copy database format '+data';

Starting backup at 01-JAN-16
using target database control]]></description><category></category></item><item><title><![CDATA[Oracle Rman 命令详解(List report backup configure)]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50414825</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50414825</guid><author>dbafish</author><pubDate>Sun, 27 Dec 2015 23:59:15 +0800</pubDate><description><![CDATA[一、list常用命令总结备忘

    list命令列出控制文件、RMAN恢复目录中备份信息， 是我们对所有可见的数据库备份文件的一个最直观的了解的方法

    list incarnation;
    list backup summary;
    list backup of database summary;
    list backup of tablespace s]]></description><category></category></item><item><title><![CDATA[oracle更改数据文件位置]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50322917</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50322917</guid><author>dbafish</author><pubDate>Wed, 16 Dec 2015 02:03:14 +0800</pubDate><description><![CDATA[环境：表空间t1
1,、将表空间t1置为offline状态SQL> alter tablespace t1 offline;

Tablespace altered.
2、查询表空间现位置SQL> select name from v$datafile;

NAME
----------------------------------------------------------------]]></description><category></category></item><item><title><![CDATA[配置双动态监听，多端口监听和静态监听]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50295407</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50295407</guid><author>dbafish</author><pubDate>Mon, 14 Dec 2015 15:30:02 +0800</pubDate><description><![CDATA[我这里已经发存在了一个监听，如没有的话可oracle下执行netca或netmgr，和手动配置一个。


配置监听时需了解和注意的地方：
SERVICE_NAME
HOST
PORT
GLOBAL_DBNAME
ORACLE_HOME     
SID_NAME


增加一个动态监听


修改 listener.ora 增加以下内容 
$ORACLE_HOME/ne]]></description><category></category></item><item><title><![CDATA[使用Opatch给oracle打补丁]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50276523</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50276523</guid><author>dbafish</author><pubDate>Sat, 12 Dec 2015 17:24:43 +0800</pubDate><description><![CDATA[11.2.0.4.0升级到11.2.0.4.8
使用新版的Opatch替换原有的Opatch在$ORACLE_HOME里


$ cd $ORACLE_HOME
$ tar zvcf OPatch.tar.bak OPatch
$ rm -rf OPatch

上传新的Opatch到$ORACLE_HOME里


在变量文件PATH处增加Opatch路径，并让变量文件生效

$]]></description><category></category></item><item><title><![CDATA[oracle 11g 手动建库]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50272135</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50272135</guid><author>dbafish</author><pubDate>Sat, 12 Dec 2015 02:01:47 +0800</pubDate><description><![CDATA[安装数据库软件并设置环境变量就不说了

创建密码文件
$ cd $ORACLE_HOME/dbs
$ orapwd file=orapwdPROD1 password=oracle

创建参数文件]]></description><category></category></item><item><title><![CDATA[检查点队列浅析]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50199709</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50199709</guid><author>dbafish</author><pubDate>Sun, 06 Dec 2015 23:15:41 +0800</pubDate><description><![CDATA[参与检查点的进程主要包括LGWR，DBWn，和CKPT，分为两大类：完全检查点和增量检查点
完全检查点主要包括以下步骤：
首先在日志缓冲中确定当前的（也就是最新的）重做记录，提取其RBA和SCN作为检查点目标
LGWR清空日志缓存，将重做记录写入在线日志
DBWn进程将检查点目标（RBA和SCN）产生的及检查点目标之前产生的脏数据块，按RBA的顺序写入数据文件
最后，CKPT进程将检查点目标（RBA和SCN）写入数据文件的头部和控制文件]]></description><category></category></item><item><title><![CDATA[Liunx学习笔记（一）常用命令]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50174877</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50174877</guid><author>dbafish</author><pubDate>Fri, 04 Dec 2015 14:41:22 +0800</pubDate><description><![CDATA[ls   查看当前目录下文件
ls -a  显示当前目录下所有文件包含隐藏文件
ls -tlr 查看当前目录下文件详细信息 -r是按修改时间排序
ls -ld 查看目录详细信息
ll同ls -l 意义相同

[root@olpt2 home]# ls -tlr
total 8
drwx------.  4 test1  test1    4096 Dec  3 10:40 test1]]></description><category></category></item><item><title><![CDATA[RAID , LVM , 配置静态IP 浅析]]></title><link>https://blog.youkuaiyun.com/dbafish/article/details/50148969</link><guid>https://blog.youkuaiyun.com/dbafish/article/details/50148969</guid><author>dbafish</author><pubDate>Wed, 02 Dec 2015 15:30:07 +0800</pubDate><description><![CDATA[RAID，LVM，静态ip配置，










磁盘列阵
RAID 即为「Redundant Array of Independent Drives」或「Redundant Array of Inexpensive Drives (or Disks)」的简写，一般俗称「磁盘阵列」，就是以两台或更多的硬盘，组成一个或增加传输速度，或增大总容量，或增加文件备份的大磁盘。]]></description><category></category></item></channel></rss>