1、重新安装grid
删除grid目录所有文件,删除oracle目录所有文件,然后在做如下清理:
[root@rac_1 grid]# rm -rf /etc/ora*
[root@rac_1 grid]# rm -rf /opt/app/grid/*
[root@rac_1 grid]# rm -rf /usr/local/bin/dbhome
[root@rac_1 grid]# rm -rf /usr/local/bin/oraenv
[root@rac_1 grid]# rm -rf /usr/local/bin/coraenv
[root@rac_1 grid]# rm -rf /opt/app/oraInventory
2、dd命令
dd if=从哪里来 of=到哪里去 bs=块大小 count=块数量
3、安装节点执行脚本root.sh的时候,注意实时监控日志文件,文件的路径:$ORACLE_HOME/log,然后执行命令: tail –f alert*.log
4、数据库集群配置
4.1、添加数据库到集群
srvctl add database –d rac –o [$OACLE_HOME]
4.2、添加实例
srvctl add instance –d rac –i rac1
srvctl add instance –d rac –i rac2
4.3、启动数据库
srvctl start database –d rac
启动过程中实时监控告警日志:
cd $ORACLE_BASE/diag/rdbms/rac/rac1/rac1/trace
tail –f alert*.log
4.4、启动实例
srvctl start instance –d rac –i rac1
srvctl start instance –d rac –i rac2
4.5、查看数据库状态
srvctl status database –d rac
5、命令行里查看磁盘组的挂载情况
$asmcmd
ASMCMD>lsdg
6、创建目录
mkdir -p /data/app/oracle/admin/rac/adump
mkdir -p /data/app/oracle/admin/rac/bdump
mkdir -p /data/app/oracle/admin/rac/dump
select status from v$instance;
expdp system/oracle directory=datadump dumpfile=fumao_zh.dmp logfile=fumao_zh.log schemas=fumao_zh
SQL> create directory datadump as '/home/oracle/088';
SQL> grant read,write on directory datadump to system;
可能会报错:
ORA-39006: internal error
ORA-39213: Metadata processing is no
可以用命令试一试如下:
1.select * from dba_objects where object_name='DBMS_DATAPUMP';
没有内容就执行以下包
2.exec sys.dbms_metadata_util.load_stylesheets
还有一种可能,就是恢复目标表空间不够大。大于原空间大小试试。
impdp system/oracle directory=datadump dumpfile=fumao_zh.dmp logfile=fumao_zh.log remap_schema=fumao_zh:fumao_zh table_exists_action=replace
2013-08-08 18:20:49 Phoenix
[grid@rac01 rac01]$ oerr ora 28000
28000, 00000, "the account is locked"
// *Cause: The user has entered wrong password consequently for maximum
// number of times specified by the user's profile parameter
// FAILED_LOGIN_ATTEMPTS, or the DBA has locked the account
// *Action: Wait for PASSWORD_LOCK_TIME or contact DBA
select 'expdp system/oracle directory=datadump dumpfile=' ||username||'.dmp' || ' logfile='||username||'.log'
from dba_users where username ='&username';