Database Software

Hello,

I have quire simple task which I need to do with RMAN. I have one tablespace ( This tablespace is called "example" and Is attached to 11g1 ) which I'm using as target for workload balancing algorithm .

I know how to create backup.

RMAN > SQL 'ALTER TABLESPACE example OFFLINE';
RMAN > BACKUP TABLESPACE example FORMAT 'fooo%y.bkp' TAG my_label
RMAN > SQL 'ALTER TABLESPACE example ONLINE';


I know how to recover/restore:

RMAN > SQL 'ALTER TABLESPACE example OFFLINE';
RMAN > RESTORE TABLESPACE example FROM TAG my_label;
RMAN > RECOVER TABLESPACE example;
RMAN > SQL 'ALTER TABLESPACE example ONLINE


// Please note that I'm writing it from memory

My problem is that I get error and have trouble to turn online tablespace when I change some data
between backup and restore operations. I guess tablespace Is locked because there is no 100%
of integration of data and new changes from transaction log should be inseted/skipped before launching
tablespace.

Error is in polish language:
ORA-01113: plik 5 wymaga zastosowania przywracania noťnikˇw // ~ 5'th file requires data storege recovery..
ORA-01110: plik danych 5: 'C:\xxx\ORADATA\ORCL\EXAMPLE01.DBF'

How can I solve this problem?

ps. When I use few times RECOVER / RESTORE i'm finally able to set Online tablespace, but I don't like
it that I'm not sure what's going on there.

Thank You,
R.