Re: Is this method of offline backup OK?

Wouldn't it be easier to restore this db if the init file was copied as well?
Especially if there was a lot of changes done to it?

Of course it also depends who is doing a restore....

just a tought
wysza

"mark" <mark_brehmen_at_yahoo.com> wrote in message news:fa4781e4.0203042026.662ce361_at_posting.google.com...
> Hi. We take bakups offline. Please tell me whether the way i backup
> oracle is fine. If not i will correct it if you point out the mistake.
> I got this from a FAQ.
> Oracle version 8.17
>
> To backup offline
>
> STEP1
>
> Connect to ORCL using administrator username and password
>
> STEP2
> Do the following queries to get a list of all files that needs to be
> backed up:
>
> select name from sys.v_$datafile;
> select member from sys.v_$logfile;
> select name from sys.v_$controlfile;
>
>
> STEP3
> Then do this (Important, else the backups are worthless)
>
> shutdown immediate;
>
> You must get a message stating that shutdown is successful. The below
> text gives the full message.
> "Database closed.
> Database dismounted.
> ORACLE instance shut down."
>
> STEP4
>
> Copy the files got in STEP1 to a different physical location (Such as
> a tape drive)
>
> To restore, just copy the files back to their original locations
> .Again, be sure to shutdown the database before copying .
Received on Tue Mar 05 2002 - 07:30:40 CST