Flashback query with database in noarchivelog mode - Revision history

127.0.0.1 at 15:44, 30 November 2011

2011-11-30T15:44:14Z

127.0.0.1 at 15:43, 30 November 2011

2011-11-30T15:43:40Z

127.0.0.1 at 15:43, 30 November 2011

2011-11-30T15:43:09Z

127.0.0.1 at 15:42, 30 November 2011

2011-11-30T15:42:36Z

127.0.0.1 at 15:39, 30 November 2011

2011-11-30T15:39:16Z

127.0.0.1: Created page with "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 a..."

2011-11-30T15:39:01Z

Created page with "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 a..."

New page

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 trimspool on
set pages 9999
set heading off
spool old_version.sql

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

spool off

@@ Line 2: / Line 2: @@
 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';
+  alter session set nls_timestamp_format = 'dd-mon-yyyy hh24:mi:ss.ff3';
   set lines 9999
   set trims on

@@ Line 13: / Line 13: @@
   as of  timestamp to_timestamp('22-sep-2011 07:30:00.000')
   where  1=1
-  and    owner='scott'
+  and    owner = 'scott'
-  and    name='mypackage'
+  and    name  = 'mypackage'
   order  by type
   ,      line;
   spool off

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

@@ Line 10: / Line 10: @@
   set heading off
   spool old_version.sql
-−
   select text from dba_source
         as of timestamp to_timestamp('22-SEP-2011 07:30:00.000')
@@ Line 16: / Line 16: @@
     and name='MYPACKAGE'
   order by type, line;
-−
   spool off