| flashback database to how far back ? [message #402265] |
Fri, 08 May 2009 04:52  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
I believe the flashback features would be capable with undo management and amount of undo-retained (undo_retention). Is this correct ?
Q. How far back can we do a flashback a database ? Can we determin by any view (or any other method) ?
Q. Also if we run a 'flasback database..' is there any way to know howmuchwork done and howmuchwork pending ?
|
|
|
|
|
|
| Re: flashback database to how far back ? [message #402344 is a reply to message #402269] |
Fri, 08 May 2009 23:14  |
tridentadm
Messages: 142
Registered: March 2006
|
Senior Member |
|
|
| Quote: |
| Quote: |
Also if we run a 'flasback database..' is there any way to know howmuchwork done and howmuchwork pending ?
|
Precise your question.
Regards
Michel
|
Eg.
-- Flashback 5 minutes.
CONN sys/password AS SYSDBA
SHUTDOWN IMMEDIATE
STARTUP MOUNT EXCLUSIVE
FLASHBACK DATABASE TO TIMESTAMP SYSDATE-(1/24/12);
ALTER DATABASE OPEN RESETLOGS;
Question : Is there any view or log from where I can check how-much of flashback-recovery is done (or is pending)
OR How much time it will take for the recovery to finish ?
Hint : Similar to view V$session_longops
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
