Creating tablespace and propagating to standby database
I have a primary database in which I need create a new tablespace. There is crontab scheduled to ship and apply archive logs to standby database for every 15 mins. i.e standby database is in recovery mode. We use Oracle8i. As per my understanding, I have to hold the crontab (used for shipping and applying archivelogs), create a tablespace in primary tablespace, copy the datafiles to standby database server (to appropriate directory), activate the crontab job, apply the archivelog to standby database, then run ALTER DATABASE command to add the datafile when we get an warning message at standby location.
Can you please suggest, if I am missing anything? Is there a better method.
You are basicly right.
For the complete steps, please see chapter 5 under
"Scenario 3: Accommodating Physical Changes in the Primary Database" in the "Oracle8i Standby Database Concepts and Administration" guide.