We have a database that is 3TB+ in size, and don't have enough space to restore it.
However, we want to retrieve code (stored procs) from a 15 day old backup.
Is is possible to restore the structure only from an Oracle backup?
Restore Structure Only
backuporaclerestore
Related Question
- Oracle RMAN – Restore Backup for Standby from External Hard Drive with Different Drive Labels
- Sql-server – Automate Backup of SQL Server Database Structure
- SQL Server 2012 – How to Restore a Specific File Group Without Primary File Group
- Restoring 40 GB Oracle backup to get db objects into Oracle 11g XE
- MySQL restore only Incremental backups with innobackupex
- SQL Server – Calculate Total Disk Space Required for Restore from Backup File
- SQL Server – Is It Possible to Restore a Database with Only Database Roles Membership?
Best Answer
The source of stored procedures is stored in the
SYSTEMtablespace in theSOURCE$table.You need not to restore any user data at all, simply restore the
SYSTEM,SYSAUXandUNDOtablespaces and skip the rest. You can then open the database with the other tablespaces offlined, and you can access the stored procedures as usual, or queryDBA_SOURCEorSOURCE$directly.