set a wait in between commands in a RMAN script
Hi
I need to put a wait between 'sql "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL";' and 'RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;' in the below given script.
Please advice me how to do it?
run
{
sql "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL";
RESYNC CATALOG FROM DB_UNIQUE_NAME ALL;
backup database plus archivelog;
delete noprompt archivelog all completed before 'sysdate -7';
backup current controlfile;
sql "ALTER DATABASE RECOVER MANAGED STANDBY DATABASE THROUGH ALL SWITCHOVER DISCONNECT USING CURRENT LOGFILE";
}
0