RMAN Backup With Some Options

Some Channel Command and Options:

RMAN> run

{

allocate channel c1 type disk maxopenfiles 20 rate 1M maxpiecesize 50M;

allocate channel c2 type disk maxopenfiles 20 rate 1M maxpiecesize 50M;

backup database;

}

RMAN> run

{

allocate channel c1 device type disk format 'c:\rman\%d%D%M%Y';

allocate channel c2 device type disk format 'c:\rman\%d%D%M%Y';

backup database;

}

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Delete any data file.

SQL> startup;

ORACLE instance started.

Total System Global Area 167772160 bytes

Fixed Size 1247876 bytes

Variable Size 79693180 bytes

Database Buffers 79691776 bytes

Redo Buffers 7139328 bytes

Database mounted.

ORA-01157: cannot identify/lock data file 1 - see DBWR trace file

ORA-01110: data file 1: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\SYSTEM01.DBF'

RMAN> run

{

allocate channel c1 type disk;

allocate channel c2 type disk;

allocate channel c3 type disk;

restore database;

recover database;

}

SQL> alter database open;

Database altered.