I suppose just how much redundancy makes you sleep well is up to you. But,
one additional bit of info to keep in mind is that the backup info also gets
stored in the control files, and rman can use those too if no catalog
database is available. Making a copy of a control file after the backup
We have both 8i and 9i instances, but 'eventually' plan to migrate everything to 9i.
I'm looking at using RMAN for our backup and recovery. We have many instances but
essentially 2 types.
1. Production instances that have both OLAP and OLTP. These must be in archive log
mode.
2. We have
I do not think you need 2 Rman catalogs.
Build a small database just for Rman. After the daily backup finished bring
it down and do os level backup of all the environment for this small backup.
You can then easily restore it in case of disk problems.
Remember: A backup is good only when you can
i must have misread the docs. i thought it was either catalog or control file. didnt
know you could do both
thanks.
From: [EMAIL PROTECTED]
Date: 2003/12/04 Thu AM 11:04:26 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RMAN questions
I suppose just how
backup of all the environment for this small backup.
It should have been: for this small database.
Sorry about the mistake.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 6:44 PM
I do not think you
Resending, just wondering if there any Shark FlashCopy users out
there. So far, it doesn't look good.
Gene [EMAIL PROTECTED] 02/06/03 05:03PM
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder
works for quick disk backups from experience. However, EMC is not an
option, we are
enter theme from Jaws
No shark flash-copy usage here
I think your going to need a bigger boat!
Cheers!
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/7/2003 3:23 PM
Resending, just wondering if there any Shark FlashCopy users out there.
So far, it
This is ok for tape restores but not for disk restore...but thanks Rob.
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 4:36 PM
To: Multiple recipients of list ORACLE-L
Take a look at this link, it might be helpful...
Thanks Dennis...
Ya.. its all on disk and problably only a test with some tuning is going
to give me realistic picture. I am going to try it on NETAPPS new disaster
recovery SAN solution
Brian Spears
-Original Message-
Sent: Wednesday, February 05, 2003 3:50 PM
To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RMAN - questions.. Rob Freeman?
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent
users
This rman would
Excellent thread on VLDB and backups. I know EMC BCVs/Timefinder
works for quick disk backups from experience. However, EMC is not an
option, we are a IBM shop w/ Shark storage, Raid-5. The IBM reps say
flashcopy works the same if not better than EMC BCVs. Question, is this
pure marketing
Oops... didn't catch the disk backup bit. Backing up 1TB to disk?? Wow!
Still, the same rules would apply. lots of disks to spread the backup IO
over :-)
RF
-Original Message-
Brian
Sent: Thursday, February 06, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
This is ok
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow to 1terabyte
database. Monster HP servers ... up t0 16 cpu, upto 10,000 concurrent users
This rman would be the secondary recovery solution (Timefinder is the
first).
Anybody know time frames I might be
PROTECTED]
06-02-2003 06:16 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RMAN - questions.. Rob Freeman?
I am considering doing an rman to disk backup and recovery solution for a
500G-- grow
Brian - Hopefully Robert will have a chance to respond to your question, but
if I might make some suggestions, I think your recovery time has two
components:
1. If the backup files are not on disk, the time to locate the tape, load
the files.
2. RMAN recovery time. I think you will just have
Is this all live OLTP type data, or might some of the data be made
read-only? How much will the data be growing and changing (if not a great
deal then look into incrementals). I can't begin to guess at the time
required those numbers are all factors of:
1. # of backup devices you will be
Take a look at this link, it might be helpful...
http://portal1.legato.com/resources/whitepapers/W012.pdf
Robert
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/5/2003 2:16 PM
I am considering doing an rman to disk backup and recovery solution for
a
500G-- grow to
For question 1.
(920)/oracle/app/oracle/admin rman nocatalog
Recovery Manager: Release 9.2.0.2.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
RMAN connect target sys/password@sid (NOTE: sid is 8.1.7)
Recovery Manager incompatible with TARGET database: RMAN
After looking at my post, I thought maybe showing the contents of the
directories involved might help show the logic (??) of the script.
/u05/oracle/admin ls
ACP1/ HLPP/ HRP1/ INTP/ MOBP/ RCNP/ RSAP/ TIMP/
/u05/oracle/admin/ACP1/backup ls -l
-rw-r- 1 oracle dba3645440 Jan
Thanks Stephan. It looks like I will be using RMAN 8.1.6 8.1.7
to interface w/ the Legato Module for Oracle.
Gene [EMAIL PROTECTED] 01/16/03 09:59AM
For question 1.(920)/oracle/app/oracle/admin
rman nocatalogRecovery Manager: Release 9.2.0.2.0 -
ProductionCopyright (c) 1995, 2002, Oracle
I am starting to plan my RMAN/Legato Networker implementation.
I purchased Robert's book and have read Appendix C 8i Differences... I am
now persuaded to use RMAN 9i. However, the da'management wants RMAN
Legato Oracle module implemented ASAP. I looked at the compatibility
matrix and it
hi listers ...
1/ i had to delete archived logs before i could back them up thru rman ...my
? is how do i notify rman that these logs no longer exist ... do i
crosscheck (mark as expired) all previous logs and then issue a complete
resynch ... or do i just resynch ... or ?
2/ i am changing the
I'll try to answer these;
You can uncatalog any archivelogs you have removed without using rman. This
will accomplish what you wish. But for the future, try to an rman
archivelog backup with the delete option. This put the archivelogs in a
backupset and then deletes them. Rman know right where
23 matches
Mail list logo