发新话题
打印

本地BE11d 备份远程LINUX库

本地BE11d 备份远程LINUX库

终于搞定本地BE备份远程LINUX上的ORACLE数据库

BE版本: 11d  本地系统: Window 2003
                      远程系统: RHLinux AS 4 + Oracle 10g

本人免费帮助BE11d+ralus本地,远程备份SQL SERVER 2K/2005+ORACLE,以及相关安装中的问题

讨论请加QQ群: 10098435 (ORACLE DBA)

[ 本帖最后由 popgo 于 2007-9-20 17:14 编辑 ]

附件

20070920_f9425677a94d709942e7HwAxvVzBgdlP.jpg (188.98 KB)

2007-9-20 17:12

BE本地备份异地ORACLE库

20070920_f9425677a94d709942e7HwAxvVzBgdlP.jpg

TOP

BE 11d RMAN backup script:

Recovery Manager: Release 10.2.0.1.0 - Production on Fri Sep 21 23:44:46 2007
Copyright (c) 1982, 2005, Oracle.  All rights reserved.

# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------

RUN {
ALLOCATE CHANNEL ch0
     TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=172.17.34.13,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={196EFE54-28A0-47EC-987D-EB91DABE9DC6},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\uni-linux\orcl';
BACKUP
     INCREMENTAL LEVEL=0
     FORMAT 'BE_U'
     TABLESPACE
         'GILLION_FRT_AIR_INX' FORCE;
BACKUP
     FORMAT 'BE_U'
     ARCHIVELOG ALL FORCE;
BACKUP CURRENT CONTROLFILE
     FORMAT 'BE_U';

RELEASE CHANNEL ch0;
}

connected to target database: ORCL (DBID=1160719714)
using target database control file instead of recovery catalog
allocated channel: ch0
channel ch0: sid=147 devtype=SBT_TAPE
channel ch0: Symantec/BackupExec/1.1.0
sent command to channel: ch0
Starting backup at 21-SEP-07
channel ch0: starting incremental level 0 datafile backupset
channel ch0: specifying datafile(s) in backupset
input datafile fno=00005 name=/mnt/hgfs/win.share/Gillion_DbfGILLION_FRT_AIR_INX
channel ch0: starting piece 1 at 21-SEP-07
starting up daemon
starting up daemon
channel ch0: finished piece 1 at 21-SEP-07
piece handle=BE_0cishig2_1_1 tag=TAG20070921T234505 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:11:00
Finished backup at 21-SEP-07
Starting backup at 21-SEP-07
current log archived
channel ch0: starting archive log backupset
channel ch0: specifying archive log(s) in backup set
input archive log thread=1 sequence=34 recid=1 stamp=633193515
input archive log thread=1 sequence=35 recid=2 stamp=633193959
input archive log thread=1 sequence=36 recid=3 stamp=633247915
input archive log thread=1 sequence=37 recid=4 stamp=633547492
input archive log thread=1 sequence=38 recid=5 stamp=633833876
input archive log thread=1 sequence=39 recid=6 stamp=633898806
input archive log thread=1 sequence=40 recid=7 stamp=633916572
channel ch0: starting piece 1 at 21-SEP-07
starting up daemon
channel ch0: finished piece 1 at 22-SEP-07
piece handle=BE_0dishj52_1_1 tag=TAG20070921T235614 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:03:57
Finished backup at 22-SEP-07
Starting backup at 22-SEP-07
channel ch0: starting full datafile backupset
channel ch0: specifying datafile(s) in backupset
including current control file in backupset
channel ch0: starting piece 1 at 22-SEP-07
starting up daemon
channel ch0: finished piece 1 at 22-SEP-07
piece handle=BE_0eishjd0_1_1 tag=TAG20070922T000032 comment=API Version 2.0,MMS Version 1.1.0.0
channel ch0: backup set complete, elapsed time: 00:03:16
Finished backup at 22-SEP-07
released channel: ch0
Recovery Manager complete.



[email=#@START_SKIP]#@START_SKIP[/email]
connect target 'sys/XXXXXX';
[email=#@END_SKIP]#@END_SKIP[/email]
# -----------------------------------------------------------------
# RMAN command section
# -----------------------------------------------------------------
RUN {
ALLOCATE CHANNEL ch0
    TYPE 'SBT_TAPE';
SEND 'BSA_SERVICE_HOST=172.17.34.13,NBBSA_TOTAL_STREAMS=1,NBBSA_JOB_COOKIE={196EFE54-28A0-47EC-987D-EB91DABE9DC6},NBBSA_DB_DEVICE_NAME=Oracle-Linux::\\uni-linux\orcl';
BACKUP
    INCREMENTAL LEVEL=0
    FORMAT 'BE_%U'
    TABLESPACE
        'GILLION_FRT_AIR_INX',
        'USERS' FORCE;
BACKUP
    FORMAT 'BE_%U'
    ARCHIVELOG ALL FORCE;
BACKUP CURRENT CONTROLFILE
    FORMAT 'BE_%U';
RELEASE CHANNEL ch0;
}

[ 本帖最后由 popgo 于 2007-9-21 13:44 编辑 ]

TOP

楼主,写篇完整的教程嘛

谢谢啦

TOP

如果能写篇详细的文档,那就最好不过了

TOP

发新话题