Operating System BACKUP procedure of an open database !

From: Christian MERCK <cm_at_sdv.fr>
Date: Tue, 22 Feb 2000 10:18:40 +0100
Message-ID: <88tkh1$r5v$1@reader1.fr.uu.net>

Hi,

I work on Oracle 8i , in achives logs mode. When I try to restore my database after an OS Backup, I have all the time the same error :
" The tablespace SYSTEM need a recovery " I think that my backup is not complete but i don't no where !

The steps are :

1. ALTER SYSTEM ARCHIVE LOG CURRENT;
2. ALTER TABLESPACE TOTO BEGIN BACKUP; ALTER TABLESPACE SYSTEM BEGIN BACKUP;
3. OS copy of the tablespaces files

    4 ) ALTER TABLESPACE TOTO END BACKUP;             ALTER TABLESPACE SYSTEM END BACKUP;     5) ALTER DATABASE BACKUP CONTROLFILE TO " d:\TOTO "

    6) ALTER SYSTEM ARCHIVE LOG CURRENT;     7 ) Copy of the archives logs.

To restore the database , I do :

    1 ) STARTUP MOUNT PFILE='C:\ORACLE\ORA81\DATABASE\INIT.ORA'     2 ) RECOVER DATABASE USING BACKUP CONTROLFILE;     3) ALTER DATABASE OPEN RESETLOGS; But I can't open my database ! It always want newest archive log, that I don't have !

Can anybody describe me the procedure to make an OS Backup of an open database ?

Thank's

--

---

Christian MERCK
mailto:cm_at_sdv.fr Received on Tue Feb 22 2000 - 03:18:40 CST