Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with 9.0.1.3 RMAN CONFIGURE Command

Re: Problem with 9.0.1.3 RMAN CONFIGURE Command

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 30 Apr 2002 04:48:36 +1000
Message-ID: <aak4ko$k0v$1@lust.ihug.co.nz>


Yeah, on second thoughts, you get a "partial resynch" after a backup. I would have expected it to pick up something as important as a configuration change, though. Let me have a play with it and I'll see if there's anything I can come up with.

Regards
HJR "Klaus Naumann" <knaumann_at_gmx-ag.de> wrote in message news:HG8z8.1$8w.77_at_news.ecrc.de...
> On Sat, 27 Apr 2002 19:06:35 +0200, Howard J. Rogers wrote:
>
> Hi Howard,
>
> > There is a resync done *after* every backup.
>
> That doesn't really matter as I've checked
> the settings after the Backup was done.
>
>
> > What makes you say that a backup doesn't resynch "correctly"?
>
> Well, you were stating that a resync would occour after
> every backup and that the changed configuration value
> would only appear after a resync.
> But it doesn't appear after the resync which was
> done bye the backup.
> When I did a manual resync, I was able to see
> the change. That's the whole problem. The auto-resync
> which is initiated by a backup (or similar) is not
> the same as a manual resync.
>
> Thanks, Klaus
>
>
> >
> > Regards
> > HJR
> >
> >
> > "Klaus Naumann" <spock_at_mgnet.de> wrote in message
> > news:s66eaa.5k3.ln_at_192.168.1.1...
> >> On Fri, 26 Apr 2002 23:54:14 +0200, Howard J. Rogers wrote:
> >>
> >> Hello Howard,
> >>
> >> > You're running with a recovery catalog. The command you issued gets
> >> > stored in the controlfile of the target database. When you resync the
> >> > catalog, you should see the new setting picked up (and remember that
> >> > a resync occurs everytime you perform a backup, copy or a
> >> > restore/recovery).
> >>
> >> this seems to be the problem. I now did a manual resync (resync
> >> catalog;) and the changed value was accepted. But the DB did a backup
> >> this night. So doing a backup doesn't resync the catalog correctly, it
> >> seems. Might this be a bug ?
> >>
> >> Thanks for the help of course !
> >>
> >> Thanks in advance, Klaus
> >>
> >>
> >>
> >> > Were you running without a catalog, the command would be picked up
> >> > immediately.
> >> >
> >> > Regards
> >> > HJR
> >> >
> >> >
> >> > "Klaus Naumann" <knaumann_at_gmx-ag.de> wrote in message
> >> > news:3P8y8.7$Wz1.5985_at_news.ecrc.de...
> >> >> Hi all,
> >> >>
> >> >> I'm seeing some trouble with RMAN on a 9.0.1.3 DB on a SUN E250
> >> >> (Solaris 2.6). I'll explain it by example:
> >> >>
> >> >> First, connect to catalog and to database:
> >> >>
> >> >> rman target / catalog rman9/***********@rcvcat
> >> >>
> >> >> This works fine:
> >> >>
> >> >> Recovery Manager: Release 9.0.1.3.0 - Production
> >> >>
> >> >> (c) Copyright 2001 Oracle Corporation. All rights reserved.
> >> >>
> >> >> connected to target database: EDB01 (DBID=2336558208) connected to
> >> >> recovery catalog database
> >> >>
> >> >> RMAN>
> >> >>
> >> >> Let's look at the stored parameters:
> >> >>
> >> >> RMAN> show all;
> >> >>
> >> >> RMAN configuration parameters are:
> >> >> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 21 DAYS;
> >> >>
> >> >> and so on ....
> >> >>
> >> >> Now I want to change a stored parameter:
> >> >>
> >> >> RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS;
> >> >>
> >> >> old RMAN configuration parameters:
> >> >> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 21 DAYS; new RMAN
> >> >> configuration parameters:
> >> >> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 14 DAYS; new RMAN
> >> >> configuration parameters are successfully stored
> >> >>
> >> >> ok, looks good also. But now we're at the problem point. Looking at
> >> >> the parameters again, I can see that it's _not_ changed:
> >> >>
> >> >> RMAN> show all;
> >> >>
> >> >> RMAN configuration parameters are:
> >> >> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 21 DAYS;
> >> >>
> >> >> Am I missing something or is this a bug ?
> >> >>
> >> >> Thanks, Klaus
> >> >>
> >> >> --
> >> >> Klaus Naumann
> >> >> Database Administration
> >> >> GMX Aktiengesellschaft
> >> >> Riesstrasse 17, 80992 München
> >> >> Telefon +49.89.143 39-0
> >> >> Telefax +49.89.143 39-100
> >> >> mailto:knaumann_at_gmx-ag.de
> >> >> http://www.gmx.net/
> >>
> >> --
> >> Full Name : Klaus Naumann | (http://www.mgnet.de/) (Germany)
> >> Nickname : Spock | Org.: Mad Guys Network Phone / FAX :
> >> ++49/177/7862964 | E-Mail: (spock_at_mgnet.de) PGP Key :
> >> www.mgnet.de/keys/key_spock.txt
>
> --
> Klaus Naumann
> Database Administration
> GMX Aktiengesellschaft
> Riesstrasse 17, 80992 München
> Telefon +49.89.143 39-0
> Telefax +49.89.143 39-100
> mailto:knaumann_at_gmx-ag.de
> http://www.gmx.net/
Received on Mon Apr 29 2002 - 13:48:36 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US