Re: Backup & Restore

Thanks Uday. I tried the following steps and it worked.

1. Sql Plus> alter database datafile 'c:\orant\database\project\project.ora' offline;
2. In NT Explorer> copied the file d:\backup\project.ora_080601_1530 to c:\orant\database\project\project.ora
3. Sql Plus> alter database recover datafile 'c:\orant\database\project\project.ora'

    Note: At this point Oracle didn't ask for any archived redolog files. It just said Database altered. I guess it is because there were no changes to the table and hence no logs??

4. Sql Plus> alter database datafile
'c:\orant\database\project\project.ora' online;

Now I will try the following.

I will do lot of transactions in the
tablespace, so that there will be some log files. After that I will try recovery.

thanks and regards,

Ganesh

"Uday" <un2000_at_hotmail.com> wrote in message news:fcf0102e.0108071008.ccc8ce7_at_posting.google.com...
> 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.
Received on Tue Aug 07 2001 - 23:52:00 CDT