Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Server > Recovery Manage...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 12 Topic 16654 of 17418
Post > Topic >>

Recovery Manager (RMAN) problem

by sati_82 <krys_tek@[EMAIL PROTECTED] > Jun 2, 2008 at 02:25 AM

Hello,

I have the following problem. I need to implement a mechanism which
will restore a database to its state in the past. The restore
operation should start on demand. The machanism is supposed to be some
kind of antidote for user errors (e.g. a user had changed data in DB
and after that it turned out that all changes made were  wrong and DB
has to be restored to its state before the user changes).

For implementastion such mechanism I plan to use RMAN. I'm doing test
for the moment and I found out that it doesn't work as I thought. I do
the following:
1. I backup (with RMAN) a TABLESPACE on which database stores user
data
2. I make changes in a table (the table is stored on backuped
TABLESPACE)
3. I restore the TABLESPACE from the file backuped at point 1.

The problem is that changes made (2) after I backup a tablespace (1)
exists in the table (but I think it shouldn't because I restore the
tablespace)(3).
Could you please tell me what is the reason for that?
I appreciate any help.

Best regards,
krys_tek
 




 12 Posts in Topic:
Recovery Manager (RMAN) problem
sati_82 <krys_tek@[EMA  2008-06-02 02:25:20 
Re: Recovery Manager (RMAN) problem
sybrandb <sybrandb@[EM  2008-06-02 05:39:19 
Re: Recovery Manager (RMAN) problem
"Vladimir M. Zakhary  2008-06-02 05:46:52 
Re: Recovery Manager (RMAN) problem
Robert Klemme <shortcu  2008-06-03 00:18:04 
Re: Recovery Manager (RMAN) problem
sati_82 <krys_tek@[EMA  2008-06-03 07:24:45 
Re: Recovery Manager (RMAN) problem
Frank van Bortel <fran  2008-06-04 10:20:37 
Re: Recovery Manager (RMAN) problem
sati_82 <krys_tek@[EMA  2008-06-03 07:38:10 
Re: Recovery Manager (RMAN) problem
gazzag <gareth@[EMAIL   2008-06-03 07:56:08 
Re: Recovery Manager (RMAN) problem
sati_82 <krys_tek@[EMA  2008-06-03 08:12:44 
Re: Recovery Manager (RMAN) problem
gazzag <gareth@[EMAIL   2008-06-03 08:21:22 
Re: Recovery Manager (RMAN) problem
Robert Klemme <shortcu  2008-06-04 00:22:57 
Re: Recovery Manager (RMAN) problem
krys_tek@[EMAIL PROTECTED  2008-07-10 07:06:11 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 1:26:17 CST 2008.