2015年5月 – 但行好事莫问前程

今天单位的HP数据库容灾服务器在启动时出错，错误信息如下图所示:Warning:multiple console coutput devices are configured.If this message remains on the screen for more than a few miutes,then this is not the device in use by HP-UX as the console output device.If you would like this device to be the one used by HP-UX as the console output device,reboot and use the EFI boot manager or the EFI ‘conconfig’ command to select this device and deconfigure the others.错误信息说这台服务器已经配置了多个控制台输出设备。如果这个提示信息在屏幕上显示超过几分钟，那么这个输出设备没有被HP-UX作为控制输出设备。如果想让HP-UX使用这个设备作为控制台输出设备，重启服务器并使用EFI boot manager或者EFI的’conconfig’命令来选择这个设备并取消其它设备的配置。

而这台HP服务器之前是能够正常启动，最近也没人进行设置，很奇怪，根据错误信息的提示重启并进行设置。

首先在启动时进入EFI boot manager设置界面

选择Boot Configuration

选择Console Configuration

从上图中可以看到HP服务器现在主控制台输出配置为Serial Acpi,辅助输出设备为VGA,因为我这里配置的是KVM所以应该主控制台输出要设置为VGA才对，但之前同事说能正常启动，这里不再讨论原因，现在将VGA作为主控制台输出设备。

保存更改,服务器会自动重启

在将控制台输出设置为VGA后服务器可以正常启动了可以做容灾演验了

一个网友在linux下的11.2.0.4 中创建RMAN的虚拟私有目录报错:

[oracle@jb ~]$ rman

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:23:25 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

RMAN> connect catalog vpc1/vpc1@cs

connected to recovery catalog database

RMAN> create virtual catalog;

found eligible base catalog owned by RMAN
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-06004: ORACLE error from recovery catalog database: ORA-00942: table or view does not exist

从上面信息可以看到found eligible base catalog owned by RMAN,说明已经找到了合格的基本恢复目录用户,由于使用的基本恢复目录用户rman已经注册了数据库,于是新建一个基本恢复目录用户cat1，虚拟私有目录用户 virtcat

1.创建基本恢复目录用户cat1,虚拟私有目录用户virtcat

SQL> create user cat1 identified by cat1
  2       default tablespace sysaux
  3       quota unlimited on sysaux;

User created.

SQL> grant recovery_catalog_owner to cat1;

Grant succeeded.

SQL> create user virtcat identified by virtcat
  2       default tablespace sysaux
  3       quota unlimited on sysaux;

User created.

SQL> grant recovery_catalog_owner to virtcat;

Grant succeeded.

2.创建基本恢复目录

[oracle@jb ~]$ rman catalog cat1/cat1@cs

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:24:50 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create catalog;

recovery catalog created

RMAN> grant register database to virtcat;

Grant succeeded.

3.创建虚拟私有恢复目录

[oracle@jb cs]$ rman catalog virtcat/virtcat@cs

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:25:40 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to recovery catalog database

RMAN> create virtual catalog;

found ineligible base catalog owned by RMAN
found eligible base catalog owned by CAT1
created virtual catalog against base catalog owned by CAT1

4.在虚拟私有目录中注册目标数据库

[oracle@jb cs]$ rman target sys/system@db catalog virtcat/virtcat@cs

Recovery Manager: Release 11.2.0.4.0 - Production on Sun May 10 17:46:51 2015

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

connected to target database: DB (DBID=1640573015)
connected to recovery catalog database

RMAN> register database;

database registered in recovery catalog
starting full resync of recovery catalog
full resync complete

总结：在创建与使用虚拟私有恢复目录时，基本恢复目录中不能注册目标数据库，否则会出现RMAN-06004, ORA-00942错误信息。

月份：2015年5月

HP服务器控制台输出设置造成的启动故障

Oracle 11g创建虚拟私有目录RMAN-06004 ORA-00942错误的处理