| Questions regarding recover database until time . [message #62485] |
Fri, 23 July 2004 18:14  |
Donny Chen
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
This is my experiment:
I did a full cold backup at 07/21/04 09:46:00, and then startup db.
After some time, one guy change the OS time of the server on which the db located, for example, back to 1999.
I notice that, and correct the time to 2004.
After that, db crashed.
I wanna recover db using the full backup up to the time which is just after I correct the time to 2004.
The archived log files are:
log 14 is just after I did full backup and then startup db;
log 17 records the change of time from 2004 to 1999
log 20 records the change of time from 1999 to 2004
log 21 records the point in time I wanna recover to
I encounter ORA-00314 during the recovery using log 20.
But I think the error should occur when meet log 17.
So what I want to know is how oracle actually performs when does ¡®recover database until time¡¯?
Thanks,
Donny
|
|
|
|
| Re: Questions regarding recover database until time . [message #62486 is a reply to message #62485] |
Fri, 23 July 2004 18:15  |
Donny Chen
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
this is how I did the recovery:
10:16:13 SQL> recover database until time '2004-07-21:10:06:00';
ORA-00279: change 6621934 generated at 07/21/2004 09:40:10 needed for thread 1
ORA-00289: suggestion : E:ORADATAARCHARC00014.001
ORA-00280: change 6621934 for thread 1 is in sequence #14
10:19:14 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 6622090 generated at 07/21/2004 09:46:57 needed for thread 1
ORA-00289: suggestion : E:ORADATAARCHARC00015.001
ORA-00280: change 6622090 for thread 1 is in sequence #15
ORA-00278: log file 'E:ORADATAARCHARC00014.001' no longer needed for this
recovery
10:22:30 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 6622092 generated at 07/21/2004 09:46:58 needed for thread 1
ORA-00289: suggestion : E:ORADATAARCHARC00016.001
ORA-00280: change 6622092 for thread 1 is in sequence #16
ORA-00278: log file 'E:ORADATAARCHARC00015.001' no longer needed for this
recovery
10:22:33 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 6622377 generated at 07/21/2004 09:52:28 needed for thread 1
ORA-00289: suggestion : E:ORADATAARCHARC00017.001
ORA-00280: change 6622377 for thread 1 is in sequence #17
ORA-00278: log file 'E:ORADATAARCHARC00016.001' no longer needed for this
recovery
10:22:38 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 6622427 generated at 07/21/1999 09:53:18 needed for thread 1
ORA-00289: suggestion : E:ORADATAARCHARC00018.001
ORA-00280: change 6622427 for thread 1 is in sequence #18
ORA-00278: log file 'E:ORADATAARCHARC00017.001' no longer needed for this
recovery
10:22:48 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00279: change 6622457 generated at 07/21/1999 09:53:48 needed for thread 1
ORA-00289: suggestion : E:ORADATAARCHARC00019.001
ORA-00280: change 6622457 for thread 1 is in sequence #19
ORA-00278: log file 'E:ORADATAARCHARC00018.001' no longer needed for this
recovery
10:23:39 Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00283: recovery session canceled due to errors
ORA-00314: log 2 of thread 1, expected sequence# 20 doesn't match 14
ORA-00312: online log 2 thread 1: 'D:ORACLEORADATADONNYDB2REDO02.LOG'
ORA-01112: media recovery not started
|
|
|
|
| Re: Questions regarding recover database until time . [message #62487 is a reply to message #62486] |
Fri, 23 July 2004 18:15 |
Donny Chen
Messages: 3
Registered: July 2004
|
Junior Member |
|
|
This is the content of Archived logfiles from the dump of controlfile:
RECID #129 Recno 129 Record timestamp 07/21/04 10:06:25 Thread=1 Seq#=21
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00021.001
Low scn: 0x0000.00650f5a 07/21/04 10:05:29 Next scn: 0x0000.00650f81 07/21/04 10:06:24
Block count=16 Blocksize=512
RECID #128 Recno 128 Record timestamp 07/21/04 10:05:29 Thread=1 Seq#=20
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00020.001
Low scn: 0x0000.00650e4d 07/21/99 10:00:23 Next scn: 0x0000.00650f5a 07/21/04 10:05:29
Block count=125 Blocksize=512
RECID #127 Recno 127 Record timestamp 07/21/99 10:00:24 Thread=1 Seq#=19
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00019.001
Low scn: 0x0000.00650cf9 07/21/99 09:53:48 Next scn: 0x0000.00650e4d 07/21/99 10:00:23
Block count=154 Blocksize=512
RECID #126 Recno 126 Record timestamp 07/21/99 09:53:49 Thread=1 Seq#=18
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00018.001
Low scn: 0x0000.00650cdb 07/21/99 09:53:18 Next scn: 0x0000.00650cf9 07/21/99 09:53:48
Block count=15 Blocksize=512
RECID #125 Recno 125 Record timestamp 07/21/99 09:53:18 Thread=1 Seq#=17
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00017.001
Low scn: 0x0000.00650ca9 07/21/04 09:52:28 Next scn: 0x0000.00650cdb 07/21/99 09:53:18
Block count=25 Blocksize=512
RECID #124 Recno 124 Record timestamp 07/21/04 09:52:29 Thread=1 Seq#=16
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00016.001
Low scn: 0x0000.00650b8c 07/21/04 09:46:58 Next scn: 0x0000.00650ca9 07/21/04 09:52:28
Block count=132 Blocksize=512
RECID #123 Recno 123 Record timestamp 07/21/04 09:47:00 Thread=1 Seq#=15
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00015.001
Low scn: 0x0000.00650b8a 07/21/04 09:46:57 Next scn: 0x0000.00650b8c 07/21/04 09:46:58
Block count=1 Blocksize=512
RECID #122 Recno 122 Record timestamp 07/21/04 09:46:58 Thread=1 Seq#=14
Flags: <produced by archive operation> <created by the ARCH process>
Resetlogs scn and time scn: 0x0000.005f90fb 07/13/04 14:12:31
filename E:ORADATAARCHARC00014.001
Low scn: 0x0000.0065022f 07/21/04 08:58:39 Next scn: 0x0000.00650b8a 07/21/04 09:46:57
Block count=1262 Blocksize=512
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
