Re: Restore

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 - 07:53:12 CDT