區(qū)塊鏈滲透培訓(xùn)課程
備庫參數(shù)文件 db_unique_name='dgfghsdb' LOG_ARCHIVE_CONFIG='DG_CONFIG=(dgfghsdb,fghsdb)' LOG_ARCHIVE_DEST_1='LOCATION=USE_DB_RECOVERY_FILE_DEST VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=dgfghsdb' LOG_ARCHIVE_DEST_2='SERVICE=fghsdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=fghsdb' log_archive_format='%T_%s_%r.arc' fal_client='dgfghsdb' FAL_SERVER='fghsdb' DB_FILE_NAME_CONVERT='/oradata/fghsdb','/oradata/dgfghsdb' LOG_FILE_NAME_CONVERT='/oradata/fghsdb','/oradata/dgfghsdb' standby_file_management=AUTO rman target sys/oracle@fghsdb auxi1iary sys/oracle@dgfghsdb duplicate target database f0r standby from active database; alter database recover managed standby database disconnect from session; alter database recover managed standby database cancel; alter database recover managed standby database using current logfile disconnect from session; SELECT UNIQUE THREAD#, MAX(SEQUENCE#) OVER(PARTITION BY THREAD#) LAST FROM V$ARCHIVED_LOG; SELECT THREAD#, L