standby_file_management question

From: Vince Laurent <vincelaurent_at_REMOVETHISsbcglobal.net>
Date: Thu, 04 Aug 2005 19:22:24 GMT
Message-ID: <dmq4f1houf5iu3pg9ru5g74fiepc9tctq9@4ax.com>

I found a note, Note:221130.1, which got me by (had a createion error) BUT the question remains: Why wasn't the standby_file_management able to create a directory? I figured this out from reading the note AND doing it:

SQL> alter database create datafile
'/oracle/PRD/920_64/dbs/UNNAMED00227' as
2 '/oracle/PRD/sapdata19/btabd_56/btabd.data56' size 2088952K; alter database create datafile '/oracle/PRD/920_64/dbs/UNNAMED00227' as
*
ERROR at line 1:
ORA-01119: error in creating database file
'/oracle/PRD/sapdata19/btabd_56/btabd.data56'
ORA-27040: skgfrcre: create error, unable to create file HP-UX Error: 2: No such file or directory

Once I created /oracle/PRD/sapdata19/btabd_56/ then the commands would work.

Can the standby database NOT make subdirectories?

---

Come race with us!
http://www.mgpmrc.org Received on Thu Aug 04 2005 - 14:22:24 CDT