Home » Server Options » Data Guard » Problem in create tablespace statement ( logical standby database) 9i version 2
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


Previous Topic: New to Oracle Data Guard !!
Next Topic: Oracle9i Logical Standby- Apply services 'INITIALIZING' forever after switchover
Goto Forum:
  


Current Time: Thu Mar 28 17:37:13 CDT 2024