|
# 18830
Chi
来自: Mexico
|
 |
|
 |
|
|
 To: Eygle
Need your help.
1.How to run the rman script with cron under Redhat ES3/ Oracle 10.2.0.2
I had a rman script under the oracle user shell:
rman target sys/pw@backup nocatalog <<EOF
run
{ backup as backupset incremental level 1 cumulative device type disk tag 'Thu_full_bkup%LEVEL_1' database;
recover copy of database;
backup device type disk tag 'Thu_full_bkup%LEVEL_1' archivelog all not backed up;
delete noprompt obsolete device type disk;
}
exit
EOF
and the cron job as "44 17 * * * /home/oracle/orabackup.sh >> /home/oracle/rmanbk.log 2>&1, but i got error message as "rman: command not found", tried puttin shell at the beginning of the script, not work either, either the job run under the root.Manually run the script or using the path worked.
2.My supervisor, a mexican, wants to travel to Bejing with his wife next March, he worries about his language, little English, absolute no Chinese.are most of the Hotel services in Bejing, and Xian, spanish friendly? Any advice.Thanks.
From: Chi
2006.10.24 00:10
|
|
|
 |
|
 |
 |
|
 |
|
|
To: Chi
rman: command not found 显然是环境变量的问题，你需要在脚本前设置环境变量。
关于旅行：）英语在北京应该能够被较为广泛的理解，其它语言则可能存在问题。
我建议通过大使馆了解一下情况。
From: eygle
2006.10.25 17:17
|
|
|
|
|
# 18828
hounanhai
|
|
|
To: Eygle
您好！
我也觉得OPS是主要考虑到冗余和负载BLANCE而设计的，但我的系统目前只用到了冗余效果，并没有负载BLANCE。所以，我想将一些后台任务在备用的INSTANCE上进行，但老大不同意，说这样可能会产生
BLOCK DEAD，我很不明白，为什么？
From: hounanhai
2006.10.23 12:28
|
|
|
|
|
To: hounanhai
OPS由于技术上的缺陷，Block在不同实例上如果引发竞争，性能的确会非常低下。
From: eygle
2006.10.25 17:19
|
|
|
|
|
# 18822
qingcaimaomao
|
|
|
 To: eygle
首先BS一下乱留言的，有本事自己种块地去。
我一台数据库服务器上有2套环境,TEST和PROD.
能否只定义一套tnsname.ora和listener.ora,然后启动一个LISTENER进程?然后在tnsname.ora和listener.ora中分别定义好TEST和PROD的SID?
目前是2套tnsname.ora和listener.ora,运行正常.
谢谢eygle
From: qingcaimaomao
2006.10.22 21:35
|
|
|
|
|
To: qingcaimaomao
一个监听器监听多个实例，这很容易做到，不过ERP软件，你最好尽量保持2个实例的独立性：）
From: eygle
2006.10.23 11:18
|
|
|
|
|
# 18809
qingcaimaomao
|
|
|
 To: eygle
我一台数据库服务器上有2套环境,TEST和PROD.
能否只定义一套tnsname.ora和listener.ora,然后启动一个LISTENER进程?然后在tnsname.ora和listener.ora中分别定义好TEST和PROD的SID?
目前是2套tnsname.ora和listener.ora,运行正常.
From: qingcaimaomao
2006.10.21 23:03
|
|
|
|
|
eygle.com
我要留言
回复
编辑
To: 
