交谈中请勿轻信汇款、中奖信息、陌生电话,勿使用外挂软件。
676822674(676822674) 11:01:44
select * from HR.EMPLOYEEStest as of timestamp to_timestamp('2012-9-15 10:40:51','yyyy/mm/dd hh24:mi:ss') where EMPLOYEE_ID=100;
田新营(676822674) 11:07:11
select versions_xid,versions_startscn,versions_starttime,versions_endscn,versions_endtime,
decode(versions_operation,'I','Insert','U','Update','D','Delete','Original') versions_operation,EMPLOYEE_ID,FIRST_NAME from HR.EMPLOYEEStest
versions between scn minvalue and maxvalue
where EMPLOYEE_ID=100 order by nvl(versions_startscn,0),nvl(versions_endscn,0);
田新营(676822674) 11:10:14
select versions_xid,versions_startscn,versions_starttime,versions_endscn,versions_endtime,
decode(versions_operation,'I','Insert','U','Update','D','Delete','Original') versions_operation,EMPLOYEE_ID,FIRST_NAME from HR.EMPLOYEEStest
versions between scn minvalue and maxvalue
where EMPLOYEE_ID=100 order by nvl(versions_startscn,0),nvl(versions_endscn,0);
田新营(676822674) 11:35:34
select * from v$flashback_database_log;
田新营(676822674) 11:40:00
flashback database to timestamp to_timestamp('2012-9-15 11:00:00','yyyy-mm-dd hh24:mi:ss');
田新营(676822674) 14:02:05
exp hr/hr@orclasm tables='EMPLOYEEStest' file='d:\hr.exp'
田新营(676822674) 14:42:53
show parameter back
cd /oracle/diag/rdbms/orclasm/orclasm/trace
田新营(676822674) 15:02:17
backup check logical validate database;ctr+c不能终止
backup check logical validate datafile 1,2;
田新营(676822674) 15:03:54
select 'blockrecover datafile '|| file# ||' block '|| block#||';' from v$database_block_corruption order by file#,block#;
田新营(676822674) 15:05:27
select sid,serial#,context,sofar,totalwork,
round(sofar/totalwork*100,2) "%_complete%"
from gv$session_longops
where opname like 'RMAN%' AND
opname not like '%aggregate%' and
totalwork !=0 and sofar<>totalwork;
田新营(676822674) 15:29:49
show parameter _allow_resetlogs_corruption;
no
select ksppinm,ksppdesc from x$ksppi where ksppinm like '%resetlogs_%';
alter system set "_allow_resetlogs_corruption"=false scope=spfile;
田新营(676822674) 15:34:52
[oracle@localhost ~]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
[oracle@localhost ~]$ sqlplus / as sysdba
田新营(676822674) 15:43:13
list incarnation of database;
田新营(676822674) 15:46:57
reset database to incarnation 3;
676822674(676822674) 11:01:44
select * from HR.EMPLOYEEStest as of timestamp to_timestamp('2012-9-15 10:40:51','yyyy/mm/dd hh24:mi:ss') where EMPLOYEE_ID=100;
田新营(676822674) 11:07:11
select versions_xid,versions_startscn,versions_starttime,versions_endscn,versions_endtime,
decode(versions_operation,'I','Insert','U','Update','D','Delete','Original') versions_operation,EMPLOYEE_ID,FIRST_NAME from HR.EMPLOYEEStest
versions between scn minvalue and maxvalue
where EMPLOYEE_ID=100 order by nvl(versions_startscn,0),nvl(versions_endscn,0);
田新营(676822674) 11:10:14
select versions_xid,versions_startscn,versions_starttime,versions_endscn,versions_endtime,
decode(versions_operation,'I','Insert','U','Update','D','Delete','Original') versions_operation,EMPLOYEE_ID,FIRST_NAME from HR.EMPLOYEEStest
versions between scn minvalue and maxvalue
where EMPLOYEE_ID=100 order by nvl(versions_startscn,0),nvl(versions_endscn,0);
田新营(676822674) 11:35:34
select * from v$flashback_database_log;
田新营(676822674) 11:40:00
flashback database to timestamp to_timestamp('2012-9-15 11:00:00','yyyy-mm-dd hh24:mi:ss');
田新营(676822674) 14:02:05
exp hr/hr@orclasm tables='EMPLOYEEStest' file='d:\hr.exp'
田新营(676822674) 14:42:53
show parameter back
cd /oracle/diag/rdbms/orclasm/orclasm/trace
田新营(676822674) 15:02:17
backup check logical validate database;ctr+c不能终止
backup check logical validate datafile 1,2;
田新营(676822674) 15:03:54
select 'blockrecover datafile '|| file# ||' block '|| block#||';' from v$database_block_corruption order by file#,block#;
田新营(676822674) 15:05:27
select sid,serial#,context,sofar,totalwork,
round(sofar/totalwork*100,2) "%_complete%"
from gv$session_longops
where opname like 'RMAN%' AND
opname not like '%aggregate%' and
totalwork !=0 and sofar<>totalwork;
田新营(676822674) 15:29:49
show parameter _allow_resetlogs_corruption;
no
select ksppinm,ksppdesc from x$ksppi where ksppinm like '%resetlogs_%';
alter system set "_allow_resetlogs_corruption"=false scope=spfile;
田新营(676822674) 15:34:52
[oracle@localhost ~]$ export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
[oracle@localhost ~]$ sqlplus / as sysdba
田新营(676822674) 15:43:13
list incarnation of database;
田新营(676822674) 15:46:57
reset database to incarnation 3;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/90986/viewspace-743634/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/90986/viewspace-743634/