RE: Rman and database shutdowns UPDATE

2003-02-12 Thread Koivu, Lisa
Ron, the analogy I always use is "who has to recover the database when it crashes?"  
When they say, well, YOU, then I say Fine.  We are going to back it up the way I see 
fit. End of story.  Have fun testing~!!

Good Luck.

Lisa Koivu
Oracle Database Administrator
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063
Office: 954-935-4117  
Fax:954-935-3639
Cell:954-683-4459


-Original Message-
Sent: Wednesday, February 12, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L


Ron - Yes they can back it up and recover it from their perspective. You've
brightened my day. Let us know if you want some more explanations to discuss
this with them again. ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, February 12, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Koivu, Lisa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




RE: Rman and database shutdowns UPDATE

2003-02-12 Thread DENNIS WILLIAMS
Ron - Thought of a simple way to explain the situation to your VMS
administrators. I've simplified a few things, but it should suffice. If I've
missed anything critical, someone will correct me ;-)
   Each Oracle datafile has a transaction number recorded. The Oracle
control file has a transaction number for each datafile. Before Oracle will
open the database, the transaction number on the control file must match the
transaction on each data file. When you shut Oracle down normal, all these
numbers match, so a cold backup after a normal shutdown is valid. This is
also why a cold backup after a shutdown abort or database crash can't be
guaranteed.
   Now, if you back the database files up while Oracle is open, the backup
will take some time, and if transactions occur in Oracle, the transaction
numbers will change during the backup, so the control file may not match
some file transaction numbers. 
   Someone mentioned that you should test it. Be careful. If the database is
quiet, it is possible to get a valid backup while the database is open. You
wouldn't want to bet on this as a backup method, but in a test situation it
could lead you to the wrong conclusion.
   Okay I'll shut up and let you get back to your nap ;-)

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 

-Original Message-
Sent: Wednesday, February 12, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




Re: Rman and database shutdowns UPDATE

2003-02-12 Thread Jay Hostetter
Ron,

  Back when we had Oracle on VMS (Oracle 7.1 - pre RMAN), we used this backup command 
for each datafile:

backup/log/ignore=(interlock,nobackup)/new 

  This will backup open files.  But if your tablespace isn't in hot backup mode, it 
doesn't help you for database recovery.  You might get lucky if there is little-to-no 
activity at the time of your backup, but this is a risk few DBAs would take.

Jay


>>> [EMAIL PROTECTED] 02/12/03 11:23AM >>>
Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers




**DISCLAIMER
This e-mail message and any files transmitted with it are intended for the use of the 
individual or entity to which they are addressed and may contain information that is 
privileged, proprietary and confidential. If you are not the intended recipient, you 
may not use, copy or disclose to anyone the message or any information contained in 
the message. If you have received this communication in error, please notify the 
sender and delete this e-mail message. The contents do not represent the opinion of 
D&E except to the extent that it relates to their official business.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jay Hostetter
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




RE: Rman and database shutdowns UPDATE

2003-02-12 Thread Freeman Robert - IL
I'd tell them, great, then lets test it.

Trust no one.

Robert


-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/12/2003 10:23 AM

Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




RE: Rman and database shutdowns UPDATE

2003-02-12 Thread STEVE OLLIG
Ron - 

the text below is from the fine VMS manual.  I suspect your SAs are
referring to the backup/ignore=interlock command.  I certainly would not
rely on it as part of my Oracle Disaster Recovery plan.  The cold backup
decision sounds to me like a wise one.


BACKUP

 Invokes the Backup utility (BACKUP) to perform the following
 BACKUP operations:

 o  Make copies of disk files.

 o  Save disk files to a BACKUP save set.

 o  Restore files from a BACKUP save set to disk.

 o  Compare disk files with other disk files or files in a BACKUP
save set.

 o  List information about the files in a BACKUP save set.

 o  Create and list BACKUP journal files.

 The two ways to back up your system disk are:

 o  If you have access to the CD-ROM for the current version of
OpenVMS Alpha or VAX, you can use the menu system supplied on
the CD-ROM to back up your system disk.

 o  If you do not have access to the CD-ROM for the current
