Re: Restore

From: madunix <madunix_at_gmail.com>
Date: Tue, 29 Jul 2008 21:11:49 -0700 (PDT)
Message-ID: <de143cd8-8a06-4380-9744-234de774e705@x35g2000hsb.googlegroups.com>

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 Received on Tue Jul 29 2008 - 23:11:49 CDT