 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussion Groups Database Servers DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybaseDesktop Databases FileMakerFoxProMS AccessParadoxGeneral General DB TopicsDatabase TheoryRelated Topics Java Development.NET DevelopmentVB DevelopmentMore Topics ... |
Database Forum / Oracle / Oracle Server / July 2008Restore
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 > Am trying to do restore of control file on Linux Machine 64Bit > CenTOS5.2, i get the following [quoted text clipped - 48 lines] > > 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 On Jul 29, 8:25 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote: > > Am trying to do restore of control file on Linux Machine 64Bit > > CenTOS5.2, i get the following [quoted text clipped - 54 lines] > > 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 > On Jul 29, 8:25 pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote: > [quoted text clipped - 98 lines] > > - 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 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 > > On Jul 29, 8:25�pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote: > > [quoted text clipped - 108 lines] > > David Fitzjarrell 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@cox.net wrote: > On Jul 29, 11:11?pm, madunix <madu...@gmail.com> wrote: > > On Jul 29, 8:25?pm, "fitzjarr...@cox.net" <orat...@msn.com> wrote: [quoted text clipped - 112 lines] > > David Fitzjarrell Right (maybe) but how could we have guessed you were working cross platform if you don't provide the OS? Shakespeare 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 !! ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > I think it has to do with the following > Cross-Platform Transportable Database: RMAN CONVERT DATABASE [quoted text clipped - 123 lines] > > Shakespeare >I did the first message > [quoted text clipped - 140 lines] >> >> Shakespeare Sorry, missed that line. Searched for it several times... Shakespeare |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.