Restore
in [Oracle Help]
|
From: madunix on 29 Jul 2008 14:04 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
From: fitzjarrell on 29 Jul 2008 14:25 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
From: madunix on 30 Jul 2008 00:11 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
From: fitzjarrell on 30 Jul 2008 08:53 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
From: madunix on 30 Jul 2008 10:51 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
|
Next
|
Last
Pages: 1 2 Prev: Oracle 10g 10.0.2 client, to connect oracle 8 server Next: AD4J Installation with JBoss |