Problem in create tablespace statement ( logical standby database) 9i version 2 [message #156806] |
Fri, 27 January 2006 23:41 |
waseem_aijaz
Messages: 16 Registered: December 2005 Location: Kingdom of Saudi Arabia
|
Junior Member |
|
|
I have configured logical standby database as described in the documentation of Oracle 9i data guard guide.
I have created a tablespace on the primary site as follows.
PRIMARY> create tablespace userdata
datafile 'c:\oracle\oradata\PRC\userdata01.dbf' size 40m;
I have configured logical standby database on the same PC and used the following parameters for mapping data files and log files.
db_file_name_convert=c:\oracle\oradata\PRC,c:\oracle\oradata\PRC\stdby
log_file_name_convert=c:\oracle\oradata\PRC,c:\oracle\oradata\PRC\stdby
@ Standby I observed that log apply service stopped. The following query gave me this information.
STANDBY> select applied_scn,newest_scn from
dba_logstdby_progress;
APPLIED_SCN NEWEST_SCN
----------- ----------
128430 251026
Later I saw alert_PRCSTDBY.log file. I saw the following error.
#############################################################
alter database start logical standby apply
ALTER DATABASE START LOGICAL STANDBY APPLY
No optional part
LSP0 started with pid=12
LOGSTDBY event: ORA-16111: log mining and apply setting up
Tue Jan 24 11:24:23 2006
Attempt to start background Logical Standby process
Completed: alter database start logical standby apply
Tue Jan 24 11:24:29 2006
create tablespace userdata
datafile 'c:\oracle\oradata\prc\userdata01.dbf' size 40m
Tue Jan 24 11:24:29 2006
ORA-1119 signalled during: create tablespace userdata
datafile 'c:\oracle\ora...
LOGSTDBY event: ORA-01119: error in creating database file ''
LOGSTDBY stmt: create tablespace userdata
datafile 'c:\oracle\oradata\prc\userdata01.dbf' size 40m
#############################################################
Here it is giving above error. I saw the error detail in documentation. It is because of insufficient space. But I have 17 GB left on my C drive. Here I think there is a problem in data file names mapping...
Can any one guide me in this case.
-aijaz
|
|
|