 | |
#21
 
| |||
| |||
|
Re: Restore -
07-30-2008
, 10:06 AM
|
On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
if you don't provide the OS?
Shakespeare
#22
| |||
| |||
|
|
"madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
#23
| |||
| |||
|
|
"madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
#24
| |||
| |||
|
|
"madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
#25
| |||
| |||
|
|
"madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
#26
| |||
| |||
|
|
I did the first message 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 !! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^ Shakespeare wrote: "madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
Shakespeare
#27
| |||
| |||
|
|
I did the first message 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 !! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^ Shakespeare wrote: "madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
Shakespeare
#28
| |||
| |||
|
|
I did the first message 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 !! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^ Shakespeare wrote: "madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
Shakespeare
#29
| |||
| |||
|
|
I did the first message 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 !! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^ Shakespeare wrote: "madunix" <madunix (AT) gmail (DOT) com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162 (AT) e39g2000hsf (DOT) 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 (DOT) net wrote: On Jul 29, 11:11?pm, madunix <madu... (AT) gmail (DOT) com> wrote: On Jul 29, 8:25?pm, "fitzjarr... (AT) cox (DOT) net" <orat... (AT) msn (DOT) com> wrote: On Jul 29, 1:04?pm, madunix <madu... (AT) gmail (DOT) 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@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@PowerEdge1 cont_backup]$ pwd /backup_rman/cont_backup [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 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 |
Shakespeare
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.