Re: Backup of D:\oracle on Windows

From: joel garry <joel-garry_at_home.com>
Date: Tue, 17 Jun 2008 11:14:57 -0700 (PDT)
Message-ID: <ab393cba-6f6a-4312-b974-ed8e953a65a0@j33g2000pri.googlegroups.com>


On Jun 17, 5:29 am, gazzag <gar..._at_jamms.org> wrote:
> On 17 Jun, 13:11, howard <pkowa..._at_gmail.com> wrote:
>
>
>
> > 1. Yes, it is the ORACLE_HOME and ORACLE_BASE.
> > 2. The datafiles would reside on a LUN on a separate drive.
> > 3. Shut it down if I want to do a cold copy.
>
> > Thanks
>
> > Howard
>
> Howard, you can't use RMAN to backup a file system.  Ideally, if any,
> the only files being written to under ORACLE_HOME will be your dump
> files.  "show parameter dump" will confirm whether this is the case or
> not.  As long as there are no database files (data files, redo etc)
> under ORACLE_HOME, I'd look into using the "xcopy" command from the
> command prompt.
>
> HTH
>
> -g

You might be able to do something like create a stored procedure that does the OS command (one example: http://www.oracle-base.com/articles/8i/ShellCommandsFromPLSQL.php ), then see the docs for "Executing a PL/SQL Stored Procedure Within RMAN: Example".

But I have this vague memory that xcopy misses a file if the db is not shutdown... or is it some service? Too long since I've tried it. I do think there is value in backing up non-data Oracle, all those config files for EM and whatall can be screwed up so easily.

jg

--
@home.com is bogus.
http://brucefwebster.com/2008/06/16/anatomy-of-a-runaway-it-project/
Received on Tue Jun 17 2008 - 13:14:57 CDT

Original text of this message