oracle数据库NBU异机恢复测试报告

时间：2024.4.27

DBID=1167102021

创建目录

E:\data

E:\oracle\admin\zbzk\bdump

E:\oracle\admin\zbzk\cdump

E:\oracle\admin\zbzk\udump

E:\oracle\admin\zbzk\pfile

E:\oracle\admin\zbzk\create

E:\archlog\

创建sid

E:\oracle\ora92\bin>oradim -new -sid zbzk -startmode "E:\oracle\admin\zbzk\pfile\init.ora"

创建密码文件

E:\>orapwd file=e:\oracle\ora92\database\pwdldl.ora password=oracle

C:\Documents and Settings\Administrator>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期六 3月 24 10:48:45 2012

SQL> conn / as sysdba;

ERROR:

ORA-12560: TNS: 协议适配器错误

启动oracle服务

net start oracleservicezbzk

设置环境变量

set oracle_sid=zbzk

E:\oracle\ora92\bin>sqlplus /nolog

SQL*Plus: Release 9.2.0.1.0 - Production on 星期五 3月 23 17:53:03 2012

SQL>startup nomount pfile="E:\oracle\admin\zbzk\pfile\init.ora"

netbackup/bin/bplist -B -C zbyczk -t 4 -R -l /

-rw------- SYSTEM SYSTEM 1900544 三月 24 09:13 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1858432K 三月 24 09:12 arch-s237-p1-t778756341:\ -rw------- SYSTEM SYSTEM 547291136 三月 24 09:03 bk_u7cn6lnn9_s236_p1_t778755817:\

-rw------- SYSTEM SYSTEM

bk_u7bn6lnn8_s235_p1_t778755816:\ 688652288 三月 24 09:03

-rw------- SYSTEM SYSTEM 1900544 三月 23 12:42 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1800128K 三月 23 12:42 arch-s233-p1-t778682521:\ -rw------- SYSTEM SYSTEM 1843200K 三月 23 12:41 arch-s232-p1-t778682464:\ -rw------- SYSTEM SYSTEM 23533632K 三月 23 12:28 bk_u77n6jfap_s231_p1_t778681689:\

-rw------- SYSTEM SYSTEM 34803520K 三月 23 12:28 bk_u76n6jfao_s230_p1_t778681688:\

-rw------- SYSTEM SYSTEM 1900544 三月 21 18:08 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1796480K 三月 21 18:07 arch-s210-p1-t778529251:\ -rw------- SYSTEM SYSTEM 1003814912 三月 21 17:58 bk_u6gn6eptp_s208_p1_t778528697:\

-rw------- SYSTEM SYSTEM 550633472 三月 21 17:58 bk_u6hn6eptq_s209_p1_t778528698:\

-rw------- SYSTEM SYSTEM 1900544 三月 20 18:10 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1810432K 三月 20 18:09 arch-s206-p1-t778442976:\ -rw------- SYSTEM SYSTEM 1843200K 三月 20 18:08 arch-s205-p1-t778442929:\ -rw------- SYSTEM SYSTEM 1843200K 三月 20 18:08 arch-s204-p1-t778442883:\ -rw------- SYSTEM SYSTEM 806551552 三月 20 17:58 bk_u6an6c5hq_s202_p1_t778442298:\

-rw------- SYSTEM SYSTEM 685375488 三月 20 17:58 bk_u6bn6c5hq_s203_p1_t778442298:\

-rw------- SYSTEM SYSTEM 1900544 三月 17 18:08 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1752768K 三月 17 18:07 arch-s188-p1-t778183633:\ -rw------- SYSTEM SYSTEM 527433728 三月 17 17:58 bk_u5rn648ds_s187_p1_t778183100:\

-rw------- SYSTEM SYSTEM 973340672 三月 17 17:58 bk_u5qn648dr_s186_p1_t778183099:\

-rw------- SYSTEM SYSTEM 1900544 三月 16 18:07 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1705536K 三月 16 18:07 arch-s184-p1-t778097231:\ -rw------- SYSTEM SYSTEM 978255872 三月 16 17:58 bk_u5mn61k1t_s182_p1_t778096701:\

-rw------- SYSTEM SYSTEM 581304320 三月 16 17:58 bk_u5nn61k1t_s183_p1_t778096701:\

-rw------- SYSTEM SYSTEM 1900544 三月 15 18:11 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1666112K 三月 15 18:10 arch-s180-p1-t778011044:\ -rw------- SYSTEM SYSTEM 23406912K 三月 15 17:58 bk_u5jn5uvlt_s179_p1_t778010301:\

-rw------- SYSTEM SYSTEM 34733632K 三月 15 17:58 bk_u5in5uvlt_s178_p1_t778010301:\

-rw------- SYSTEM SYSTEM 1900544 三月 14 18:07 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1610048K 三月 14 18:07 arch-s176-p1-t777924426:\ -rw------- SYSTEM SYSTEM 509411328 三月 14 17:58 bk_u5fn5sb9u_s175_p1_t777923902:\

-rw------- SYSTEM SYSTEM 905379840 三月 14 17:58 bk_u5en5sb9t_s174_p1_t777923901:\

-rw------- SYSTEM SYSTEM 1900544 三月 13 18:07 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1611840K 三月 13 18:06 arch-s172-p1-t777838017:\ -rw------- SYSTEM SYSTEM 514719744 三月 13 17:58 bk_u5bn5pmtu_s171_p1_t777837502:\

-rw------- SYSTEM SYSTEM 627965952 三月 13 17:58 bk_u5an5pmtu_s170_p1_t777837502:\

-rw------- SYSTEM SYSTEM 1900544 三月 12 18:08 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1663040K 三月 12 18:07 arch-s168-p1-t777751636:\ -rw------- SYSTEM SYSTEM 538378240 三月 12 17:58 bk_u57n5n2hu_s167_p1_t777751102:\

-rw------- SYSTEM SYSTEM 673054720 三月 12 17:58 bk_u56n5n2hu_s166_p1_t777751102:\

-rw------- SYSTEM SYSTEM 1900544 三月 11 18:07 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1564096K 三月 11 18:07 arch-s164-p1-t777665229:\ -rw------- SYSTEM SYSTEM 540409856 三月 11 17:58 bk_u53n5ke5v_s163_p1_t777664703:\

-rw------- SYSTEM SYSTEM 645988352 三月 11 17:58 bk_u52n5ke5v_s162_p1_t777664703:\

-rw------- SYSTEM SYSTEM 1900544 三月 10 18:07 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1525376K 三月 10 18:07 arch-s160-p1-t777578830:\ -rw------- SYSTEM SYSTEM 483655680 三月 10 17:58 bk_u4vn5hpq0_s159_p1_t777578304:\

-rw------- SYSTEM SYSTEM 847970304 三月 10 17:58 bk_u4un5hppv_s158_p1_t777578303:\

-rw------- SYSTEM SYSTEM 1900544 三月 02 16:55 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1257152K 三月 02 16:54 arch-s124-p1-t776883263:\ -rw------- SYSTEM SYSTEM 420872192 三月 02 16:43 bk_u3rn4sie6_s123_p1_t776882630:\

-rw------- SYSTEM SYSTEM 605880320 三月 02 16:43 bk_u3qn4sie6_s122_p1_t776882630:\

-rw------- SYSTEM SYSTEM 1900544 三月 01 18:12 cntrl_p_t:\

-rw------- SYSTEM SYSTEM 1082496K 三月 01 18:11 arch-s120-p1-t776801509:\ -rw------- SYSTEM SYSTEM 1126400K 三月 01 18:11 arch-s119-p1-t776801463:\

-rw------- SYSTEM SYSTEM

bk_u3mn4q2e6_s118_p1_t776800710:\

-rw------- SYSTEM SYSTEM

bk_u3ln4q2e5_s117_p1_t776800709:\

恢复控制文件

C:\Program Files\VERITAS\NetBackup\bin>rman target /

23160960K 34630528K 三月三月 01 01 17:58 17:58

恢复管理器: 版本9.2.0.1.0 - Production

RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-00554: initialization of internal recovery manager package failed

RMAN-04005: error from target database:

ORA-12560: TNS: 协议适配器错误

C:\Program Files\VERITAS\NetBackup\bin>set oracle_sid=zbzk

C:\Program Files\VERITAS\NetBackup\bin>rman target /

恢复管理器: 版本9.2.0.1.0 - Production

连接到目标数据库: zbzk（未安装）

RMAN> set DBID=1167102021

正在执行命令: SET DBID

RMAN> run

{

allocate channel d1 type 'SBT_TAPE';

send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbyczk';

restore controlfile from 'cntrl_p_t';

release channel d1;

}

分配的通道: d1

通道 d1: sid=15 devtype=SBT_TAPE

通道d1: Veritas NetBackup for Oracle - Release 7.1 (20110203)

向通道发命令: d1

启动 restore 于 24-3月 -12

通道 d1: 正在恢复控制文件

通道 d1: 恢复完成

正在复制控制文件

输出文件名=E:\DATA\CONTROL01.CTL

输出文件名=E:\DATA\CONTROL02.CTL

输出文件名=E:\DATA\CONTROL03.CTL

完成 restore 于 24-3月 -12

释放的通道: d1

启动数据库到mount状态。

SQL> alter database mount；

SQL>create spfile from pfile="E:\oracle\admin\zbzk\pfile\init.ora"

恢复归档日志

RMAN> list backup of archivelog all;

RMAN> run {

allocate channel d1 type 'SBT_TAPE';

send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbyczk'; set archivelog destination to 'E:\archlog\';

restore archivelog sequence 78 thread 1;

restore archivelog sequence 79 thread 1;

release channel t1;

}

恢复数据文件

RMAN>

run{

allocate channel d1 type 'SBT_TAPE';

send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbyczk';

Set newname for datafile 1 to 'E:\data\SYSTEM01.DBF';

Set newname for datafile 2 to 'E:\data\UNDOTBS01.DBF';

Set newname for datafile 3 to 'E:\data\SYSAUX01.DBF';

Set newname for datafile 4 to 'E:\data\USERS01.DBF';

Set newname for datafile 5 to 'E:\data\SMO01.DBF';

Set newname for datafile 6 to 'E:\data\CRM_DB.ORA';

Set newname for datafile 7 to 'E:\data\FCDB_AUDIT_DATA01.DBF';

Set newname for datafile 8 to 'E:\data\FCDB_AUDIT_INDX01.DBF';

restore datafile 1,2,3,4,5,6,7,8;

switch datafile all;

}

RMAN>

run{

allocate channel d1 type 'SBT_TAPE';

send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbyczk';

Set newname for datafile 1 TO 'E:\DATA\SYSTEM01.DBF';

Set newname for datafile 2 TO 'E:\DATA\UNDOTBS01.DBF';

Set newname for datafile 3 TO 'E:\DATA\INDX01.DBF';

Set newname for datafile 4 TO 'E:\DATA\TOOLS01.DBF';

Set newname for datafile 5 TO 'E:\DATA\USERS01.DBF';

Set newname for datafile 6 TO 'E:\DATA\TAZMSPCE01.ORA';

Set newname for datafile 7 TO 'E:\DATA\TAZMSPCE02.ORA';

Set newname for datafile 8 TO 'E:\DATA\TAZMSPCE03.ORA';

Set newname for datafile 9 TO 'E:\DATA\TAZMSPCE04.ORA';

Set newname for datafile 10 TO 'E:\DATA\DATAGATHER.ORA';

Set newname for datafile 11 TO 'E:\DATA\DATAGATH.ORA';

Set newname for datafile 12 TO 'E:\DATA\TAZMSPCE05.ORA';

Set newname for datafile 13 TO 'E:\DATA\SDZK01.ORA';

Set newname for datafile 14 TO 'E:\DATA\TAZMSPCE06.ORA';

Set newname for datafile 15 TO 'E:\DATA\DYNAMIC_OTHER.ORA';

Set newname for datafile 16 TO 'E:\DATA\DYNAMIC_COLLECT.ORA';

Set newname for datafile 19 TO 'E:\DATA\IDX_DYNAMIC3.ORA.ORA.ORA'; Set newname for datafile 17 TO 'E:\DATA\IDX_DYNAMIC.ORA';

Set newname for datafile 18 TO 'E:\DATA\IDX_DYNAMIC2.ORA.ORA';

Set newname for datafile 20 TO 'E:\DATA\IDX_DYNAMIC4.ORA.ORA.ORA.ORA'; Set newname for datafile 21 TO 'E:\DATA\IDX_DYNAMIC5.ORA.ORA.ORA.ORA'; Set newname for datafile 22 TO 'E:\DATA\PORTAL.ORA';

Set newname for datafile 23 TO 'E:\DATA\PERFSTAT.ORA';

Set newname for datafile 24 TO 'E:\DATA\DYNAMIC_BILL.ORA';

restore datafile 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24; switch datafile all;

}

