I need to add a redo group member to a mounted database -- and while I'm at it, that ALTER statement should repeat in a DO loop across all instances on the host. Let's start with:
1 ALTER DATABASE ADD LOGFILE MEMBER
3* TO GROUP 1;
I'm trying to recall the syntax to substitute the host's value for ORACLE_HOME ( ? ) and ORACLE_SID -- and failing to find the right search terms. Someone help the kid, please.