oracle 11G dataguard 恢复
程序员文章站
2022-08-09 10:53:39
检查主备机的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;