xoxomos
asked on
Rman restore
I mad a full rman backup including controlfile. No catalog.
I then from the os command line removed all the dbf's and control files.
Now i'm trying to restore from the backup and getting the message
RMAN> restore database;
Starting restore at 09-JAN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=763 devtype=DISK
creating datafile fno=1 name=/u01/app/oracle/orada
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of restore command at 01/09/2009 13:34:25
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u01/app/oracle/oradata/B
When I listed the backup i saw the system01.dbf was included in the backupset
What do i need to do before issuing the restore command ?
I then from the os command line removed all the dbf's and control files.
Now i'm trying to restore from the backup and getting the message
RMAN> restore database;
Starting restore at 09-JAN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=763 devtype=DISK
creating datafile fno=1 name=/u01/app/oracle/orada
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
RMAN-03002: failure of restore command at 01/09/2009 13:34:25
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/u01/app/oracle/oradata/B
When I listed the backup i saw the system01.dbf was included in the backupset
What do i need to do before issuing the restore command ?
laneduncan
At first blush, it would appear either that the file exists still (and thus cannot be created by RMAN), or that the Oracle user (that's the user with which you're invoking RMAN, correct?) cannot create the file in that dir. I'd double-check to be sure the file perms are set up correctly before doing too much work on it.
ASKER
I'm running rman as oracle user. Oracle owns the directory. I deleted the files, so they don't exist except on the rman backupset.
ASKER
Basically i've got a rman full backup archived logs and redo logs. All the datafiles and controlfiles have been wiped out with the exception of the controlfile on the rman backup itself.
ASKER
RMAN> connect target /
RMAN-00571: ==========================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ==========================
ORA-00210: cannot open the specified control file
ORA-00202: control file: '/u01/app/oracle/oradata/B
ORA-27041: unable to open file
SVR4 Error: 2: No such file or directory
Additional information: 3
from here, i need to tell rman there is a backup at /uemc/sbackup/09k44on2_1_1
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
It didn't really resolve this issue, but that trial recovery article is worth it!!!
thanks
thanks