Creating RMAN stored scripts with Substitution Variable
In our datacenter we have to take cold backup for quite lot of instance against 30 to 35 server(all are UAT not production), since instead of configuring RMAN to all the server(connect catalog and then target) for backup,
Does we have have one stored script created in the RMAN server from there shall we connect to all other server one by one for respective DB instances for RMAN backup, By passing server / instance name through substitution variables.
Handling such scenario, make us to have single script centrally to handle the backup , since to manage network (resources like channels / save strings). if we can store single script which inturn