Re: Re: 오늘의 마지막 문제. 백업과 복구 이수자 평가 4번 문제

[22기_권오현]

[oracle@ora19c dbs]$ cat initZEUS.ora
db_name=ZEUS
compatible=19.3.0
memory_target=1G
processes=300
undo_management=AUTO
undo_tablespace=UNDOTBS1
remote_login_passwordfile=EXCLUSIVE
db_unique_name=ZEUS
control_files=('/u01/app/oracle/oradata/ZEUS/disk1/ctrl1.ctl',
'/u01/app/oracle/oradata/ZEUS/disk2/ctrl2.ctl',
'/u01/app/oracle/oradata/ZEUS/disk3/ctrl3.ctl')

standby_file_management=auto

db_file_name_convert='/home/oracle/ZEUSSTBY','/u01/app/oracle/oradata/ZEUS'
log_file_name_convert='/home/oracle/ZEUSSTBY','/u01/app/oracle/oradata/ZEUS'

log_archive_dest_1='location=/home/oracle/ZEUS/arch valid_for=(all_logfiles,all_roles)'

log_archive_dest_2='service=ZEUSSTBY LGWR SYNC AFFIRM valid_for=(online_logfiles,primary_role)'

fal_server=ZEUSSTBY
fal_client=ZEUS

[oracle@ora19c dbs]$ cat initZEUSSTBY.ora
compatible=19.3.0.0
control_files = (/home/oracle/ZEUSSTBY/disk1/ctrl1.ctl ,
/home/oracle/ZEUSSTBY/disk2/ctrl2.ctl ,
/home/oracle/ZEUSSTBY/disk3/ctrl3.ctl )
db_block_size=8192
db_name=ZEUS
service_names=ZEUSSTBY
global_names=true
job_queue_processes=10
open_cursors=500
processes=100
remote_login_passwordfile='EXCLUSIVE'
memory_target=1G
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
db_recovery_file_dest_size=4G
db_recovery_file_dest=/home/oracle/ZEUSSTBY/flash
db_unique_name=ZEUSSTBY
standby_file_management=auto
db_file_name_convert='/u01/app/oracle/oradata/ZEUS','/home/oracle/ZEUSSTBY'
log_file_name_convert='/u01/app/oracle/oradata/ZEUS','/home/oracle/ZEUSSTBY'
log_archive_dest_1='location=/home/oracle/ZEUSSTBY/arch valid_for=(all_logfiles, all_roles)'
log_archive_dest_2='service=ZEUS LGWR SYNC AFFIRM valid_for=(online_logfiles, primary_role)'
#fal_server=ZEUS
#fal_client=ZEUSSTBY

[22기_권오현]

새롭게 standby 가 될 쪽의 fal_server=SBDB 와 fal_client=PROD 가 주석이 풀려있어야합니다.