备库查询导致的ORA(2)

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00021 to /U01/app/oracle/oradata/TEST/TEST_new_index04.dbf
channel ORA_DISK_1: reading from backup piece /U01/app/oracle/temp/full_1804_908984436_1
channel ORA_DISK_1: restored backup piece 1
piece handle=/U01/app/oracle/temp/full_1804_908984436_1 tag=TAG20160412T154036
channel ORA_DISK_1: restore complete, elapsed time: 00:00:36
Finished restore at 12-APR-16

这个时候不用重启备库,数据文件的SCN就自然推进到了新的值,再次查看数据文件的状态就变为了ONLINE.
通过这个案例可以看出,对于数据文件的操作还是需要非常谨慎,对于数据文件的状态监控也应该是运维监控的一个重要参考。

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

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