ITPub博客

首页 > Linux操作系统 > Linux操作系统 > RMAN恢复一例

RMAN恢复一例

原创 Linux操作系统 作者:dear2170 时间:2009-05-19 10:23:22 0 删除 编辑

DB : ORACLE9204

OS : AIX5304

备份脚本:

全备:

run{
allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup full tag 'dbfull' format 'dbfull_%t_%s_%p' diskratio=0 database include current controlfile;
sql 'alter system archive log current';
backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete input;
release channel t1;
}

增量备份:

run{
allocate channel t1 type 'sbt_tape'  parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
backup incremental level 1 tag '%d_full_%s_%p' filesperset 5 database  diskratio=0  include current controlfile;
sql 'alter system archive log current';
backup format 'arch%t_%s_%p' diskratio=0 archivelog all delete input;
release channel t1;
}

以下是整个恢复记录:

root@etpdb1:/data/etprd/etprddata>su - oracle9
oracle9@etpdb1:/ora/etprd>rman target /

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database (not started)

RMAN> startup nomount

Oracle instance started

Total System Global Area    1815055840 bytes

Fixed Size                      744928 bytes
Variable Size                301989888 bytes
Database Buffers            1509949440 bytes
Redo Buffers                   2371584 bytes

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> restore controlfile from 'dbfull_686451601_980_1';
4> }

using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=14 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0

Starting restore at 15-MAY-09

channel t1: restoring controlfile
channel t1: restore complete
replicating controlfile
input filename=/data/etprd/etprddata/control01.ctl
output filename=/data/etprd/etprddata/control02.ctl
output filename=/data/etprd/etprddata/control03.ctl
Finished restore at 15-MAY-09
released channel: t1

RMAN> shutdown immediate

Oracle instance shut down

RMAN> startup mount

connected to target database (not started)
Oracle instance started
database mounted

Total System Global Area    1815055840 bytes

Fixed Size                      744928 bytes
Variable Size                301989888 bytes
Database Buffers            1509949440 bytes
Redo Buffers                   2371584 bytes

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> restore database;
4> }

allocated channel: t1
channel t1: sid=14 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0

Starting restore at 15-MAY-09

channel t1: starting datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /data/etprd/etprddata/system01.dbf
restoring datafile 00002 to /data/etprd/etprddata/undotbs01.dbf
restoring datafile 00003 to /data/etprd/etprddata/cwmlite01.dbf
restoring datafile 00004 to /data/etprd/etprddata/drsys01.dbf
restoring datafile 00005 to /data/etprd/etprddata/example01.dbf
restoring datafile 00006 to /data/etprd/etprddata/indx01.dbf
restoring datafile 00007 to /data/etprd/etprddata/odm01.dbf
restoring datafile 00008 to /data/etprd/etprddata/tools01.dbf
restoring datafile 00009 to /data/etprd/etprddata/users01.dbf
restoring datafile 00010 to /data/etprd/etprddata/xdb01.dbf
restoring datafile 00011 to /data/etprd/etprddata/ACM.dbf
restoring datafile 00012 to /data/etprd/etprddata/ANALYSIS.dbf
restoring datafile 00013 to /data/etprd/etprddata/BUYER.dbf
restoring datafile 00014 to /data/etprd/etprddata/SOURCING.dbf
restoring datafile 00015 to /data/etprd/etprddata/SOURCINGARCHIVE.dbf
restoring datafile 00016 to /data/etprd/etprddata/PORTAL.dbf
restoring datafile 00017 to /data/etprd/etprddata/lportal.dbf
restoring datafile 00018 to /data/etprd/etprddata/tivts_orainst1.dbf
restoring datafile 00019 to /data/etprd/etprddata/CUSM.dbf
restoring datafile 00020 to /data/etprd/etprddata/sourcing-1.dbf
restoring datafile 00021 to /data/etprd/etprddata/buyer2.dbf
restoring datafile 00022 to /data/etprd/etprddata/sourcing-2.dbf
restoring datafile 00023 to /data/etprd/etprddata/sourcing-3.dbf
restoring datafile 00024 to /data/etprd/etprddata/CUSM01.dbf
restoring datafile 00025 to /data/etprd/etprddata/sourcing-4.dbf
restoring datafile 00026 to /data/etprd/etprddata/buyer3.dbf
restoring datafile 00027 to /data/etprd/etprddata/sourcing-5.dbf
restoring datafile 00028 to /data/etprd/etprddata/cusm02.dbf
restoring datafile 00029 to /data/etprd/etprddata/sourcing-6.dbf
restoring datafile 00030 to /data/etprd/etprddata/sourcing-7.dbf
restoring datafile 00031 to /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=dbfull_685846801_937_1 tag=DBFULL params=NULL
channel t1: restore complete
Finished restore at 15-MAY-09
released channel: t1

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> recover database using backup until time '2009-05-11 06:50:00';

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "identifier": expecting one of: "archivelog, check, delete, from, high, noredo, ;, skip, tablespace, until"
RMAN-01008: the bad identifier was: using
RMAN-01007: at line 3 column 18 file: standard input

RMAN> }

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01005: syntax error: found "}": expecting one of: "allocate, alter, backup, beginline, blockrecover, catalog, change, connect, copy, create, crosscheck, configure, duplicate, debug, delete, drop, exit, endinline, host, {, library, list, mount, open, print, quit, recover, register, release, replace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setlimit, sql, spool, startup, shutdown, send, show, test, upgrade, validate"
RMAN-01007: at line 1 column 1 file: standard input

RMAN>

RMAN> exit


Recovery Manager complete.
oracle9@etpdb1:/ora/etprd>export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
oracle9@etpdb1:/ora/etprd>rman target
oracle9@etpdb1:/ora/etprd>
oracle9@etpdb1:/ora/etprd>rman target /

Recovery Manager: Release 9.2.0.4.0 - 64bit Production

Copyright (c) 1995, 2002, Oracle Corporation.  All rights reserved.

connected to target database: ASMPRDN (DBID=1081792182)

RMAN> run{
2> allocate channel t1 type 'sbt_tape' parms 'ENV=(tdpo_optfile=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';
3> recover database  until time '2009-05-11 06:50:00';
4> }

using target database controlfile instead of recovery catalog
allocated channel: t1
channel t1: sid=9 devtype=SBT_TAPE
channel t1: Data Protection for Oracle: version 5.3.3.0

Starting recover at 2009-05-15 20:14:47
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /data/etprd/etprddata/system01.dbf
destination for restore of datafile 00002: /data/etprd/etprddata/undotbs01.dbf
destination for restore of datafile 00018: /data/etprd/etprddata/tivts_orainst1.dbf
destination for restore of datafile 00022: /data/etprd/etprddata/sourcing-2.dbf
channel t1: restored backup piece 1
piece handle=take50kh_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00005: /data/etprd/etprddata/example01.dbf
destination for restore of datafile 00010: /data/etprd/etprddata/xdb01.dbf
destination for restore of datafile 00011: /data/etprd/etprddata/ACM.dbf
destination for restore of datafile 00017: /data/etprd/etprddata/lportal.dbf
destination for restore of datafile 00031: /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=tbke50mj_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /data/etprd/etprddata/drsys01.dbf
destination for restore of datafile 00007: /data/etprd/etprddata/odm01.dbf
destination for restore of datafile 00021: /data/etprd/etprddata/buyer2.dbf
destination for restore of datafile 00027: /data/etprd/etprddata/sourcing-5.dbf
destination for restore of datafile 00030: /data/etprd/etprddata/sourcing-7.dbf
channel t1: restored backup piece 1
piece handle=tcke50nc_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00008: /data/etprd/etprddata/tools01.dbf
destination for restore of datafile 00013: /data/etprd/etprddata/BUYER.dbf
destination for restore of datafile 00019: /data/etprd/etprddata/CUSM.dbf
destination for restore of datafile 00020: /data/etprd/etprddata/sourcing-1.dbf
destination for restore of datafile 00024: /data/etprd/etprddata/CUSM01.dbf
channel t1: restored backup piece 1
piece handle=tdke50o5_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /data/etprd/etprddata/indx01.dbf
destination for restore of datafile 00015: /data/etprd/etprddata/SOURCINGARCHIVE.dbf
destination for restore of datafile 00023: /data/etprd/etprddata/sourcing-3.dbf
destination for restore of datafile 00026: /data/etprd/etprddata/buyer3.dbf
destination for restore of datafile 00028: /data/etprd/etprddata/cusm02.dbf
channel t1: restored backup piece 1
piece handle=teke50ou_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /data/etprd/etprddata/cwmlite01.dbf
destination for restore of datafile 00012: /data/etprd/etprddata/ANALYSIS.dbf
destination for restore of datafile 00014: /data/etprd/etprddata/SOURCING.dbf
channel t1: restored backup piece 1
piece handle=tfke50pn_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /data/etprd/etprddata/users01.dbf
destination for restore of datafile 00016: /data/etprd/etprddata/PORTAL.dbf
destination for restore of datafile 00025: /data/etprd/etprddata/sourcing-4.dbf
destination for restore of datafile 00029: /data/etprd/etprddata/sourcing-6.dbf
channel t1: restored backup piece 1
piece handle=tgke50qg_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /data/etprd/etprddata/system01.dbf
destination for restore of datafile 00002: /data/etprd/etprddata/undotbs01.dbf
destination for restore of datafile 00018: /data/etprd/etprddata/tivts_orainst1.dbf
destination for restore of datafile 00022: /data/etprd/etprddata/sourcing-2.dbf
channel t1: restored backup piece 1
piece handle=thke7l0i_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00005: /data/etprd/etprddata/example01.dbf
destination for restore of datafile 00010: /data/etprd/etprddata/xdb01.dbf
destination for restore of datafile 00011: /data/etprd/etprddata/ACM.dbf
destination for restore of datafile 00017: /data/etprd/etprddata/lportal.dbf
destination for restore of datafile 00031: /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=tike7l2j_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /data/etprd/etprddata/drsys01.dbf
destination for restore of datafile 00007: /data/etprd/etprddata/odm01.dbf
destination for restore of datafile 00021: /data/etprd/etprddata/buyer2.dbf
destination for restore of datafile 00027: /data/etprd/etprddata/sourcing-5.dbf
destination for restore of datafile 00030: /data/etprd/etprddata/sourcing-7.dbf
channel t1: restored backup piece 1
piece handle=tjke7l3c_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00008: /data/etprd/etprddata/tools01.dbf
destination for restore of datafile 00013: /data/etprd/etprddata/BUYER.dbf
destination for restore of datafile 00019: /data/etprd/etprddata/CUSM.dbf
destination for restore of datafile 00020: /data/etprd/etprddata/sourcing-1.dbf
destination for restore of datafile 00024: /data/etprd/etprddata/CUSM01.dbf
channel t1: restored backup piece 1
piece handle=tkke7l45_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /data/etprd/etprddata/indx01.dbf
destination for restore of datafile 00015: /data/etprd/etprddata/SOURCINGARCHIVE.dbf
destination for restore of datafile 00023: /data/etprd/etprddata/sourcing-3.dbf
destination for restore of datafile 00026: /data/etprd/etprddata/buyer3.dbf
destination for restore of datafile 00028: /data/etprd/etprddata/cusm02.dbf
channel t1: restored backup piece 1
piece handle=tlke7l4u_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /data/etprd/etprddata/cwmlite01.dbf
destination for restore of datafile 00012: /data/etprd/etprddata/ANALYSIS.dbf
destination for restore of datafile 00014: /data/etprd/etprddata/SOURCING.dbf
channel t1: restored backup piece 1
piece handle=tmke7l5n_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /data/etprd/etprddata/users01.dbf
destination for restore of datafile 00016: /data/etprd/etprddata/PORTAL.dbf
destination for restore of datafile 00025: /data/etprd/etprddata/sourcing-4.dbf
destination for restore of datafile 00029: /data/etprd/etprddata/sourcing-6.dbf
channel t1: restored backup piece 1
piece handle=tnke7l6g_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /data/etprd/etprddata/system01.dbf
destination for restore of datafile 00002: /data/etprd/etprddata/undotbs01.dbf
destination for restore of datafile 00018: /data/etprd/etprddata/tivts_orainst1.dbf
destination for restore of datafile 00022: /data/etprd/etprddata/sourcing-2.dbf
channel t1: restored backup piece 1
piece handle=tokea9ch_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00005: /data/etprd/etprddata/example01.dbf
destination for restore of datafile 00010: /data/etprd/etprddata/xdb01.dbf
destination for restore of datafile 00011: /data/etprd/etprddata/ACM.dbf
destination for restore of datafile 00017: /data/etprd/etprddata/lportal.dbf
destination for restore of datafile 00031: /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=tpkea9es_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /data/etprd/etprddata/drsys01.dbf
destination for restore of datafile 00007: /data/etprd/etprddata/odm01.dbf
destination for restore of datafile 00021: /data/etprd/etprddata/buyer2.dbf
destination for restore of datafile 00027: /data/etprd/etprddata/sourcing-5.dbf
destination for restore of datafile 00030: /data/etprd/etprddata/sourcing-7.dbf
channel t1: restored backup piece 1
piece handle=tqkea9fl_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00008: /data/etprd/etprddata/tools01.dbf
destination for restore of datafile 00013: /data/etprd/etprddata/BUYER.dbf
destination for restore of datafile 00019: /data/etprd/etprddata/CUSM.dbf
destination for restore of datafile 00020: /data/etprd/etprddata/sourcing-1.dbf
destination for restore of datafile 00024: /data/etprd/etprddata/CUSM01.dbf
channel t1: restored backup piece 1
piece handle=trkea9gf_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /data/etprd/etprddata/indx01.dbf
destination for restore of datafile 00015: /data/etprd/etprddata/SOURCINGARCHIVE.dbf
destination for restore of datafile 00023: /data/etprd/etprddata/sourcing-3.dbf
destination for restore of datafile 00026: /data/etprd/etprddata/buyer3.dbf
destination for restore of datafile 00028: /data/etprd/etprddata/cusm02.dbf
channel t1: restored backup piece 1
piece handle=tskea9h8_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /data/etprd/etprddata/cwmlite01.dbf
destination for restore of datafile 00012: /data/etprd/etprddata/ANALYSIS.dbf
destination for restore of datafile 00014: /data/etprd/etprddata/SOURCING.dbf
channel t1: restored backup piece 1
piece handle=ttkea9i1_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /data/etprd/etprddata/users01.dbf
destination for restore of datafile 00016: /data/etprd/etprddata/PORTAL.dbf
destination for restore of datafile 00025: /data/etprd/etprddata/sourcing-4.dbf
destination for restore of datafile 00029: /data/etprd/etprddata/sourcing-6.dbf
channel t1: restored backup piece 1
piece handle=tukea9iq_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /data/etprd/etprddata/system01.dbf
destination for restore of datafile 00002: /data/etprd/etprddata/undotbs01.dbf
destination for restore of datafile 00018: /data/etprd/etprddata/tivts_orainst1.dbf
destination for restore of datafile 00022: /data/etprd/etprddata/sourcing-2.dbf
channel t1: restored backup piece 1
piece handle=tvkectoh_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00005: /data/etprd/etprddata/example01.dbf
destination for restore of datafile 00010: /data/etprd/etprddata/xdb01.dbf
destination for restore of datafile 00011: /data/etprd/etprddata/ACM.dbf
destination for restore of datafile 00017: /data/etprd/etprddata/lportal.dbf
destination for restore of datafile 00031: /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=u0kectqi_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /data/etprd/etprddata/drsys01.dbf
destination for restore of datafile 00007: /data/etprd/etprddata/odm01.dbf
destination for restore of datafile 00021: /data/etprd/etprddata/buyer2.dbf
destination for restore of datafile 00027: /data/etprd/etprddata/sourcing-5.dbf
destination for restore of datafile 00030: /data/etprd/etprddata/sourcing-7.dbf
channel t1: restored backup piece 1
piece handle=u1kectrb_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00008: /data/etprd/etprddata/tools01.dbf
destination for restore of datafile 00013: /data/etprd/etprddata/BUYER.dbf
destination for restore of datafile 00019: /data/etprd/etprddata/CUSM.dbf
destination for restore of datafile 00020: /data/etprd/etprddata/sourcing-1.dbf
destination for restore of datafile 00024: /data/etprd/etprddata/CUSM01.dbf
channel t1: restored backup piece 1
piece handle=u2kects4_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /data/etprd/etprddata/indx01.dbf
destination for restore of datafile 00015: /data/etprd/etprddata/SOURCINGARCHIVE.dbf
destination for restore of datafile 00023: /data/etprd/etprddata/sourcing-3.dbf
destination for restore of datafile 00026: /data/etprd/etprddata/buyer3.dbf
destination for restore of datafile 00028: /data/etprd/etprddata/cusm02.dbf
channel t1: restored backup piece 1
piece handle=u3kectst_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /data/etprd/etprddata/cwmlite01.dbf
destination for restore of datafile 00012: /data/etprd/etprddata/ANALYSIS.dbf
destination for restore of datafile 00014: /data/etprd/etprddata/SOURCING.dbf
channel t1: restored backup piece 1
piece handle=u4kecttn_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /data/etprd/etprddata/users01.dbf
destination for restore of datafile 00016: /data/etprd/etprddata/PORTAL.dbf
destination for restore of datafile 00025: /data/etprd/etprddata/sourcing-4.dbf
destination for restore of datafile 00029: /data/etprd/etprddata/sourcing-6.dbf
channel t1: restored backup piece 1
piece handle=u5kectug_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /data/etprd/etprddata/system01.dbf
destination for restore of datafile 00002: /data/etprd/etprddata/undotbs01.dbf
destination for restore of datafile 00018: /data/etprd/etprddata/tivts_orainst1.dbf
destination for restore of datafile 00022: /data/etprd/etprddata/sourcing-2.dbf
channel t1: restored backup piece 1
piece handle=u6kefi4i_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00005: /data/etprd/etprddata/example01.dbf
destination for restore of datafile 00010: /data/etprd/etprddata/xdb01.dbf
destination for restore of datafile 00011: /data/etprd/etprddata/ACM.dbf
destination for restore of datafile 00017: /data/etprd/etprddata/lportal.dbf
destination for restore of datafile 00031: /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=u7kefi6t_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /data/etprd/etprddata/drsys01.dbf
destination for restore of datafile 00007: /data/etprd/etprddata/odm01.dbf
destination for restore of datafile 00021: /data/etprd/etprddata/buyer2.dbf
destination for restore of datafile 00027: /data/etprd/etprddata/sourcing-5.dbf
destination for restore of datafile 00030: /data/etprd/etprddata/sourcing-7.dbf
channel t1: restored backup piece 1
piece handle=u8kefi7m_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00008: /data/etprd/etprddata/tools01.dbf
destination for restore of datafile 00013: /data/etprd/etprddata/BUYER.dbf
destination for restore of datafile 00019: /data/etprd/etprddata/CUSM.dbf
destination for restore of datafile 00020: /data/etprd/etprddata/sourcing-1.dbf
destination for restore of datafile 00024: /data/etprd/etprddata/CUSM01.dbf
channel t1: restored backup piece 1
piece handle=u9kefi8f_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /data/etprd/etprddata/indx01.dbf
destination for restore of datafile 00015: /data/etprd/etprddata/SOURCINGARCHIVE.dbf
destination for restore of datafile 00023: /data/etprd/etprddata/sourcing-3.dbf
destination for restore of datafile 00026: /data/etprd/etprddata/buyer3.dbf
destination for restore of datafile 00028: /data/etprd/etprddata/cusm02.dbf
channel t1: restored backup piece 1
piece handle=uakefi98_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /data/etprd/etprddata/cwmlite01.dbf
destination for restore of datafile 00012: /data/etprd/etprddata/ANALYSIS.dbf
destination for restore of datafile 00014: /data/etprd/etprddata/SOURCING.dbf
channel t1: restored backup piece 1
piece handle=ubkefia2_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /data/etprd/etprddata/users01.dbf
destination for restore of datafile 00016: /data/etprd/etprddata/PORTAL.dbf
destination for restore of datafile 00025: /data/etprd/etprddata/sourcing-4.dbf
destination for restore of datafile 00029: /data/etprd/etprddata/sourcing-6.dbf
channel t1: restored backup piece 1
piece handle=uckefiar_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00001: /data/etprd/etprddata/system01.dbf
destination for restore of datafile 00002: /data/etprd/etprddata/undotbs01.dbf
destination for restore of datafile 00018: /data/etprd/etprddata/tivts_orainst1.dbf
destination for restore of datafile 00022: /data/etprd/etprddata/sourcing-2.dbf
channel t1: restored backup piece 1
piece handle=udkei6gi_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00005: /data/etprd/etprddata/example01.dbf
destination for restore of datafile 00010: /data/etprd/etprddata/xdb01.dbf
destination for restore of datafile 00011: /data/etprd/etprddata/ACM.dbf
destination for restore of datafile 00017: /data/etprd/etprddata/lportal.dbf
destination for restore of datafile 00031: /data/etprd/etprddata/buyer4.dbf
channel t1: restored backup piece 1
piece handle=uekei6j7_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00004: /data/etprd/etprddata/drsys01.dbf
destination for restore of datafile 00007: /data/etprd/etprddata/odm01.dbf
destination for restore of datafile 00021: /data/etprd/etprddata/buyer2.dbf
destination for restore of datafile 00027: /data/etprd/etprddata/sourcing-5.dbf
destination for restore of datafile 00030: /data/etprd/etprddata/sourcing-7.dbf
channel t1: restored backup piece 1
piece handle=ufkei6k0_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00008: /data/etprd/etprddata/tools01.dbf
destination for restore of datafile 00013: /data/etprd/etprddata/BUYER.dbf
destination for restore of datafile 00019: /data/etprd/etprddata/CUSM.dbf
destination for restore of datafile 00020: /data/etprd/etprddata/sourcing-1.dbf
destination for restore of datafile 00024: /data/etprd/etprddata/CUSM01.dbf
channel t1: restored backup piece 1
piece handle=ugkei6kp_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00006: /data/etprd/etprddata/indx01.dbf
destination for restore of datafile 00015: /data/etprd/etprddata/SOURCINGARCHIVE.dbf
destination for restore of datafile 00023: /data/etprd/etprddata/sourcing-3.dbf
destination for restore of datafile 00026: /data/etprd/etprddata/buyer3.dbf
destination for restore of datafile 00028: /data/etprd/etprddata/cusm02.dbf
channel t1: restored backup piece 1
piece handle=uhkei6li_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00003: /data/etprd/etprddata/cwmlite01.dbf
destination for restore of datafile 00012: /data/etprd/etprddata/ANALYSIS.dbf
destination for restore of datafile 00014: /data/etprd/etprddata/SOURCING.dbf
channel t1: restored backup piece 1
piece handle=uikei6mb_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete
channel t1: starting incremental datafile backupset restore
channel t1: specifying datafile(s) to restore from backup set
destination for restore of datafile 00009: /data/etprd/etprddata/users01.dbf
destination for restore of datafile 00016: /data/etprd/etprddata/PORTAL.dbf
destination for restore of datafile 00025: /data/etprd/etprddata/sourcing-4.dbf
destination for restore of datafile 00029: /data/etprd/etprddata/sourcing-6.dbf
channel t1: restored backup piece 1
piece handle=ujkei6n4_1_1 tag=%D_FULL_%S_%P params=NULL
channel t1: restore complete

starting media recovery

archive log thread 1 sequence 27588 is already on disk as file /arch/etprd/arch/1_27588.dbf
archive log thread 1 sequence 27589 is already on disk as file /arch/etprd/arch/1_27589.dbf
archive log thread 1 sequence 27590 is already on disk as file /arch/etprd/arch/1_27590.dbf
archive log thread 1 sequence 27591 is already on disk as file /arch/etprd/arch/1_27591.dbf
archive log thread 1 sequence 27592 is already on disk as file /arch/etprd/arch/1_27592.dbf
archive log thread 1 sequence 27593 is already on disk as file /arch/etprd/arch/1_27593.dbf
archive log thread 1 sequence 27594 is already on disk as file /arch/etprd/arch/1_27594.dbf
archive log thread 1 sequence 27595 is already on disk as file /arch/etprd/arch/1_27595.dbf
archive log thread 1 sequence 27596 is already on disk as file /arch/etprd/arch/1_27596.dbf
archive log thread 1 sequence 27597 is already on disk as file /arch/etprd/arch/1_27597.dbf
archive log thread 1 sequence 27598 is already on disk as file /arch/etprd/arch/1_27598.dbf
archive log thread 1 sequence 27599 is already on disk as file /arch/etprd/arch/1_27599.dbf
archive log thread 1 sequence 27600 is already on disk as file /arch/etprd/arch/1_27600.dbf
archive log thread 1 sequence 27601 is already on disk as file /arch/etprd/arch/1_27601.dbf
archive log thread 1 sequence 27602 is already on disk as file /arch/etprd/arch/1_27602.dbf
archive log thread 1 sequence 27603 is already on disk as file /arch/etprd/arch/1_27603.dbf
archive log thread 1 sequence 27604 is already on disk as file /arch/etprd/arch/1_27604.dbf
archive log thread 1 sequence 27605 is already on disk as file /arch/etprd/arch/1_27605.dbf
archive log thread 1 sequence 27606 is already on disk as file /arch/etprd/arch/1_27606.dbf
archive log thread 1 sequence 27607 is already on disk as file /arch/etprd/arch/1_27607.dbf
archive log thread 1 sequence 27608 is already on disk as file /arch/etprd/arch/1_27608.dbf
archive log thread 1 sequence 27609 is already on disk as file /arch/etprd/arch/1_27609.dbf
archive log thread 1 sequence 27610 is already on disk as file /arch/etprd/arch/1_27610.dbf
archive log thread 1 sequence 27611 is already on disk as file /arch/etprd/arch/1_27611.dbf
archive log thread 1 sequence 27612 is already on disk as file /arch/etprd/arch/1_27612.dbf
archive log thread 1 sequence 27613 is already on disk as file /arch/etprd/arch/1_27613.dbf
archive log thread 1 sequence 27614 is already on disk as file /arch/etprd/arch/1_27614.dbf
archive log thread 1 sequence 27615 is already on disk as file /arch/etprd/arch/1_27615.dbf
archive log thread 1 sequence 27616 is already on disk as file /arch/etprd/arch/1_27616.dbf
archive log filename=/arch/etprd/arch/1_27588.dbf thread=1 sequence=27588
archive log filename=/arch/etprd/arch/1_27589.dbf thread=1 sequence=27589
archive log filename=/arch/etprd/arch/1_27590.dbf thread=1 sequence=27590
archive log filename=/arch/etprd/arch/1_27591.dbf thread=1 sequence=27591
archive log filename=/arch/etprd/arch/1_27592.dbf thread=1 sequence=27592
archive log filename=/arch/etprd/arch/1_27593.dbf thread=1 sequence=27593
archive log filename=/arch/etprd/arch/1_27594.dbf thread=1 sequence=27594
archive log filename=/arch/etprd/arch/1_27595.dbf thread=1 sequence=27595
archive log filename=/arch/etprd/arch/1_27596.dbf thread=1 sequence=27596
archive log filename=/arch/etprd/arch/1_27597.dbf thread=1 sequence=27597
archive log filename=/arch/etprd/arch/1_27598.dbf thread=1 sequence=27598
archive log filename=/arch/etprd/arch/1_27599.dbf thread=1 sequence=27599
archive log filename=/arch/etprd/arch/1_27600.dbf thread=1 sequence=27600
archive log filename=/arch/etprd/arch/1_27601.dbf thread=1 sequence=27601
archive log filename=/arch/etprd/arch/1_27602.dbf thread=1 sequence=27602
archive log filename=/arch/etprd/arch/1_27603.dbf thread=1 sequence=27603
archive log filename=/arch/etprd/arch/1_27604.dbf thread=1 sequence=27604
archive log filename=/arch/etprd/arch/1_27605.dbf thread=1 sequence=27605
archive log filename=/arch/etprd/arch/1_27606.dbf thread=1 sequence=27606
archive log filename=/arch/etprd/arch/1_27607.dbf thread=1 sequence=27607
archive log filename=/arch/etprd/arch/1_27608.dbf thread=1 sequence=27608
archive log filename=/arch/etprd/arch/1_27609.dbf thread=1 sequence=27609
archive log filename=/arch/etprd/arch/1_27610.dbf thread=1 sequence=27610
archive log filename=/arch/etprd/arch/1_27611.dbf thread=1 sequence=27611
archive log filename=/arch/etprd/arch/1_27612.dbf thread=1 sequence=27612
archive log filename=/arch/etprd/arch/1_27613.dbf thread=1 sequence=27613
archive log filename=/arch/etprd/arch/1_27614.dbf thread=1 sequence=27614
archive log filename=/arch/etprd/arch/1_27615.dbf thread=1 sequence=27615
archive log filename=/arch/etprd/arch/1_27616.dbf thread=1 sequence=27616
archive log filename=/arch/etprd/arch/1_27617.dbf thread=1 sequence=27617
archive log filename=/arch/etprd/arch/1_27618.dbf thread=1 sequence=27618
archive log filename=/arch/etprd/arch/1_27619.dbf thread=1 sequence=27619
archive log filename=/arch/etprd/arch/1_27620.dbf thread=1 sequence=27620
archive log filename=/arch/etprd/arch/1_27621.dbf thread=1 sequence=27621
archive log filename=/arch/etprd/arch/1_27622.dbf thread=1 sequence=27622
archive log filename=/arch/etprd/arch/1_27623.dbf thread=1 sequence=27623
archive log filename=/arch/etprd/arch/1_27624.dbf thread=1 sequence=27624
archive log filename=/arch/etprd/arch/1_27625.dbf thread=1 sequence=27625
archive log filename=/arch/etprd/arch/1_27626.dbf thread=1 sequence=27626
archive log filename=/arch/etprd/arch/1_27627.dbf thread=1 sequence=27627
archive log filename=/arch/etprd/arch/1_27628.dbf thread=1 sequence=27628
archive log filename=/arch/etprd/arch/1_27629.dbf thread=1 sequence=27629
archive log filename=/arch/etprd/arch/1_27630.dbf thread=1 sequence=27630
archive log filename=/arch/etprd/arch/1_27631.dbf thread=1 sequence=27631
archive log filename=/arch/etprd/arch/1_27632.dbf thread=1 sequence=27632
archive log filename=/arch/etprd/arch/1_27633.dbf thread=1 sequence=27633
archive log filename=/arch/etprd/arch/1_27634.dbf thread=1 sequence=27634
archive log filename=/arch/etprd/arch/1_27635.dbf thread=1 sequence=27635
archive log filename=/arch/etprd/arch/1_27636.dbf thread=1 sequence=27636
archive log filename=/arch/etprd/arch/1_27637.dbf thread=1 sequence=27637
archive log filename=/arch/etprd/arch/1_27638.dbf thread=1 sequence=27638
archive log filename=/arch/etprd/arch/1_27639.dbf thread=1 sequence=27639
archive log filename=/arch/etprd/arch/1_27640.dbf thread=1 sequence=27640
archive log filename=/arch/etprd/arch/1_27641.dbf thread=1 sequence=27641
archive log filename=/arch/etprd/arch/1_27642.dbf thread=1 sequence=27642
archive log filename=/arch/etprd/arch/1_27643.dbf thread=1 sequence=27643
archive log filename=/arch/etprd/arch/1_27644.dbf thread=1 sequence=27644
archive log filename=/arch/etprd/arch/1_27645.dbf thread=1 sequence=27645
archive log filename=/arch/etprd/arch/1_27646.dbf thread=1 sequence=27646
archive log filename=/arch/etprd/arch/1_27647.dbf thread=1 sequence=27647
archive log filename=/arch/etprd/arch/1_27648.dbf thread=1 sequence=27648
media recovery complete
Finished recover at 2009-05-15 20:23:08
released channel: t1

RMAN> alter database open resetlogs;

database opened

RMAN>

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13561774/viewspace-600391/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 一些有用的sql
请登录后发表评论 登录
全部评论

注册时间:2008-11-29

  • 博文量
    20
  • 访问量
    40928