| database restoration time. [message #59149] |
Fri, 31 October 2003 11:08  |
Roger
Messages: 10
Registered: September 2000
|
Junior Member |
|
|
I've 2 questions guys. Recently one of my team has done a point in time recovery by creating a new database. My question is how can i find out the new "database creation date". and the time till point in time recovery has done on the new database.
-R
|
|
|
|
| Re: database restoration time. [message #59152 is a reply to message #59149] |
Fri, 31 October 2003 11:57  |
Thiru
Messages: 1089
Registered: May 2002
|
Senior Member |
|
|
Database restoration time varies on database size,IO channels,drive speed etc. Recovery time varies on CPU speed,parallel recovery,amount of archived redo,IO etc..
Check your alert.log for the detailed recovery times..
Database creation/open resetlogs time, from
select to_char(created,'DD-MON-YY HH:MI'),to_char(RESETLOGS_TIME,'DD-MON-YY HH:MI')
from v$database;
Also V$DATABASE_INCARNATION will tell you when 'this' database incarnated.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
