Database Backup and Recovery (MOSC)

MOSC Banner

Error in executing sored script in rman

edited Nov 20, 2009 5:42AM in Database Backup and Recovery (MOSC) 3 commentsAnswered
 I have the followiing script that is failing:
connect catalog rman/<rman password>
connect target sys/<password>@WINDOWDB
run { execute script backup_archives; }

----------------------------------------------------------------------------------
{
	
ALLOCATE CHANNEL dev1 DEVICE TYPE DISK FORMAT 'c:\arc_temp\AL_%d_%U_%p';
crosscheck archivelog all;
delete expired archivelog all;
backup archivelog all skip inaccessible delete input;
}


-------------------------------------------------------
RMAN>
echo set on


RMAN> connect catalog *
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used

RMAN> connect target *
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06167: already connected

RMAN> run { execute script backup_archives; }
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

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