dbTalk Databases Forums  

Backup of D:\oracle on Windows

Go Back dbTalk Databases Forums Databases comp.databases.oracle.server Backup of D:\oracle on Windows

comp.databases.oracle.server comp.databases.oracle.server


Discuss Backup of D:\oracle on Windows in the comp.databases.oracle.server forum.



Reply
Page 4 of 4 < 1 2 3 4
 
Thread Tools Display Modes
  #31  
Old   
joel garry
 
Posts: n/a

Default Re: Backup of D:\oracle on Windows - 06-17-2008 , 01:14 PM





On Jun 17, 5:29*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 17 Jun, 13:11, howard <pkowa... (AT) gmail (DOT) 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/...sFromPLSQL.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/...ay-it-project/


Reply With Quote
  #32  
Old   
joel garry
 
Posts: n/a

Default Re: Backup of D:\oracle on Windows - 06-17-2008 , 01:14 PM





On Jun 17, 5:29*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 17 Jun, 13:11, howard <pkowa... (AT) gmail (DOT) 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/...sFromPLSQL.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/...ay-it-project/


Reply With Quote
  #33  
Old   
joel garry
 
Posts: n/a

Default Re: Backup of D:\oracle on Windows - 06-17-2008 , 01:14 PM


On Jun 17, 5:29*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 17 Jun, 13:11, howard <pkowa... (AT) gmail (DOT) 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/...sFromPLSQL.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/...ay-it-project/


Reply With Quote
  #34  
Old   
joel garry
 
Posts: n/a

Default Re: Backup of D:\oracle on Windows - 06-17-2008 , 01:14 PM


On Jun 17, 5:29*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 17 Jun, 13:11, howard <pkowa... (AT) gmail (DOT) 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/...sFromPLSQL.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/...ay-it-project/


Reply With Quote
  #35  
Old   
joel garry
 
Posts: n/a

Default Re: Backup of D:\oracle on Windows - 06-17-2008 , 01:14 PM


On Jun 17, 5:29*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 17 Jun, 13:11, howard <pkowa... (AT) gmail (DOT) 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/...sFromPLSQL.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/...ay-it-project/


Reply With Quote
  #36  
Old   
joel garry
 
Posts: n/a

Default Re: Backup of D:\oracle on Windows - 06-17-2008 , 01:14 PM


On Jun 17, 5:29*am, gazzag <gar... (AT) jamms (DOT) org> wrote:
Quote:
On 17 Jun, 13:11, howard <pkowa... (AT) gmail (DOT) 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/...sFromPLSQL.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/...ay-it-project/


Reply With Quote
Reply
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top