Re: Restore

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 30 Jul 2008 17:06:58 +0200
Message-ID: <4890838f$0$49891$e4fe514c@news.xs4all.nl>

"madunix" <madunix_at_gmail.com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162_at_e39g2000hsf.googlegroups.com... I think it has to do with the following
Cross-Platform Transportable Database: RMAN CONVERT DATABASE h**p://download-uk.oracle.com/docs/cd/B19306_01/backup.102/b14191/ dbxptrn002.htm

fitzjarrell_at_cox.net wrote:
> On Jul 29, 11:11?pm, madunix <madu..._at_gmail.com> wrote:
> > On Jul 29, 8:25?pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
> >
> >
> >
> >
> >
> > > On Jul 29, 1:04?pm, madunix <madu..._at_gmail.com> wrote:
> >
> > > > Am trying to do restore of control file on Linux Machine 64Bit
> > > > CenTOS5.2, i get the following
> >
> > > > RMAN> restore controlfile;
> >
> > > > Starting restore at 29-07-2008
> > > > using channel ORA_DISK_1
> >
> > > > channel ORA_DISK_1: starting datafile backupset restore
> > > > channel ORA_DISK_1: restoring control file
> > > > channel ORA_DISK_1: reading from backup piece /u01/oracle/product/
> > > > 10.2.0/db/dbs/c-2142365377-20080729-01
> > > > ORA-19870: error reading backup piece /u01/oracle/product/10.2.0/db/
> > > > dbs/c-2142365377-20080729-01
> > > > ORA-19505: failed to identify file
> > > > "/u01/oracle/product/10.2.0/db/dbs/
> > > > c-2142365377-20080729-01"
> > > > ORA-27037: unable to obtain file status
> > > > Linux-x86_64 Error: 13: Permission denied
> > > > Additional information: 3
> > > > failover to previous backup
> >
> > > > channel ORA_DISK_1: restoring control file
> > > > ORA-19625: error identifying file /backup_rman/cont_backup/
> > > > ctl_file_t661365316_s2103_p1
> > > > ORA-27047: unable to read the header block of file
> > > > Additional information: 2
> > > > ORA-19600: input file is control file ?(/backup_rman/cont_backup/
> > > > ctl_file_t661365316_s2103_p1)
> > > > ORA-19601: output file is control file ?(/u01/oracle/oradata/
> > > > control0.ctl)
> > > > failover to previous backup
> >
> > > > - The control files has been transfered from AIX5.3 to a Linux
> > > > Machine !!
> > > > - I checked the permissions, they are rw.
> >
> > > > [oracle_at_PowerEdge1 cont_backup]$ ls -al
> > > > total 92272
> > > > drwxrwxrwx 2 oracle dba ? ? 4096 Jul 29 17:05 .
> > > > drwxrwxrwx 4 oracle dba ? ? 4096 Jul 29 17:10 ..
> > > > -rw-rw-rw- 1 oracle dba 17661952 Mar 19 19:14
> > > > ctl_file_t643581595_s1675_p1
> > > > -rw-rw-rw- 1 oracle dba 17661952 Mar 19 19:14
> > > > ctl_file_t648930789_s1833_p1
> > > > -rw-rw-rw- 1 oracle dba 19693568 Jul 29 04:26
> > > > ctl_file_t661285579_s2098_p1
> > > > -rw-rw-rw- 1 oracle dba 19693568 Jul 30 ?2008
> > > > ctl_file_t661357792_s2100_p1
> > > > -rw-rw-rw- 1 oracle dba 19644416 Jul 30 ?2008
> > > > ctl_file_t661365316_s2103_p1
> >
> > > > any help
> >
> > > It appears these files are not in a directory structure matching that
> > > on the original server. ?You'll need to create that same directory
> > > structure then move the files before RMAN can read them.
> >
> > > David Fitzjarrell
> >
> > the y have the same structure
> >
> > Source machine:
> > bash-3.00$ pwd
> > /backup_rman/cont_backup
> > bash-3.00$ ls -al
> > total 222832
> > drwxr-xr-x ? 2 oracle ? dba ? ? ? ? ? ?4096 Jul 29 18:16 .
> > drwxr-xr-x ? 8 root ? ? system ? ? ? ? 4096 Mar 24 08:17 ..
> > -rwxr-xr-x ? 1 oracle ? dba ? ? ? ?17661952 Mar 19 09:14
> > ctl_file_t643581595_s1675_p1
> > -rw-r----- ? 1 oracle ? dba ? ? ? ?17661952 Mar 19 09:14
> > ctl_file_t648930789_s1833_p1
> > -rw-r----- ? 1 oracle ? dba ? ? ? ?19693568 Jul 28 18:26
> > ctl_file_t661285579_s2098_p1
> > -rw-r----- ? 1 oracle ? dba ? ? ? ?19693568 Jul 29 14:29
> > ctl_file_t661357792_s2100_p1
> > -rw-r----- ? 1 oracle ? dba ? ? ? ?19644416 Jul 29 16:35
> > ctl_file_t661365316_s2103_p1
> > -rw-r----- ? 1 oracle ? dba ? ? ? ?19726336 Jul 29 18:16
> > ctl_file_t661371396_s2112_p1
> >
> > Target Machine:
> > [oracle_at_PowerEdge1 cont_backup]$ pwd
> > /backup_rman/cont_backup
> > [oracle_at_PowerEdge1 cont_backup]$ ls -al
> > total 92272
> > drwxrwxrwx 2 oracle dba ? ? 4096 Jul 29 17:05 .
> > drwxrwxrwx 4 oracle dba ? ? 4096 Jul 29 17:10 ..
> > -rw-rw-rw- 1 oracle dba 17661952 Mar 19 19:14
> > ctl_file_t643581595_s1675_p1
> > -rw-rw-rw- 1 oracle dba 17661952 Mar 19 19:14
> > ctl_file_t648930789_s1833_p1
> > -rw-rw-rw- 1 oracle dba 19693568 Jul 29 04:26
> > ctl_file_t661285579_s2098_p1
> > -rw-rw-rw- 1 oracle dba 19693568 Jul 30 00:29
> > ctl_file_t661357792_s2100_p1
> > -rw-rw-rw- 1 oracle dba 19644416 Jul 30 02:35
> > ctl_file_t661365316_s2103_p1- Hide quoted text -
> >
> > - Show quoted text -

>

> Yet that structure does not match that which RMAN is looking for:
>

> ORA-19870: error reading backup piece /u01/oracle/product/10.2.0/db/
> dbs/c-2142365377-20080729-01
>

> I'd be checking the source machine for files in the /u01/oracle/
> product/10.2.0/db/dbs directory as you're clearly missing these items.
>
>

> David Fitzjarrell

Right (maybe) but how could we have guessed you were working cross platform if you don't provide the OS?

Shakespeare Received on Wed Jul 30 2008 - 10:06:58 CDT

Original text of this message