ITPub博客

=========================================================== 作者: xhailiang(http://xhailiang.itpub.net)发表于:2006.11.09 20:20分类: oracle 出处：http://xhailiang.itpub.net/post/6051/228105------------...

RMAN> duplicate target database to testerdb;Starting Duplicate Db at 27-OCT-04using target database controlfile instead of recovery catalogallocated channel: ORA_AUX_DISK_1channel ORA_AUX_DISK_1: sid=...

set serveroutput on format wrappedSET SQLBLANKLINES ONsql>select deptno,2 empno,3 ename4 from emp5 where6 #desc empName Null? Type----------------------------------------- -------- --------------EMPNO...

$ORACLE_SID=prod1$rmanRMAN> startup nomount;startup failed: ORA-01078: failure in processing system parametersLRM-00109: could not open parameter file '/data1/app/oracle/oracle/product/10.2.0/db_1/dbs/initprod1.ora'starting Oracle instance without parameter file for retrival of spfileOracle instance startedTotal System Global Area 159383552 bytesFixed Size 2019224 bytesVariable Size 67108968 bytesDatabase Buffers 83886080 bytesRedo Buffers

1、创建记录表 create table system.session_event_history initrans 4 as select b.sid, b.serial#, b.username, b.osuser, b.paddr, b.process, b.logon_time, b.type, ...

SELECT current_scn, SCN_TO_TIMESTAMP(current_scn) FROM v$database; select timestamp_to_scn(to_date('20061214 17:18:27','yyyymmdd hh24:mi:ss')) from dual ;

为了防止sga使用swap分区，可以设置参数lock_sga=true

恢复默认值alter system reset open_cursors scope=spfile sid='*'；为修改加入注释alter system set open_cursors=500 comment ='test 1' scope=both；相关视图select *from v$spparameterwhere name='control_file...

http://weiranjie.itpub.net/post/26925/450820[@more@]

一、日常管理1.1 备用服务器的管理模式与只读模式1、启动到管理模式SQL>shutdown immediateSQL>startup nomount pfile=?/dbs/inittestdbsdby.oraSQL>alter database mount standby databaseSQL>alter database recover managed standby database disconnect from session;2、启动到只读方式SQL>shutdown immediateSQL>startup nomount pfile=?/dbs/inittestdbsdby.oraSQL>alter database mount standby databaseSQL>alter database open read only3、如果在管理恢复模式下到只读模式SQL>recover managed stand

tom关于parse的解释There are two types of parses (well, actually "three" these days).They are o HARD parse -- the query has never been seen before, isn't in the shared pool. We must parse it, hash it,...

select dbms_rowid.rowid_object('AAAGHLAAMAAAAJkAAY') from dualselect dbms_rowid.rowid_object('AAAGFZAAMAAAAGXABo') from dualselect object_name from all_objectswhere object_id in(25035,24921)

--每个用户使用的资源SELECT A.USERNAME,B.BLOCK_GETS,B.CONSISTENT_GETS,B.PHYSICAL_READS,B.BLOCK_CHANGES,B.CONSISTENT_CHANGESFROM V$SESSION A,V$SESS_IO BWHERE A.SID=B.SIDORDER BY USERNAME;----用户访问的...

ORA-16038的解决数据库装载完毕。ORA-16038: 日志 3 序列号 5035 无法归档ORA-19809: 超出了恢复文件数的限制ORA-00312: 联机日志 3 线程 1:......REDO03.LOG'DB是归档模式, 每个日志组只有一个文件(新太公司的人通常使用的方法,FT), 没办法, 搜寻文档和晚上的资料, 有如下的解决方法:损坏非当前联机日志：1、启动数据库，遇到ORA-00312 or ORA-00313错误，如:ORA-00313: open failed for members of log group 4 of thread 1ORA-00312: online log 3 thread 1: '/opt/oracle/db04/oradata/ORCL/redo03.log'从这里我们知道日志组1的数据文

LOB ( lob项，...） STORE AS lob_segment_name CHUNK integer PCTVERSION integer CACHE NOCACHE LOGGING/NOLOGGING TABLESPACE tablespace_name STORAGE storage子句 INDEX INDEX字句 lob_segment_name:...

STARTUP Command Behavior If you execute the STARTUP command without any PFILE searches the default location on the server (for example: $ORACLE_ named as follows: • SPFILE<$ORACLE_SID>.ORA &#822...

　在安装完oracle10g后，由于jre默认使用的字体问题，使得em,dbca,netca,netmgr显示中文时出现"□□"字样的乱码，下面来说明这个问题的解决办法: 　　1. 改变$ORACLE_HOME/jdk目录下的jre的默认字体 　　cd $ORACLE_...

q and useany convenient delimiter, single or multibyte, or any of the [ ], { }, ( ), or < >character pairs. select q'x's'dfsdfx' from dual; select q'!'s'dfsdf!' from dual;得到的结果是's'dfsdfThe new ...

用oracle9i连接oracle10g Exp一个表的时候，系统提示exp-00003 错误！$ oerr exp 0000300003, 00000, "no storage definition found for segment(%lu, %lu)"// *Cause: Export could not find the storage definiti...