02-15-2011 04:00 AM
Hi,
I’m using NetBackup 7.0 (windows master server) and Oracle database 11 is running on Linux 5.5 operating system.
My DBA wants to restore single tablespace from backup. We have restored full database and it is working fine. but facing problem while restoring single tablespace.
Let me know if I’m missing some thing and what is the best way to restore single tablespaces in NetBackup.
Look forward useful information.
Solved! Go to Solution.
02-16-2011 04:04 AM
Hi,
The way you are doing is not right. If you are dropping/deleting database from Oracle its mean that Oracle is also updating respective control files. In that case you have to restore old control file and restore point in time database.
DBAs always create problem for that especially when they don't have idea of database recovery. I'll suggest you to delete datafiles from OS and try to restore it, i'm share that will work for you. I've done the same practice for one of my customer.
following are the limitations of GUI recovery.
following link will really assist you to restore tablespace,
http://dbataj.blogspot.com/2008/03/how-to-recover-dropped-tablespace.html
i hope that will assist you.
02-15-2011 04:24 AM
What options have you selected for recovery, are you applying the redo logs after the restore of the database is complete? I'm no oracle guru but if you do, that is probably just re-doing the delete. You probably need to do a point in time recovery with something like recover database until change/time. and then a alter database open resetlogs.
02-15-2011 06:06 AM
So let him have at it. It can be as simple as the example in the Admin Guide or as complicated as some DBAs like to make it.
RUN
{
allocate channel t1 'SBT_TAPE';
sql 'alter tablespace TEST offline immediate'
# restore the datafile to a new location
set newname for datafile '/oradata/test.f' to '/oradata_new/test.f';
restore tablespace TEST;
# make the control file recognize the restored file as current
switch datafile all;
recover tablespace TEST;
release channel t1;
}
02-16-2011 04:04 AM
Hi,
The way you are doing is not right. If you are dropping/deleting database from Oracle its mean that Oracle is also updating respective control files. In that case you have to restore old control file and restore point in time database.
DBAs always create problem for that especially when they don't have idea of database recovery. I'll suggest you to delete datafiles from OS and try to restore it, i'm share that will work for you. I've done the same practice for one of my customer.
following are the limitations of GUI recovery.
following link will really assist you to restore tablespace,
http://dbataj.blogspot.com/2008/03/how-to-recover-dropped-tablespace.html
i hope that will assist you.