- 论坛徽章:
- 0
|
现有一Oracle10.2.0.3的数据库,通过nbu调用rman进行了整库备份(backup database)备份脚本如下:
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';
send 'NB_ORA_CLIENT=P595ALPAR1';
BACKUP
$BACKUP_TYPE
TAG hot_db_bk_level0
FILESPERSET 5
# recommended format
FORMAT 'bk_%s_%p_%t'
DATABASE;
sql 'alter system archive log current';
RELEASE CHANNEL ch00;
# backup all archive logs
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=dbserver';
BACKUP
filesperset 20
FORMAT 'al_%s_%p_%t'
ARCHIVELOG ALL delete input;
RELEASE CHANNEL ch00;
#
# Note: During the process of backing up the database, RMAN also backs up the
# control file. This version of the control file does not contain the
# information about the current backup because "nocatalog" has been specified.
# To include the information about the current backup, the control file should
# be backed up as the last step of the RMAN section. This step would not be
# necessary if we were using a recovery catalog.
#
ALLOCATE CHANNEL ch00 TYPE disk;
copy CURRENT CONTROLFILE to '/usr/openv/scripts/dbserver_control.ctl' ;
RELEASE CHANNEL ch00;
}
EOF
现在遇到一个问题,用户发现这个数据库中有一个表空间中的数据有问题了,想单独恢复这个表空间到3天前的状态(不恢复整个数据库),请问各位可以实现吗?能告诉大致的过程吗?谢谢!
补充一下:最近没有做这个表空间的exp备份。
[ 本帖最后由 lyh303 于 2010-1-6 13:55 编辑 ] |
|