Restore
in [Oracle Help]
|
From: Shakespeare on 30 Jul 2008 11:06 "madunix" <madunix(a)gmail.com> schreef in bericht news:3392a8d2-f98e-42ad-a275-0b63e5dc7162(a)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(a)cox.net wrote: > On Jul 29, 11:11?pm, madunix <madu...(a)gmail.com> wrote: > > On Jul 29, 8:25?pm, "fitzjarr...(a)cox.net" <orat...(a)msn.com> wrote: > > > > > > > > > > > > > On Jul 29, 1:04?pm, madunix <madu...(a)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(a)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(a)PowerEdge1 cont_backup]$ pwd > > /backup_rman/cont_backup > > [oracle(a)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
From: madunix on 30 Jul 2008 12:25 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(a)gmail.com> schreef in bericht > news:3392a8d2-f98e-42ad-a275-0b63e5dc7162(a)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(a)cox.net wrote: > > On Jul 29, 11:11?pm, madunix <madu...(a)gmail.com> wrote: > > > On Jul 29, 8:25?pm, "fitzjarr...(a)cox.net" <orat...(a)msn.com> wrote: > > > > > > > > > > > > > > > > > > > On Jul 29, 1:04?pm, madunix <madu...(a)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(a)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(a)PowerEdge1 cont_backup]$ pwd > > > /backup_rman/cont_backup > > > [oracle(a)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
From: Shakespeare on 30 Jul 2008 15:24 "madunix" <madunix(a)gmail.com> schreef in bericht news:2fcb76be-625d-40af-9dcf-ae657e77733f(a)l64g2000hse.googlegroups.com... >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(a)gmail.com> schreef in bericht >> news:3392a8d2-f98e-42ad-a275-0b63e5dc7162(a)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(a)cox.net wrote: >> > On Jul 29, 11:11?pm, madunix <madu...(a)gmail.com> wrote: >> > > On Jul 29, 8:25?pm, "fitzjarr...(a)cox.net" <orat...(a)msn.com> wrote: >> > > >> > > >> > > >> > > >> > > >> > > > On Jul 29, 1:04?pm, madunix <madu...(a)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(a)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(a)PowerEdge1 cont_backup]$ pwd >> > > /backup_rman/cont_backup >> > > [oracle(a)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 Sorry, missed that line. Searched for it several times... Shakespeare
First
|
Prev
|
Pages: 1 2 Prev: Oracle 10g 10.0.2 client, to connect oracle 8 server Next: AD4J Installation with JBoss |