Re: Backup problem

From: Jimmy Collins <jimmy_at_jcollins.de>
Date: Thu, 20 Dec 2001 13:26:46 +0100
Message-ID: <ufssv9.ol5.ln@spider.jc-local>

"Rüdiger J. Schulz" <johannes.schulz_at_web.de> schrieb im Newsbeitrag news:3c21d57d$1_at_netnews.web.de...
> you dont have to shutdown the "oracle service"!
> sometimes the NT-Service leaf some file in the state "open"...
>
>
> if you want to make a full-"offline"-backup try this:
>
>
> -- connect internal/password_at_tnsname
> -- shutdown immediate
> -- > now backup all your datafiles (with os-commands like
> -- > "copy", or so ...)
> -- startup mount
> -- ALTER DATABASE
> -- BACKUP CONTROLFILE TO 'x:\blabla\ctrl.bak' REUSE;
> -- ALTER DATABASE OPEN;
???
You don´t need "...backup controlfile to..."! You just need this when doing online-backup. After shutdown you can just copy the controlfiles.

> after this procedure you have your full-offline-backup AND
> your controlfile is backuped (file: ctrl.bak), too.
>
>
> hth
> Rüdiger J. Schulz
> rjs_at_berlin.de

Jimmy Collins Received on Thu Dec 20 2001 - 06:26:46 CST