Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Backup & Restore
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