Home » Server Options » Data Guard » adding a tablespace in primary database
adding a tablespace in primary database [message #282869] Sat, 24 November 2007 06:45 Go to next message
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
Re: adding a tablespace in primary database [message #282870 is a reply to message #282869] Sat, 24 November 2007 06:48 Go to previous messageGo to next message
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
Re: adding a tablespace in primary database [message #283277 is a reply to message #282870] Mon, 26 November 2007 10:24 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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!
Re: adding a tablespace in primary database [message #283631 is a reply to message #283395] Tue, 27 November 2007 15:01 Go to previous messageGo to next message
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#
Re: adding a tablespace in primary database [message #283647 is a reply to message #283395] Tue, 27 November 2007 17:03 Go to previous message
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:
  


Current Time: Thu Mar 28 14:28:32 CDT 2024