Home » SQL & PL/SQL » Client Tools » Can't read SCN (Oracle RDBMS, 10.2, RHEL5)
Can't read SCN [message #552588] Thu, 26 April 2012 13:22 Go to next message
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.
Re: Can't read SCN [message #552589 is a reply to message #552588] Thu, 26 April 2012 13:26 Go to previous messageGo to next message
BlackSwan
Messages: 26187
Registered: January 2009
Location: SoCal
Senior Member
column scn format 9999999999999999999
Re: Can't read SCN [message #552590 is a reply to message #552589] Thu, 26 April 2012 13:28 Go to previous messageGo to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
Wow, that was way too easy. Thanks!
Re: Can't read SCN [message #552591 is a reply to message #552590] Thu, 26 April 2012 13:46 Go to previous message
Michel Cadot
Messages: 65840
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
or
set numwidth 15

Regards
Michel
Previous Topic: setting oracle parameters
Next Topic: sqlplus : multiple scripts in argument (batch execution)
Goto Forum:
  


Current Time: Tue Oct 16 13:18:00 CDT 2018