Backup Using RMAN

Text description of sbr81083.gif follows

Figure: RMAN Channel allocation


SQL> archive log list;

Database log mode              Archive Mode

Automatic archival             Enabled

Archive destination            USE_DB_RECOVERY_FILE_DEST

Oldest online log sequence     17

Next log sequence to archive   19

Current log sequence           19

 

SQL> create table b(name varchar2(100));

 

Table created.

 

SQL> insert into b values('**** INSERT BEFORE BACKUP *****');

 

1 row created.

 

SQL> commit;

 

Commit complete.

 

H:\>set oracle_sid=dba20

 

H:\>rman

 

Recovery Manager: Release 10.2.0.1.0 - Production on Mon Jan 18 11:30:00 2010

 

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

 

RMAN> connect target sys/sys

 

connected to target database: DBA20 (DBID=847839442)

 

RMAN> run{

2> allocate channel c1 type disk;

3> allocate channel c2 type disk;

4> allocate channel c3 type disk;

5> allocate channel c4 type disk;

6> backup database;

7> }

 

SQL> insert into b values('**** INSERT AFTER BACKUP *****');

 

1 row created.

 

SQL> commit;

 

Commit complete.

 

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

Delete USERS.DBF/SYSTEM.DBF

 

SQL> startup;

ORACLE instance started.

 

Total System Global Area  167772160 bytes

Fixed Size                  1247876 bytes

Variable Size              71304572 bytes

Database Buffers           88080384 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

2> {

3> allocate channel c1 type disk;

4> allocate channel c2 type disk;

5> allocate channel c3 type disk;

6> restore database;

7> recover database;

8> }

 

 

SQL> alter database open;

 

Database altered.

 

SQL> select * from b;

 

NAME

-----------------------------------------

 

**** INSERT BEFORE BACKUP *****

**** INSERT AFTER BACKUP *****

 

Some Channel Command and Options:

Comments