<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[cslz25498的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/cslz25498</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; cslz25498]]></copyright><item><title><![CDATA[kill job]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269969</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269969</guid><author>cslz25498</author><pubDate>Thu, 20 Aug 2015 20:23:48 +0800</pubDate><description><![CDATA[alter system set job_queue_processes=0 scope=both;


	


	第一步：查看正在运行的jobs


	SQL&gt;select * from dba_...]]></description><category></category></item><item><title><![CDATA[oracle角色与权限]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269972</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269972</guid><author>cslz25498</author><pubDate>Thu, 20 Aug 2015 20:21:17 +0800</pubDate><description><![CDATA[##DBA_ROLE_PRIVS
DBA_ROLE_PRIVS describes the roles granted to all users and roles in the database.（授予用户和其他角色的角色）...]]></description><category></category></item><item><title><![CDATA[data guard搭建]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269968</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269968</guid><author>cslz25498</author><pubDate>Wed, 10 Jun 2015 11:50:35 +0800</pubDate><description><![CDATA[搭建data guard 


	主库：hostname（TESTDB2)   db_name （ DG2） db_unique_name （DG2) 


	备库：hostname（TESTDB...]]></description><category></category></item><item><title><![CDATA[rman 管理备份报告和检查删除]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269965</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269965</guid><author>cslz25498</author><pubDate>Wed, 10 Jun 2015 11:49:23 +0800</pubDate><description><![CDATA[LIST 

	概述可用的备份 


	 
	
		RMAN&gt; list backup summary;
	
	
		RMAN&gt; list backup of database/archive...]]></description><category></category></item><item><title><![CDATA[RAMN复制数据库]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269966</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269966</guid><author>cslz25498</author><pubDate>Sat, 16 May 2015 12:08:26 +0800</pubDate><description><![CDATA[target:rhel6 auxiliary:enmo




在auxiliary上面


建立一个参数文件让实例可以启动到nomount
[oracle@enmo dbs]$ vi initenmo.or...]]></description><category></category></item><item><title><![CDATA[丢失current日志文件]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269967</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269967</guid><author>cslz25498</author><pubDate>Wed, 06 May 2015 19:43:47 +0800</pubDate><description><![CDATA[SYS@rhel6&gt; select group#,status from v$log;


  GROUP# STATUS
---------- ----------------
1 INACTIVE
2 ...]]></description><category></category></item><item><title><![CDATA[恢复重做日志incative]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269964</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269964</guid><author>cslz25498</author><pubDate>Wed, 06 May 2015 19:10:56 +0800</pubDate><description><![CDATA[SYS@rhel6&gt; select group#,members,status from v$log;


  GROUP#  MEMBERS STATUS
---------- ---------- --...]]></description><category></category></item><item><title><![CDATA[集合运算符]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269963</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269963</guid><author>cslz25498</author><pubDate>Mon, 04 May 2015 16:50:31 +0800</pubDate><description><![CDATA[注意事项：
1：在select列表中的列名和表达式在数量上必须匹配
2：第二个查询中的每一列的数据类型必须和第一个查询其对应的列的数据类型匹配
３、ORDER BY子句不能在某个单独的查询中应用，只能用在整个查询的最后，用...]]></description><category></category></item><item><title><![CDATA[重建控制文件]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269962</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269962</guid><author>cslz25498</author><pubDate>Sun, 12 Apr 2015 20:53:37 +0800</pubDate><description><![CDATA[找到最近的trace文件从中获得重建控制文件的脚本
Set #2. RESETLOGS case
--
-- The following commands will create a new control file a...]]></description><category></category></item><item><title><![CDATA[手工建库]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269961</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269961</guid><author>cslz25498</author><pubDate>Sat, 04 Apr 2015 23:41:36 +0800</pubDate><description><![CDATA[1.环境变量设置2.创建所需目录3.生成密码文件4.创建pfile参数文件5.生成spfile参数文件6.执行创建数据库语句7.执行catalog.sql和catproc.sql脚本8.最后的检查


.bash_...]]></description><category></category></item><item><title><![CDATA[tnsnames.ora,sqlnet.ora,listener.ora的具体内容]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269959</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269959</guid><author>cslz25498</author><pubDate>Tue, 31 Mar 2015 23:18:24 +0800</pubDate><description><![CDATA[tnsnames.ora：主要位于客户端，用于保存网络服务名到连接描述符的映射，适用于本地命名方式
sqlnet.ora  ：位于客户端和数据库服务端，主要包含默认域名、命名方式排序、连接路由信息、外部命令参数、数据库访...]]></description><category></category></item><item><title><![CDATA[改变文件权限与属性]]></title><link>https://blog.youkuaiyun.com/cslz25498/article/details/100269960</link><guid>https://blog.youkuaiyun.com/cslz25498/article/details/100269960</guid><author>cslz25498</author><pubDate>Wed, 25 Mar 2015 23:29:10 +0800</pubDate><description><![CDATA[chgrp：改变档案所属群组；chown：改变档案拥有者；chmod：改变档案权限
chgrp [-R] dirname/filename，-R是递归持续变更

chown [-R] 账号名称， 档案或者目录
chown...]]></description><category></category></item></channel></rss>