Perform tablespace recovery with RMAN |
 |
By Kenny Smith
15 Dec 2003 | IOUG |
|
|
The following is Recovery Manager tip #5 from "30 tips in 30 minutes," brought to you by the IOUG. Return to the main page for more tips on this topic.
RMAN will perform a tablespace point in time recovery with just a few simple commands. Connect to the target database, the catalog schema and auxiliary instance. Run these commands to recover the USERS tablespace up to (but not including) time 15:34:38 on July 22:
run {
set command id to 'Perform TSPITR';
set until time "to_date('22-JUL-2002 15:34:38,
'DD-MON-YYYY HH24:MI:SS')";
allocate clone channel d1 type disk;
recover tablespace users;
}
For more details: see chapter 17 of "Oracle backup and recovery 101."
Get more tips in minutes! Return to the main page.
About the author: Kenny Smith has been working with Oracle technology on HP servers for over a decade. He specializes in Oracle database architecture, database administration and development. He has presented at numerous Oracle conferences on two continents. He has published many articles describing Oracle solutions and has co-authored "Oracle backup and recovery 101" from Oracle Press.
IOUG: Become a member of the IOUG to access the paper referenced here and a repository of technical content created for Oracle users by Oracle users.
|
