Hi you can start from this one, I have a questin in which mode is your
databse archivelog or noarchivelog (YOU should ALWAYS place db in
archivelogmode)
BACKUP :
sqlplus /nolog
conn sys/[Email Address Removed] as sysdba
shutdown immediate
After database shutsdown
COPY d:\oracle\oradata\* e:\backup\...

If you want to restore a database
In noarchivelog mode:
copy back or your files from e:\backup to d:\oracle\oradate
and start db -- your databse will be consitent to the time you did cold
backup

In archivelog mode
copy back to d:\oracle\oradata\ file s from backup
restore archivelogs using
sqlplus /nolog
conn sys/[Email Address Removed] as sysdba
startup mount
restore database -- when prompt specify automatic

These example is very simple and assumes full database recovery, but you
can also recover datafiles
if you have more questions ask a list

Best Regards
Krystian Zieja / mob

>
>
> hi gurus,
>
> can someone give me the script for oracle cold database backup and restore
> in windows .
>
>
> thanx in advance
> vipul
>
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these
> terms:http://www.lazydba.com/legal.html
>
>



Oracle LazyDBA home page