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: Backup & Restore

Re: Backup & Restore

From: Ganesh Kamath <ganesh.kamath_at_in.bosch.com>
Date: Tue, 7 Aug 2001 08:48:14 +0530
Message-ID: <9knmmp$l4k$1@proxy.fe.internet.bosch.com>

Thanks a lot Uday. Now I am clear on how to do a backup. I tried it and it worked fine.

Now the part 2 - recovery. How do I recover from the backed up file? Say I backed up as "project.ora_080601_1530". If I want to restore this data on 10th August, how do I do this?

Pls help.

Thanks again.

Ganesh


"Uday" <un2000_at_hotmail.com> wrote in message news:fcf0102e.0108060637.7d7983a6_at_posting.google.com...
> Hi Ganesh,
> Here's what you could do:
> 1. Place the tablespace associated with the datafile in hot
> backup.
> sql*plus> alter tablespace <tablespace_name> begin backup;
> 2. Copy the Datafile using an OS copy command to the destination
> (use appro.commands in case of raw datafiles )
> OS:WinNT> copy source_file_name to Destination_file_name;
> 3. Remove the tablespace from hot backup;
> sql*plus> alter tablespace <tablespace_name> end backup;
> That is all.
> You might want to make sure that the destination filename does reflect
the date & time of the backup( viz. oject.ora_080601_1530). Makes it easier to identify the file and makes the filename unique too. You might want script this process. Once scripted run it as a job from something like cron on unix so that it runs on a specific Day& TimeOfDay.Then as long as you have all the archivelogs after this backup you can restore the database till whatever point in time after the backup - in case you need to.
> Uday
Received on Mon Aug 06 2001 - 22:18:14 CDT

Original text of this message

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