standby - Page 6
DBAsupport.com Forums - Powered by vBulletin
Page 6 of 6 FirstFirst ... 456
Results 51 to 55 of 55

Thread: standby

  1. #51
    Join Date
    Jan 2007
    Posts
    231
    primary is working on pfile currently now.But they have used wrong pfile and started the database,because i check archive parameter.It shows only primaryDB and it doesn't shows standby path. So if i restart primarydb, archiving to standby will work i belive.But standby is not working properly now.what to do?

  2. #52
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    who...they?

    so start again your analysis from the scratch of creating a standby db, everything that was discussed was useless.
    ---------------

  3. #53
    Join Date
    Jan 2007
    Posts
    231
    ray..,
    Without shutdown of primary,can i do standby? (i.e, setting everyting correctly in standbydb and can down my primary only for 15min.)if iam able to open standby in read only mode.I can restart primary with right spfile which will take only 10min.

  4. #54
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    It seems as though you are executing the command used to recreate the controlfile for your primary database. To create a standby controlfile, you need to:

    alter database create standby controlfile as '/path/file.ext';

    Check the syntax and run it on a test system first.
    Last edited by waitecj; 03-13-2007 at 12:05 PM.
    Assistance is Futile...

  5. #55
    Join Date
    Jan 2007
    Posts
    231
    ok ..rey,

    If there is no other go, i will do it from scratch.

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