SQL> create table sat(id number) tablespace test; Table created.
RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup incremental level 0 tag=sat database; }
SQL> create table sun(id number) tablespace test; Table created.
RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup incremental level 1 tag=sun database; }
SQL> create table mon(id number) tablespace test; Table created.
RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; backup incremental level 2 tag=mon database; }
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down.
Delete TEST01.DBF
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 5 - see DBWR trace file ORA-01110: data file 5: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBA20\TEST01.DBF'
RMAN> run { allocate channel c1 type disk; allocate channel c2 type disk; restore database; recover database; alter database open; }
SQL> desc sat; Name Null? Type ----------------------------------------- -------- ----------------- ID NUMBER
SQL> desc sun; Name Null? Type ----------------------------------------- -------- ----------------- ID NUMBER
SQL> desc mon; Name Null? Type ----------------------------------------- -------- ----------------- ID NUMBER
|