-
编辑 删除
TNS-12535
SQL> select * from v$version where rownum < 2;<br /><br />BANNER<br />--------------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production<br /><br /><br />SQL> !cat /etc/issue<br />Enterprise Li...
-
编辑 删除
Linux Error: 29: Illegal seek
SQL> !cat /etc/issue<br />Enterprise Linux Enterprise Linux Server release 5.5 (Carthage)<br />Kernel \r on an \m<br /><br /><br /><br /><br />SQL> select * from v$version where rownum<2;<br /><br /><br />BANNER<br />---------------------------------------------------------------...
-
编辑 删除
数据字典
SQL> select * from v$version where rownum<2;<br /><br /><br />BANNER<br />--------------------------------------------------------------------------------<br />Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production<br /><br /><br />SQL> !cat /etc/issue<br />Enterpri...
-
编辑 删除
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...
-
编辑 删除
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. &...
