subject:"RE\: RMAN restore to another node"

RE: RMAN restore to another node

2002-09-18 Thread Johnson Poovathummoottil


Backup control file with RMAN. 9i makes it easy with
the use of 'configure controlfile autobackup on'. In
8i 'backup current controlfile'


--- DENNIS WILLIAMS <[EMAIL PROTECTED]> 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.
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> 
> 
> 
> -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 <[EMAIL PROTECTED]>
> 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"
> > <[EMAIL PROTECTED]>
> > 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 <[EMAIL PROTECTED]>
> 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.
> > > [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> > > -Original Message-
> > > From: Johnson Poovathummoottil
> > > [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, September 17, 2002 9:02 AM
> > > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> > > Cc: '[EMAIL PROTECTED]'
> > > 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 <[EMAIL PROTECTED]>
> > 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
> > > > Lif

RE: RMAN restore to another node

2002-09-18 Thread Mercadante, Thomas F

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.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

-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 <[EMAIL PROTECTED]> 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"
> <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > -----Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 9:02 AM
> > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > 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 <[EMAIL PROTECTED]>
> 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.
> > > [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> > > -Original Message-
> > > From: Johnson Poovathummoottil
> > > [mailto:[EMAIL PROTECTED]]
> > > Sent: Tuesday, September 17, 2002 9:23 AM
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: RMAN restore to another node
> > >
> > >
> > &

RE: RMAN restore to another node

2002-09-18 Thread DENNIS WILLIAMS


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.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 


-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 <[EMAIL PROTECTED]> 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"
> <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > -----Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 9:02 AM
> > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > 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 <[EMAIL PROTECTED]>
> 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.
> > > [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> > > -Original Message-
> > > From: Johnson Poovathummoottil
> > > [mailto:[EMAIL PROTECTED]]
> > > 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 successfu

Re: RMAN restore to another node

2002-09-18 Thread Johnson Poovathummoottil


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 <[EMAIL PROTECTED]> 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"
> <[EMAIL PROTECTED]>
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > -Original Message-----
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 9:02 AM
> > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > 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 <[EMAIL PROTECTED]>
> 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.
> > > [EMAIL PROTECTED]
> > > <mailto:[EMAIL PROTECTED]>
> > >
> > >
> > > -Original Message-
> > > From: Johnson Poovathummoottil
> > > [mailto:[EMAIL PROTECTED]]
> > > 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
> > >
>

Re: RMAN restore to another node

2002-09-17 Thread Ruth Gramolini


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" <[EMAIL PROTECTED]>
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 <[EMAIL PROTECTED]> 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.
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]>
>
>
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 9:02 AM
> To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > 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
> >

RE: RMAN restore to another node

2002-09-17 Thread Mercadante, Thomas F


OK.  I'll ask.   

Where is the backup piece?  Is it in a same named directory as in the other
machine?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 12:48 PM
To: Multiple recipients of list ORACLE-L


I am restoring the whole database. 

regarding RMAN-06026   I think  RMAN is not able to
find where my backup piece is. For the controlfile I
could specify 'restore from' whereas that is not
allowed for database or datfiles.

--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> My other question is, why are you getting this
> error:
> 
> > RMAN-06026: some targets not found - aborting
> restore
> 
> 
> Are you trying to restore all of the files, are just
> some of them?
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 10:20 AM
> To: Mercadante, Thomas F; '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: RMAN restore to another node
> 
> 
> my RMAN script is the following I have not released
> any channels explicitly.
> 
> run
> {
> allocate channel c1 type disk;
> allocate channel c2 type disk;
> allocate channel c3 type disk;
> set newname for datafile 1 to 
> '/extracts1/DB01_temp/system_01a.dbf';
> set newname for datafile 2 to 
> '/extracts1/DB01_temp/rbslrg01.dbf';
> set newname for datafile 3 to 
> '/extracts1/DB01_temp/tools01.dbf';
> set newname for datafile 4 to 
> '/extracts1/DB01_temp/temp01.dbf';
> set newname for datafile 5 to 
> '/extracts1/DB01_temp/usersdata01.dbf';
> set newname for datafile 6 to 
> '/extracts1/DB01_temp/usersidx01.dbf';
> set newname for datafile 7 to 
> '/extracts1/DB01_temp/oem_repository.dbf';
> set newname for datafile 8 to 
> '/extracts1/DB01_temp/users01.dbf';
> restore database ;
> switch datafile all;
> }
> 
> I tried allocating 3 additional channels just before
> 'restore database;' but they too were released along
> with the original 3 and the same error followed.
> 
> 
> --- "Mercadante, Thomas F"
> <[EMAIL PROTECTED]>
> wrote:
> > Joni,
> > 
> > It looks like you are releasing the channels
> before
> > you are finished with
> > them.
> > 
> > Can you add another ALLOCATE CHANNEL command
> before
> > you attempt the RESTORE
> > command?
> > 
> > You did not provide the rman commands, so I am
> only
> > guessing here - but that
> > is what the error is telling you.  You do not have
> > any channel's available
> > for Rman to use.
> > 
> > Good Luck.
> > 
> > Tom Mercadante
> > Oracle Certified Professional
> > 
> > 
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 10: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 restor

RE: RMAN restore to another node

2002-09-17 Thread Mike Killough


You are allocating an auxilliary channel?

connect catalog rman/manager@rcat
connect target system/manager@db1
connect auxiliary "system/manager as sysdba"

run {
set until time '17-SEP-2002 08:30:39';
allocate auxiliary channel disk1 type disk;

set newname for datafile 1 to '/ot2_01/oradata/db1/system01.dbf';
set newname for datafile 2 to '/ot2_01/oradata/db1/undotbs01.dbf';
set newname for datafile 3 to '/ot2_01/oradata/db1/drsys01.dbf';
...
set newname for datafile 70 to '/ot2_01/oradata/db1/users01.dbf';
duplicate target database to db2
logfile '/ot2_01/oradata/db2/redo01.log' size 100M,
'/ot2_01/oradata/db2/redo02.log' size 100M,
'/ot2_01/oradata/db2/redo03.log' size 100M;
}





>From: Johnson Poovathummoottil <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: RMAN restore to another node
>Date: Tue, 17 Sep 2002 07:43:28 -0800
>
>I tried that too. But did it not help. here is the
>ouput.
>
>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
>
>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
>
>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:
>===
>RMAN-03002: failure of restore command at 09/17/2002
>10:29:13
>RMAN-06026: some targets not found - aborting restore
>RMAN-06100: no channel to restore a backup or copy of
>datafile 8
>RMAN-06100: no channel to restore a backup or copy of
>datafile 7
>RMAN-06100: no channel to restore a backup or copy of
>datafile 6
>RMAN-06100: no channel to restore a backup or copy of
>datafile 5
>RMAN-06100: no channel to restore a backup or copy of
>datafile 4
>RMAN-06100: no channel to restore a backup or copy of
>datafile 3
>RMAN-06100: no channel to restore a backup or copy of
>datafile 2
>RMAN-06100: no channel to restore a backup or copy of
>datafile 1
>
>
>--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > Johnson
> >Their explanation doesn't make sense to me. I
> > have had RMAN fail to get
> > the backup piece, and the error message is very
> > clear.
> >Just in case the SET NEWNAME is somehow affecting
> > the recovery, you might
> > take them out just to see what happens. I would also
> > have moved the ALLOCATE
> > CHANNEL below the SET NEWNAME, rather than opening a
> > new set of channels,
> > but then I haven't used SET NEWNAME. I just had my
> > Unix sys admin create
> > mount points named the same as the mount points on
> > the production system.
> >Perhaps someone can post an RMAN recovery script
> > that includes a SET
> > NEWNAME, so you can compare. You might also post
> > your recovery script, that
> > might clarify something.
> >Also, this is Oracle 9.2, and most of my RMAN
> > practice has been on Oracle
> > 8.1.6.
> >Another thought for a test is to backup the
> > production control file
> > separately and then place it where it is needed,
> > rather than have RMAN
> > recover it. I'm just wondering whether you are
> > getting some side-effect from
> > the successful control file recovery.
> >  
> > Dennis Williams
> > DBA
> > Lifetouch, Inc.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]>
> >
> >
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 9:16 AM
> > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> > Subject: RE: RMAN restore to another node
> >
> >
> > 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 <[EMAIL PROTECTED]> wrote:
> > > Johnson - Did Oracle Support offer any theories on
> > > why the RMAN channel

RE: RMAN restore to another node

2002-09-17 Thread DENNIS WILLIAMS

Johnson
   Their explanation doesn't make sense to me. I have had RMAN fail to get
the backup piece, and the error message is very clear.
   Just in case the SET NEWNAME is somehow affecting the recovery, you might
take them out just to see what happens. I would also have moved the ALLOCATE
CHANNEL below the SET NEWNAME, rather than opening a new set of channels,
but then I haven't used SET NEWNAME. I just had my Unix sys admin create
mount points named the same as the mount points on the production system. 
   Perhaps someone can post an RMAN recovery script that includes a SET
NEWNAME, so you can compare. You might also post your recovery script, that
might clarify something.
   Also, this is Oracle 9.2, and most of my RMAN practice has been on Oracle
8.1.6.
   Another thought for a test is to backup the production control file
separately and then place it where it is needed, rather than have RMAN
recover it. I'm just wondering whether you are getting some side-effect from
the successful control file recovery. 

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> 

-Original Message-
Sent: Tuesday, September 17, 2002 9:16 AM
To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'

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 <[EMAIL PROTECTED]> 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.
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> 
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 9:02 AM
> To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]> 
> > 
> > 
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > 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
> > chann

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil


my RMAN script is the following I have not released
any channels explicitly.

run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
set newname for datafile 1 to 
'/extracts1/DB01_temp/system_01a.dbf';
set newname for datafile 2 to 
'/extracts1/DB01_temp/rbslrg01.dbf';
set newname for datafile 3 to 
'/extracts1/DB01_temp/tools01.dbf';
set newname for datafile 4 to 
'/extracts1/DB01_temp/temp01.dbf';
set newname for datafile 5 to 
'/extracts1/DB01_temp/usersdata01.dbf';
set newname for datafile 6 to 
'/extracts1/DB01_temp/usersidx01.dbf';
set newname for datafile 7 to 
'/extracts1/DB01_temp/oem_repository.dbf';
set newname for datafile 8 to 
'/extracts1/DB01_temp/users01.dbf';
restore database ;
switch datafile all;
}

