Skip to content

create standby database

create standby database published on 1 комментарий к записи create standby database

*copy passwd file from primary
scp $ORACLE_HOME/dbs/passwd$ORACLE_SID{instance_number}
cp [pwd file from primary] orapw$ORACLE_SID

*create static listener

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
     (GLOBAL_DBNAME = u41testdb.rt.ru)
     (ORACLE_HOME = /oracle/app/base/db/12.1.0.2)
     (SID_NAME = s41testdb)
    )
   )

create audit directory:

mkdir -p /oracle/app/base/admin/s41testdb

create asm directory:

ASMCMD [+] > mkdir +DATA/u41testdb

*startup dummy instance:


echo db_name='db_name' > pfile.ora
startup nomount pfile='pfile.ora'

*connect auxiliary instance +connect target instance

rman target sys/xxxxx@u41testdb auxiliary sys/xxxxx@s41testdb
RMAN> duplicate target database for standby from active database spfile set "db_unique_name"="s41testdb" set "cluster_database"="false" set "audit_file_dest"="/oracle/app/base/admin/s41testdb";

DGMGRL> create configuration u41dg as primary database is u41testdb connect identifier is u41testdb	;
Configuration "u41dg" created with primary database "u41testdb"
DGMGRL> add database s41testdb as connect identifier is s41testdb maintained as physical;
Database "s41testdb" added
DGMGRL> enable configuration;
Enabled.
DGMGRL>

1 комментарий

run {
allocate channel prmy1 type disk rate 50m;
allocate auxiliary channel stby type disk rate 50m;
duplicate target database for standby from active database
spfile
set «DB_UNIQUE_NAME»=»P00TEST»
set «audit_file_dest»=»/oracle/app/base/admin/p00TEST/audmp»
set «db_file_name_convert»=»+DATA/S00TEST/»,»+DATA/P00TEST/», «+REDO/S00TEST/»,»+REDO/P00TEST/»
set «log_file_name_convert»=»+DATA/S00TEST/»,»+DATA/P00TEST/», «+REDO/S00TEST/»,»+REDO/P00TEST/»
set «use_large_pages»=»false»;
}

Добавить комментарий

Ваш e-mail не будет опубликован. Обязательные поля помечены *

Primary Sidebar

Яндекс.Метрика