10 Replies Latest reply: Mar 17, 2014 7:02 AM by Artem S. Tsygankov RSS

    Recreate UNDO tablespace on Logical Standby.

    Artem S. Tsygankov

      Dear friends,

      Please let me know if I recreate UNDO tablespace on Logical Standby database?

      Like following script:

       

      connect / as sysdba

      create undo tablespace UNDO2 DATAFILE '/oradata/undo2_01.dbf' SIZE 128M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

      alter system set undo_tablespace='UNDO2';

      drop tablespace UNDO1 including contents and datafiles;

      create undo tablespace UNDO1 DATAFILE '/oradata/undo1_01.dbf' SIZE 128M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED;

      alter system set undo_tablespace='UNDO1';

      drop tablespace UNDO2 including contents and datafiles;

      exit

       

      Or is it possible only in an usual database (not standby)?

      Parameter standby_file_management=MANUAL

      Database version 11.2.0.3