How to add Tempfile in Standby (Bigfile and Normal)
Steps to perform:
Step 1 :
Add the temp file to existing Temp tablespace/ Create new BIGFILE/Normal Temp tablespace in Primary with existing syntax as below.
Example:
create temporary tablespace TEMP tempfile '<DGname>' size 1g autoextend on next 512m maxsize 31g;
or
alter temporary tablespace TEMP add tempfile '<DGNAME>' size 1g autoextend on next 512m maxsize 31g;
or
create bigfile temporary tablespace TEMP tempfile '<DGname>' size 1g autoextend on next 512m maxsize 1T;
Step 2:
As Redo will not be generated so at Standby side tempfiles will not be created automatically but Metadata will be synced.
Turn OFF the MRP process in standby and database should be opened in read only mode.
Step 3:
If you created normal temp tablespace / add new tempfile to existing temp tablespace then syntax as below.
alter tablespace TEMP add tempfile '<DGname>' size 1g autoextend on next 512m maxsize 31g;
for BIGFILE:
alter tablespace TEMP add tempfile '<DGname>' size 1g autoextend on next 512m maxsize 1T;
Comments
Post a Comment