User Tools

Site Tools


flashback_query_with_database_in_noarchivelog_mode

This is an old revision of the document!


Flashback_query_with_database_in_noarchivelog_mode

Typically, development databases are not started in archivelog mode. This causes a problem for hot backups but not necessarily for flashback queries. You can still flashback to any time within the online redo logs:

alter session set nls_timestamp_format = 'dd-mon-yyyy hh24:mi:ss.ff3'; set lines 9999 set trims on set pages 9999 set headi off spool old_version.sql

select text from dba_source as of timestamp to_timestamp('22-sep-2011 07:30:00.000') where 1=1 and owner = 'scott' and name = 'mypackage' order by type , line;

spool off

flashback_query_with_database_in_noarchivelog_mode.1544273360.txt.gz · Last modified: 2018/12/08 12:49 by 0.0.0.0

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki