# Physical Standby тохируулах

**URL:** <https://www.batmunkh.net/t/physical-standby/75>\
**Category:** Tutorials, Solutions\
**Tags:** guard, standby, physical, data, dataguard, oracle\
**Created:** [December 28, 2016, 5:36pm UTC](https://www.batmunkh.net/t/physical-standby/75 "2016-12-28T17:36:26Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [December 28, 2016, 5:36pm UTC](https://www.batmunkh.net/t/physical-standby/75/1 "2016-12-28T17:36:27Z")

</div>

[Data Guard](https://www.batmunkh.net/t/data-guard/74)-ийн талаар оруулсан танилцуулга мэдээллийг [энд дарж](https://www.batmunkh.net/t/data-guard/74) үзнэ үү.

Уг тохиргоог хэд хэдэн янзаар хийж болох боловч би энэ удаад өөрийн мэдэх байж болох хамгийн товч хувилбарыг орууллаа.

Үндсэн бааз - Primary ([node111.oracle.me](http://node111.oracle.me)) - ORCL  
Хуулбар бааз Standby ([node112.oracle.me](http://node112.oracle.me)) - SBY1

## Primary тохиргоо ([node111.oracle.me](http://node111.oracle.me))

Archivelog идэвхжүүлээгүй бол идэвжүүлээрэй.

```
-- archivelog той холбоотой тохиргоонууд
SQL> alter system set log_archive_dest_2='service=SBY1 valid_for=(primary_role, online_logfiles) db_unique_name=SBY1'
System altered.

SQL> alter system set standby_file_management=auto;
System altered.

SQL> alter system set log_archive_config='dg_config=(ORCL,SBY1)';
System altered.

-- pfile гаргаж авах
SQL> create pfile='/tmp/initSBY1.ora' from spfile;
File created.

```

Лог файлууд архивлагдсан эсэхийг дараах коммандаар шалгана.

```
SQL> select sequence#,applied,status, to_char(first_time,'dd-mm-yyyy hh24:mi:ss') from v$archived_log;

 SEQUENCE# APPLIED S TO_CHAR(FIRST_TIME,
---------- --------- - -------------------
	 9 NO A 28-12-2016 02:39:11
	10 NO A 28-12-2016 02:41:44
	11 NO A 29-12-2016 00:02:45
	12 NO A 29-12-2016 00:05:49
	13 NO A 29-12-2016 00:07:22

```

Primary серверийг зааж өгнө. Oracle 11g дээр тохируулах шаардлагагүй бөгөөд Oracle 12c дээр харин заавал тохируулж өгнө.

```
SQL> alter system set fal_server=ORCL;
System altered.

```

pfile-ийг standby-д зориулж засварлана.

```
[oracle@node111 ~]$ vi /tmp/initSBY1.ora

*.audit_file_dest='/u01/app/oracle/admin/SBY1/adump'
*.audit_trail='db'
*.compatible='12.1.0.0.0'
*.control_files='/u01/app/oracle/oradata/SBY1/control01.ctl','/u01/app/oracle/fast_recovery_area/SBY1/control02.ctl'
*.db_block_size=8192
*.db_domain=''
*.db_name='ORCL'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4800m
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SBY1XDB)'
*.log_archive_format='%t_%s_%r.dbf'
*.open_cursors=300
*.pga_aggregate_target=190m
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=470m
*.undo_tablespace='UNDOTBS1'

db_unique_name='SBY1'
service_names=SBY1
standby_file_management=auto
db_file_name_convert='ORCL','SBY1'
log_file_name_convert='ORCL','SBY1'

log_archive_config='dg_config=(ORCL,SBY1)'
log_archive_dest_2='service=ORCL valid_for=(primary_role,online_logfiles) db_unique_name=ORCL'

```

Засварлаж тохируулсан pfile-ийг standby сервер рүү хуулах

```
[oracle@node111 ~]$ scp /tmp/initSBY1.ora oracle@node112.oracle.me:/tmp/

```

Сүлжээнээс холбогдох тохиргоог хийх

```
[oracle@node111 ~]$ cd $ORACLE_HOME/network/admin/
[oracle@node111 ~]$ vi tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node111.oracle.me)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

SBY1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node112.oracle.me)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SBY1)
    )
  )

[oracle@node111 ~]$ vi listener.ora
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SBY1)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = SBY1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SBY1_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node111.oracle.me)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

[oracle@node111 ~]$ lsnrctl reload

```

## Standby тохиргоо ([node112.oracle.me](http://node112.oracle.me))

SBY1-ийг oratab файлд нэмж өгөх

```
[oracle@node112 ~]$ cat /etc/oratab
SBY1:/u01/app/oracle/product/12.1.0/db_1:N

```

Орчныг тохируулах

```
[oracle@node112 ~]$ . oraenv
ORACLE_SID = [SBY1] ? SBY1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@node112 ~]$

```

Баазын хавтсуудыг үүсгэх

```
[oracle@node112 ~]$ mkdir -p /u01/app/oracle/fast_recovery_area/SBY1
[oracle@node112 ~]$ mkdir -p /u01/app/oracle/oradata/SBY1
[oracle@node112 ~]$ mkdir -p /u01/app/oracle/admin/SBY1/adump

```

Standby instance асаах

```
[oracle@node112 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.1.0 Production on Thu Dec 29 05:31:33 2016
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.

SQL> create spfile from pfile='/tmp/initSBY1.ora';
File created.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 492707840 bytes
Fixed Size 2289928 bytes
Variable Size 260050680 bytes
Database Buffers 226492416 bytes
Redo Buffers 3874816 bytes
SQL>

```

Сүлжээнээс холбогдох тохиргоо

```
[oracle@node112 ~]$ cd /u01/app/oracle/product/12.1.0/db_1/network/admin/
[oracle@node112 admin]$ vi tnsnames.ora

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node111.oracle.me)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ORCL)
    )
  )

SBY1 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node112.oracle.me)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = SBY1)
    )
  )

```

listener тохируулах

```
[oracle@node112 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/12.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SBY1)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = SBY1)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = ORCL_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = ORCL)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = SBY1_DGMGRL)
      (ORACLE_HOME = /u01/app/oracle/product/12.1.0/db_1)
      (SID_NAME = SBY1)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = node112.oracle.me)(PORT = 1521))
    )
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
  )

ADR_BASE_LISTENER = /u01/app/oracle

```

**[node111.oracle.me](http://node111.oracle.me) (primary)**

Нууц үгний файлыг хуулах. Ингэснээр standby бааз руу primary баазын sys хэрэглэгчийн нууц үгийг ашиглан хандах боломжтой болно

```
[oracle@node111 ~]$ cd /u01/app/oracle/product/12.1.0/db_1/dbs
[oracle@node111 dbs]$ scp orapwORCL node112.oracle.me:/u01/app/oracle/product/12.1.0/db_1/dbs/orapwSBY1

```

Үндсэн баазыг RMAN ашиглаж хуулбарлах

```
[oracle@node111 admin]$ rman target sys@ORCL auxiliary sys@SBY1

Recovery Manager: Release 12.1.0.1.0 - Production on Thu Dec 29 00:20:34 2016
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.

connected to target database: ORCL (DBID=1459527240)
connected to auxiliary database (not mounted)

RMAN> duplicate target database for standby from active database;

Starting Duplicate Db at 29-DEC-16
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=22 device type=DISK

contents of Memory Script:
{
   backup as copy reuse
   targetfile '/u01/app/oracle/product/12.1.0/db_1/dbs/orapwORCL' auxiliary format
 '/u01/app/oracle/product/12.1.0/db_1/dbs/orapwSBY1' ;
}
executing Memory Script

Starting backup at 29-DEC-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
Finished backup at 29-DEC-16

contents of Memory Script:
{
   restore clone from service 'ORCL' standby controlfile;
}
executing Memory Script

Starting restore at 29-DEC-16
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service ORCL
channel ORA_AUX_DISK_1: restoring control file
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u01/app/oracle/oradata/SBY1/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/SBY1/control02.ctl
Finished restore at 29-DEC-16

contents of Memory Script:
{
   sql clone 'alter database mount standby database';
}
executing Memory Script

sql statement: alter database mount standby database

contents of Memory Script:
{
   set newname for tempfile 1 to
 "/u01/app/oracle/oradata/SBY1/temp01.dbf";
   switch clone tempfile all;
   set newname for datafile 1 to
 "/u01/app/oracle/oradata/SBY1/system01.dbf";
   set newname for datafile 2 to
 "/u01/app/oracle/oradata/SBY1/example01.dbf";
   set newname for datafile 3 to
 "/u01/app/oracle/oradata/SBY1/sysaux01.dbf";
   set newname for datafile 4 to
 "/u01/app/oracle/oradata/SBY1/undotbs01.dbf";
   set newname for datafile 6 to
 "/u01/app/oracle/oradata/SBY1/users01.dbf";
   restore
   from service 'ORCL' clone database
   ;
   sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /u01/app/oracle/oradata/SBY1/temp01.dbf in control file

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 29-DEC-16
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service ORCL
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00001 to /u01/app/oracle/oradata/SBY1/system01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service ORCL
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00002 to /u01/app/oracle/oradata/SBY1/example01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:35
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service ORCL
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00003 to /u01/app/oracle/oradata/SBY1/sysaux01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:45
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service ORCL
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00004 to /u01/app/oracle/oradata/SBY1/undotbs01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:14
channel ORA_AUX_DISK_1: starting datafile backup set restore
channel ORA_AUX_DISK_1: using network backup set from service ORCL
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_AUX_DISK_1: restoring datafile 00006 to /u01/app/oracle/oradata/SBY1/users01.dbf
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
Finished restore at 29-DEC-16

sql statement: alter system archive log current

contents of Memory Script:
{
   switch clone datafile all;
}
executing Memory Script

datafile 1 switched to datafile copy
input datafile copy RECID=1 STAMP=931844747 file name=/u01/app/oracle/oradata/SBY1/system01.dbf
datafile 2 switched to datafile copy
input datafile copy RECID=2 STAMP=931844747 file name=/u01/app/oracle/oradata/SBY1/example01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=3 STAMP=931844747 file name=/u01/app/oracle/oradata/SBY1/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=4 STAMP=931844747 file name=/u01/app/oracle/oradata/SBY1/undotbs01.dbf
datafile 6 switched to datafile copy
input datafile copy RECID=5 STAMP=931844747 file name=/u01/app/oracle/oradata/SBY1/users01.dbf
Finished Duplicate Db at 29-DEC-16

RMAN> exit

```

**[node112.oracle.me](http://node112.oracle.me) (standby)**

Standby log файл нэмэх. Нийт одоогийн байгаа нийт лог файлаас нэгээр их байна.

```
SQL> alter system set fal_server=ORCL;
System altered.

SQL> col member format a40
SQL> select group#,status,member from v$logfile;

    GROUP# STATUS MEMBER
---------- ------- ----------------------------------------
	 3 /u01/app/oracle/oradata/ORCL/redo03.log
	 2 /u01/app/oracle/oradata/ORCL/redo02.log
	 1 /u01/app/oracle/oradata/ORCL/redo01.log

SQL>
SQL> alter database add standby logfile group &a ('/u01/app/oracle/oradata/SBY1/re&a') size 50m;
Enter value for a: 4
Enter value for a: 4.log
old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/SBY1/re&a') size 50m
new 1: alter database add standby logfile group 4 ('/u01/app/oracle/oradata/SBY1/re4.log') size 50m

Database altered.

SQL> /
Enter value for a: 5
Enter value for a: 5.log
old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/SBY1/re&a') size 50m
new 1: alter database add standby logfile group 5 ('/u01/app/oracle/oradata/SBY1/re5.log') size 50m

Database altered.

SQL> /
Enter value for a: 6
Enter value for a: 6.log
old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/SBY1/re&a') size 50m
new 1: alter database add standby logfile group 6 ('/u01/app/oracle/oradata/SBY1/re6.log') size 50m

Database altered.

SQL> /
Enter value for a: 7
Enter value for a: 7.log
old 1: alter database add standby logfile group &a ('/u01/app/oracle/oradata/SBY1/re&a') size 50m
new 1: alter database add standby logfile group 7 ('/u01/app/oracle/oradata/SBY1/re7.log') size 50m

Database altered.

```

Standby-ийг ажиллуулах

```
SQL> recover managed standby database disconnect;
Media recovery complete.

```

Дараах коммандыг бүх сервер дээр ажиллуулж харьцуулж харж шалгаж болно.

```
-- standby
 SQL> select sequence#,applied,status, to_char(first_time,'dd-mm-yyyy hh24:mi:ss') from v$archived_log;

 SEQUENCE# APPLIED S TO_CHAR(FIRST_TIME,
---------- --------- - -------------------
	15 IN-MEMORY A 29-12-2016 00:23:37
	14 YES A 29-12-2016 00:11:34
	16 YES A 29-12-2016 00:23:53
	17 NO A 29-12-2016 00:25:08

-- primary
SQL> select sequence#,applied,status, to_char(first_time,'dd-mm-yyyy hh24:mi:ss') from v$archived_log;

 SEQUENCE# APPLIED S TO_CHAR(FIRST_TIME,
---------- --------- - -------------------
	 9 NO A 28-12-2016 02:39:11
	10 NO A 28-12-2016 02:41:44
	11 NO A 29-12-2016 00:02:45
	12 NO A 29-12-2016 00:05:49
	13 NO A 29-12-2016 00:07:22
	14 NO A 29-12-2016 00:11:34
	15 NO A 29-12-2016 00:23:37
	15 YES A 29-12-2016 00:23:37
	14 YES A 29-12-2016 00:11:34
	16 NO A 29-12-2016 00:23:53
	16 YES A 29-12-2016 00:23:53
	17 NO A 29-12-2016 00:25:08
	17 NO A 29-12-2016 00:25:08

13 rows selected.

```

Standby-ийг зогсоох, болиулахдаа дараах коммандыг ажиллуулна.

```
SQL> recover managed standby database cancel;
Media recovery complete.

```

Уг процесс эхэлсэн эсэхийг мөн дараах байдлаар шалгаж болно.

```
[oracle@node112 ~]$ ps aux | grep mrp
oracle 5640 0.0 1.9 826808 40324 ? Ss 05:49 0:00 ora_mrp0_SBY1
oracle 6674 0.0 0.0 61180 760 pts/1 S+ 06:57 0:00 grep mrp
[oracle@node112 ~]$

```

---

<div class="post-metadata">

**Author:** ![nyambayar](https://www.batmunkh.net/user_avatar/www.batmunkh.net/nyambayar/32/209_2.png) [@nyambayar](https://www.batmunkh.net/u/nyambayar)\
**Post date:** [October 4, 2017, 12:57am UTC](https://www.batmunkh.net/t/physical-standby/75/2 "2017-10-04T00:57:41Z")

</div>

Энэ заавраар windows server, oralce 11g r2 дээр хийхэд асуух зүйл байна:  
1.

> [@batmunkh](#):
>
> /u01/app/oracle/fast\_recovery\_area

энэ миний тохиолдолд C:\app\Administrator\flash\_recovery\_area гэж байна зөв үү?  
2.

> [@batmunkh](#):
>
> Засварлаж тохируулсан pfile-ийг standby сервер рүү хуулах  
> [oracle@node111 ~]$ scp /tmp/initSBY1.ora [oracle@node112.oracle.me](mailto:oracle@node112.oracle.me):/tmp/

Энэ /tmp/ directory-г windows дээр олдоггүй ээ

---

<div class="post-metadata">

**Author:** ![nyambayar](https://www.batmunkh.net/user_avatar/www.batmunkh.net/nyambayar/32/209_2.png) [@nyambayar](https://www.batmunkh.net/u/nyambayar)\
**Post date:** [October 4, 2017, 2:10am UTC](https://www.batmunkh.net/t/physical-standby/75/3 "2017-10-04T02:10:08Z")

</div>

Энэ өмнө асуусан 2-оо учрыг нь олчихлоо одоо  
3.

Нууц үгний файлыг хуулах. Ингэснээр standby бааз руу primary баазын sys хэрэглэгчийн нууц үгийг ашиглан хандах боломжтой болно  
[oracle@node111 ~]$ cd /u01/app/oracle/product/12.1.0/db\_1/dbs  
[oracle@node111 dbs]$ scp orapwORCL [node112.oracle.me](http://node112.oracle.me):/u01/app/oracle/product/12.1.0/db\_1/dbs/orapwS

Энэ дээр л манараад байна. Энэ path дээр дараах file-ууд байна аль нь юм болоо?  
init.ora  
opctrn11.h  
opctrn11  
oracle11  
perf11.ora  
Эсвэл үүсгэдэг юм уу? Бас хуулахдаа дарж хуулах уу?

---

<div class="post-metadata">

**Author:** ![nyambayar](https://www.batmunkh.net/user_avatar/www.batmunkh.net/nyambayar/32/209_2.png) [@nyambayar](https://www.batmunkh.net/u/nyambayar)\
**Post date:** [October 5, 2017, 1:55am UTC](https://www.batmunkh.net/t/physical-standby/75/4 "2017-10-05T01:55:55Z")

</div>

Ийм алдаа зааж байгаа

 ![auxiliary](https://www.batmunkh.net/uploads/default/original/1X/7729a87aa4f0755150d72a0948b241d7a72b830b.PNG)

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [October 5, 2017, 2:18pm UTC](https://www.batmunkh.net/t/physical-standby/75/5 "2017-10-05T14:18:17Z")

</div>

orapw{SID} файл 2 сервер дээр байх шаардлагатай. Гаднаас хандахад ашиглагддаг файл.

$ORACLE\_HOME/dbs хавтсанд байрлана

---

<div class="post-metadata">

**Author:** ![nyambayar](https://www.batmunkh.net/user_avatar/www.batmunkh.net/nyambayar/32/209_2.png) [@nyambayar](https://www.batmunkh.net/u/nyambayar)\
**Post date:** [October 6, 2017, 12:42am UTC](https://www.batmunkh.net/t/physical-standby/75/6 "2017-10-06T00:42:04Z")

</div>

Минийх windows server yumaa

> [@batmunkh](#):
>
> $ORACLE\_HOME/dbs хавтсанд байрлана

энэ хавтасанд: orapw{SID} ийм file алга

> [@nyambayar](#):
>
> init.ora
> 
> opctrn11.h
> 
> opctrn11
> 
> oracle11
> 
> perf11.ora

дараах file-ууд л байна

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [October 6, 2017, 10:16am UTC](https://www.batmunkh.net/t/physical-standby/75/7 "2017-10-06T10:16:54Z")

</div>

orapwd коммандын тусламжтайгаар үүсгэж болно.

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [October 7, 2017, 5:56am UTC](https://www.batmunkh.net/t/physical-standby/75/8 "2017-10-07T05:56:51Z")

</div>

Видео хичээл бэлтгэж орууллаа.

---

<div class="post-metadata">

**Author:** ![muunuu](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/m/7cd45c/32.png) [@muunuu](https://www.batmunkh.net/u/muunuu)\
**Post date:** [November 20, 2018, 10:14am UTC](https://www.batmunkh.net/t/physical-standby/75/9 "2018-11-20T10:14:34Z")

</div>

duplicate хийхэд ийм алдаа гарч яах ёстой юм бол

 ![image](https://www.batmunkh.net/uploads/default/original/1X/4743581b68628c5d46567079e74c3d7758965f20.png)

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [November 20, 2018, 12:11pm UTC](https://www.batmunkh.net/t/physical-standby/75/10 "2018-11-20T12:11:57Z")

</div>

set newname нөхцлийг ашиглаад файлуудын нэрээ зөв замруу хөрвүүлчих

---

<div class="post-metadata">

**Author:** ![tumenjargal](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tumenjargal/32/236_2.png) [@tumenjargal](https://www.batmunkh.net/u/tumenjargal)\
**Post date:** [November 20, 2018, 12:14pm UTC](https://www.batmunkh.net/t/physical-standby/75/11 "2018-11-20T12:14:01Z")

</div>

Dupilcate нь энгийнээр “restore control file”, “restore database”, recover хийх үйлдлүүдийг parameter, tns, listener файлуудийн дагуу bundle - аар нь хийдэг. Өөрөөр хэлбэл бүх config duplicate хийхээс өмнө зөв байх ёстой. Доорх мэдээллүүд, коммандын үр дүнг явуулаач хө.

- init файл
- tnsnames.ora
- lsnrctl services
- select name from v$datafile;
- rman connect хийж байгаа комманд

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [November 20, 2018, 12:20pm UTC](https://www.batmunkh.net/t/physical-standby/75/12 "2018-11-20T12:20:57Z")

</div>

Өдөр RAC to Single DG тохируулж байхад гарч байсан алдаа байнаа. ASM -с файлсистем рүү хөрвүүлж чадахгүй болохоор нь set newname ашиглаад явуулчихсан. Араас нь duplicate коммандаа залгуулаад явуулна .

```
run{
    set newname for datafile 1 to '/u01/app/oracle/oradata/ORCL/datafile/01.dbf';
    set newname for datafile 2 to '/u01/app/oracle/oradata/ORCL/datafile/02.dbf';
    duplicate target database for standby from active database nofilenamecheck;
}

```

19505 яг санаж байна 😃 db\_file\_name\_convert болохгүй байна лээ. 11.2.0.4 байсан билүү дээ.

---

<div class="post-metadata">

**Author:** ![batchimeg.b](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/ee7513/32.png) [@batchimeg.b](https://www.batmunkh.net/u/batchimeg.b)\
**Post date:** [April 2, 2019, 4:23am UTC](https://www.batmunkh.net/t/physical-standby/75/13 "2019-04-02T04:23:58Z")

</div>

HI guys 🙂  
yu asuuyaa? Physical standby tohiruulsan chin primary database deer log switch hiigdsenii daraa l data n standby.ruu orj ireed bh yum. Shuud real time ywdagguie. primary.iin archive log version.gees standby.iin archive log version +1 eer iluu ywaad bh yum. Medlegeesee huwaaltsaach

---

<div class="post-metadata">

**Author:** ![tumenjargal](https://www.batmunkh.net/user_avatar/www.batmunkh.net/tumenjargal/32/236_2.png) [@tumenjargal](https://www.batmunkh.net/u/tumenjargal)\
**Post date:** [April 2, 2019, 12:45pm UTC](https://www.batmunkh.net/t/physical-standby/75/14 "2019-04-02T12:45:03Z")

</div>

- Хэрвээ standby logfile нэмсэн бол “using current logfile” option - г нэмээд real-time apply хийдэг. DR бааз нь Standby logfile - с recover хийнэ гэсэн үг.  
alter database recover managed standby database using current logfile disconnect from session;

Одоогийн хоцроод байгаа нь доорх шиг холбосон байж магад, эсвэл standby logfile байхгүй,  
alter database recover managed standby database disconnect from session;

Мөн дата өөрчлөлт их байдаг бол standby logfile чинь багадаж байж магадгүй 🙂

---

<div class="post-metadata">

**Author:** ![batchimeg.b](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/b/ee7513/32.png) [@batchimeg.b](https://www.batmunkh.net/u/batchimeg.b)\
**Post date:** [April 18, 2019, 3:13am UTC](https://www.batmunkh.net/t/physical-standby/75/15 "2019-04-18T03:13:27Z")

</div>

Hi,

Standby database serveree restart хийсний дараа баазаа Stanby-аар асаах гэсэн ийм алдаа зааж байна. ALTER database recover managed standby database disconnect from session;  
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect from session; хийгээд archive log-уудаа хуулахгүй байна. Үүнийг хэрхэн шийдвэрлэх вэ? Туслаач нөхдөө 🙂

 ![rman](https://www.batmunkh.net/uploads/default/original/1X/efbdc4b9bd3247041053909bfe68b4f13b5b253d.jpeg)

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [April 18, 2019, 3:42am UTC](https://www.batmunkh.net/t/physical-standby/75/16 "2019-04-18T03:42:29Z")

</div>

```
recover managed standby database disconnect;

```

гээд хэсэг хүлээ. recovery хэрэгтэй гэсэн үг. mount горимоос хэсэг явуулах шаардлагатай.

---

<div class="post-metadata">

**Author:** ![zolboo](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/z/e47774/32.png) [@zolboo](https://www.batmunkh.net/u/zolboo)\
**Post date:** [January 30, 2021, 8:04am UTC](https://www.batmunkh.net/t/physical-standby/75/17 "2021-01-30T08:04:48Z")

</div>

Standby database server дээрээ  
alter database open; хийхээр ийм алдаа өгч байгаа.  
Дараах 2 командыг ажиллуулаад дахин alter database open; хийсэн ялгаагүй байгааг хэрхэн шийдвэрлэх вэ? guys

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;  
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT;

 ![Screenshot 2021-01-29 194123](https://www.batmunkh.net/uploads/default/original/1X/c9f13e9489f336924e3e5390a372fb9d9dbd8107.png)

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [January 30, 2021, 9:19am UTC](https://www.batmunkh.net/t/physical-standby/75/18 "2021-01-30T09:19:45Z")

</div>

recovery процессоо нилээд явуулж байгаад өгөгдөл зэрэгцсэний дараа л open хийж болно доо. Шууд хоцрогдолтой үед болохгүй

---

<div class="post-metadata">

**Author:** ![zolboo](https://www.batmunkh.net/letter_avatar_proxy/v4/letter/z/e47774/32.png) [@zolboo](https://www.batmunkh.net/u/zolboo)\
**Post date:** [January 30, 2021, 9:20pm UTC](https://www.batmunkh.net/t/physical-standby/75/19 "2021-01-30T21:20:09Z")

</div>

RMAN-н дараах командаар файлуудаа зэрэгцүүлээд асуудлаа шийдвэрлэсэн.

duplicate target database for standby from active database nofilenamecheck;

---

<div class="post-metadata">

**Author:** ![batmunkh](https://www.batmunkh.net/user_avatar/www.batmunkh.net/batmunkh/32/297_2.png) [@batmunkh](https://www.batmunkh.net/u/batmunkh)\
**Post date:** [January 31, 2021, 8:49am UTC](https://www.batmunkh.net/t/physical-standby/75/20 "2021-01-31T08:49:25Z")

</div>

duplicate хийсний дараагаар recovery процессийг ажиллуулж өгөгдөл тэнцтэл хүлээж таардаг.

[Next page](https://www.batmunkh.net/t/physical-standby/75.md?page=2)