I tried allocating 3 additional channels just before
'restore database;' but they too were released along
with the original 3 and the same error followed.


--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> Joni,
> 
> It looks like you are releasing the channels before
> you are finished with
> them.
> 
> Can you add another ALLOCATE CHANNEL command before
> you attempt the RESTORE
> command?
> 
> You did not provide the rman commands, so I am only
> guessing here - but that
> is what the error is telling you.  You do not have
> any channel's available
> for Rman to use.
> 
> Good Luck.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 10: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:
>
===
> RMAN-03002: failure of restore command at 09/17/2002
> 08:27:16
> RMAN-06026: some targets not found - aborting
> restore
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 8
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 7
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 6
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 5
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 4
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 3
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 2
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 1
> 
> 
> 
> 
> 
> __
> 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: [EMAIL PROTECT

RE: RMAN restore to another node

2002-09-17 Thread Mercadante, Thomas F


Joni,

It looks like you are releasing the channels before you are finished with
them.

Can you add another ALLOCATE CHANNEL command before you attempt the RESTORE
command?

You did not provide the rman commands, so I am only guessing here - but that
is what the error is telling you.  You do not have any channel's available
for Rman to use.

Good Luck.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 10:23 AM
To: Multiple recipients of list ORACLE-L


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:
===
RMAN-03002: failure of restore command at 09/17/2002
08:27:16
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1





__
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: RMAN restore to another node

2002-09-17 Thread Deborah Lorraine


Testing a duplicate of 9.2.0.1.0, I had that problem of channels releasing 
and then getting an error about no channel, and it turned out I needed a 
new MML library for 9i.

Now I have a problem that I can't restore the database unless I first 
delete all old datafiles.  This behavior is different than old versions, 
and in my opinion, a bug.

Have others encountered this issue?

Debi


At 07:13 AM 9/17/2002 -0800, you 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.
>[EMAIL PROTECTED] 
>
>
>-Original Message-
>Sent: Tuesday, September 17, 2002 9:02 AM
>To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
>Cc: '[EMAIL PROTECTED]'
>
>
>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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > 
> >
> >
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > 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:
> >
>===
> > RMAN-03002: failure of restore command at 09/17/2002
> > 08:27:16
> > RMAN-06026: some targets not found - aborting
> > restore
> > RMAN-06100: no channel to restore a backup or copy
> > of
> > datafile 8
> > RMAN-06100: no channel to restore a backup or copy
> > of
> > datafile 7
> > RMAN-06100: no channel to restore a backup or copy
> > of
> > datafile 6
> > RMAN-06100: no channel to restore a backup or copy
> > of
> > datafile 5
> > RMAN-06100: no channel to restore a backup or copy
> > of
> > datafile 4
> > RMAN-06100: no c

RE: RMAN restore to another node

2002-09-17 Thread Mercadante, Thomas F


My other question is, why are you getting this error:

> RMAN-06026: some targets not found - aborting restore


Are you trying to restore all of the files, are just some of them?

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Tuesday, September 17, 2002 10:20 AM
To: Mercadante, Thomas F; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


my RMAN script is the following I have not released
any channels explicitly.

run
{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
set newname for datafile 1 to 
'/extracts1/DB01_temp/system_01a.dbf';
set newname for datafile 2 to 
'/extracts1/DB01_temp/rbslrg01.dbf';
set newname for datafile 3 to 
'/extracts1/DB01_temp/tools01.dbf';
set newname for datafile 4 to 
'/extracts1/DB01_temp/temp01.dbf';
set newname for datafile 5 to 
'/extracts1/DB01_temp/usersdata01.dbf';
set newname for datafile 6 to 
'/extracts1/DB01_temp/usersidx01.dbf';
set newname for datafile 7 to 
'/extracts1/DB01_temp/oem_repository.dbf';
set newname for datafile 8 to 
'/extracts1/DB01_temp/users01.dbf';
restore database ;
switch datafile all;
}

I tried allocating 3 additional channels just before
'restore database;' but they too were released along
with the original 3 and the same error followed.


--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> Joni,
> 
> It looks like you are releasing the channels before
> you are finished with
> them.
> 
> Can you add another ALLOCATE CHANNEL command before
> you attempt the RESTORE
> command?
> 
> You did not provide the rman commands, so I am only
> guessing here - but that
> is what the error is telling you.  You do not have
> any channel's available
> for Rman to use.
> 
> Good Luck.
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 10: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:
>
===
> RMAN-03002: failure of restore command at 09/17/2002
> 08:27:16
> RMAN-06026: some targets not found - aborting
> restore
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 8
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 7
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 6
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 5
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 4
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 3
> RMAN-06100: no channel to restore a backup or co

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil


I am restoring the whole database. 

regarding RMAN-06026   I think  RMAN is not able to
find where my backup piece is. For the controlfile I
could specify 'restore from' whereas that is not
allowed for database or datfiles.

--- "Mercadante, Thomas F" <[EMAIL PROTECTED]>
wrote:
> My other question is, why are you getting this
> error:
> 
> > RMAN-06026: some targets not found - aborting
> restore
> 
> 
> Are you trying to restore all of the files, are just
> some of them?
> 
> Tom Mercadante
> Oracle Certified Professional
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 10:20 AM
> To: Mercadante, Thomas F; '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> Subject: RE: RMAN restore to another node
> 
> 
> my RMAN script is the following I have not released
> any channels explicitly.
> 
> run
> {
> allocate channel c1 type disk;
> allocate channel c2 type disk;
> allocate channel c3 type disk;
> set newname for datafile 1 to 
> '/extracts1/DB01_temp/system_01a.dbf';
> set newname for datafile 2 to 
> '/extracts1/DB01_temp/rbslrg01.dbf';
> set newname for datafile 3 to 
> '/extracts1/DB01_temp/tools01.dbf';
> set newname for datafile 4 to 
> '/extracts1/DB01_temp/temp01.dbf';
> set newname for datafile 5 to 
> '/extracts1/DB01_temp/usersdata01.dbf';
> set newname for datafile 6 to 
> '/extracts1/DB01_temp/usersidx01.dbf';
> set newname for datafile 7 to 
> '/extracts1/DB01_temp/oem_repository.dbf';
> set newname for datafile 8 to 
> '/extracts1/DB01_temp/users01.dbf';
> restore database ;
> switch datafile all;
> }
> 
> I tried allocating 3 additional channels just before
> 'restore database;' but they too were released along
> with the original 3 and the same error followed.
> 
> 
> --- "Mercadante, Thomas F"
> <[EMAIL PROTECTED]>
> wrote:
> > Joni,
> > 
> > It looks like you are releasing the channels
> before
> > you are finished with
> > them.
> > 
> > Can you add another ALLOCATE CHANNEL command
> before
> > you attempt the RESTORE
> > command?
> > 
> > You did not provide the rman commands, so I am
> only
> > guessing here - but that
> > is what the error is telling you.  You do not have
> > any channel's available
> > for Rman to use.
> > 
> > Good Luck.
> > 
> > Tom Mercadante
> > Oracle Certified Professional
> > 
> > 
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 10: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 fil

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil


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 <[EMAIL PROTECTED]> 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.
> [EMAIL PROTECTED]
>  
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> 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:
>
===
> RMAN-03002: failure of restore command at 09/17/2002
> 08:27:16
> RMAN-06026: some targets not found - aborting
> restore
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 8
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 7
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 6
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 5
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 4
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 3
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 2
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 1
> 
> 
> 
> 
> 
> __
> 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: [EMAIL PROTECTED]
> 
> 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: [EMAIL PROTECTED] (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).


__
Do you Yahoo!?
Yahoo! News - Today's headlines
http://news.yahoo.com
-- 
Please se

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil


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 <[EMAIL PROTECTED]> 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.
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> 
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 9:02 AM
> To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> Cc: '[EMAIL PROTECTED]'
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]> 
> > 
> > 
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > 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
>

