Re: Backup & Restore

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. project.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      

"Ganesh Kamath" <ganesh.kamath_at_in.bosch.com> wrote in message news:<9klrho$1vt$1_at_proxy.fe.internet.bosch.com>...
> Hello,
>
> My requirement is like this:
>
> I have a database running in archivelog mode. The datafile is
> e:\orant\database\project.ora. I need to backup this file everyweek (say
> Saturday). In case something goes wrong with my data, I need to restore it
> from the previous backup. I don't have any tape device. During backup I just
> want to copy the project.ora file to some other computer.
>
> Pls can anybody tell me how to backup and restore with appropriate commands.
> I went through the documentation and still confused about this.
>
> thanks a lot,
> Ganesh
Received on Mon Aug 06 2001 - 09:37:16 CDT