Creating tablespace and propagating to standby database
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Creating tablespace and propagating to standby database

  1. #1
    Join Date
    May 2000
    Location
    India
    Posts
    18

    Creating tablespace and propagating to standby database

    Hi,

    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.

    Thanks
    Bhas

  2. #2
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Hi,

    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.

    Regards,
    Nir

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width