I have 30.7GB backup file generated from RMAN. The original ./datafile is 950.28GB. According to previous DBA, there is a lot of free space in table space. Now, I have 300GB free disk space in hard disk. How can i restore the backup file using limited disk space ? Thkb4
RMAN restore to lower disk space
disk-spaceoraclerestorerman
Related Question
- Can we restore backup for standby from external hard drive with differnet drive labels
- Sql-server – UnShrunk SQL Server database restore which is larger than available disk space
- Will I have to restore controlfile in RMAN level 1 backupset before recover database
- RMAN – no datafile found during recovery
- Restoring RMAN backup in Oracle 9i to another server
- Sql-server – Restore DB Backup with limited amount of disk space
- Linux – RMAN Disk Backups
Best Answer
One of the first things Oracle does at restore time is pre-create the data files to the defined size. So you do need a way to store the full size of the files. A compressed filesystem could be used for that and with a little luck it works. It just does not solve the problem.
What you do want is to re organize the source database. The quickest way is to prepare a new database with correct sized tablespaces and datafiles. Next use datapump to transport the schemas to the new database. If needed, this can even be done online by using smart tools like dbvisit replicate (or goldengate if money is of no importance). Trash the old database when the two are in sync.