How to get back purged data into the tables [message #606783] |
Wed, 29 January 2014 05:55 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi all,
I purged all the data from the tables through purged program .How to get back purged data into the tables.Please its very important to me.
Thank You
|
|
|
|
|
|
|
|
|
|
|
Re: How to get back purged data into the tables [message #606795 is a reply to message #606783] |
Wed, 29 January 2014 07:58 |
|
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
select * from emp1
delete from emp1
where empno=1234
--insert into emp1 values(2222,'SIVA','ORacle',NULL,sysdate,7777,100,40);
SELECT TABLE_NAME,ROW_MOVEMENT FROM USER_TABLES WHERE TABLE_NAME='EMP1';
ALTER TABLE emp1 ENABLE ROW MOVEMENT;
SELECT TABLE_NAME,ROW_MOVEMENT FROM USER_TABLES WHERE TABLE_NAME='emp1';
FLASHBACK TABLE emp1 TO TIMESTAMP SYSDATE-1;
I tried with insert only 1 row in the table and if i insert 2 rows and delete one row and run the above queries , the data not recover.It is worked on only if i have only one record , then only it show the deleted data.
|
|
|
|
|
|
|
Re: How to get back purged data into the tables [message #606800 is a reply to message #606787] |
Wed, 29 January 2014 08:22 |
Lalit Kumar B
Messages: 3174 Registered: May 2013 Location: World Wide on the Web
|
Senior Member |
|
|
mist598 wrote on Wed, 29 January 2014 17:40
I have one purged program ran in the Oracle applications & i deleted data from all most all from the 12 tables, how can i get the data into the tables
With NOARCHIVELOG mode and no FLASHBACK_ON, is all this happening in your PROD or TEST environment? If PROD then you need to seriously think about it.
|
|
|
|
Re: How to get back purged data into the tables [message #606802 is a reply to message #606795] |
Wed, 29 January 2014 08:34 |
joy_division
Messages: 4963 Registered: February 2005 Location: East Coast USA
|
Senior Member |
|
|
mist598 wrote on Wed, 29 January 2014 08:58[code]
SELECT TABLE_NAME,ROW_MOVEMENT FROM USER_TABLES WHERE TABLE_NAME='emp1';
That will never return any rows in your case.
Based on all your questions, I think you really need to read Database Concepts and learn a lot more before you continue using an Oracle database.
I also hope someone with more knowledge is the dba, although being that database is not in archivelog mode and flashback is off, I would think not.
|
|
|
Re: How to get back purged data into the tables [message #606803 is a reply to message #606790] |
Wed, 29 January 2014 08:41 |
pablolee
Messages: 2882 Registered: May 2007 Location: Scotland
|
Senior Member |
|
|
mist598 wrote on Wed, 29 January 2014 13:40Quote:Restore from a backup.
No Back up. Please suggest me.
Are you sure that there is no backup? To have a production database that has no backups seems unlikely to me. Not if there is anyone there who has a clue about Oracle. I strongly suggest that you go and speak to the person that actually knows about Oracle and ask him or her if they do actually have backups.
What is the nature of the database? Is it a transactional database or is it batch loaded? Is it cleared down and loaded each time or is the load incremental? What I'm getting at is, could the database be 'recovered' simply by re-running the previous batch load (if there was such a thing)
|
|
|
Re: How to get back purged data into the tables [message #606827 is a reply to message #606795] |
Wed, 29 January 2014 14:18 |
John Watson
Messages: 8931 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
The FLASHBACK TABLE command you demonstrated worked because you were quick. It will not work to solve your problem, firstly because too much time has gone by, and secondly because running a purge routine in an EBS database may have updated thousands of tables. You can't flashback just a few of them without destroying the financial integrity of the system.
Your only option, as I said before, is to ask a question in the EBS forum: explain what you did (for instance, which responsibility you were in, or what concurrent programs you ran) and perhaps someone there knows if the purge will have done an archive somewhere first.
I think it would help if you explained what is going on. The only EBS databases I have ever seen that were not in archivelog mode have been demonstration VISION databases. If that is what you have broken, no problem: remove everything, and start again. If it is a production database, you can also install new one - but of course all it will have is the seeded data. If it was a real production database, with lots of configuration and data, the best you can do is talk about it with the client. You, your DBA, your project manager, everyone involved, will all be trying to CYA, which is not helpful. You all need to remember that it is the client who matters.
|
|
|