Re: Operating System BACKUP procedure of an open database !

At the end of the backup, and before you copy control file, issue an 'alter system switch logfile'. This insure a checkpoint.

'Archive log current' just write to disk what may be written (completed and switched redo logs, but did not force being filled redo logs to be archived and switched).

Also when you restore, why do you automatically take your restore from backup controlfile and 'open reset logs'. These features are only for partial restore (ie : up to time), not full restore like 'recover database '. Open resetlogs are usually requested by 'create controlfile' command (if you need tio change your path, issue a backup controlfile to trace and retrieve it for modification in udum).

B. Polarski

  "Christian MERCK" <cm_at_sdv.fr> wrote:
> 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
>
>

--
B.Polarski

http://www.geocities.com/bpolarsk
Email : bpolarsk_at_yahoo.com

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 22 2000 - 05:40:56 CST