-
编辑 删除
redo中的update
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !uname -aLinux localhost.localdomain 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i6...
-
编辑 删除
RMAN的LIST
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)K...
-
编辑 删除
RMAN-1
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !uname -aLinux localhost.localdomain 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i6...
-
编辑 删除
os认证
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !uname -aLinux localhost.localdomain 2.6.18-194.el5 #1 SMP Mon Mar 29 20:06:41 EDT 2010 i...
-
编辑 删除
dbca.sh
#!/bin/sh -f# $Header: assistants/bin/dbca.sh /main/84 2009/06/15 09:11:43 svsathe Exp $## dbca.sh## Copyright (c) 1997, 2009, Oracle and/or its affiliates. All rights reserved. ## NAME# dbassist - Shell script to run Database Creation Assistant### &n...
-
编辑 删除
resetlogs noresetlogs
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r...
-
编辑 删除
RMAN前奏
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r o...
-
编辑 删除
EXPDP/IMPDP
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r ...
-
编辑 删除
EXP/IMP
EXP/IMP是oracle中比较传统的数据库逻辑备份工具实现全库或者表空间的逻辑备份，但是不支持用户的交互模式，即在备份过程中无法控制或者切换进程。下面介绍如何使用exp/imp：SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Ora...
-
编辑 删除
人生少走弯路的十大忠告
1.买个闹钟，以便按时叫醒你。 自贪睡和不守时，都将成为你工作和事业上的绊脚石，任何时候都一样。不仅要学会准时，更要学会提前。就如你坐车去某地，沿途的风景很美，你忍不住下车看一看，后来虽然你还是赶到了某地，却不是准时到达。“闹钟”只是一种简单的标志和提示，真正灵活、实用的时间，掌握在每个人的心中...
-
编辑 删除
startup alter.log spfile.ora
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r o...
-
编辑 删除
open阶段的一致性检验（二）
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r o...
-
编辑 删除
RecycleBin
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r o...
-
编辑 删除
The account is locked
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issue Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kerne...
-
编辑 删除
SCN 时间戳的相互转换
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r o...
-
编辑 删除
动态注册监听
SQL> select * from v$version where rownum=1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - ProductionSQL> !cat /etc/issueEnterprise Linux Enterprise Linux Server release 5.5 (Carthage)Kernel \r o...
-
编辑 删除
addmrpt.sql
SQL> select * from v$version where rownum<2;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production$ORACLE_HOME/rdbms/admin/addmrpt.sqlRemRem $Header: addmrpt.sql 13-oct-2003.14:01:18 pbelkna...
-
编辑 删除
ashrpt.sql
SQL> select * from v$version where rownum<2;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production$ORACLE_HOME/rdbms/admin/ashrpt.sqlRem Copyright (c) 2004, 2005, Oracle. All rights reserved. &...
-
编辑 删除
awrrpt.sql
SQL> select * from v$version where rownum<2;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production$ORACLE_HOME/rdbms/admin/awrrpt.sqlRem $Header: awrrpt.sql 24-oct-2003.12:04:53 pbelknap Exp...
-
编辑 删除
蒙蒙烟雨山城
这个星期和朋友约好周六下山看电影，对于美剧还是挺亲睐的，但是也是要看网评剧情，哈哈！ 朋友A和同学B，早上被朋友A叫醒，很早的啊，晚上搞得太晚了，但是电影票顶的时间不好，中午要赶到解放碑吃饭，所以懒洋洋的起来了。这几天重庆天气烟雨蒙蒙，小雨连绵，其实对于小雨，不是拒绝的，脑海里总是用...
