| recover to specific time [message #391233] |
Wed, 11 March 2009 09:09  |
ykozhevnikov
Messages: 59
Registered: November 2008
Location: USA
|
Member |
|
|
this is what was done to check recover until time.
1. rman > backup database /* 10.30 PM*/
2. insert into scott.dept values ( 90,'Q','Q'); /*10.33 PM*/
3. rman > shutdown immediate; /*10.33 PM */
4. rm users01.* /* 10.35 PM */
5. rman > startup; /* 10 .36 */
6.
/* run the script in another shell */
run {
allocate channel t1 type disk;
SET UNTIL TIME "to_date('03/10/2009 10:31:00','mm/dd/yyyy hh24:mi:ss')";
restore tablespace users;
recover tablespace users;
release channel t1;
}
7. rman > alter database open;
8. select * from scott.dept; /* entries from step 2 is here*/
My question is why I have data tha came into the table after
the recover time ?
Thanks
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: recover to specific time [message #392868 is a reply to message #391945] |
Thu, 19 March 2009 09:15  |
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
|
Senior Member |
|
|
| Mahesh Rajendran wrote on Sun, 15 March 2009 08:40 | As EBrian said,
this is not the way it should be done.
Check the log files. You will see that you are doing
a full recovery.
|
I agree. You check the log file and see what happened.
Thid script should not take effect if it doesn't run into error.
SET UNTIL TIME "to_date('03/10/2009 10:31:00','mm/dd/yyyy hh24:mi:ss')";
Regards,
Alex
[Updated on: Thu, 19 March 2009 09:46] by Moderator Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
