RMAN Script

Create Script:

H:\>rman target sys/sys@dba20 catalog munna/munna@cat

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 23 22:37:02 2010

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database: DBA20 (DBID=847839442)

connected to recovery catalog database

RMAN> create script full_backup

{

allocate channel c1 type disk;

allocate channel c2 type disk;

backup database;

}

created script full_backup

Run Script:

RMAN> run{execute script full_backup;}

Replace Script:

RMAN> replace script full_backup

{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

backup database;

backup(archivelog all);

}

replaced script full_backup

Delete Script:

RMAN> delete script full_back;

deleted script: full_back

Data dictionary View:

    • RC_STORED_SCRIPT

    • RC_STORED_SCRIPT_LINE