version of OpenVMS VAX, you must use standalone BACKUP to
back up your system disk (VAX only). Standalone BACKUP is
a form of the Backup utility (VAX only) that you boot into
main memory (instead of executing under the control of the
operating system).

 For more information about BACKUP and standalone BACKUP tasks
 refer to the OpenVMS System Manager's Manual.

 Format:

 BACKUP input-specifier output-specifier


  Additional information available:

  Parameters Qualifiers
  /ALIAS /ASSIST/BACKUP/BEFORE/BLOCK_SIZE   /BRIEF
  /BUFFER_COUNT /BY_OWNER  /COMMENT   /COMPARE   /CONFIRM   /CONVERT
  /CRC   /CREATED   /DELETE/DENSITY
  Example
  /EXACT_ORDER  /EXCLUDE   /EXPIRED   /FAST  /FULL
  /GROUP_SIZE   /IGNORE/IMAGE /INCREMENTAL
  /INITIALIZE   /INTERCHANGE  /JOURNAL   /LABEL /LIST
  /LOG   /MEDIA_FORMAT /MODIFIED  /NEW_VERSION
  /NOINCREMENTAL/OVERLAY   /OWNER_UIC /PHYSICAL  /PROTECTION
  /RECORD/RELEASE_TAPE /REPLACE   /REWIND/SAVE_SET  /SELECT
  /SINCE /TAPE_EXPIRATION  /TRUNCATE  /UNSHELVE  /VERIFY/VOLUME
  Examples

BACKUP Subtopic? /ignore

BACKUP

  /IGNORE

/IGNORE=option

 Command Qualifier

 Specifies that a BACKUP save or copy operation will override
 restrictions placed on files or will not perform tape label
 processing checks.

 The /IGNORE=option qualifier has the following options:

 ACCESSIBILITYProcesses files on a tape that is protected by
  a volume accessibility character, or on a tape
  created by HSC Backup. The option applies only
  to tapes. It affects the first tape mounted and
  all subsequent tapes in the save set.


 INTERLOCKProcesses files that otherwise could not be
  processed due to file access conflicts. Use
  this option to save or copy files currently open
  for writing. You must have the user privilege
  SYSPRV, a system UIC, or ownership of the volume
  to use this option.
 LABEL_   Saves or copies the contents of files to the
 PROCESSING   specified magnetic tape volume regardless of
  the information contained in the volume header
  record. BACKUP does not verify the volume label
  or expiration date before writing information to
  the tape volume. Note that you cannot use this
  option with the /EXACT_ORDER qualifier.
 NOBACKUP Saves or copies both the file header record and
  the contents of files marked with the NOBACKUP
  flag by the /NOBACKUP qualifier of the DCL
  command SET FILE. If you do not specify this
  option, BACKUP saves only the file header record
  of files marked with the NOBACKUP flag.

-Original Message-
Sent: Wednesday, February 12, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does no

RE: Rman and database shutdowns UPDATE

2003-02-12 Thread DENNIS WILLIAMS
Ron - Yes they can back it up and recover it from their perspective. You've
brightened my day. Let us know if you want some more explanations to discuss
this with them again. ;-)
Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
[EMAIL PROTECTED] 


-Original Message-
Sent: Wednesday, February 12, 2003 10:24 AM
To: Multiple recipients of list ORACLE-L


Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




RE: Rman and database shutdowns UPDATE

2003-02-12 Thread Mercadante, Thomas F
Ron,

While Vms *can* backup the open datafile, it is worthless when you need to
recover it.  I know, I've been there.  Worked on Open Vms for about 8 years,
including Oracle for 3 years.  The file would need recovery immediately upon
an attempt to open it.  And I would not bet my job that I could recover it
properly.

If you wish, you could put the tablespace in "Hot Backup" mode and let Vms
back it up - that would work fine.  Just be aware of the issues.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, February 12, 2003 11:24 AM
To: Multiple recipients of list ORACLE-L


Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mercadante, Thomas F
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).




Re: Rman and database shutdowns UPDATE

2003-02-12 Thread Ron Rogers
Just got out of a meeting with the systems group. The Incremental backup
was not working because the command was written wrong. There has been a
decision to do cold backups each night.
 The system people swear that the OpenVms can successfully backup an
open file (datafile) and have it recovered properly. They can backup it
up with an Ignore flag that backups up open files?
 I will go with a cold backup methodology.
Ron
>>> [EMAIL PROTECTED] 02/12/03 10:18AM >>>
List,

OS OpenVms 7.3-1
Oracle 8.1.7 rel 3
Archivelog mode.
 We are trying to work through backup issues here and I have a
question.
The system nightly backup procedures backup up the disks used by
Oracle
(software and data). A full backup works but an incremental does not
backup any files. Inorder to get the changed files to be backed up as
an
incremental the sysadmin shutdown the database to flag the files as
changed.
Questions:
 How will the shutdown effect the RMAN backup if it does not know that
it was shutdown for a cold backup? 
Are there any possible problems doing a restore from the cold backup
and then using the RMAN backup/restore?

 I am still trying to figure out the OpenVms OS. Perserverience
required...!
Ron
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED] 

Fat City Network Services-- 858-538-5051 http://www.fatcity.com 
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).