Database Backup and Recovery (MOSC)

MOSC Banner

set a wait in between commands in a RMAN script

edited Jan 2, 2014 2:45AM in Database Backup and Recovery (MOSC) 20 commentsAnswered
 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";
}

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center