Re: Restore

From: madunix <madunix_at_gmail.com>
Date: Wed, 30 Jul 2008 07:51:23 -0700 (PDT)
Message-ID: <3392a8d2-f98e-42ad-a275-0b63e5dc7162@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
Received on Wed Jul 30 2008 - 09:51:23 CDT

Original text of this message