复制内容到剪贴板
代码:
以oracle身份登陆,启动数据库到nomount状态
ldyydbs1#[<oracle>]rman target sys/manager
Recovery Manager: Release 9.2.0.1.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: LD1DB (DBID=419778048)
RMAN> connect catalog rman_nbu/rman_nbu@rman
二、恢复控制文件
RMAN> RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
restore controlfile;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
三、 复数据文件
RMAN> RUN {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
ALLOCATE CHANNEL ch01 TYPE 'SBT_TAPE';
RESTORE DATABASE;
RELEASE CHANNEL ch00;
RELEASE CHANNEL ch01;
}
四、 恢复归档文件
启动数据库到mount状态
startup mount
查看序列号：
lognum的获取方式:
sql>select name,sequence# from v$archived_log;
name: 归档日志的名称
sequence#:归档日志对应的lognum；
根据序列号恢复归档文件
RMAN> RUN {
2> ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
3> restore archivelog from logseq 1 until logseq 62;
4> RELEASE CHANNEL ch00;
5> }
