ITPub博客

Repeat 500 times7FF7F727C9D0 00000000 00000000 012C0000 04C10202 [..........,.....]7FF7F727C9E0 78787803 0202012C 610104C1 0202012C [.xxx,......a,...]7FF7F727C9F0 610103C1 0202012C 610102C1 23690601 [...a,......a..i#]Block header dump: 0x01002647 Object id on Block? Y seg/obj: 0x14214 csc: 0x00.af2351 itc: 2 flg: E typ: 1 - DATA brn: 0 bdba: 0x1002640 ver: 0x01 opc: 0 inc: 0 exflg: 0 Itl Xid Uba Flag Lck Scn/Fsc0x01 0x0006.014.00002

3.flashback query(a).flashback query à只能查看一个时间点的select * from t1 as of timestamp to_timestamp('2012/06/10 15:18:47','yyyy/mm/dd hh24:mi:ss');select * from t1 as of timestamp to_timestamp('2012/06/10 15:18:47','yyyy/mm/dd hh24:mi:ss') where id not in(select id from t1) (b).flashback version query à可以查看一个时间段内的select versions_xid,versions_startscn,versions_endscn,versions_operation,id ,name from t1 versions between scn minva

如果恢复的时候使用了using backup controlfile表明恢复的终点不明确。

1. 准备数据,SQL> create table test as select * from all_objects;Table created.SQL> analyze table test compute statistics;Table analyzed.SQL> select blocks from user_tables where table_name='TEST';&nbs...

(1) 查询失败，block错误SQL> select * from test;select * from test              *ERROR at line 1:ORA-01578: ORACLE data block corrup...

1.编辑BBED（11g不支持了，需要从10g copy过来）Copy $ORA10g_HOME/rdbms/lib/ssbbded.o to $ORA11g_HOME/rdbms/libCopy $ORA10g_HOME/rdbms/lib/sbbdpt.o to $ORA11g_HOME/rdbms/libMessage files (li...

1.DBVdbv file=/u01/oradata/deer/system01.dbf  参数：file                   检查的数据文件名(没有缺省值)start &n...

select a.NAME,a.checkpoint_change#,b.CHECKPOINT_CHANGE#,case  when (a.CHECKPOINT_CHANGE#=a.CHECKPOINT_CHANGE#) then 'startup normal'  when (a.CHECKPOINT_CHANGE#>b.CHECKPOINT_CHANGE#) the...

oracle用户crontab无权限使用[oracle@deer ~]$ crontab -e/var/spool/cron/oracle: Permission denied出现如上错误，查看crontab的权限。[root@deer u01]# ll /usr/bin/crontab -rwxr-xrwx. 1 root root 47520 M...

某Oracle真实RMAN备份脚本和策略分享： 【自动作业 crontab 内容】 #* * * * * /oradata3/oracle/rman/rman1 #10 10 03 * * /oradata3/oracle/rman/rman0 #20 10 * * 6 /oradata3/oracle/rman/rman1 20 1...

select ksppinm "Parameter Name", ksppstvl "Value",ksppstdf "Default"from x$ksppi x, x$ksppcv ywhere x.indx = y.indxand ksppinm like '/_%trace%' escape '/';Tracing by Enabling EventsAlter s...

(1)data dictionary cache hit ratio     select * from v$rowcache     select sum(gets)/(sum(gets)+sum(getmisses)) from v$rowcache where gets+getmi...

select (select value from v$sysstat where name='physical reads') phy ,(select value from v$sysstat where name='db block gets') get,(select value from v$sysstat where name='consistent g...

select a.name,b.XACTS,d.Sid,d.USERNAME,e.SQL_TEXT from v$rollname a,v$rollstat b,v$transaction c,v$session d ,v$sqltext ewhere a.usn=b.USN and b.USN=c.XIDUSN and c.ADDR=d.TADDR and d.sql_id=e.sql_...

Normal 0 0 2 false false false MicrosoftInternetExplorer4