Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › oracle11g R2 版本1 ， gv$archived_log.name is nULL ...

0 积分	0 好友	1 主题

发消息

[SQL调优] oracle11g R2 版本1 ， gv$archived_log.name is nULL

1^#

发表于 2012-12-5 14:31:57 | 查看: 4500| 回复: 4

基本信息：
1. 操作系统：sun solaris 5.0
2. 数据库版本: oracle 11g r2 11.2.0.1.0
3. 做的是rac

用pl/sql 工具查询时出现：v$archived_log.name is nULL 如下图。

分享0

收藏0 回复只看该作者道具举报

xifenfei

2^#

发表于 2012-12-5 22:11:29

因为归档日志被rman删除了

回复只看该作者道具举报

psufnxk2000

3^#

发表于 2012-12-6 00:15:32

Archived log file name. If set to NULL, either the log file was cleared before it was archived or an RMAN backup command with the "delete input" option was executed to back up archivelog all (RMAN> backup archivelog all delete input;).

回复只看该作者道具举报

Liu Maclean(刘相兵

4^#

发表于 2012-12-6 13:24:00

using RMAN backup of archivelog all; with the "delete input" option will
remove "NAME" from V$ARCHIVED_LOG for those archivelog sequences in 10g.

In earlier releases like 9i we still kept the "NAME" of those archivelog
sequence# even if a rman backup of archive log all with "delete input" option
was used.

回复只看该作者道具举报

lb6201883

5^#

发表于 2012-12-6 13:36:09

Thanks for all

回复只看该作者道具举报

返回列表

		自动登录	找回密码
密码			注册