暂无图片
oracle 11g 备库undo_tablespace
我来答
我是路人甲
2024-04-17
oracle 11g 备库undo_tablespace

oracle 11.2.0.4 主库rac,备库单实例,发现备库undo_tablespace参数为空未设置,会有不利的影响吗?

我来答
添加附件
收藏
问题补充
2条回答
默认
最新
我是路人甲

UNDO_TABLESPACE

Parameter type
Syntax
Default value
Modifiable
Range of values
Basic
String
UNDO_TABLESPACE = undoname
The first available undo tablespace in the database.
ALTER SYSTEM
Legal name of an existing undo tablespace
Yes
Oracle RAC Each instance must have a unique value for this parameter, when it is
set.

If the UNDO_TABLESPACE parameter is omitted, the first available undo tablespace in the
database is chosen. If no undo tablespace is available, the instance will start without an
undo tablespace. In such cases, user transactions will be executed using the SYSTEM
rollback segment. You should avoid running in this mode under normal
circumstances.  

暂无图片 评论
暂无图片 有用 0
暂无图片
yhd_my

当然会有,你的备库要切换成主库时,没有undo_tablespace可以吗?

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