RMAN script example & run script

SQL*Plus: Release 9.2.0.1.0 - Production on Fri Jan 8 12:34:42 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

SQL> CONN /AS SYSDBA;
Connected.
SQL> CREATE TABLESPACE RMAN4 DATAFILE 'H:\ORACLE\ORADATA\IACM\RMAN401.DBF' SIZE
30M;

Tablespace created.

SQL>

SQL> CREATE USER RAJ IDENTIFIED BY KUMAR
  2  DEFAULT TABLESPACE RMAN4
  3  QUOTA UNLIMITED ON RMAN4;

User created.



SQL> GRANT CONNECT,RESOURCE TO RAJ;

Grant succeeded.

SQL> GRANT RECOVERY_CATALOG_OWNER TO RAJ;

Grant succeeded.

SQL>



Microsoft Windows XP [Version 5.1.2600]
(C) Copyright 1985-2001 Microsoft Corp.

C:\Documents and Settings\Administrator>CD\

C:\>RMAN TARGET / CATALOG RAJ/KUMAR

Recovery Manager: Release 9.2.0.1.0 - Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: IACM (DBID=1202858792)
connected to recovery catalog database
recovery catalog is not installed

RMAN> CREATE CATALOG;

recovery catalog created

RMAN> REGISTER DATABASE;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

RMAN>


RMAN> create script level0backup {
2> backup
3> incremental level 0
4> format 'c:\tinku01%d_%s'
5> filesperset 2
6> (database include current controlfile);
7> sql 'alter system archive log current';
8> }

created script level0backup

RMAN>

RMAN> run {execute script level0backup;}

executing script: level0backup

Starting backup at 22-FEB-10
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00006 name=F:\ORACLE\ORADATA\KUMAR\INDX01.DBF
input datafile fno=00003 name=F:\ORACLE\ORADATA\KUMAR\CWMLITE01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_2 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00009 name=F:\ORACLE\ORADATA\KUMAR\USERS01.DBF
input datafile fno=00004 name=F:\ORACLE\ORADATA\KUMAR\DRSYS01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_3 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00010 name=F:\ORACLE\ORADATA\KUMAR\XDB01.DBF
input datafile fno=00007 name=F:\ORACLE\ORADATA\KUMAR\ODM01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_4 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=F:\ORACLE\ORADATA\KUMAR\RMAN01.DBF
input datafile fno=00008 name=F:\ORACLE\ORADATA\KUMAR\TOOLS01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_5 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current SPFILE in backupset
including current controlfile in backupset
input datafile fno=00001 name=F:\ORACLE\ORADATA\KUMAR\SYSTEM01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_6 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:36
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00002 name=F:\ORACLE\ORADATA\KUMAR\UNDOTBS01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_7 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00005 name=F:\ORACLE\ORADATA\KUMAR\EXAMPLE01.DBF
channel ORA_DISK_1: starting piece 1 at 22-FEB-10
channel ORA_DISK_1: finished piece 1 at 22-FEB-10
piece handle=C:\TINKU01KUMAR_8 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:15
Finished backup at 22-FEB-10

sql statement: alter system archive log current