{"id":137,"date":"2008-10-29T16:55:00","date_gmt":"2008-10-29T14:55:00","guid":{"rendered":"http:\/\/antynet.pl\/index.php\/2008\/10\/29\/oracle-standby\/"},"modified":"2010-08-24T22:42:46","modified_gmt":"2010-08-24T20:42:46","slug":"oracle-standby","status":"publish","type":"post","link":"https:\/\/www.antynet.pl\/index.php\/2008\/10\/29\/oracle-standby\/","title":{"rendered":"ORACLE STANDBY"},"content":{"rendered":"
\n

baza PRIMARY<\/p>\n

\n
    \n
  1. uruchomienie trybu ARCHIVELOG<\/li>\n
  2. uruchomienie logowania do redolog\u00f3w wszystkich obiekt\u00f3w – „ALTER DATABASE FORCE LOGGING;”
    spradzenie – ” SELECT force_logging FROM v$database<\/li>\n
  3. wpisanie do tnsname namiaru na baz\u0119 STANDBY<\/li>\n
  4. wpisanie do pliku INIT:\n
    log_archive_dest_1=’location=[archivelog_path]’
    log_archive_dest_2=’service=[standby_tnsname] mandatory reopen=60′<\/div>\n<\/li>\n
  5. wy\u0142\u0105czenie bazy lub wprowadzenie w tryb backup – „ALTER DATABASE BEGIN BACKUP;”<\/li>\n
  6. wykonanie kopii plik\u00f3w bazy – bez redolog\u00f3w;<\/li>\n
  7. w\u0142\u0105czenie bazy lub wyj\u015bcie z trybu backup = „ALTER DATABASE END BACKUP;”<\/li>\n
  8. wykonanie pliku kontrolnego dla bazy STANDBY – „ALTER DATABASE CREATE STANDBY CONTROLFILE AS '[file_path]’;”<\/li>\n
  9. wykonanie kopii plik\u00f3w archiwalnych bazy powsta\u0142ych w czasie backupu<\/li>\n
  10. przerzucenie skopiowanych plik\u00f3w na baz\u0119 STANDBY<\/li>\n<\/ol>\n
    \n

    baza STANDBY<\/p>\n

    \n
      \n
    1. wpisanie do pliku INIT:\n
      log_archive_dest_1=’location=[archivelog_path]’
      standby_archive_dest=[archivelog_from_primary_path]
      db_file_name_convert='[datafile_primary_dir_path]’,'[datafile_standby_dir_path]’
      log_file_name_convert='[redolog_primary_dir_path]’,'[redolog_standby_dir_path]’<\/div>\n

      opis:
      log_archive_dest_1 – wskazuje gdzie b\u0119d\u0105 pliki archiwalne kiedy baza zostanie aktywowana
      standby_archive_dest – wskazuje gdzie b\u0119d\u0105 wrzucane archivelogi z bazy PRIMARY
      db_file_name_convert – ustawia mapowanie \u015bcie\u017cki do katalogu z plikami danych, konieczne poniewa\u017c w pliku controlfile b\u0119d\u0105 namiary z bazy PRIMARY
      log_file_name_convert – analogicznie tylko dla redolg\u00f3w<\/li>\n

    2. skopiowanie plik\u00f3w danych i archivelog\u00f3w do odpowiedniej lokalizacji (pami\u0119ta\u0107 o ustawieniu praw i w\u0142a\u015bciciela)<\/li>\n
    3. skopiowanie i powielenie wcze\u015bniej utworzonego pliku kontrolnego zgodnie z warto\u015bciami w pliku INIT<\/li>\n
    4. uruchomienie bazy:
      startup nomount
      alter database mount standby database
      alter database recover managed standby database disconnect from session\n<\/li>\n<\/ol>\n

      przydatne kwerendy:
      <\/span>SELECT sequence#,first_time,next_time,applied FROM v$archived_log ORDER BY sequence# desc;
      SELECT * FROM v$archive_gap;
      SELECT process,status,sequence#,thread# FROM v$managed_standby;
      SELECT open_mode FROM v$database;
      ALTER SYSTEM ARCHIVE LOG CURRENT;
      otwarcie bazy do odczytu<\/span> (baza przyjmuje archivelogi jednak ich nie uaktualnia):
      alter database read only;
      komunikat:<\/p>\n

      ERROR at line 1:
      ORA-01154: database busy. Open, close, mount, and dismount not allowed now<\/div>\n

      recover managed standby database cancel;
      komuniat:<\/p>\n

      Media recovery complete.<\/div>\n

      alter database open read only;
      powr\u00f3t do trybu standby:<\/span>
      shutdown immediate;
      dalej w\/g punktu 4 – uruchamianie bazy
      aktywacja bazy standby:<\/span>
      recover managed standby database cancel;
      shutdown immediate;
      startup nomount;
      alter database mount standby database;
      #skopiowa\u0107 ostatni redolog z bazy PRIMARY;
      recover standby database;
      #w trybie interaktywnym wpisa\u0107 lokalizacj\u0119 powy\u017cszego pliku
      alter database activate standby database;
      shutdown immediate;
      startup;<\/p>\n","protected":false},"excerpt":{"rendered":"

      baza PRIMARY uruchomienie trybu ARCHIVELOG uruchomienie logowania do redolog\u00f3w wszystkich obiekt\u00f3w – „ALTER DATABASE FORCE LOGGING;”spradzenie – ” SELECT force_logging FROM v$database wpisanie do tnsname namiaru na baz\u0119 STANDBY wpisanie do pliku INIT: log_archive_dest_1=’location=[archivelog_path]’log_archive_dest_2=’service=[standby_tnsname] mandatory reopen=60′ wy\u0142\u0105czenie bazy lub wprowadzenie w tryb backup – „ALTER DATABASE BEGIN BACKUP;” wykonanie kopii plik\u00f3w bazy – bez redolog\u00f3w; […]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[80],"tags":[55],"class_list":["post-137","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle-standby"],"_links":{"self":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/137","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/comments?post=137"}],"version-history":[{"count":1,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/137\/revisions"}],"predecessor-version":[{"id":199,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/posts\/137\/revisions\/199"}],"wp:attachment":[{"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/media?parent=137"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/categories?post=137"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.antynet.pl\/index.php\/wp-json\/wp\/v2\/tags?post=137"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}