|
-
I just did one not long ago with Rman to recovery tablespace.
I accidentally dropped one tablespace and its datafile . I use Rman to do my backup and recovery. Be sure you have a good copy of full backup, and on archivelog mode.
To use Rman to recover tablespace:
RMAN> run {
sql 'alter tablesapce tablespacename offline immediate';
allocate channel ch1 type disk;
set new name for datafile '/.../...' to '/.../...';
restore tablespace tablespacename;
switch datafile all;
recover tablespace tablespacename;
sql 'alter tablespace tablespacename online';
}
If you have any problems in doing so, please email me @[email protected]. I am glad to help.
Dragon
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|