Hi all

I followed the below steps to create hot backup database, but when I restore I got the problem.

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open.

And then I try to open with resetlogs and noresetlogs, I got another error

ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1 : '/db02/oracle/oradata/system01.dbf'


Please help me to solve this problem. I tried so many different ways but it still doesn't work.

Thanks




alter tablespace system begin backup;
!cp to backup directory
alter tablespace system end backup;

REM ****** backup user tablespace

alter tablespace user begin backup;
!cp to backup directory
alter tablespace user end backup;

REM ****** backup rollback tablespace
alter tablespace rollback begin backup;
!cp to backup directory
alter tablespace rollback end backup;

REM ****** backup temp tablespace
alter tablespace temp begin backup;
!cp to backup directory
alter tablespace temp end backup;




REM ****** Perform controlfile backup

Alter database backup controlfile to filename reuse;
Alter database backup controlfile to filename reuse;
alter database backup controlfile to trace;
copy file to backup directory

REM ****** Backup online redo-logs

Alter system archive log all;

copy redo log files into backup directory