檢查主備機的sys 密碼是否一致,忘記密碼可以修改,同步 。alter user sys identified by xxx; orapwd file=oraxxx.ora password=admin entries=40force=y; 檢查靜態tnsnames.ora 和listener.or... ...
- 檢查主備機的sys 密碼是否一致,忘記密碼可以修改,同步 。alter user sys identified by xxx; orapwd file=oraxxx.ora password=admin entries=40 force=y;
- 檢查靜態tnsnames.ora 和listener.ora ,確保正常測試:sqlplus sys/oracle@COMSTAR2 as sysdba / sqlplus sys/oracle@COMSTAR1 as sysdba
- 備庫 sql>shutdown immediate,刪除原有的數據文件。
- rman target sys/oracle@comstar1 auxiliary sys/oracle@comstar2 nocatalog
- duplicate target database for standby from active database nofilenamecheck;