| Restore tablespace to another server via RMAN to a point in time [message #161228] |
Thu, 02 March 2006 14:01  |
phantomracer
Messages: 1
Registered: March 2006
|
Junior Member |
|
|
I have an interesting question. I can't seem to find an exact script to perform this task.
We have 2 instances on 2 servers, Prod and Dev. I need to restore a tablespace only from Prod to Dev to a point in time in the past.
Here is what I have so far. With production involved, I didn't want to have a syntax error and blow away current production data. Tablespace on dev is currently offline. Files on both system are in the same directory, and the same size.
Any tips or tricks would be greatly appreciated!
(while on production/target)
connect target /
connect rcvcat
connect auxiliary sys/password@dev
RUN
{
allocate auxiliary channel t1 type 'SBT_TAPE'
set until time "to_date('06-feb-06 02:00:00','yy-mon-dd hh24:mi:ss')";
RESTORE TABLESPACE tablespace_name;
RECOVER TABLESPACE tablespace_name;
}
Thanks for any help
Paul
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
