Recovery Using RMAN Giving errors

Hi,
I am trying to recover a lost datafile using rman and get errors.

Here is the script I am running and below that are errors.



RMAN> run {
2> allocate channel c2 type disk;
3> restore database;
4> recover database;
5> release channel c2;
6> }

RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: c2
RMAN-08500: channel c2: sid=11 devtype=DISK

RMAN-03022: compiling command: restore

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel c2: starting datafile backupset restore
RMAN-08502: set_count=3 set_stamp=428428372
RMAN-08019: channel c2: restoring datafile 1
RMAN-08509: destination for restore of datafile 1: C:\ORA805\DATABASE\SYS1ORCL.O
RA
RMAN-08019: channel c2: restoring datafile 2
RMAN-08509: destination for restore of datafile 2: C:\ORA805\DATABASE\USR1ORCL.O
RA
RMAN-08019: channel c2: restoring datafile 3
RMAN-08509: destination for restore of datafile 3: C:\ORA805\DATABASE\RBS1ORCL.O
RA
RMAN-08019: channel c2: restoring datafile 4
RMAN-08509: destination for restore of datafile 4: C:\ORA805\DATABASE\TMP1ORCL.O
RA
RMAN-08019: channel c2: restoring datafile 5
RMAN-08509: destination for restore of datafile 5: C:\ORA805\DATABASE\USR2ORCL.O
RA
RMAN-08019: channel c2: restoring datafile 6
RMAN-08509: destination for restore of datafile 6: C:\ORA805\DATABASE\TEMPORCL.O
RA
RMAN-08019: channel c2: restoring datafile 7
RMAN-08509: destination for restore of datafile 7: C:\ORA805\DATABASE\REC_DATAOR
CL.ORA
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: c2
RMAN-00569: ================error message stack follows================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE
RMAN-07004: unhandled exception during command execution on channel c2
RMAN-10032: unhandled exception during execution of job step 1: ORA-06512: at li
ne 148
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible

ORA-19504: failed to create file "C:\ORA805\DATABASE\REC_DATAORCL.ORA"
ORA-27038: skgfrcre: file exists
OSD-04010: option specified, file already exists
ORA-06512: at "SYS.X$DBMS_BACKUP_RESTORE", line 925
RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.RESTOREBACKUPP
IECE

Thanks
Anurag

I am not much familiar with Oracle on Windows platform.

This could be due to Oracle not having permission to remove the existing file and restore the backup copy to the destination.

1, verify C:\ORA805\DATABASE\REC_DATAORCL.ORA exists

2, try removing the file urself (only if you are ging to restore) and restore the file from backup

3, recover the DB

Yes, The file exists and i tried to restore it after removing it but it still does not work.

Please Suggest.

Thanks
Anurag

Did you check whether there is enough space?

Also, try adding a file thru sql*plus and see what error it is giving (if another test DB on the machine is available)

(ex. Alter tablespace ts1 add datafile C:\ORA805\DATABASE\REC_DATAORCLn.ORA size size1 ;

It gives me the following error when I try to create the file through sql plus


Alter tablespace usr add datafile 'C:\ORA805DATABASE\REC_DATAORCL100.ORA'
*
ERROR at line 1:
ORA-01119: error in creating database file 'C:\ORA805\DATABASE\REC_DATAORCL100.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

But I am able to create the datafiles using server manager and enterprise manager.

Please suggest how do i fix this.

Thanks
Anurag

check the path,

I guess 'C:\ORA805DATABASE' has to be
'C:\ORA805\DATABASE'

Note the "SLASH" betwn ORA805 and DATABASE

BTW, is it a parallel DB?

That would be correct, but how are you connecting to the target database as SYS/SYSTEM/SOME_USER. If you are a sys/system, then make sure of the file permissions like. As prince suggested it has to do some thing with your file permissions I beleive, if you were able to restore the other file except this one.

Sam

The path is correct. It has a / in it.
It is 'C:\ORA805\DATABASE'

Alter tablespace usr
add datafile
'C:\ORA805\DATABASE\REC_DATAORCL100.ORA';

I connect to the target database using internal.

It is not a Parallel Database.

Thanks
Anurag

How do i view/manage file permissions for the user internal and assign it the required permissions to perform the recovery on a windows 2000 machine.

I have a Oracle 8.0.5 database installed.


And why is that I am able to create a datafile using server manager and enterprise manager using the same user and not sql plus?????


Thanks
Anurag

I am not sure, whether this is of any help. Anyway try this.

Righ click the mouse on another file which got restored and compare its properties, securities with the one which is giving the problem. May be you will find some information.

Also make sure ur path, SID all set properly to avoid mess-ups

Prince..

Does the user you use has the RMAN privileges to backup and restore. Check that on. One other thing is that you might have explicitly assigned the roles that allows the user to create the table spcae, which I beleive would allow him to create datafiles. Folks correct me if I am wrong, i think to recover you have to be a sys, which would have all the database privileges by default. Or the user have to be a DBA.


I hope this would help you in some way,

Sam