恢复数据库。

RMAN>

run{

allocate channel d1 type 'SBT_TAPE';

send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbyczk';

set until sequence 9386 thread 1;

restore database;

recover database;

release channel t1;

}

SQL> alter database open resetlogs;

select * from v$logfile;

1 ONLINE X:\DATA\REDO01.LOG

2 ONLINE X:\DATA\REDO02.LOG

3 ONLINE X:\DATA\REDO03.LOG

ALTER DATABASE RENAME 'X:\DATA\REDO01.LOG' ,'X:\DATA\REDO02.LOG','X:\DATA\REDO03.LOG' to 'E:\DATA\REDO01.LOG','E:\DATA\REDO02.LOG','E:\DATA\REDO03.LOG';

FILE

分销数据库本机恢复

恢复控制文件

RMAN>

run

{

allocate channel d1 type 'SBT_TAPE';

send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbserverB_service'; restore controlfile from 'cntrl_9369_1_778716822';

release channel d1;

}

恢复数据库

RMAN> alter database mount;

database mounted

RMAN> run

2> {

3> allocate channel d1 type 'SBT_TAPE';

4> send 'NB_ORA_SERV=netbackup,NB_ORA_CLIENT=zbserverB_service'; 5> RESTORE DATABASE;

6> RECOVER DATABASE;

7> release channel d1;

8> }

using target database controlfile instead of recovery catalog

allocated channel: d1

channel d1: sid=10 devtype=SBT_TAPE

channel d1: Veritas NetBackup for Oracle - Release 7.1 (2011020322)

sent command to channel: d1

Starting restore at 24-MAR-12

channel d1: starting datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

restoring datafile 00001 to /oradb/system01.dbf

restoring datafile 00013 to /oraindex/DY_INDEX_TS_03.dbf

restoring datafile 00021 to /oraindex/ST_INDEX_TS_04.dbf

restoring datafile 00025 to /oradata/ST_TS_02.dbf

channel d1: restored backup piece 1

piece handle=bk_9324_1_778456619 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

restoring datafile 00005 to /oradb/users01.dbf

restoring datafile 00007 to /oradata/DY_CO_TS_01.dbf

restoring datafile 00014 to /oradata/DY_OTHER_TS_01.dbf

restoring datafile 00015 to /oradata/DY_OTHER_TS_02.dbf

restoring datafile 00023 to /oradata/ST_INDEX_TS_06.dbf

channel d1: restored backup piece 1

piece handle=bk_9325_1_778456619 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

restoring datafile 00003 to /oradb/indx01.dbf

restoring datafile 00010 to /oradata/DY_GL_TS_01.dbf

restoring datafile 00016 to /oradata/DY_OTHER_TS_03.dbf

restoring datafile 00022 to /oraindex/ST_INDEX_TS_05.dbf

restoring datafile 00026 to /oradata/ST_TS_03.dbf

channel d1: restored backup piece 1

piece handle=bk_9326_1_778456825 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

restoring datafile 00004 to /oradb/tools01.dbf

restoring datafile 00006 to /oradata/CALLCENTER.dbf

restoring datafile 00012 to /oraindex/DY_INDEX_TS_02.dbf

restoring datafile 00020 to /oraindex/ST_INDEX_TS_03.dbf

restoring datafile 00024 to /oradata/ST_TS_01.dbf

channel d1: restored backup piece 1

piece handle=bk_9327_1_778457020 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

restoring datafile 00008 to /oradata/DY_CO_TS_02.dbf

restoring datafile 00011 to /oraindex/DY_INDEX_TS_01.dbf

restoring datafile 00017 to /oradata/DY_OTHER_TS_04.dbf

restoring datafile 00018 to /oraindex/ST_INDEX_TS_01.dbf

restoring datafile 00019 to /oraindex/ST_INDEX_TS_02.dbf

channel d1: restored backup piece 1

piece handle=bk_9328_1_778457236 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

restoring datafile 00002 to /oradb/undotbs01.dbf

restoring datafile 00009 to /oradata/DY_CO_TS_03.dbf

channel d1: restored backup piece 1

piece handle=bk_9329_1_778457411 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

Finished restore at 24-MAR-12

Starting recover at 24-MAR-12

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00005: /oradb/users01.dbf

destination for restore of datafile 00007: /oradata/DY_CO_TS_01.dbf destination for restore of datafile 00014: /oradata/DY_OTHER_TS_01.dbf destination for restore of datafile 00015: /oradata/DY_OTHER_TS_02.dbf destination for restore of datafile 00023: /oradata/ST_INDEX_TS_06.dbf channel d1: restored backup piece 1

piece handle=bk_9336_1_778543018 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: /oradb/system01.dbf

destination for restore of datafile 00013: /oraindex/DY_INDEX_TS_03.dbf destination for restore of datafile 00021: /oraindex/ST_INDEX_TS_04.dbf destination for restore of datafile 00025: /oradata/ST_TS_02.dbf

channel d1: restored backup piece 1

piece handle=bk_9335_1_778543018 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00003: /oradb/indx01.dbf

destination for restore of datafile 00010: /oradata/DY_GL_TS_01.dbf destination for restore of datafile 00016: /oradata/DY_OTHER_TS_03.dbf destination for restore of datafile 00022: /oraindex/ST_INDEX_TS_05.dbf destination for restore of datafile 00026: /oradata/ST_TS_03.dbf

channel d1: restored backup piece 1

piece handle=bk_9337_1_778543133 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00004: /oradb/tools01.dbf

destination for restore of datafile 00006: /oradata/CALLCENTER.dbf

destination for restore of datafile 00012: /oraindex/DY_INDEX_TS_02.dbf destination for restore of datafile 00020: /oraindex/ST_INDEX_TS_03.dbf destination for restore of datafile 00024: /oradata/ST_TS_01.dbf

channel d1: restored backup piece 1

piece handle=bk_9338_1_778543238 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00008: /oradata/DY_CO_TS_02.dbf destination for restore of datafile 00011: /oraindex/DY_INDEX_TS_01.dbf destination for restore of datafile 00017: /oradata/DY_OTHER_TS_04.dbf destination for restore of datafile 00018: /oraindex/ST_INDEX_TS_01.dbf destination for restore of datafile 00019: /oraindex/ST_INDEX_TS_02.dbf channel d1: restored backup piece 1

piece handle=bk_9339_1_778543333 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00002: /oradb/undotbs01.dbf

destination for restore of datafile 00009: /oradata/DY_CO_TS_03.dbf channel d1: restored backup piece 1

piece handle=bk_9340_1_778543428 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00005: /oradb/users01.dbf

piece handle=bk_9347_1_778629417 tag=HOT_DB_BK_LEVEL0 params=NULL

channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: /oradb/system01.dbf

channel d1: restored backup piece 1

piece handle=bk_9346_1_778629417 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00003: /oradb/indx01.dbf

channel d1: restored backup piece 1

piece handle=bk_9348_1_778629533 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00004: /oradb/tools01.dbf

destination for restore of datafile 00006: /oradata/CALLCENTER.dbf

channel d1: restored backup piece 1

piece handle=bk_9349_1_778629638 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

piece handle=bk_9350_1_778629733 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00002: /oradb/undotbs01.dbf

destination for restore of datafile 00009: /oradata/DY_CO_TS_03.dbf

channel d1: restored backup piece 1

piece handle=bk_9351_1_778629838 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00001: /oradb/system01.dbf

channel d1: restored backup piece 1

piece handle=bk_9357_1_778715816 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00005: /oradb/users01.dbf

piece handle=bk_9358_1_778715816 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00003: /oradb/indx01.dbf

channel d1: restored backup piece 1

piece handle=bk_9359_1_778715932 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00004: /oradb/tools01.dbf

destination for restore of datafile 00006: /oradata/CALLCENTER.dbf

channel d1: restored backup piece 1

piece handle=bk_9360_1_778716027 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00008: /oradata/DY_CO_TS_02.dbf

destination for restore of datafile 00011: /oraindex/DY_INDEX_TS_01.dbf

destination for restore of datafile 00017: /oradata/DY_OTHER_TS_04.dbf

destination for restore of datafile 00018: /oraindex/ST_INDEX_TS_01.dbf

destination for restore of datafile 00019: /oraindex/ST_INDEX_TS_02.dbf

channel d1: restored backup piece 1

piece handle=bk_9361_1_778716132 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

channel d1: starting incremental datafile backupset restore

channel d1: specifying datafile(s) to restore from backup set

destination for restore of datafile 00002: /oradb/undotbs01.dbf

destination for restore of datafile 00009: /oradata/DY_CO_TS_03.dbf

channel d1: restored backup piece 1

piece handle=bk_9362_1_778716227 tag=HOT_DB_BK_LEVEL0 params=NULL channel d1: restore complete

starting media recovery

archive log thread 1 sequence 27952 is already on disk as file /oradb/redo01.log archive log thread 1 sequence 27953 is already on disk as file /oradb/redo02.log archive log thread 1 sequence 27954 is already on disk as file /oradb/redo03.log channel d1: starting archive log restore to default destination

channel d1: restoring archive log

archive log thread=1 sequence=27950

channel d1: restoring archive log

archive log thread=1 sequence=27951

channel d1: restored backup piece 1

piece handle=al_9368_1_778716738 tag=TAG20120323T220900 params=NULL channel d1: restore complete

archive log filename=/ora_archlog/1_27950.dbf thread=1 sequence=27950 archive log filename=/ora_archlog/1_27951.dbf thread=1 sequence=27951 archive log filename=/oradb/redo01.log thread=1 sequence=27952

archive log filename=/oradb/redo02.log thread=1 sequence=27953

archive log filename=/oradb/redo03.log thread=1 sequence=27954

media recovery complete

Finished recover at 24-MAR-12

released channel: d1

RMAN> alter database open;

RMAN-03002: failure of alter db command at 03/24/2012 19:57:16

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

RMAN> quit

Recovery Manager complete.

$ sqlplus /nolog

SQL*Plus: Release 9.2.0.7.0 - Production on Sat Mar 24 19:57:26 2012

SQL> conn / as sysdba;

Connected.

SQL> select status from v$instance;

STATUS

------------

MOUNTED

SQL> alter database open;

alter database open

ERROR at line 1:

ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open NORESETLOGS;

alter database open NORESETLOGS

ERROR at line 1:

ORA-01588: must use RESETLOGS option for database open

SQL> alter database RESETLOGS;

alter database RESETLOGS

ERROR at line 1:

ORA-02231: missing or invalid option to ALTER DATABASE

SQL> alter database open RESETLOGS;

Database altered.

oracle数据库NBU异机恢复测试报告

文件恢复

打开备份恢复客户端

oracle数据库NBU异机恢复测试报告

点击菜单---文件--选择备份机器和策略类型，服务器选择master server,选择源客户端和要恢复的目标客户端，选择备份策略类型为standard,点击

