Re: Restore

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Wed, 30 Jul 2008 21:24:04 +0200
Message-ID: <4890bfd0$0$49880$e4fe514c@news.xs4all.nl>

"madunix" <madunix_at_gmail.com> schreef in bericht news:2fcb76be-625d-40af-9dcf-ae657e77733f_at_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_at_gmail.com> schreef in bericht
>> news:3392a8d2-f98e-42ad-a275-0b63e5dc7162_at_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_at_cox.net wrote:
>> > On Jul 29, 11:11?pm, madunix <madu..._at_gmail.com> wrote:
>> > > On Jul 29, 8:25?pm, "fitzjarr..._at_cox.net" <orat..._at_msn.com> wrote:
>> > >
>> > >
>> > >
>> > >
>> > >
>> > > > On Jul 29, 1:04?pm, madunix <madu..._at_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_at_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_at_PowerEdge1 cont_backup]$ pwd
>> > > /backup_rman/cont_backup
>> > > [oracle_at_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 Received on Wed Jul 30 2008 - 14:24:04 CDT

Original text of this message