When you decide to use a user-managed backup strategy rather than RMAN, you will need to develop scripts to perform hot or cold backups. One of the most important things you should do to simplify your maintenance requirements is to develop scripts that are generated from the Oracle catalog. If done properly, you won’t need to change your backup scripts every time you add a new file or change the location of a file.
Automate your backups with scripts that are generated from the Oracle Catalog.
Whenever you perform a backup, it is extremely useful to know the status of your database including the data ...