-
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
Thanx
Sam
Life is a journey, not a destination!
-
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..
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|