OraFAQ Forum: Data Guard » adding a tablespace in primary database

Home » Server Options » Data Guard » adding a tablespace in primary database

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

adding a tablespace in primary database [message #282869]

Sat, 24 November 2007 06:45

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Dear All,

I had one Production DB with one Standby DB
Standby DB has different Directory Structure
Now i want to add a tablespace in production DB
my question is ,should i need to do something with Standby DB or it will updated automatically?

thanx

Report message to a moderator

Re: adding a tablespace in primary database [message #282870 is a reply to message #282869]

Sat, 24 November 2007 06:48

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

If standby_file_management=TRUE then it is automatically updated standby database.

http://download.oracle.com/docs/cd/B14117_01/server.101/b10823/manage_ps.htm#1010429

Report message to a moderator

Re: adding a tablespace in primary database [message #283277 is a reply to message #282870]

Mon, 26 November 2007 10:24

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

The great benefit of DG is that you have to do nothing on standby site except monitoring,
but make make make sure your PRIMARY database should be in LOGGING MODE.

[Updated on: Mon, 26 November 2007 10:24]

Report message to a moderator

Re: adding a tablespace in primary database [message #283395 is a reply to message #283277]

Tue, 27 November 2007 00:44

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Both Primary and standby database are in logging mode
At Primary DB
SQL>select FORCE_LOGGING
from v$database
FOR
---
YES

At Standby DB
SQL>select FORCE_LOGGING
from v$database
FOR
---
YES
while standby_file_managment=auto and db_file_name_convert is properly set
when i try to create a tablespace in primary database ,its not populated at standby Db
but when i check the alert file for stanndby db
i got the following error
Mon Nov 26 19:25:32 2007
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
Attempt to start background Managed Standby Recovery process
MRP0 started with pid=20
MRP0: Background Managed Standby Recovery process started
MRP0: Background Media Recovery terminated with error 1111
Mon Nov 26 19:25:38 2007
Errors in file d:\oracle\admin\abc\bdump\abc_mrp0_3192.trc:
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: 'D:\ORACLE\ORA92\DATABASE\UNNAMED00011'
ORA-01157: cannot identify/lock data file 11 - see DBWR trace file
ORA-01111: name for data file 11 is unknown - rename to correct file
ORA-01110: data file 11: 'D:\ORACLE\ORA92\DATABASE\UNNAMED00011'
MRP0: Background Media Recovery process shutdown
Mon Nov 26 19:25:40 2007
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DI

please suggest!

Report message to a moderator

Re: adding a tablespace in primary database [message #283631 is a reply to message #283395]

Tue, 27 November 2007 15:01

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Quote:

ORA-01110: data file 11: 'D:\ORACLE\ORA92\DATABASE\UNNAMED00011

I guess theres some problem in your already existing file n0 11

SQL> ;
  1  select a.file#,b.name from v$datafile a ,v$tablespace b
  2* where a.ts#=b.ts#

Report message to a moderator

Re: adding a tablespace in primary database [message #283647 is a reply to message #283395]

Tue, 27 November 2007 17:03

www.sidibe.net
Messages: 9
Registered: March 2004

Junior Member

if STANDBY_FILE_MANAGEMENT is set to "auto" and db_file_name_convert properly set (DB_FILE_NAME_CONVERT = (production path, standby path)) then you have nothing to do.

We assume that all other Dataguard parameters are properly set.

Regards

[Edit MC: Put your link in your profile not in your post.]

[Updated on: Tue, 27 November 2007 23:31] by Moderator

Report message to a moderator

Previous Topic:	ora-00314 after "alter system switch logfile"
Next Topic:	switchover from primary db to standby

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 17 05:46:09 CST 2026