[已解決]将oracle数据库备份到存储上,是否要将备份脚本的SBT_TAPE改为DISK?

bowmanleong

现在的脚本是:
CMD_STR="
ORACLE_HOME=$ORACLE_HOME
export ORACLE_HOME
ORACLE_SID=$ORACLE_SID
export ORACLE_SID
$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append << EOF
RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
echo send 'NB_ORA_POLICY=oracle_database_full, NB_ORA_SERV=vasbackup';
backup spfile;
BACKUP
    $BACKUP_TYPE
    SKIP INACCESSIBLE
    TAG hot_db_bk_level0
    FILESPERSET 5
    # recommended format
    FORMAT 'bk_%s_%p_%t'
    DATABASE;
    sql 'alter system archive log current';
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
echo send 'NB_ORA_POLICY=oracle_database_full, NB_ORA_SERV=vasbackup';
BACKUP
   filesperset 20
   FORMAT 'al_%s_%p_%t'
   ARCHIVELOG ALL;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
DELETE NOPROMPT ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-3';
RELEASE CHANNEL ch00;

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
策略每次进行的时候,都会出现下面的报错:
22:59:35.625 [24155] <2> logparams: -sb -rdbms oracle -S vasbackup -to 300 -c oracle_database_full -s Full -clnt mpdb-b-vasclient -FULL -kl 28 -b mpdb-b-vasclient_1378911647 -jobid 41
22:59:35.635 [24155] <4> bphdb: Module: libncf, Release: 7.5.0.3 , Build: 08/30/2011 23:00:00 CDT (20110830)
22:59:35.636 [24155] <4> bphdb: System: SunOS, mpdb-b, 5.10, Generic_141444-09, sun4u, {5}
22:59:35.636 [24155] <4> bphdb: Current code page: ICU: US-ASCII, Max. character width: 1, Substitution character: 0x1A [.], Unicode substitution character: 0xfffd [.]
22:59:35.636 [24155] <4> bphdb: Running as user '0', primary group '0'
22:59:35.636 [24155] <4> bphdb: Environment variable IS_NETBACKUP_DAEMON=YES
22:59:35.636 [24155] <4> bphdb: Environment variable CRS_HOME=/opt/oracle/product/10.2.0/crs_1
22:59:35.636 [24155] <4> bphdb: Environment variable DISPLAY=localhost:10.0
22:59:35.636 [24155] <4> bphdb: Environment variable HOME=/
22:59:35.636 [24155] <4> bphdb: Environment variable LOGNAME=root
22:59:35.636 [24155] <4> bphdb: Environment variable MAIL=/var/mail//root
22:59:35.637 [24155] <4> bphdb: Environment variable NLS_LANG=american_america.UTF8
22:59:35.637 [24155] <4> bphdb: Environment variable OLDPWD=/
22:59:35.637 [24155] <4> bphdb: Environment variable ORACLE_BASE=/opt/oracle
22:59:35.637 [24155] <4> bphdb: Environment variable ORACLE_HOME=/opt/oracle/product/10.2.0/db_1
22:59:35.637 [24155] <4> bphdb: Environment variable ORACLE_SID=SMTIN2
22:59:35.637 [24155] <4> bphdb: Environment variable PATH=/opt/oracle/product/10.2.0/db_1/bin:/opt/oracle/product/10.2.0/crs_1/OPatch:/opt/oracle/product/10.2.0/crs_1/bin:/usr/local/bin:/usr/sbin:/usr/bin
22:59:35.637 [24155] <4> bphdb: Environment variable PS1=[mpdb-b ]
22:59:35.637 [24155] <4> bphdb: Environment variable PWD=/usr/openv/netbackup
22:59:35.637 [24155] <4> bphdb: Environment variable SHELL=/usr/bin/bash
22:59:35.637 [24155] <4> bphdb: Environment variable SHLVL=1
22:59:35.637 [24155] <4> bphdb: Environment variable SSH_CLIENT=192.168.20.100 64362 22
22:59:35.637 [24155] <4> bphdb: Environment variable SSH_CONNECTION=192.168.20.100 64362 192.168.20.13 22
22:59:35.637 [24155] <4> bphdb: Environment variable SSH_TTY=/dev/pts/1
22:59:35.637 [24155] <4> bphdb: Environment variable TERM=xterm
22:59:35.637 [24155] <4> bphdb: Environment variable TMP=/tmp
22:59:35.637 [24155] <4> bphdb: Environment variable TMPDIR=/tmp
22:59:35.637 [24155] <4> bphdb: Environment variable TZ=Hongkong
22:59:35.637 [24155] <4> bphdb: Environment variable USER=root
22:59:35.637 [24155] <4> bphdb: Environment variable _=/usr/openv/netbackup/bin/bp.start_all
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_POLICY=oracle_database_full
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_CLIENT=mpdb-b-vasclient
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_MODE=B
22:59:35.637 [24155] <4> bphdb: INF - NB_ORA_POLICY=oracle_database_full
22:59:35.637 [24155] <4> bphdb: INF - NB_ORA_SCHED not defined.
22:59:35.637 [24155] <4> bphdb: INF - NB_ORA_PC_SCHED=Full
22:59:35.637 [24155] <4> bphdb: INF - NB_ORA_SERV=vasbackup
22:59:35.637 [24155] <4> bphdb: INF - NB_ORA_PC_BTYPE not set
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_FULL=1
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_INCR=0
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_CINC=0
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_SCHEDULED=1
22:59:35.637 [24155] <4> bphdb: INF - setenv NB_ORA_PARENT_JOBID=41
22:59:35.637 [24155] <4> bphdb: INF - BACKUP START 24155
22:59:35.638 [24155] <4> bphdb: INF - CONTINUE BACKUP message received
22:59:35.638 [24155] <16> bphdb: set recv timeout error
22:59:35.638 [24155] <16> bphdb: set recv timeout error
22:59:35.638 [24155] <4> bphdb: INF - Processing /root/mpdb_b_vasclient.sh
22:59:35.640 [24155] <4> bphdb: INF - Waiting for the child status
22:59:35.642 [24156] <4> bphdb: INF - Child executing /root/mpdb_b_vasclient.sh
23:08:41.714 [24155] <16> bphdb: ERR - Script exited with status = 1 <the requested operation was partially successful>
23:08:41.714 [24155] <16> bphdb: ERR - bphdb exit status = 6: the backup failed to back up the requested files
23:08:41.714 [24155] <4> bphdb: INF - EXIT STATUS 6: the backup failed to back up the requested files

bowmanleong

已解決
問題應該是之前把腳本拿到Windows環境里修改...把腳本格式改變了,所以在Linux下面運行不到....