Saturday 27 April 2024
How To Retrieve Data Using FLASHBACK Command In Oracle.
This command undoes changes made by Oracle Database to the data files that exist when you run the command.
FLASHBACK can fix logical failures, but not physical failures
FLASHBACK DATABASE is usually much faster than a RESTORE operation followed by point-in-time recovery because no data files are restored. The time needed to perform FLASHBACK DATABASE depends on the number of changes made to the database since the desired flashback time. On the other hand, the time needed to do a traditional point-in-time recovery from restored backups depends on the size of the database.
For Example :
Note: If Flashback is not working on SQL Tools/Oracle DataTable you can First run the command given below and then run the flashback command.
FLASHBACK DATABASE is usually much faster than a RESTORE operation followed by point-in-time recovery because no data files are restored. The time needed to perform FLASHBACK DATABASE depends on the number of changes made to the database since the desired flashback time. On the other hand, the time needed to do a traditional point-in-time recovery from restored backups depends on the size of the database.
For Example :
FLASHBACK TABLE TABLENAME to TIMESTAMP(SYSDATE-1);
Note: If Flashback is not working on SQL Tools/Oracle DataTable you can First run the command given below and then run the flashback command.
ALTER TABLE TABLENAME ENABLE ROW MOVEMENT;
Subscribe to:
Post Comments
(
Atom
)
Perfect
ReplyDelete