Re: Restore

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 Received on Tue Jul 29 2008 - 13:25:44 CDT