Adding to what Amit said, you can also revisit your backup policy.
If it allows you to create incremental backups, then go for it, as only the changed blocks will be backed up and less space will be consumed for next backup.
You did not mentioned the version of your DB, if it is 10g then it is worth to read about block_change_tracking feature of 10g.
Refer to following oracle documentation about Incremental backups:
The easiest way is to take export dump of one prod database and then import
that into other prod database.
First of all check all the tablespace names existing in one database and then pre-create these tablespaces into other database and then you can start the import.
It requires target database in either MOUNT or OPEN stage to duplicate database using RMAN. Could you give the complete RMAN command that you are using to duplicate the database?
This blog reflect our own views and do not necessarily represent the views of our current or previous employers.
The contents of this blog are from our experience, you may use at your own risk, however you are strongly advised to cross reference with Product documentation and test before deploying to production environments.
Recent Comments