RE: RMAN restore to another node

2002-09-17 Thread Johnson Poovathummoottil


I tried that too. But did it not help. here is the
ouput.

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

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

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:
===
RMAN-03002: failure of restore command at 09/17/2002
10:29:13
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1


--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> Johnson
>Their explanation doesn't make sense to me. I
> have had RMAN fail to get
> the backup piece, and the error message is very
> clear.
>Just in case the SET NEWNAME is somehow affecting
> the recovery, you might
> take them out just to see what happens. I would also
> have moved the ALLOCATE
> CHANNEL below the SET NEWNAME, rather than opening a
> new set of channels,
> but then I haven't used SET NEWNAME. I just had my
> Unix sys admin create
> mount points named the same as the mount points on
> the production system. 
>Perhaps someone can post an RMAN recovery script
> that includes a SET
> NEWNAME, so you can compare. You might also post
> your recovery script, that
> might clarify something.
>Also, this is Oracle 9.2, and most of my RMAN
> practice has been on Oracle
> 8.1.6.
>Another thought for a test is to backup the
> production control file
> separately and then place it where it is needed,
> rather than have RMAN
> recover it. I'm just wondering whether you are
> getting some side-effect from
> the successful control file recovery. 
>  
> Dennis Williams
> DBA
> Lifetouch, Inc.
> [EMAIL PROTECTED]
> <mailto:[EMAIL PROTECTED]> 
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, September 17, 2002 9:16 AM
> To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> Subject: RE: RMAN restore to another node
> 
> 
> 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 <[EMAIL PROTECTED]> 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.
> > [EMAIL PROTECTED]
> > <mailto:[EMAIL PROTECTED]> 
> > 
> > 
> > -Original Message-
> > From: Johnson Poovathummoottil
> > [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, September 17, 2002 9:02 AM
> > To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
> > Cc: '[EMAIL PROTECTED]'
> > 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 <[EMAIL PROTECTED]>
> 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.

RE: RMAN restore to another node

2002-09-17 Thread DENNIS WILLIAMS


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.
[EMAIL PROTECTED]  


-Original Message-
Sent: Tuesday, September 17, 2002 9:02 AM
To: DENNIS WILLIAMS; '[EMAIL PROTECTED]'
Cc: '[EMAIL PROTECTED]'


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 <[EMAIL PROTECTED]> 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.
> [EMAIL PROTECTED]
>  
> 
> 
> -Original Message-
> From: Johnson Poovathummoottil
> [mailto:[EMAIL PROTECTED]]
> 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:
>
===
> RMAN-03002: failure of restore command at 09/17/2002
> 08:27:16
> RMAN-06026: some targets not found - aborting
> restore
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 8
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 7
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 6
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 5
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 4
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 3
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 2
> RMAN-06100: no channel to restore a backup or copy
> of
> datafile 1
> 
> 
> 
> 
> 
> __
> 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: [EMAIL PROTECTED]
> 
> Fat City Network Services-- 858-538-5051
> http://www.fatcity.com
> San Diego, California-- Mailing list and web
> hosting services
>
-
> To REMOVE yo

RE: RMAN restore to another node

2002-09-17 Thread DENNIS WILLIAMS


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.
[EMAIL PROTECTED]  


-Original Message-
Sent: Tuesday, September 17, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L


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:
===
RMAN-03002: failure of restore command at 09/17/2002
08:27:16
RMAN-06026: some targets not found - aborting restore
RMAN-06100: no channel to restore a backup or copy of
datafile 8
RMAN-06100: no channel to restore a backup or copy of
datafile 7
RMAN-06100: no channel to restore a backup or copy of
datafile 6
RMAN-06100: no channel to restore a backup or copy of
datafile 5
RMAN-06100: no channel to restore a backup or copy of
datafile 4
RMAN-06100: no channel to restore a backup or copy of
datafile 3
RMAN-06100: no channel to restore a backup or copy of
datafile 2
RMAN-06100: no channel to restore a backup or copy of
datafile 1





__
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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]

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: [EMAIL PROTECTED] (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).

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

Re: RMAN restore to another node

Re: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

RE: RMAN restore to another node

18 matches

Site Navigation

Mail list logo

Footer information