- I have DB1 database on Server1 .
- I have taken backup.
- After that I have created table TEST.
- Inserted some values in the TEST table.
- Truncated table.
And want to return my TEST table to its previous state.
- For this I took backup(datafiles, archive logs, controlfile, spfile)
I don't want to recover whole database, just this table is needed. It can be done by restoring and recovering database to another host, export table from the new DB and import to the existing DB(DB1).
Let's assume I have just one server... Can I restore and recover database on the same machine with the new database name?
Waiting your suggestions, I will also try to search something...