Oracle 10g DG 数据文件迁移案例分析(3)

Do you really want to delete the above objects (enter YES or NO)? yes
deleted datafile copy
datafile copy filename=/datafile/data9.dbf recid=13 stamp=975320371
deleted datafile copy
datafile copy filename=/datafile/data10.dbf recid=14 stamp=975320371
deleted datafile copy
datafile copy filename=/datafile/datafile11.dbf recid=15 stamp=975320371
Deleted 3 objects

4.2 开启日志应用:
SQL> --recover_std_real
SQL> alter database recover managed standby database using current logfile disconnect from session;

Database altered.

SQL> set lines 1000
SQL> select * from v$dataguard_stats;

NAME                            VALUE                                                            UNIT                          TIME_COMPUTED
-------------------------------- ---------------------------------------------------------------- ------------------------------ ------------------------------
apply finish time                +00 00:00:00.0                                                  day(2) to second(1) interval  05-MAY-2018 10:20:56
apply lag                        +00 00:02:00                                                    day(2) to second(0) interval  05-MAY-2018 10:20:56
estimated startup time          41                                                              second                        05-MAY-2018 10:20:56
standby has been open            N                                                                                              05-MAY-2018 10:20:56
transport lag                    +00 00:00:00                                                    day(2) to second(0) interval  05-MAY-2018 10:20:56

SQL>  select recovery_mode from v$archive_dest_status;

RECOVERY_MODE
-----------------------
MANAGED REAL TIME APPLY
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE
IDLE

11 rows selected.

至此,就完成了客户的需求,我们可以多思考一下,如果客户环境是11g的ADG环境呢?会有哪些不同呢?

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/1d543603d11fdebf73ab2133b432b5f4.html