asked on

Client lost a table - Db from 1 tera I have a good coldbackup from 5-13 -No archivelog db

Hi experts.

Client lost a table - Db from 1 tera I have a good coldbackup from 5-13 -No archivelog db

No export for that particular table.

Can I recover that table from a coldbackup?

ASKER CERTIFIED SOLUTION

johnsone

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LindaC

ASKER

Wow johnsone, if this comes ok, you will be the new and greatest super-hero.

Can it be in another database inside the same server?
Adding a san disk for the recovery of those dbf's from NEtbackup?

SOLUTION

Sean Stuber

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

johnsone

I prefer a different server so mistakes cannot be make affecting the real database. However, it can be done on the same server. On the same server, shutting down the original instance is the safest way to go. Be sure to use a different SID, as you cannot have 2 SIDs with the same name on the same server.

I'm not 100% sure same server with both databases up will work. I haven't done that in a long time. I thought that the lock file has the database name and not the SID, in which case you couldn't bring up 2 databases with the same name, even if they have different SIDs. If you have an issue with the lock file, you would need to create a new ORACLE_HOME and put the restored database in that home. That should get around the lock file problem.

SOLUTION

Greg Clough

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

LindaC

ASKER

Thank you!

LindaC

ASKER

Database version 9.2