Home » Server Options » Data Guard » TableSpace Creation Problem in Standby database (Oracle 10g R2 + Windows 2000 + Logical Standby)
TableSpace Creation Problem in Standby database [message #318478] Wed, 07 May 2008 00:22 Go to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Hi,

In my logical standby environment, I can't able to create tablespace after switch overing archivelog from primary database.

My both environment different structure that's why i am used DB_FILE_NAME_CONVERT.


Primary Database Parameter:

SQL> show parameter db_file_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      D:\Oracle\Data\EdkStby\, E:\or
                                                 acle\product\10.2.0\oradata\ed
                                                 k\
SQL> show parameter standby

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest                 string      %ORACLE_HOME%\RDBMS
standby_file_management              string      AUTO


Logical Standby parameter
SQL> show parameter db_file_name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string      E:\oracle\product\10.2.0\orada
                                                 ta\edk\, D:\Oracle\Data\EdkStb
                                                 y\
SQL> show parameter standby

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
standby_archive_dest                 string      %ORACLE_HOME%\RDBMS
standby_file_management              string      AUTO


Alert log from Logical Standby DB:

Quote:
create tablespace Babu datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EDK\BAbu01.dbf' size 5m reuse autoextend on next 5m maxsize 100m
Wed May 07 09:43:29 2008
ORA-1119 signalled during: create tablespace Babu datafile 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EDK\BAbu01.dbf' size 5m reuse autoextend on next 5m maxsize 100m...
LOGSTDBY status: ORA-01119: error in creating database file 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\EDK\BAbu01.dbf'
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
LOGSTDBY Apply process P004 pid=85 OS id=1864 stopped



I don't have E - Drive in my logical standby but datafile stored in D - Drive.

SQL> select file_name from dba_data_files;

FILE_NAME
---------------------------------------------------
D:\ORACLE\DATA\EDKSTBY\USERS01.DBF
D:\ORACLE\DATA\EDKSTBY\SYSAUX01.DBF
D:\ORACLE\DATA\EDKSTBY\UNDOTBS01.DBF
D:\ORACLE\DATA\EDKSTBY\SYSTEM01.DBF


Any thing missing in my configuration. Please let me know

Babu
Re: TableSpace Creation Problem in Standby database [message #319471 is a reply to message #318478] Sun, 11 May 2008 15:13 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
Babu

db_file_name_convert has parameter order in this way...on primary

'primary path' ,' secondary path'

I think you have it reverse order. please change that parameter on primary (also reflect same on standby) and it should work

Sandeep
Previous Topic: not log in after shutdown
Next Topic: drop physical standby database
Goto Forum:
  


Current Time: Thu Mar 28 09:06:15 CDT 2024