Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Archive Logs

Re: Archive Logs

From: Paweł Kokot <pkokot_at_zg.szczecin.pl>
Date: Wed, 1 Dec 1999 13:10:46 +0100
Message-ID: <8232sn$3t9$1@sunsite.icm.edu.pl>


Thnx,
I know all you wrote, but there is problem. ORACLE says that database does not need to be recovered. So what to do with it?

redos you mean archivelogs?

--
Paweł Kokot
STAR-SOFT Cieszyn
John Chiu <johnymc_at_netscape.net> wrote in message news:82323a$lu7$1_at_news2.tor.accglobal.net...
> 1. cold backup your current database datafiles and redos.
> 2. restore your backup database files and all your backup archivelogs for
> the past three weeks and perform a database recovery. This will roll
forward
> all your transactions and recover your database to the point of disaster.
> 3. open database with resetlogs.
> 4. shutdown the database and perform a cold backup of all your database
> files.
> 5. startup database
> if you have a hot backup and all the related archivelogs then you can
> perform the recovery on the tablespaces in concern. This will take less
> time.
>
> HTH
>
> John Chiu
>
> Paweł Kokot <pkokot_at_zg.szczecin.pl> wrote in message
> news:822ldm$ng9$1_at_sunsite.icm.edu.pl...
> > Hi,
> > I have a problem. I have ORACLE database (on tape 3 weeks old) and
> > archivelogs (3 weeks). There was disaster yesterday. How can I rebuild
my
> > database using old database and archivelogs?
> >
> > --
> > Paweł Kokot
> > STAR-SOFT Cieszyn
> >
> >
>
>
Received on Wed Dec 01 1999 - 06:10:46 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US