-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|