Path: news.netfront.net!news.glorb.com!postnews.google.com!u10g2000prn.googlegroups.com!not-for-mail
From: Carlos <miotromailcarlos@netscape.net>
Newsgroups: comp.databases.oracle.server
Subject: Re: DBID for RMAN backup with format '%u'
Date: Mon, 11 Feb 2008 02:28:16 -0800 (PST)
Organization: http://groups.google.com
Lines: 61
Message-ID: <be8145ba-cae4-4c3c-b91e-b8226787c7a9@u10g2000prn.googlegroups.com>
References: <036a357e-cd02-4418-ba69-d840f1c4c751@s19g2000prg.googlegroups.com> 
 <ebeae71e-40de-4cec-a84d-deac1cdfb09b@j20g2000hsi.googlegroups.com> 
 <ad3d5c29-3026-48ea-ac87-d92d66d3ee11@v17g2000hsa.googlegroups.com>
NNTP-Posting-Host: 83.38.169.94
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1202725696 8093 127.0.0.1 (11 Feb 2008 10:28:16 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 11 Feb 2008 10:28:16 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: u10g2000prn.googlegroups.com; posting-host=83.38.169.94; 
 posting-account=iCiu-AkAAAB7JZqNr9faYSQGgABIw6VI
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.2; es-ES; rv:1.8.1.12) 
 Gecko/20080201 Firefox/2.0.0.12,gzip(gfe),gzip(gfe)
Xref: news.netfront.net comp.databases.oracle.server:182321

On 11 feb, 11:19, sybrandb <sybra...@gmail.com> wrote:
> On Feb 10, 7:42 pm, Carlos <miotromailcar...@netscape.net> wrote:
>
>
>
> > On 10 feb, 19:38, Carlos <miotromailcar...@netscape.net> wrote:
>
> > > Hi all:
>
> > > I've been given two backups from an Oracle Database: one 'cold' and
> > > one 'hot'. They both come from a lost server.
>
> > > The fact is that they have been made with the format '%u' (eight
> > > alphanumerics) and I must recover the database on a new server. I
> > > cannot get the DBID from the backup files name because of this format
> > > '%u'.
>
> > > How can I get the DBID to recover the DB on a new server?
>
> > > Thanks in advance.
>
> > > Cheers.
>
> > > Carlos.
>
> > I forgot:
>
> > This is Oracle 10.2.0.3 on Enterprise Linux  5.
>
> > The backups have been made with AUTOBACKUP ON (or so I'm told).
>
> > TIA.
>
> > Cheers.
>
> > Carlos.- Hide quoted text -
>
> > - Show quoted text -
>
> In that case there is a separate backup of the controlfile. It always
> has the DBID in it's name. c-<dbid>-<yyyyymmdd>-<piece>
> Please find it.
>
> --
> Sybrand Bakker
> Senior Oracle DBA

Thanks Sybrand, I knew that, but the only files I've been given are
the ones I reported (As I said, the original server is gone).

Anyway, RMAN includes the current controlfile and spfile in backup set
when the datafile 1 is included in the backup (which is the case).

Is there any way to get the DBID to restore the backups onto another
server?

TIA.

Cheers.

Carlos.