3 Replies Latest reply: Apr 30, 2013 3:33 AM by Richa RSS

    Datafile not shipped from Primary database to Standby database

    Richa
      Hi,

      (1) Created one new user
      (2) Created a new tablespace and added datafile on Primary Database
      (3) Set default tablespace to user

      But till now this new datafile is not shipped on Standby database.

      Database version - 10.2.0.3
      OS - Windows

      Parameter on both Primary and Standby database:-

      SQL> show parameter standby_file_management;

      NAME TYPE VALUE
      ------------------------------------ ----------- ------------------------------
      standby_file_management string AUTO

      Both have same file system but the difference is only case sensitive.

      Datafile location on Primary - D:\testdata

      Datafile location on Standby - D:\TESTDATA

      Please help.