Restore table to another location from large size of database in oracle

Restore dropped or delete record table to another location from large size database in oracle

For this restore operation you need to have the full backup of the database before the table deleted or dropped.
If many application is working on same database then you need to restore one table of one application then you donot need to restore completed database.
You can restore system tablespace plus the tablespace that application is using to save time. IF database is in terabytes then it will take time and need more space to restore complete database. then fetch the table from it.

To reduce restore time you need to follow following general steps:

Step 1. Find the table data in which tablespace it belong.

Step 2. Create new database on another server.

Step 3. Restored the tablespace  system,undo ,sysaux  and with tablespace which having data.

Restore tablespace system,undo,sysaux , app_data_tx;

Step 4. Recover the database with skip option of other tablespace which is present in the database.

Recover database skip …….(all other tablespace which not needed)

Step 5. Startup the database

Step 6. alter database open resetlog.



Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.