OraFAQ Forum: Data Guard » TableSpace Creation Problem in Standby database

Home » Server Options » Data Guard » TableSpace Creation Problem in Standby database (Oracle 10g R2 + Windows 2000 + Logical Standby)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

TableSpace Creation Problem in Standby database [message #318478]

Wed, 07 May 2008 00:22

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

Report message to a moderator

Re: TableSpace Creation Problem in Standby database [message #319471 is a reply to message #318478]

Sun, 11 May 2008 15:13

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 03 18:07:43 CST 2024