Skip to Content

Tablespace reorg with Dataguard Oracle 12c

Hi All,

Is it possible to reorg a tablespace when dataguard is active?

We've just deleted 500m records from our ERP system and now want to reorg the tablespaces to regain the space saved, but we have dataguard active. If I create a new tablespace on a different volume due to space, this can't be replicated to the physical standby. How best to achieve this? Do I need to stop log shipping, reorg the tablespaces then recreate the physical standby from the new datafiles?

Thanks
Craig

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 24, 2017 at 10:47 PM

    Hi Craig,

    No need to switch of the log shipping/DG for tablespace creation and online reorg. Only the thing is you need to have enough space to manage archive logs as online reorg generates huge number of archive logs.

    Take a look at below link for more details on actions on primary database that can effect you secondary database in Data guard environment.

    https://docs.oracle.com/cd/B19306_01/server.102/b14239/manage_ps.htm#i1022518

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded