Home » RDBMS Server » Backup & Recovery » recover to specific time (linux oracle 10.0.0.2)
recover to specific time [message #391233] Wed, 11 March 2009 09:09 Go to next message
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 #391238 is a reply to message #391233] Wed, 11 March 2009 09:29 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
hi,

I guess you need to show the db time by sql when doing these tests. It will be more accurate.
Regards,
Alex
Re: recover to specific time [message #391244 is a reply to message #391238] Wed, 11 March 2009 09:35 Go to previous messageGo to next message
ykozhevnikov
Messages: 59
Registered: November 2008
Location: USA
Member
Alex
do you mean to check time--> select sysdate from dual; ?
Re: recover to specific time [message #391807 is a reply to message #391233] Fri, 13 March 2009 11:00 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You don't perform PITR for a tablespace like this. You did a full recovery that's why you didn't have to do OPEN RESETLOGS. Check RMAN Tablespace Point-in-Time Recovery (TSPITR).
Re: recover to specific time [message #391911 is a reply to message #391244] Sat, 14 March 2009 09:39 Go to previous messageGo to next message
alexzeng
Messages: 133
Registered: August 2005
Location: alexzeng.wordpress.com
Senior Member
ykozhevnikov wrote on Wed, 11 March 2009 22:35
Alex
do you mean to check time--> select sysdate from dual; ?


Yes!
Regards,
Alex

[Updated on: Sun, 15 March 2009 01:28] by Moderator

Report message to a moderator

Re: recover to specific time [message #391927 is a reply to message #391911] Sat, 14 March 2009 11:40 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
The time is irrelevant in this situation.
Re: recover to specific time [message #391945 is a reply to message #391244] Sat, 14 March 2009 19:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
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.
Re: recover to specific time [message #392868 is a reply to message #391945] Thu, 19 March 2009 09:15 Go to previous message
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

Previous Topic: System Backup
Next Topic: sql query for RMAN catalog database to report SID and last successfull backup
Goto Forum:
  


Current Time: Fri Mar 29 02:05:40 CDT 2024