写了个生产库的备份脚本，大家帮忙挑一下，看哪里有问题

Yong Huang · 发表于 2009-8-14 22:22

> 用backup database plus archivelog，备份顺序让rman自己搞定好了，

Good suggestion.

> 连接到单实例中，并且type为disk，有没有必要分配3个通道希望高手们给些意见。

If he has enough CPU, why not use it? If you don't use it, you're wasting it anyway.

Yong Huang

c4313848 · 发表于 2009-8-17 08:48

原帖由 zhmengjun 于 2009-8-14 15:07 发表
if [ -d $BACKUP_PATH/data/$DATE/ ]; then
echo "----Delete the data backup ----"
#rm -rf $BACKUP_PATH/data/$DATE/*
else
echo "----auto create backup dir ----- $BACKUP_PATH/data/$DATE"
mkdir -p $BACKUP_PATH/data/$DATE
fi

1、mkdir -p $BACKUP_PATH/data/$DATE是不是要放在fi后面呢？还是我理解错了？

2、用backup database plus archivelog，备份顺序让rman自己搞定好了，

3、连接到单实例中，并且type为disk，有没有必要分配3个通道希望高手们给些意见。

1. 可能是你理解有问题，我上面的逻辑可能也有点问题，
上面的代码，
   原意是：如果当天不是第一次备份就删除当日前次备份。要是这样的话，就应该是
   if [ -d $BACKUP_PATH/data/$DATE/ ]; then
         echo "----Delete the data backup ----"
      rm -rf $BACKUP_PATH/data/$DATE/*
   fi

   echo "----auto create backup dir ----- $BACKUP_PATH/data/$DATE"
   mkdir -p $BACKUP_PATH/data/$DATE

   后来感觉删除当日前次备份这样做也不是很好，就把删除的代码去掉了。

3. 我机器上是有4个双核的CPU，就像上面说的，不用也浪费

c4313848 · 发表于 2009-8-17 08:55

备份顺序自己搞定也行，

上面那个脚本顺序没有问题。

是我自己恢复的时候做错了，

用第一次生产的控制文件，结果这个控制文件是在备份数据库的时候自己备份的，里面没有包含归档日志的信息。
应该用第二次生成的控制文件恢复才对（是在备份归档日志时候自动备份的）。

wxhoracle · 发表于 2009-8-19 17:30

no problem

niul_work · 发表于 2009-9-1 09:45

原帖由 Yong Huang 于 2009-8-6 22:46 发表
I don't see anything wrong. Can you run it to see if it works? Preferably run it once and use the backup to test restore. It the restored database works as expected, you're all done.

Some very minor comments:

(1) Can you say tag'something' without a space in between?
(2) Expect is pretty archaic now. It's interesting you're using it. To achieve maximum control, such as 20 seconds timeout?
(3) If this is a new database, why not use 10.2.0.4 or 11g?

Yong Huang

Yong Huang

对于第2点，我想知道对于pretty的替代工具是什么呢？

yellowlee · 发表于 2009-9-1 11:12

www.**.og ?

yellowlee · 发表于 2009-9-1 11:23

www.oracle.com ?

Yong Huang · 发表于 2009-9-2 00:29

>> (2) Expect is pretty archaic now. It's interesting you're using it.
>> To achieve maximum control, such as 20 seconds timeout?
>
> 对于第2点，我想知道对于pretty的替代工具是什么呢？

You mean replacement for Expect? I don't know any general replacement. But for specific tasks, authors of some tools are aware of the issue (i.e. users want to use his tool from a batch file) so they build the capability in the tool. For example, ftp has -n option, and sftp has -b. Read man page for details.

Yong Huang