Very possible to do. It's a bit involved but it is documented in my
Oracle9i RMAN Backup and Recovery book and it will work for 8i.
RF
Robert G. Freeman
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books
I have done it in 8.0.6.3 and one earlier version. As Robert says, it is a
bit involved. I had help from Oracle Support when I had to do it.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, January 19, 2003 1:23 AM
Indeed you can do
Title: RE: RE : RMAN Repository
In
your case, the recovery catalog makes it MUCH MUCH easier! :-) So, I'm
not saying you are incorrect, only that nobody should ever think they are
unrecoverable just because RMAN can not find a backup set record in the
repository or control file
the absolute fall back plan is that you will just have to manually
extract the backup sets from media and recover.
RF
-Original Message-
Sent: Friday, January 10, 2003 3:40 PM
To: Multiple recipients of list ORACLE-L
Why is everyone trying to link the Rman repository and it's recovery
scenarious
was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent a shiver through the spine, Jared. I admit, I never
tested
the
recovery of the RMAN repository and never (shame on me!)
considered
the
effect of incomplete
oh Lord, I hope not. The scripts aren't that perfect.
Besides, that would get REALLY noisy, wouldn't it?
I don't put comments in because I'm perfect, I put them in because of
the exact opposite condition. Swiss-cheese memory, so if I don't
comment what I've done, I have to reinvent the wheel
And I learned, in the one management class I ever took, that if I ever
want to be promoted, or move on to more fun stuff, I have to have made
my job one that someone else can step into.
You know, if more people realized that, then there would be fewer people
complaining about not moving up in
Indeed you can do this. It's a bit involved, but it's documented in my
Oracle9i RMAN Backup and Recovery Book, and it is supported in 8i.
RF
-Original Message-
Hostetter
Sent: Friday, January 10, 2003 6:59 AM
To: Multiple recipients of list ORACLE-L
But I don't anticipate having to
Title: RE: RE : RMAN Repository
I do
have one scenario where you really have to use a recovery catalog... When
attempting to backup a VLDB that usesread only tablespaces and extremely
infrequent backups for most of the data (i.e. a large datawarehouse), a recovery
catalog is very important
Geez Tom, I didn't realize it was so simple. ;)
On Friday 10 January 2003 11:04, Mercadante, Thomas F wrote:
separate and simplify the issues.
develop a bullet-proof backup and recovery plan for the Rman repository
*first*.
then develop plans for production databases.
trying to do both
the RMAN perspective.
/Quote
That sent a shiver through the spine, Jared. I admit, I never tested
the
recovery of the RMAN repository and never (shame on me!) considered
the
effect of incomplete recovery of the catalog.
Others, any ideas? specifically the effect of losing the catalog
But I don't anticipate having to recover from a prior incarnation
when I have a perfectly good backup from the last successful backup.
I get requests from developers to refresh test databases from production backups
that are 30 days old. This is for billing system software, where they need to
be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent a shiver through the spine, Jared. I admit, I never tested
the
recovery of the RMAN repository and never (shame on me!) considered
the
effect of incomplete recovery of the catalog.
Others, any ideas
: Re: RE : RMAN Repository
Importance: High
Hot backup of the repository is fine as long as you can be
assured that all files needed for a complete recovery are
going to be available.
Recover a hot backup of an RMAN repository to another
server using imcomplete recovery, ( your RMAN
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RE : RMAN Repository
Huh!!!
Quote
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent
of the RMAN repository and never (shame on me!) considered
the
effect of incomplete recovery of the catalog.
Others, any ideas? specifically the effect of losing the catalog
database
and recreating it from a hot backup? Robert Freeman, perhaps?
This is another reason why I dislike the idea
, it may be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent a shiver through the spine, Jared. I admit, I never tested
the
recovery of the RMAN repository and never (shame on me!) considered
the
effect of incomplete recovery of the catalog
the
recovery of the RMAN repository and never (shame on me!)
considered
the
effect of incomplete recovery of the catalog.
Others, any ideas? specifically the effect of losing the catalog
database
and recreating it from a hot backup? Robert Freeman, perhaps
!!!
Quote
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent a shiver through the spine, Jared. I admit, I never tested
the
recovery of the RMAN repository and never
Why is everyone trying to link the Rman repository and it's recovery
scenarious with recoverying production databases?
The Rman repository is just another Oracle database. It needs it's own
backup and recovery plan. Worrying about incomplete recovery of this
database in relation to recoverying
Simple export of the rman user usually does the trick.
But then what about the backup of the repository backup.. and so on :)
bs
-Original Message-
Sent: Friday, January 10, 2003 2:04 PM
To: Multiple recipients of list ORACLE-L
Why is everyone trying to link the Rman repository
Why is everyone trying to link the Rman repository and it's recovery
scenarious with recoverying production databases?
How is that? We are talking about the recovery of the rman catalog database
only. The question is if the catalog database were to crash and it had hot
backup; and the recovery
-L
[EMAIL PROTECTED]
cc:
Subject:RE : RMAN Repository
Joe,
That's what I have heard (from 2 Oracle University
Professors/Lecturers/Demonstrators). But no one would tell me when it may
happen. We do not use RMAN (yet) so I did not pursue it further.
- Kirti
.
I should point out that even if you use an RMAN repository, the recovery
information is still stored in the control files, so you can still perform a
control file recovery. But Jared is correct that it is much more difficult
if you must try to recover the control file from the RMAN backup piece
.
I should point out that even if you use an RMAN repository, the recovery
information is still stored in the control files, so you can still perform a
control file recovery. But Jared is correct that it is much more difficult
if you must try to recover the control file from the RMAN backup piece
PROTECTED]
01/08/2003 11:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:RE : RMAN Repository
Joe,
That's what I have heard (from 2 Oracle University
Professors/Lecturers/Demonstrators
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of it.
Has anyone else heard the RMAN repository was going away? It appears much
simpler to setup w/out the repository. Besides reporting advantages, what
embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of it.
Has anyone else heard the RMAN repository was going away? It appears much
simpler to setup w/out the repository. Besides reporting advantages, what
are the real benefits to using a repository
point out that even if you use an RMAN repository, the
recovery
information is still stored in the control files, so you can still perform
a
control file recovery. But Jared is correct that it is much more difficult
if you must try to recover the control file from the RMAN backup piece
Title: RE: RE : RMAN Repository
If you aren't using a repository all you have to do is make sure control file backups are part of the routine. There are 2 ways to backup the backup metadata: 1) the RMAN repository database; 2) backup controlfiles.
Functionally and operationally they're
to a mail reader or gateway that understands how to
properly handle MIME multipart messages.
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of
it. Has anyone else heard the RMAN repository was going
: RMAN Repository
Joe,
That's what I have heard (from 2 Oracle University
Professors/Lecturers/Demonstrators). But no one would tell me when it may
happen. We do not use RMAN (yet) so I did not pursue it further.
- Kirti
-Original Message-
Sent: Wednesday, January 08, 2003 1:08 PM
Of Gene
Sais
Sent: Thursday, January 09, 2003
9:50 AM
To: Multiple recipients of list
ORACLE-L
Subject: Re: RE : RMAN Repository
Interesting thread, since I am just
embarking on using RMAN. If the repository is to go away then why bother
learning the intricacies of it. Has anyone else heard
recipients of list ORACLE-LSubject:
Re: RE : RMAN Repository
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of it.
Has anyone else heard the RMAN repository was going away? It appears
much simpler to setup
at that moment. ;-)
So, you should be able to recover your repository and/or take a fresh
backup.
I should point out that even if you use an RMAN repository, the recovery
information is still stored in the control files, so you can still perform a
control file recovery. But Jared is correct
Title: RE: RE : RMAN Repository
I find it useful for organizing and keeping track of my backups so that during recovery it is as simple as running pre-scripted queries to see what I have available - geez am I the only one who likes RMAN and doesn't think it makes things that difficult
Title: RE: RE : RMAN Repository
The only things you can't do with
controlfile RMAN/database metadata is:
1) use previous "incarnations" of the
database for recovery;
Actually, you can, it's just a manual process. This is
documented in the RMAN book. Also, in 9i you can do automa
, you should be able to recover your repository and/or take a fresh
backup.
I should point out that even if you use an RMAN repository, the
recovery
information is still stored in the control files, so you can still perform
a
control file recovery. But Jared is correct that it is much more
then why bother learning the
intricacies of it.Has anyone else heard the RMAN repository was going
away? It appears muchsimpler to setup w/out the repository.
Besides reporting advantages, whatare the real benefits to using a
repository?Thanks,GenePS. Now reading Robert's book.
[EMAIL PROTECTED] 01
of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: RE : RMAN Repository
If you aren't using a repository all you have to do is make sure control
file backups are part of the routine. There are 2 ways to backup the
backup metadata: 1) the RMAN repository database; 2) backup
Title: RE: RE : RMAN Repository
Yeah but do you have to pay for another Veritas NetBackup license and server to backup the catalog? If just have one database server and one database license why should I have to buy another license and install another 1-2GB of Oracle software on another server
Title: RE: RE : RMAN Repository
If I need a database to backup a database then do I need
another database to backup the database that backed up the original database?
Exactly my thoughts.
Igor Neyman, OCP DBA[EMAIL PROTECTED]
- Original Message -
From:
Orr, Steve
/08/2003 11:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L ORACLE-
[EMAIL PROTECTED]
cc:
Subject:RE : RMAN Repository
Joe,
That's what I have heard (from 2 Oracle University
Professors/Lecturers/Demonstrators
the database that backed up the original
database?
Exactly my thoughts.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
From: Orr, Steve
To: Multiple recipients of list ORACLE-L
Sent: Thursday, January 09, 2003 1:18 PM
Subject: RE: RE : RMAN Repository
Yeah
, 2003 9:50 AM
To: Multiple recipients of list ORACLE-L
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning the intricacies of
it.
Has anyone else heard the RMAN repository was going away? It appears
much
simpler to setup
: RMAN Repository
If you aren't using a repository all you have to do is make sure control
file backups are part of the routine. There are 2 ways to backup the
backup metadata: 1) the RMAN repository database; 2) backup controlfiles.
Functionally and operationally they're pretty much the same
-From: Gene Sais
[mailto:[EMAIL PROTECTED]]Sent: Thursday, January 09, 2003
9:50 AMTo: Multiple recipients of list ORACLE-LSubject:
Re: RE : RMAN Repository
Interesting thread, since I am just embarking on using RMAN. If the
repository is to go away then why bother learning
the repository you'd have to spend a lot of your time either typing commands
each day or creating programs to perform what RMAN offers built in.
As to the rumors that Oracle is going to soon abandon the RMAN
repository, I agree with Robert (if I recall correctly). How could they?
Large Oracle
to spend a lot of your time either typing commands
each day or creating programs to perform what RMAN offers built in.
As to the rumors that Oracle is going to soon abandon the RMAN
repository, I agree with Robert (if I recall correctly). How could they?
Large Oracle customers are heavily
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried it myself.
Speaking of backing up the RMAN repository, does anyone
back them up hot?
Seems to me that would not be a good idea.
Jared
Ruth Gramolini [EMAIL PROTECTED
Is it an old fashioned backup (non-rman)? I export our rman repository and ftp the
.dmp file to another server.
Jay
[EMAIL PROTECTED] 01/09/03 03:30PM
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried it myself
in.
As to the rumors that Oracle is going to soon abandon the RMAN
repository, I agree with Robert (if I recall correctly). How could they?
Large Oracle customers are heavily committed to the repository, and Oracle
usually doesn't do anything that stupid. But people are whining about why
they are forced
, Sussex, WI USA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 2:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: RE : RMAN Repository
I do a cold backup of my repository daily.
Replication of it is not a bad idea
Hot backup of the repository is fine as long as you can be
assured that all files needed for a complete recovery are
going to be available.
Recover a hot backup of an RMAN repository to another
server using imcomplete recovery, ( your RMAN server
burned to a crisp, drives and all ), and you
Title: RE: RE : RMAN Repository
You can have a very large site and still do just fine without an RMAN
repository. RE the non-database solution, Oracle has already done that,
it's called the controlfile. I tend to agree with Robert F. who wrote the
book on RMAN where, in another post he wrote
Title: RE: RE : RMAN Repository
Hey
Brian,
I only
talk about the way it SHOULD be... not what I actually do.
:-)
I
confess to presently using the suppository,er a repositorybut
anticipate just using control files
after we upgrade to 9i with its enhanced RMAN features. I have a shell
Title: RE: RE : RMAN Repository
Never heard of the q29_6 parameter. :-)
Looks like excess glue spilled during a cut and paste operation.
-Original Message-
From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]]
Sent: Thursday, January 09, 2003 3:24 PM
To: Multiple recipients of list
-
Sent: Thursday, January 09, 2003 4:07 PM
To: Multiple recipients of list ORACLE-L
You can have a very large site and still do just fine without an RMAN
repository. RE the non-database solution, Oracle has already done that,
it's called the controlfile. I tend to agree with Robert F. who
Huh!!!
Quote
If the backup was made while the repository was in use for
other backups, it may be in a logically inconsistent state from
the RMAN perspective.
/Quote
That sent a shiver through the spine, Jared. I admit, I never tested the
recovery of the RMAN repository and never (shame on me
Title: RE: RE : RMAN Repository
I
agree Steve, and thanks for the info.
Do you have any procedures to cover backup logic
holes if you
have
to rebuild the controlfile for some reason (Ie.. maximum files reached
etc)
Do you
accept losing the backup history and cross fingers or ... have
The database containing RMAN repository does not need to be up 100%, only
when the backup is going on restoring. Therefore, in many sites, DBAs can
actually shutdown the database and take cold backup, just for convenience
sake, if not anything else. Jared wanted to know if anybody used hot backup
: RMAN Repository
Is it an old fashioned backup (non-rman)? I export our rman repository
and ftp the .dmp file to another server.
Jay
[EMAIL PROTECTED] 01/09/03 03:30PM
I do a cold backup of my repository daily.
Replication of it is not a bad idea, as Arup mentioned,
though I haven't tried
and cross fingers or ... have
procedure
to account for that?
Brian
-Original Message-
Sent: Thursday, January 09, 2003 4:07 PM
To: Multiple recipients of list ORACLE-L
You can have a very large site and still do just fine without an RMAN
repository. RE the non-database solution, Oracle
To: Multiple recipients of list ORACLE-L
putting on a flame retardant suit
As long as they aint skinny, looks are good :)
Obilgatory oracle statement/question: rumor has it by some instructors
that RMAN repository is going away and only control file recoveries
will be possible, truth
recipients of list ORACLE-L
snip
Obilgatory oracle statement/question: rumor has it by some instructors
that RMAN repository is going away and only control file recoveries
will be possible, truth or fiction?
joe
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Deshpande
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE : RMAN Repository
Joe,
That's what I have heard (from 2 Oracle University
Professors/Lecturers/Demonstrators). But no one would tell me when it may
happen. We do not use RMAN (yet
by: [EMAIL PROTECTED]
01/08/2003 11:44 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE : RMAN Repository
Joe,
That's what I have heard (from 2 Oracle University
Professors/Lecturers/Demonstrators). But no one would
as putting the RMAN repository on
the same server as your production database.
Jared
Joe Testa [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/08/2003 02:19 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject
of the
repository is as simple as opening up in vi and typing the lines. Guess
which one is simpler?
Just a thought.
Arup Nanda
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Wed, 08 Jan
recipients of list ORACLE-L
Steve,
From the 817 documentation on RMAN:
Storage of the RMAN Repository Exclusively in the Control File
Because most information in the recovery catalog is also available in the
target database's control file, RMAN supports an operational mode in which
it uses
70 matches
Mail list logo