Oracle 10g DG 数据文件迁移的实现

 Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select name, database_role, open_mode from gv$database;

NAME   DATABASE_ROLE  OPEN_MODE
--------- ---------------- ----------
JY    PHYSICAL STANDBY MOUNTED

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.

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:04:20
apply lag             +00 00:00:12                           day(2) to second(0) interval  05-MAY-2018 10:04:20
estimated startup time       41                                second             05-MAY-2018 10:04:20
standby has been open       N                                                05-MAY-2018 10:04:20
transport lag           +00 00:00:00                           day(2) to second(0) interval  05-MAY-2018 10:04:20