https://blog.youkuaiyun.com/ying0216zh-cnhttps://blog.youkuaiyun.com/https://blog.youkuaiyun.com/ying0216/article/details/5472584https://blog.youkuaiyun.com/ying0216/article/details/5472584ying0216Sun, 11 Apr 2010 13:42:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5447431https://blog.youkuaiyun.com/ying0216/article/details/5447431ying0216Sat, 03 Apr 2010 12:41:00 +0800新建备份设备(3)创建操作员当备份成功或者失败的时候,通过网络通信通知管理员(4)在管理里面-->维护计划-->新建维护计划-->在计划任务的设计界面-->拖动备份数据到右边主编辑页面-->右键编辑-->选择你想要备份的数据库（例如下图我的是Test）然后选]]>https://blog.youkuaiyun.com/ying0216/article/details/5447428https://blog.youkuaiyun.com/ying0216/article/details/5447428ying0216Sat, 03 Apr 2010 12:39:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5359852https://blog.youkuaiyun.com/ying0216/article/details/5359852ying0216Tue, 09 Mar 2010 13:19:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5359844https://blog.youkuaiyun.com/ying0216/article/details/5359844ying0216Tue, 09 Mar 2010 13:18:00 +0800alter database force logging; Database altered. 3. 创建密码文件 [oracle@PRIMARY]orapwd file=orapwprimary password=xxxxxxx; 4. 修改有关data guard的参数]]>https://blog.youkuaiyun.com/ying0216/article/details/5359834https://blog.youkuaiyun.com/ying0216/article/details/5359834ying0216Tue, 09 Mar 2010 13:16:00 +0800set oracle_sid=inthdmp2 F:/oracle>sqlplus "/ as sysdba" Copyright (c) 1982, 2005, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup ORACLE 例程已经启动。 数据库装载完毕。 数据库已经打开。 SQL> 2、连接并启动辅助实例到no]]>https://blog.youkuaiyun.com/ying0216/article/details/5327473https://blog.youkuaiyun.com/ying0216/article/details/5327473ying0216Thu, 25 Feb 2010 21:53:00 +0800set oracle_sid=inthdmp2 F:/oracle>sqlplus "/ as sysdba" Copyright (c) 1982, 2005, Oracle. All rights reserved. 已连接到空闲例程。 SQL> startup ORACLE 例程已经启动。 数据库装载完毕。 数据库已经打开。 SQL> 2、连接并启动辅助实例到no]]>https://blog.youkuaiyun.com/ying0216/article/details/5327153https://blog.youkuaiyun.com/ying0216/article/details/5327153ying0216Thu, 25 Feb 2010 18:36:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5284785https://blog.youkuaiyun.com/ying0216/article/details/5284785ying0216Wed, 03 Feb 2010 13:53:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5279462https://blog.youkuaiyun.com/ying0216/article/details/5279462ying0216Tue, 02 Feb 2010 09:40:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5092617https://blog.youkuaiyun.com/ying0216/article/details/5092617ying0216Mon, 28 Dec 2009 17:16:00 +0800startup mount ORACLE instance started. Total System Global Area 167772160 bytes Fixed Size 1247924 ]]>https://blog.youkuaiyun.com/ying0216/article/details/5092584https://blog.youkuaiyun.com/ying0216/article/details/5092584ying0216Mon, 28 Dec 2009 17:13:00 +0800oradim -new -sid abc Instance created. 2.为了sys用户可以连入数据库执行操作，先创建数据库的密码文件，密码文件的名称必须为PWDsid.ora C:/WINDOWS>]]>https://blog.youkuaiyun.com/ying0216/article/details/5092007https://blog.youkuaiyun.com/ying0216/article/details/5092007ying0216Mon, 28 Dec 2009 16:22:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5091950https://blog.youkuaiyun.com/ying0216/article/details/5091950ying0216Mon, 28 Dec 2009 16:15:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5091920https://blog.youkuaiyun.com/ying0216/article/details/5091920ying0216Mon, 28 Dec 2009 16:11:00 +0800 desc v$log; Name Null? Type ----------------------------------------- -------- ---------------------------- GROU]]>https://blog.youkuaiyun.com/ying0216/article/details/5057389https://blog.youkuaiyun.com/ying0216/article/details/5057389ying0216Tue, 22 Dec 2009 18:48:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5018989https://blog.youkuaiyun.com/ying0216/article/details/5018989ying0216Wed, 16 Dec 2009 15:13:00 +0800https://blog.youkuaiyun.com/ying0216/article/details/5018976https://blog.youkuaiyun.com/ying0216/article/details/5018976ying0216Wed, 16 Dec 2009 15:11:00 +0800 select to_char(add_months(sysdate,-1),yyyy-MM-dd) PreTod]]>https://blog.youkuaiyun.com/ying0216/article/details/5018958https://blog.youkuaiyun.com/ying0216/article/details/5018958ying0216Wed, 16 Dec 2009 15:10:00 +0800 select trunc(sysdate,Q) from dual;TRUNC(SYSDATE,Q)------------------2007-4-12.trunc(sysdate,D) 本周的第一天(周日)SQL> select ]]>https://blog.youkuaiyun.com/ying0216/article/details/5018945https://blog.youkuaiyun.com/ying0216/article/details/5018945ying0216Wed, 16 Dec 2009 15:08:00 +0800 Select to_char(sysdate,Y) from dual;TO_CHAR(SYSDATE,Y)--------------------7SQL> Select to_char(sysdate,YY) from dual;TO_C]]>