OraFAQ Forum: Client Tools » Can't read SCN

Home » Other » Client Tools » Can't read SCN (Oracle RDBMS, 10.2, RHEL5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Can't read SCN [message #552588]

Thu, 26 April 2012 13:22

TLegend33
Messages: 203
Registered: March 2005

Senior Member

I'm testing out some rman point-in-time recovery and working on recovery to a certain SCN. I've added logfiles and started logminer, and here is the result:

SQL> select scn, timestamp, seg_name, seg_type_name, operation, sql_redo from v$logmnr_contents where table_name = 'TONY'; 

       SCN TIMESTAMP	       SEG_NAME 		      SEG_TYPE_NAME		       OPERATION       SQL_REDO
---------- ------------------- ------------------------------ -------------------------------- --------------- --------------------------------------------------
1.8154E+10 2012-04-20 13:46:00 TONY                           TABLE			       DDL	       truncate table TONY;

How can I decipher the correct SCN for my recovery?

Thanks.

Report message to a moderator