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 y
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
>> 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 u
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
Granted, the catalog needs to stored somewhere
> and
> > > it
> > > happens to be in (surprise! surprise!!) an Oracle database; but
> it's
> > > more
> > > akin to driving a leather interior tank to work everyday. It
> could
> > > have been
> the RMAN perspective.
> > > >
> > > >
> > > > 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
>
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
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 rec
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 uses read only tablespaces and extremely
infrequent backups for most of the data (i.e. a large datawarehouse), a recovery
catalog is very
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 d
tory 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 recrea
me: 10 Jan 2003 00:23:24.0598 (UTC)
> > > >FILETIME=[7D17A560:01C2B83E]
> > > >
> > > >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.
> > >
where and
> > > it
> > > happens to be in (surprise! surprise!!) an Oracle database; but it's
> > > more
> > > akin to driving a leather interior tank to work everyday. It could
> > > have been
> > > plain and simple like a text file. A sql based
]
> > > >X-OriginalArrivalTime: 10 Jan 2003 00:23:24.0598 (UTC)
> > > >FILETIME=[7D17A560:01C2B83E]
> > > >
> > > >Hot backup of the repository is fine as long as you can be
> > > >assured that all files needed for a complete recover
reason why I dislike the idea of a database to
> store
> > > the
> > > recovery catalog. Granted, the catalog needs to stored somewhere
> and
> > > it
> > > happens to be in (surprise! surprise!!) an Oracle database; but
> it's
> > > more
why I dislike the idea of a database to store
> > > the
> > > recovery catalog. Granted, the catalog needs to stored somewhere and
> > > it
> > > happens to be in (surprise! surprise!!) an Oracle database; but it's
> > > more
> > > akin to
t; > have been
> > plain and simple like a text file. A sql based interface would not
> > have been
> > possible; but then again is it there, really? The RMAN scripts could
> > have
> > been adapted to query and manipulate the ascii text file. Just my
> >
-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:Re: RE : RMAN Repository
Huh!!!
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
]
> Cc: Jesse, Rich; [EMAIL PROTECTED]
> Subject: 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
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: [EM
>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
ut 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
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,
ent by: [EMAIL PROTECTED]
01/09/2003 08:45 AM
Please respond to ORACLE-L
To: Multiple recipients 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
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
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 repository but
anticipate just using control files
after we upgrade to 9i with its enhanced RMAN features. I have a
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
up 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
08:45 AM
Please respond to ORACLE-L
To: Multiple recipients 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
cc:
Subject: RE : 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
essage-
> > 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.
> >
&g
d/Tech International, 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 repos
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
> Jared
>
>
>
>
>
>
> "Ruth Gramolini" <[EMAIL PROTECTED]>
> 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:
>
ase 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/Demons
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 of the databases you are using the "real" recovery catalog for.
Then
you
i" <[EMAIL PROTECTED]>
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
ande, 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
>
>
;
>
>
>"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 :
mazon.com!
-Original Message-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
IL 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 controlfiles.
trol files
> > >are lost, and the only recovery data is stored in the control file?
> > >
> > >This doesn't sound very reasonable.
> > >
> > >Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > &g
og for all
production, developement, and test databases that I back up.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 09, 2003 1:44 PM
RE: RE : RMAN Repository>If I need a database to backup a database then
nd how does one go about restoring a database when all control files
> >are lost, and the only recovery data is stored in the control file?
> >
> >This doesn't sound very reasonable.
> >
> >Jared
> >
> >
> >
> >
> >
> >
> >"De
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, St
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
RACLE-L
To: Multiple recipients 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
backu
oesn't 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 P
>
> > This doesn't sound very reasonable.
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > "Deshpande, Kirti" <[EMAIL PROTECTED]>
> > Sent by: [EMAIL PROTECTED]
> > 01/08/2003 11:44 AM
> > Please respond to ORACLE-L
&g
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
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 diff
onable.
>
> 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]>
>
: 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 intricacies of it.
Has anyone else heard the RMAN repository was going away? It appears
much
Behalf 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
file?
> >
> >This doesn't sound very reasonable.
> >
> >Jared
> >
> >
> >
> >
> >
> >
> >"Deshpande, Kirti" <[EMAIL PROTECTED]>
> >Sent by: [EMAIL PROTECTED]
> > 01/08/2003 11:44 AM
> > Please
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 th
3 4:14 PM
>
>
> > And how does one go about restoring a database when all control files
> > are lost, and the only recovery data is stored in the control file?
> >
> > This doesn't sound very reasonable.
> >
> > Jared
> >
> >
> >
&g
tored in the control file?
>
>This doesn't sound very reasonable.
>
>Jared
>
>
>
>
>
>
>"Deshpande, Kirti" <[EMAIL PROTECTED]>
>Sent by: [EMAIL PROTECTED]
> 01/08/2003 11:44 AM
> Please respond to ORACLE-L
>
>
> To:
RACLE-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
t;
> 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]>
>
nt 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
OTECTED]>
> 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 w
: [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 U
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,
Subject: 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).
t
AIL 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 heard (from 2 Oracle University
Professors
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 when 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 recipie
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 allows
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 r
70 matches
Mail list logo