oracle数据库NBU异机恢复测试报告

点击选择恢复，选中要恢复的文件，点击开始恢复

oracle数据库NBU异机恢复测试报告

选择恢复到原始位置，点击开始恢复

oracle数据库NBU异机恢复测试报告

选择是

oracle数据库NBU异机恢复测试报告

文件成功恢复

oracle数据库NBU异机恢复测试报告

更多相关推荐：

Oracle数据库巡检方案: Oracle数据库巡检维护方案一巡检维护的目的为了保障数据库正常运行保证数据的安全性完整性和可用性需进行数据库巡检维护二巡检维护的分类数据库巡检维护包含的内容很多如果每天都将这些项目进行一遍在时间上是不允许的可...
oracle数据库巡检报告模板: 系统oracle数据库巡检报告文档控制修改记录审阅分发目录文档控制2检查总结5概要5总体概况5优化建议5介绍6目标6检查方法6检查范围6数据库配置分析7硬件配置7软件配置7数据库参数8控制文件9Temporar...
Oracle数据库巡检报告: XXX数据库XXX巡检报告1第一部分操作系统参数检查211检查数据库cpuIO内存性能212检查Oracle服务进程22第二部分Oracle数据库检查321数据库状态3211检查oracle环境变量3212检查...
oracle巡检报告模式: 1.1硬件配置1.2数据库配置1.3基于Oracle的应用2系统和数据库的可用性2.1数据库监控：2.1.1Parameterssetpagesize1000数据库初始参数#showParametersSQLc…
Oracle数据库巡检SQL: FILEDatebaseXunJiansqlpromptpromptpromptDatabaseXunJianpromptpromptpromptpromptpromptCreatingdatabasereportpromptTh...
oracle 数据库维护工作内容: oracle数据oracle数据库的维护老兄转一篇帖子我也是这样操作的载自oracle中文技术论坛从整体上介绍了一个dba的职责和任务等等ORACLE数据库管理员应按如下方式对ORACLE数据库系统做定期监控1...
Oracle数据库日常检查: Oracle数据库日常检查A查看所有的实例及其后台进程是否正常确认所有的instance工作正常登陆到所有的数据库或instance上检测oracle后台进程envgrepSIDORACLESIDUWNMS3B...

20xxoracle数据库维保招标文件: 第一部分项目须知一项目编号二采购项目名称20xx年度oracle数据库续保三采购方式公开招标四采购内容数量及参数要求服务或售后服务要求乙方应提供原厂级别724即每周7个工作日每天24小时2小时内到达现场全天技术...
Oracle10g数据库巡检工具使用方法及SQL汇总: Oracle10g数据库巡检工具使用方法及SQL汇总一使用方法使用该工具可以大大简化数据库巡检的工作并可生成HTML文档方便阅读和保存使用软件前需要修改系统时间一般向前调整2年及可如今天是20xx年5月10日使...
oracle数据库job问题发生检查列表: ChecklistForJobIssuesIstheDatabaseInstanceinRESTRICTEDSESSIONSmodeIstheparameterJOBQUEUEPROCESSESsetto0Isthehiddenp...

Oracle数据库课程设计——学生考勤系统的Oracle实现1: 辽宁工程技术大学Oracle数据库课程设计报告学生考勤系统姓名班级学号完成日期指导教师XXXX辽宁工程技术大学软件学院目录1学生考勤管理系统背景分析32学生考勤管理系统需求分析321用户需求描述3221学生用户...
Java oracle数据库课程设计报告: 南阳理工学院数据库程序设计课程设计报告课题姓名学号同组姓名专业班级指导教师设计时间20xx年6月目录1开发背景32系统描述33数据分析431数据流图432数据字典44概念模型设计941ER图95逻辑模型设计及优...

oracle数据库巡检报告（11篇）

热门关注

oracle数据库课程设计报告-学生考勤系统

Oracle数据库课程设计——Oracle实现

Oracle数据库课程设计

oracle日常巡检