Hey Sultan Shiffa,
I agree with you! However, the table was truncated and his database
is running in "noarchivelog" mode. He has an export from yesterday but
he needs to recover transactions from 4 hours earlier today. I
suggested that since he has the export, maybe he could use LOGMINER and
read the redologs and see if he could get back the DML statements. Is
this a good process?
Please take a few minutes to provide feedback on the quality of service you received. The Department of Education values your feedback as a customer. Commissioner John L. Winn is committed to continuously assessing and improving the level and quality of services provided to you by Department staff. Simply use the link below. Thank you in advance for completing the survey.
http://data.fldoe.org/cs/default.cfm?staff=Ed.[Email address protected]
-----Original Message-----
From: Sultan Shiffa
[mailto:oracledba-ezmlmshield-x57249837.[Email address protected]
Sent: Tuesday, November 28, 2006 10:31 AM
To: LazyDBA Discussion
Subject: RE: getting back
Additional Information!
Startup mount
Flashback database to scn
ALTER DATABASE OPEN RESETLOGS;
-----Original Message-----
From: Sultan Shiffa
[mailto:oracledba-ezmlmshield-x18120471.[Email address protected]
Sent: 28 November 2006 16:28
To: LazyDBA Discussion
Subject: RE: getting back
Prerequisites for flashback
Archive mode
Alter databse flashback on (in mount state)
Checking
Show parameter flash
Show parameter recoverz
V$FLASHBACK_DATABASE_LOG
To recover DDL and Truncate
SQL> SELECT oldest_flashback_scn, oldest_flashback_time
FROM v$flashback_database_log;
FLASHBACK DATABASE TO SCN
Or
FLASHBACK DATABASE TO TIMESTAMP <timestamp>
Here we go
-----Original Message-----
From: Samarasinghe Deepthi
[mailto:oracledba-ezmlmshield-x48477107.[Email address protected]
Sent: 28 November 2006 16:22
To: LazyDBA Discussion
Subject: RE: getting back
If the table is truncated then you can use:
FLASHBACK TABLE <table_name> AS OF TIMESTAMP <timestamp>;
Deepthi Samarasinghe
Database Architect
-----Original Message-----
From: Samarasinghe Deepthi
[mailto:oracledba-ezmlmshield-x85795877.[Email address protected]
Sent: Tuesday, November 28, 2006 9:48 AM
To: LazyDBA Discussion
Subject: RE: getting back
FLASHBACK TABLE <table_name> to BEFORE DROP;
Deepthi Samarasinghe
Database Architect
-----Original Message-----
From: Shaju J. Joseph
[mailto:oracledba-ezmlmshield-x52476026.[Email address protected]
Sent: Tuesday, November 28, 2006 4:30 AM
To: LazyDBA Discussion
Subject: getting back
Hi Gurus
One of our developers has truncated a table in a 10g Database. Which
is in no archive log mode. How can I retrieve it through FLASHBACK QUERY
. Is there any way to get it back??
Thanking you
--Joseph
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
Oracle LazyDBA home page