DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Materialzed view log Question.

  1. 07-26-2005, 06:20 AM #1
    paragp1981
    paragp1981 is offline Member
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245

    Materialzed view log Question.

    Hi,
    We have 2 servers one (A) is having materialzed view logs on it. Second (B) is having Materialzed view on it. We will do snapshot refresh every night. Now A is going for RAC (3 nodes) today night.
    Project has been given to some body outside DBA. What he is planning to do is take HOT backup from A and it will copy it to those 3 nodes and i dont know why but he said he is gonna open that RAC DB with open resetlogs. My concern is now after doing that will happen to MV LOG. Will refresh happen successfully??.

    tnsnames and all are gonna be same.

    I searched all over net didnt find anything.

    Rgds
    Parag
    Reply With Quote Reply With Quote
  2. 07-27-2005, 04:38 AM #2
    paragp1981
    paragp1981 is offline Member
    Join Date
    Apr 2003
    Location
    Pune,Maharashtra. India.
    Posts
    245
    Hi,
    Thanks It happened correctly. no problems came with snap refresh.

    Rgds
    Parag
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width