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
]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com with Microsoft
]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600);
Thu, 9 Jan
2003 16:23:24 -0800
Received: from fatcity.UUCP (uucp
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
my
thoughts!
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164
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
adapted to query and manipulate the ascii text file. Just my
thoughts!
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
: 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
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600);
Thu, 9 Jan
2003 16:23:24 -0800
? The RMAN scripts could
have
been adapted to query and manipulate the ascii text file. Just my
thoughts!
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com
recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600);
Thu, 9 Jan
2003 16:23:24
]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com with Microsoft SMTPSVC
of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc2-f20.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600);
Thu, 9 Jan
2003 16:23:24 -0800
thoughts!
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09 Jan 2003 15:19:43 -0800
MIME-Version: 1.0
Received: from
-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
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) so I did not pursue it further.
- Kirti
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) so I did not pursue it further.
- Kirti
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
very reasonable.
Jared
Deshpande, Kirti [EMAIL PROTECTED]
Sent 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
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) so I did
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
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). But no one would tell me when
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
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
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
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
Dennis - I am now running 8.1.6 8.1.7 w/out RMAN, soon to upgrade to
9.2 then implement RMAN. I have 25 db instances. I am thinking of
using RMAN w/out a repository unless there aregreat reasons not to
:)
Gene [EMAIL PROTECTED] 01/09/03 11:24AM
Gene - Which Oracle version(s)? How many
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
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). But no one would tell me when
/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 tell me
-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
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) so I
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) so I did not pursue it further
]
Sent by: [EMAIL PROTECTED]
01/09/2003 11:04 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RE : RMAN Repository
The earlly versions of rman suggested that you put a 2nd recovery catalog
in one
PROTECTED]
cc:
Subject:Re: RE : RMAN Repository
The earlly versions of rman suggested that you put a 2nd recovery catalog
in one of the databases you are using the real recovery catalog for.
Then
you use this to record the backups of the recovery catalog database. I
sound very reasonable.
Jared
Deshpande, Kirti [EMAIL PROTECTED]
Sent 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
, 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
with a definitive answer.
Jared
Arup Nanda [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/09/2003 01:09 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: RE : RMAN Repository
Jared,
I do. Actually, I
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
: 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 pretty much
; but then again is it there, really? The RMAN scripts could have
been adapted to query and manipulate the ascii text file. Just my thoughts!
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: RE : RMAN Repository
Date: Thu, 09
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
, 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, as Arup mentioned,
though I haven't tried it myself.
Speaking of backing up the RMAN repository, does anyone
back
ORACLE-L
[EMAIL PROTECTED]
cc:
Subject:Re: RE : RMAN Repository
The earlly versions of rman suggested that you put a 2nd recovery catalog
in one of the databases you are using the real recovery catalog for.
Then
you use this to record the backups of the recovery catalog
: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 pretty much
Joe - I think it is a matter of emphasis. I think you will always have a
choice between the control file and the repository. In Oracle8i they
emphasized the repository. In Oracle9i they are pointing out that the
control file is also appropriate for some sites. I think this is good
because it
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
To: Multiple
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
:Re: RE : RMAN Repository
its a pain in the arse but you have to pull out the backed up
controlfile(you did backup the controlfile, eh?) out of the rman backup
piece(i've got a script that will do it automagically based on the
filename pieces you pass it).
then once the backed up controlfile
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
Thanks Bruce,
So it looks like the only feature that does not have an alternative solution
is the stored scripts. You can backup the controlfile and keep the logs to
cover everything else.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 19, 2001 5:31 PM
To: Multiple
69 matches
Mail list logo