Backup Strategy Recommendation

RMAN will not backup the below files so it is advised to take the copy of the below files on regular basis (weekly/any change/addition to the file).
  • Tnsnames.ora
  • Listener.ora
  • Password file
  • Init.ora

The Best practice is to take create the pfile once the spfile is updated.

Below is the recommended strategy.

Figure 8-1 Recommended strategy