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/sdc/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@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
On Tue, Jul 29, 2008 at 05:19:46PM +0200, Mad Unix wrote:
- The control files has been transfered from AIX5.3 to a Linux Machine !!
This is an Oracle issue and not a CentOS issue.
Please note that, typically, Oracle binary files are not portable between hardware and OS platforms. When I used to DBA Oracle (Oracle 8; that long ago) we were told by Oracle that files were not portable (eg between HPUX and Solaris, or Solaris and Linux).
- The control files has been transfered from AIX5.3 to a Linux Machine !!
This is an Oracle issue and not a CentOS issue.
Please note that, typically, Oracle binary files are not portable between hardware and OS platforms. When I used to DBA Oracle (Oracle 8; that long ago) we were told by Oracle that files were not portable (eg between HPUX and Solaris, or Solaris and Linux).
This definitely belongs to an Oracle mailing list. However, please look at possible issues between Big/Little Endian architectures. I've seen this when moving between different archs.
MAL