troubleshooting Question

Rman restore

Avatar of xoxomos
xoxomos asked on
Oracle Database
6 Comments1 Solution1068 ViewsLast Modified:
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/oradata/BB60/system01.dbf
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/BB60/system01.dbf'

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 ?
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros