real-time 실습

[21기_이상민]

ALTER SYSTEM SET log_archive_dest_2='service="sbdb" SYNC AFFIRM NODELAY optional compression=disable max_failure=0 reopen=300 db_unique_name="sbdb" net_timeout=30 valid_for=(online_logfile,all_roles)';


폴더는 경로 설정
 ALTER DATABASE ADD STANDBY LOGFILE
  GROUP 10 ('/u01/app/oracle/oradata/SBDB/stby_redo10.log') SIZE 100M,
  GROUP 11 ('/u01/app/oracle/oradata/SBDB/stby_redo11.log') SIZE 100M,
  GROUP 12 ('/u01/app/oracle/oradata/SBDB/stby_redo12.log') SIZE 100M,
  GROUP 13 ('/u01/app/oracle/oradata/SBDB/stby_redo13.log') SIZE 100M,
  GROUP 14 ('/u01/app/oracle/oradata/SBDB/stby_redo14.log') SIZE 100M,
  GROUP 15 ('/u01/app/oracle/oradata/SBDB/stby_redo15.log') SIZE 100M;