Backup control file with RMAN. 9i makes it easy with
the use of 'configure controlfile autobackup on'. In
8i 'backup current controlfile'
- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM> wrote:
> Johnson - Congratulations on solving your problem
> and thank you for sharing
> the solution with the rest of us that are in the
> same boat. When you say you
> are taking a backup of the control files after the
> regular backup, are you
> backing the control files up with RMAN or with the
> system command?
>
>
> Dennis Williams
> DBA
> Lifetouch, Inc.
> dwilliams_at_lifetouch.com
> <mailto:dwilliams_at_lifetouch.com>
>
>
> -----Original Message-----
> Sent: Wednesday, September 18, 2002 9:13 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Thanks to all who replied. I got a lot of hints from
> all.
>
> The problem I had was because I was not separately
> backuping up the control files. I was relying on the
> control files backup included in the full database
> backups. These control files do not have details
> about
> the current backup. So when that control file is
> restored, since it does not have a details about the
> latest backup to disk(backup to disk was done for
> test
> purpose, this database was beeing backed up to
> tape),
> and since according to it the lastest backup was to
> tape, it was looking for channel to go to tape and
> finding none gave the 'no channel error'.
>
> The remedy is to take backup of control files after
> the backup regular backups (tested works fine). or
> use recovery catalog and use auxliary connection
> (still to test).
>
> In 9i setting autobackup on does a separate backup
> of
> the control file.
>
>
> --- Ruth Gramolini <rgramolini_at_tax.state.vt.us>
> wrote:
> > Do you have your backup restored to the box you
> are
> > trying to restore from?
> > I
> > Have you build a database to hold the restored
> data?
> > If so, are all of the tablespaces and datafiles
> the
> > same name on the box you
> > are restoring to?
> > We need more information to help you further.
> >
> > Regards,
> > Ruth
> >
> >
> > ----- Original Message -----
> > To: "Multiple recipients of list ORACLE-L"
> > <ORACLE-L_at_fatcity.com>
> > Sent: Tuesday, September 17, 2002 11:18 AM
> >
> >
> > They are alluding it to a possibilty that RMAN
> > cannot
> > find the backup piece and just before showing the
> > error it realeasing channels and that releasing
> > channels per se does not point to any problem.
> >
> > --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> wrote:
> > > Johnson - Did Oracle Support offer any theories
> on
> > > why the RMAN channels
> > > were being spontaneously released? Is Oracle
> > Support
> > > looking into this as a
> > > possible bug, and you are just checking to see
> > > whether anyone else has
> > > experienced this behavior?
> > >
> > > Dennis Williams
> > > DBA
> > > Lifetouch, Inc.
> > > dwilliams_at_lifetouch.com
> > > <mailto:dwilliams_at_lifetouch.com>
> > >
> > >
> > > -----Original Message-----
> > > From: Johnson Poovathummoottil
> > > [mailto:joni_65_at_yahoo.com]
> > > Sent: Tuesday, September 17, 2002 9:02 AM
> > > To: DENNIS WILLIAMS; 'ORACLE-L_at_fatcity.com'
> > > Cc: 'joni_65_at_yahoo.com'
> > > Subject: RE: RMAN restore to another node
> > >
> > >
> > > Oracle support too pointed to that. I tested
> with
> > > allocating 3 more channnels after 'set newname'.
> > But
> > > no change. They were released. and same error
> > > followed.
> > >
> > > --- DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
> > wrote:
> > > > Johnson
> > > > From what I read of your trace file, the
> > > channels
> > > > are being released,
> > > > presumably just before you need them. Do you
> > have
> > > > that explicitly coded in
> > > > your RMAN recovery script, or are they being
> > > > released for another reason. My
> > > > immediate response is that maybe the problem
> > lies
> > > in
> > > > why those channels are
> > > > being released. Can you move your channel
> > commands
> > > > after the SET NEWNAME
> > > > commands?
> > > >
> > > > Dennis Williams
> > > > DBA
> > > > Lifetouch, Inc.
> > > > dwilliams_at_lifetouch.com
> > > > <mailto:dwilliams_at_lifetouch.com>
> > > >
> > > >
> > > > -----Original Message-----
> > > > From: Johnson Poovathummoottil
> > > > [mailto:joni_65_at_yahoo.com]
> > > > Sent: Tuesday, September 17, 2002 9:23 AM
> > > > To: Multiple recipients of list ORACLE-L
> > > > Subject: RMAN restore to another node
> > > >
> > > >
> > > > Hi all,
> > > >
> > > > I am stuck on this restore for two days and
> > Oracle
> > > > support seems to offering little help.
> > > >
> > > > I seem to be doing everything according to
> > manuals
> > > > and
> > > > metalink notes but am not able to do the
> > restore.
> > > >
> > > > The case is I am restoring a database to
> another
> > > > node.
> > > > I have successfully restore the control file
> but
> > > > when
> > > > I tried to restore the database I get
> > > > RMAN-06100: no channel to restore a backup or
> > copy
> > > > of
> > > > datafile 1
> > > > for every datafile.
> > > >
> > > > I am inserting the RMAN trace . I would
> > appreciate
> > > > if
> > > > someone can lead in the right direction.
> > > > Recovery Manager: Release 9.2.0.1.0 -
> Production
> > > >
> > > > Copyright (c) 1995, 2002, Oracle Corporation.
> > All
> > > > rights reserved.
> > > >
> > > > ORACLE_HOME = /opt/Apps/oracle/product/9.2.0
> > > > System name: SunOS
> > > > Node name: EdwDev
> > > > Release: 5.8
> > > > Version: Generic_108528-15
> > > > Machine: sun4u
> > > >
> > > > Starting with debugging turned off
> > > >
> > > > connected to target database: DB01 (not
> mounted)
> > > > using target database controlfile instead of
> > > > recovery
> > > > catalog
> > > >
>
=== message truncated ===
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnson Poovathummoottil
INET: joni_65_at_yahoo.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Wed Sep 18 2002 - 14:35:07 CDT