Re: Backup & Restore

Well Ganesh,
  For the restore you will need:
   -->. The Datafile you backed up.
   -->. All archivelogs from the point of the backup till when you want to restore( at least from the point in time where you issued the 'alter tablespace ...begin backup command' ). If any one is missing complete recovery will not be possible.

   --> Current control file.
   -->. If you have backed up only one file or all files for one tablespace you cannot recover the whole Database. However, you will be able to recover the datafile you backed up in case you lose that datafile - so you will be able to recover all datafiles you backed up provided you have all the required archived logs. For the entire DB you would have to repeat the backup steps for each tablespace in the DB.
  Steps: assuming you databse is open: I am using sqlplus. If ur version is older than 8.1.6 use svrmgrl.

    OS> sqlplus /nolog
    sql> connect / as sysdba;
    sql> alter database datafile '<filename>' offline; ****In case the original media is bad or corrupt, do the following. Otherwise you can copy the backup on the current offline datafile in which case a rename is not required and the following step can be skipped.

    sql> alter database rename file '<oldfileName>' to '<newfilename>';

    sql> recover datafile '<datafile>';
    At this point oracle will ask for the Appropriate archived redolog files

    beginning with the earliest ...keep applying till you get a message

    "Media recovery complete"
    sql> alter database datafile '<filename>' online; Thats all.
Hope this answers your question.         

"Ganesh Kamath" <ganesh.kamath_at_in.bosch.com> wrote in message news:<9koiss$ll9$1_at_proxy.fe.internet.bosch.com>...
> I just did this to do the backup:
>
> In Sql Plus> alter tablespace project begin backup;
> In NT Explorer> copied the file c:\orant\database\project\project.ora to
> d:\backup\project.ora_080601_1530
> In Sql Plus> alter tablespace project end backup;
>
> - Ganesh
>
>
> "Norman Dunbar" <ndunbar_at_lynxfinancialsystems.co.uk> wrote in message
> news:48B95088F03ED511BE5A00508BEED0882AFBC9_at_tapps.leeds.lfs.co.uk...
> > PS. When you took the hot backup, you did keep the archive logs going
> > back to the start of the backup, and not the end of the backup didn't
> > you ??
> >
> > Norman.
> >
> > ------------------------------------------------------------------------
> > --------
> > Norman Dunbar EMail: NDunbar_at_LynxFinancialSystems.co.uk
> > Database/Unix administrator Phone: 0113 289 6265
> > Lynx Financial Systems Ltd. Fax: 0113 201 7265
> > URL: http://www.LynxFinancialSystems.com
> > ------------------------------------------------------------------------
> > --------
> >
Received on Tue Aug 07 2001 - 13:08:26 CDT