Re: Operating System BACKUP procedure of an open database !

Thank's !!
I 've done "alter system switch logfile". Now I haven't problem about archive log number , but it still give me an error about the tablespace system :

    ORA_01113 : File 1 needs media recovery.     ORA_01110 : data file 1 : D:\DATAFILES\MEDIA\SYSTEM.001

 I will explain you what i want. Tell me if it's a good solution ! In order to backup the database, I want to make a full database backup once a week. Then every days, I just want to backup the archives redo logs. So, if there is a crash or something else, I could apply the archives redo logs on my full database backup and restore the database in the same state.

That's why I try to apply my archives logs ! But actually, i always have errors.

Bernard Polarski <bpolarsk_at_yahoo.com> a écrit dans le message : 88tsk8$oov$1_at_nnrp1.deja.com...
> 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 - 07:52:28 CST