Being DBA, we all are well aware SCN. We all known about it’s important. SCN is the most important element of Oracle Database. It helps DBA in the Recovery Database.




Database SCN number some time is very important

1) Particularly when you are doing rman recovery

2) Filling gaps of archive logs between the primary server and Physical standby server.

Below SQL queries will give SCN for a particular date and date to get SCN.

SQL>select current_scn from v$database;
SQL> select timestamp_to_scn(to_timestamp('24/10/2017 14:24:54','DD/MM/YYYY HH24:MI:SS')) as scn from dual;
SQL> select scn_to_timestamp(7705798324) as timestamp from dual;
24-OCT-17 PM

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

Anuradha’s LinkedIn: Anuradha’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.