New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

curlog #2

Open

baobao219 opened this issue Jan 21, 2019 · 1 comment

baobao219 commented Jan 21, 2019

在RAC环境中，无法正确执行curlog.sql脚本，建议修改如下
select member from v$logfile where group# in (select group# from v$log where status = 'CURRENT');
即将“=”修改为"in"

Author

baobao219 commented Jan 21, 2019

或者修改成如下内容
SELECT
member
FROM
v$logfile
WHERE
group# =(
SELECT
group#
FROM
v$log
WHERE
status = 'CURRENT'
AND thread# = userenv('instance')
);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment