12 2019 档案

Oracle rac环境下数据文件误建在本地目录的处理过程
摘要：错误描述Mon Nov 16 19:02:38 2015Errors in file /u01/app/oracle/diag/rdbms/zwzwdb/zwzwdb1/trace/zwzwdb1_m000_27416.trc:ORA-01157: cannot identify/lock data file 18 - see DBWR trace fileORA-01110: data file... 阅读全文
posted @ 2019-12-27 15:48 小草一亩三分地 阅读(792) 评论(0) 推荐(1)
aix 静默安装 转载
摘要：# oslevel -s7100-02-02-1316软件：aix.ppc64_11gR2_database_1of2.zipaix.ppc64_11gR2_database_2of2.zip1.创建oinstall、dba组和oracle用户mkgroup -A oinstallmkgroup -A dbamkuser pgrp='oinstall' groups=dba oracle2.创建o... 阅读全文
posted @ 2019-12-16 22:00 小草一亩三分地 阅读(213) 评论(0) 推荐(0)
rman异机异构恢复
摘要：一.源端数据库全备1.全库备份脚本cat rman_full_backup.shsource /home/oracle/.bash_profilerman target / log=/home/oracle/backup/logs/backupall_rman.logrestore controlfile from '/app/backup/backup/backupsets/ora_cfc-39... 阅读全文
posted @ 2019-12-10 11:13 小草一亩三分地 阅读(508) 评论(0) 推荐(0)