I always backup the control file separately (using Rman) as my final step
during a database backup.
Actually, by database backup includes (in order)
Database Backup
Archivelog Backup
Control file Backup.
3 Rman steps.
My Archivelog backup only backs the archivelogs - not the control file.
Tom Mercadante
Oracle Certified Professional
-----Original Message-----
Sent: Wednesday, September 18, 2002 11:48 AM
To: Multiple recipients of list ORACLE-L
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
> > >
> > > RMAN>
> > > executing command: SET DBID
> > >
> > > RMAN> 2> 3> 4>
> > > allocated channel: ci
> > > channel ci: sid=10 devtype=DISK
> > >
> > > Starting restore at 17-SEP-02
> > >
> > > channel ci: restoring controlfile
> > > channel ci: restore complete
> > > replicating controlfile
> > > input filename=/extracts1/DB01_temp/ctrl1.ctl
> > > output filename=/extracts1/DB01_temp/ctrl2.ctl
> > > output filename=/extracts1/DB01_temp/ctrl3.ctl
> > > Finished restore at 17-SEP-02
> > > released channel: ci
> > >
> > > RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13>
> 14>
> > > 15>
> > > 16>
> > > allocated channel: c1
> > > channel c1: sid=10 devtype=DISK
> > >
> > > allocated channel: c2
> > > channel c2: sid=11 devtype=DISK
> > >
> > > allocated channel: c3
> > > channel c3: sid=12 devtype=DISK
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > executing command: SET NEWNAME
> > >
> > > Starting restore at 17-SEP-02
> > >
> > > released channel: c1
> > > released channel: c2
> > > released channel: c3
> > > RMAN-00571:
> > >
> >
>
> > > RMAN-00569: =============== ERROR MESSAGE STACK
> > > FOLLOWS ===============
> > > RMAN-00571:
> > >
> >
>
>
=== 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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us
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 - 12:03:27 CDT
