记录源端windows上oracle的dbid

[plain] view plaincopyprint?

1. SQL> select dbid from v$database;  
2.       DBID  
3. ----------  
4.   66428446  

SQL> select dbid from v$database;
      DBID
----------
  66428446

[plain] view plaincopyprint?

1. RMAN> RUN{  
2. 2> ALLOCATE CHANNEL C1 TYPE DISK;  
3. 3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';  
4. 4> BACKUP AS BACKUPSET FORMAT 'c:\bak\%T_%s_%p_BAK_DATA' DATABASE;  
5. 5> BACKUP ARCHIVELOG ALL FORMAT 'c:\bak\%T_%s_%p_BAK_ARC' DELETE INPUT;  
6. 6> BACKUP CURRENT CONTROLFILE FORMAT 'c:\bak\%U_BAK_CTL';  
7. 7> RELEASE CHANNEL C1;  
8. 8> }  
9.   
10. 使用目标数据库控制文件替代恢复目录  
11. 分配的通道: C1  
12. 通道 C1: sid=521 devtype=DISK  
13.   
14. sql 语句: ALTER SYSTEM ARCHIVE LOG CURRENT  
15.   
16. 启动 backup 于 10-2月 -14  
17. 通道 C1: 启动全部数据文件备份集  
18. 通道 C1: 正在指定备份集中的数据文件  
19. 输入数据文件 fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSTEM01.DBF  
20. 输入数据文件 fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSAUX01.DBF  
21. 输入数据文件 fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\EXAMPLE01.DBF  
22. 输入数据文件 fno=00006 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF  
23. 输入数据文件 fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\UNDOTBS01.DBF  
24. 输入数据文件 fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\USERS01.DBF  
25. 通道 C1: 正在启动段 1 于 10-2月 -14  
26.  MAN-03009: backup 命令 (C1 通道上, 在 02/10/2014 21:50:37 上) 失败  
27. ORA-19566: 超出损坏块限制 0 (文件 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF)  
28. 继续执行其它作业步骤, 将不重新运行失败的作业  
29. 通道 C1: 启动全部数据文件备份集  
30. 通道 C1: 正在指定备份集中的数据文件  
31. 备份集中包括当前控制文件  
32. 在备份集中包含当前的 SPFILE  
33. 通道 C1: 正在启动段 1 于 10-2月 -14  
34. 通道 C1: 已完成段 1 于 10-2月 -14  
35. 段句柄=C:\BAK\20140210_9_1_BAK_DATA 标记=TAG20140210T215036 注释=NONE  
36. 通道 C1: 备份集已完成, 经过时间:00:00:02  
37. 释放的通道: C1  
38. RMAN-00571: ===========================================================  
39. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  
40. RMAN-00571: ===========================================================  

RMAN> RUN{
2> ALLOCATE CHANNEL C1 TYPE DISK;
3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
4> BACKUP AS BACKUPSET FORMAT 'c:\bak\%T_%s_%p_BAK_DATA' DATABASE;
5> BACKUP ARCHIVELOG ALL FORMAT 'c:\bak\%T_%s_%p_BAK_ARC' DELETE INPUT;
6> BACKUP CURRENT CONTROLFILE FORMAT 'c:\bak\%U_BAK_CTL';
7> RELEASE CHANNEL C1;
8> }

使用目标数据库控制文件替代恢复目录
分配的通道: C1
通道 C1: sid=521 devtype=DISK

sql 语句: ALTER SYSTEM ARCHIVE LOG CURRENT

启动 backup 于 10-2月 -14
通道 C1: 启动全部数据文件备份集
通道 C1: 正在指定备份集中的数据文件
输入数据文件 fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSTEM01.DBF
输入数据文件 fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSAUX01.DBF
输入数据文件 fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\EXAMPLE01.DBF
输入数据文件 fno=00006 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF
输入数据文件 fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\UNDOTBS01.DBF
输入数据文件 fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\USERS01.DBF
通道 C1: 正在启动段 1 于 10-2月 -14
 MAN-03009: backup 命令 (C1 通道上, 在 02/10/2014 21:50:37 上) 失败
ORA-19566: 超出损坏块限制 0 (文件 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF)
继续执行其它作业步骤, 将不重新运行失败的作业
通道 C1: 启动全部数据文件备份集
通道 C1: 正在指定备份集中的数据文件
备份集中包括当前控制文件
在备份集中包含当前的 SPFILE
通道 C1: 正在启动段 1 于 10-2月 -14
通道 C1: 已完成段 1 于 10-2月 -14
段句柄=C:\BAK\20140210_9_1_BAK_DATA 标记=TAG20140210T215036 注释=NONE
通道 C1: 备份集已完成, 经过时间:00:00:02
释放的通道: C1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================

[plain] view plaincopyprint?

1. C:\>dbv file=C:\oracle\product\10.2.0\oradata\dbserver\zwc.dbf  
2.   
3. DBVERIFY: Release 10.2.0.4.0 - Production on 星期一 2月 10 21:47:45 2014  
4.   
5. Copyright (c) 1982, 2007, Oracle.  All rights reserved.  
6.   
7. DBVERIFY - 开始验证: FILE = C:\oracle\product\10.2.0\oradata\dbserver\zwc.dbf  
8. 页 1129 标记为损坏  
9. Corrupt block relative dba: 0x01800469 (file 6, block 1129)  
10. Bad check value found during dbv:  
11. Data in bad block:  
12.  type: 6 format: 2 rdba: 0x01800469  
13.  last change scn: 0x0000.0009c385 seq: 0x1 flg: 0x06  
14.  spare1: 0x0 spare2: 0x0 spare3: 0x0  
15.  consistency value in tail: 0xc3850601  
16.  check value in block header: 0x9a56  
17.  computed block checksum: 0xd64e  
18.   
19. 页 1132 标记为损坏  
20. Corrupt block relative dba: 0x0180046c (file 6, block 1132)  
21. Bad check value found during dbv:  
22. Data in bad block:  
23.  type: 6 format: 2 rdba: 0x0180046c  
24.  last change scn: 0x0000.0009c385 seq: 0x1 flg: 0x06  
25.  spare1: 0x0 spare2: 0x0 spare3: 0x0  
26.  consistency value in tail: 0xc3850601  
27.  check value in block header: 0xd748  
28.  computed block checksum: 0x7e6  
29.   
30.   
31.   
32. DBVERIFY - 验证完成  
33.   
34. 检查的页总数: 12800  
35. 处理的页总数 (数据): 12135  
36. 失败的页总数 (数据): 0  
37. 处理的页总数 (索引): 0  
38. 失败的页总数 (索引): 0  
39. 处理的页总数 (其它): 159  
40. 处理的总页数 (段)  : 0  
41. 失败的总页数 (段)  : 0  
42. 空的页总数: 504  
43. 标记为损坏的总页数: 2  
44. 流入的页总数: 0  
45. 最高块 SCN            : 639878 (0.639878)  
46.   
47. C:\>  

C:\>dbv file=C:\oracle\product\10.2.0\oradata\dbserver\zwc.dbf

DBVERIFY: Release 10.2.0.4.0 - Production on 星期一 2月 10 21:47:45 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - 开始验证: FILE = C:\oracle\product\10.2.0\oradata\dbserver\zwc.dbf
页 1129 标记为损坏
Corrupt block relative dba: 0x01800469 (file 6, block 1129)
Bad check value found during dbv:
Data in bad block:
 type: 6 format: 2 rdba: 0x01800469
 last change scn: 0x0000.0009c385 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xc3850601
 check value in block header: 0x9a56
 computed block checksum: 0xd64e

页 1132 标记为损坏
Corrupt block relative dba: 0x0180046c (file 6, block 1132)
Bad check value found during dbv:
Data in bad block:
 type: 6 format: 2 rdba: 0x0180046c
 last change scn: 0x0000.0009c385 seq: 0x1 flg: 0x06
 spare1: 0x0 spare2: 0x0 spare3: 0x0
 consistency value in tail: 0xc3850601
 check value in block header: 0xd748
 computed block checksum: 0x7e6



DBVERIFY - 验证完成

检查的页总数: 12800
处理的页总数 (数据): 12135
失败的页总数 (数据): 0
处理的页总数 (索引): 0
失败的页总数 (索引): 0
处理的页总数 (其它): 159
处理的总页数 (段)  : 0
失败的总页数 (段)  : 0
空的页总数: 504
标记为损坏的总页数: 2
流入的页总数: 0
最高块 SCN            : 639878 (0.639878)

C:\>

[plain] view plaincopyprint?

1. 恢复管理器: Release 10.2.0.4.0 - Production on 星期一 2月 10 21:58:28 2014  
2.   
3. Copyright (c) 1982, 2007, Oracle.  All rights reserved.  
4.   
5. 连接到目标数据库: DBSERVER (DBID=66428446)  
6.   
7. RMAN>  
8.   
9. RMAN>  
10.   
11. RMAN> run{  
12. 2> ALLOCATE CHANNEL C1 TYPE DISK;  
13. 3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';  
14. 4> SET MAXCORRUPT FOR DATAFILE 6 TO 2;  
15. 5> BACKUP AS BACKUPSET FORMAT 'c:\bak\%T_%s_%p_BAK_DATA' DATABASE;  
16. 6> BACKUP ARCHIVELOG ALL FORMAT 'c:\bak\%T_%s_%p_BAK_ARC' DELETE INPUT;  
17. 7> BACKUP CURRENT CONTROLFILE FORMAT 'c:\bak\%U_BAK_CTL';  
18. 8> RELEASE CHANNEL C1;  
19. 9> }  
20.   
21. 使用目标数据库控制文件替代恢复目录  
22. 分配的通道: C1  
23. 通道 C1: sid=521 devtype=DISK  
24.   
25. sql 语句: ALTER SYSTEM ARCHIVE LOG CURRENT  
26.   
27. 正在执行命令: SET MAX CORRUPT  
28.   
29. 启动 backup 于 10-2月 -14  
30. 通道 C1: 启动全部数据文件备份集  
31. 通道 C1: 正在指定备份集中的数据文件  
32. 输入数据文件 fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSTEM01.DBF  
33. 输入数据文件 fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSAUX01.DBF  
34. 输入数据文件 fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\EXAMPLE01.DBF  
35. 输入数据文件 fno=00006 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF  
36. 输入数据文件 fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\UNDOTBS01.DBF  
37. 输入数据文件 fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\USERS01.DBF  
38. 通道 C1: 正在启动段 1 于 10-2月 -14  
39. 通道 C1: 已完成段 1 于 10-2月 -14  
40. 段句柄=C:\BAK\20140210_16_1_BAK_DATA 标记=TAG20140210T215842 注释=NONE  
41. 通道 C1: 备份集已完成, 经过时间:00:00:07  
42. 通道 C1: 启动全部数据文件备份集  
43. 通道 C1: 正在指定备份集中的数据文件  
44. 备份集中包括当前控制文件  
45. 在备份集中包含当前的 SPFILE  
46. 通道 C1: 正在启动段 1 于 10-2月 -14  
47. 通道 C1: 已完成段 1 于 10-2月 -14  
48. 段句柄=C:\BAK\20140210_17_1_BAK_DATA 标记=TAG20140210T215842 注释=NONE  
49. 通道 C1: 备份集已完成, 经过时间:00:00:02  
50. 完成 backup 于 10-2月 -14  
51.   
52. 启动 backup 于 10-2月 -14  
53. 当前日志已存档  
54. 通道 C1: 正在启动存档日志备份集  
55. 通道 C1: 正在指定备份集中的存档日志  
56. 输入存档日志线程 =1 序列 =19 记录 ID=18 时间戳=839195922  
57. 输入存档日志线程 =1 序列 =20 记录 ID=19 时间戳=839195932  
58. 通道 C1: 正在启动段 1 于 10-2月 -14  
59. 通道 C1: 已完成段 1 于 10-2月 -14  
60. 段句柄=C:\BAK\20140210_18_1_BAK_ARC 标记=TAG20140210T215852 注释=NONE  
61. 通道 C1: 备份集已完成, 经过时间:00:00:02  
62. 通道 C1: 正在删除存档日志  
63. 存档日志文件名 =C:\ARCH\ARC00019_0839181856.001 记录 ID=18 时间戳 =839195922  
64. 存档日志文件名 =C:\ARCH\ARC00020_0839181856.001 记录 ID=19 时间戳 =839195932  
65. 完成 backup 于 10-2月 -14  
66.   
67. 启动 backup 于 10-2月 -14  
68. 通道 C1: 启动全部数据文件备份集  
69. 通道 C1: 正在指定备份集中的数据文件  
70. 备份集中包括当前控制文件  
71. 通道 C1: 正在启动段 1 于 10-2月 -14  
72. 通道 C1: 已完成段 1 于 10-2月 -14  
73. 段句柄=C:\BAK\0JP0A78U_1_1_BAK_CTL 标记=TAG20140210T215854 注释=NONE  
74. 通道 C1: 备份集已完成, 经过时间:00:00:01  
75. 完成 backup 于 10-2月 -14  
76.   
77. 释放的通道: C1  
78.   
79. RMAN>  

恢复管理器: Release 10.2.0.4.0 - Production on 星期一 2月 10 21:58:28 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

连接到目标数据库: DBSERVER (DBID=66428446)

RMAN>

RMAN>

RMAN> run{
2> ALLOCATE CHANNEL C1 TYPE DISK;
3> SQL 'ALTER SYSTEM ARCHIVE LOG CURRENT';
4> SET MAXCORRUPT FOR DATAFILE 6 TO 2;
5> BACKUP AS BACKUPSET FORMAT 'c:\bak\%T_%s_%p_BAK_DATA' DATABASE;
6> BACKUP ARCHIVELOG ALL FORMAT 'c:\bak\%T_%s_%p_BAK_ARC' DELETE INPUT;
7> BACKUP CURRENT CONTROLFILE FORMAT 'c:\bak\%U_BAK_CTL';
8> RELEASE CHANNEL C1;
9> }

使用目标数据库控制文件替代恢复目录
分配的通道: C1
通道 C1: sid=521 devtype=DISK

sql 语句: ALTER SYSTEM ARCHIVE LOG CURRENT

正在执行命令: SET MAX CORRUPT

启动 backup 于 10-2月 -14
通道 C1: 启动全部数据文件备份集
通道 C1: 正在指定备份集中的数据文件
输入数据文件 fno=00001 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSTEM01.DBF
输入数据文件 fno=00003 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSAUX01.DBF
输入数据文件 fno=00005 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\EXAMPLE01.DBF
输入数据文件 fno=00006 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF
输入数据文件 fno=00002 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\UNDOTBS01.DBF
输入数据文件 fno=00004 name=C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\USERS01.DBF
通道 C1: 正在启动段 1 于 10-2月 -14
通道 C1: 已完成段 1 于 10-2月 -14
段句柄=C:\BAK\20140210_16_1_BAK_DATA 标记=TAG20140210T215842 注释=NONE
通道 C1: 备份集已完成, 经过时间:00:00:07
通道 C1: 启动全部数据文件备份集
通道 C1: 正在指定备份集中的数据文件
备份集中包括当前控制文件
在备份集中包含当前的 SPFILE
通道 C1: 正在启动段 1 于 10-2月 -14
通道 C1: 已完成段 1 于 10-2月 -14
段句柄=C:\BAK\20140210_17_1_BAK_DATA 标记=TAG20140210T215842 注释=NONE
通道 C1: 备份集已完成, 经过时间:00:00:02
完成 backup 于 10-2月 -14

启动 backup 于 10-2月 -14
当前日志已存档
通道 C1: 正在启动存档日志备份集
通道 C1: 正在指定备份集中的存档日志
输入存档日志线程 =1 序列 =19 记录 ID=18 时间戳=839195922
输入存档日志线程 =1 序列 =20 记录 ID=19 时间戳=839195932
通道 C1: 正在启动段 1 于 10-2月 -14
通道 C1: 已完成段 1 于 10-2月 -14
段句柄=C:\BAK\20140210_18_1_BAK_ARC 标记=TAG20140210T215852 注释=NONE
通道 C1: 备份集已完成, 经过时间:00:00:02
通道 C1: 正在删除存档日志
存档日志文件名 =C:\ARCH\ARC00019_0839181856.001 记录 ID=18 时间戳 =839195922
存档日志文件名 =C:\ARCH\ARC00020_0839181856.001 记录 ID=19 时间戳 =839195932
完成 backup 于 10-2月 -14

启动 backup 于 10-2月 -14
通道 C1: 启动全部数据文件备份集
通道 C1: 正在指定备份集中的数据文件
备份集中包括当前控制文件
通道 C1: 正在启动段 1 于 10-2月 -14
通道 C1: 已完成段 1 于 10-2月 -14
段句柄=C:\BAK\0JP0A78U_1_1_BAK_CTL 标记=TAG20140210T215854 注释=NONE
通道 C1: 备份集已完成, 经过时间:00:00:01
完成 backup 于 10-2月 -14

释放的通道: C1

RMAN>

[plain] view plaincopyprint?

1. SQL> create pfile from spfile;  
2.   
3. 文件已创建。  
4.   
5. SQL> show parameter spfile;  
6.   
7. NAME                                 TYPE        VALUE  
8. ------------------------------------ ----------- ------------------------------  
9. spfile                               string      C:\ORACLE\PRODUCT\10.2.0\DB_1\  
10.                                                  DATABASE\SPFILEORCL.ORA  
11.   
12.   
13. orcl.__db_cache_size=436207616  
14. orcl.__java_pool_size=4194304  
15. orcl.__large_pool_size=4194304  
16. orcl.__shared_pool_size=159383552  
17. orcl.__streams_pool_size=0  
18. *.audit_file_dest='C:\oracle\product\10.2.0\admin\dbserver\adump'  
19. *.background_dump_dest='C:\oracle\product\10.2.0\admin\dbserver\bdump'  
20. *.compatible='10.2.0.3.0'  
21. *.control_files='C:\oracle\product\10.2.0\oradata\dbserver\control01.ctl','C:\oracle\product\10.2.0\oradata\dbserver\control02.ctl','C:\oracle\product\10.2.0\oradata\dbserver\control03.ctl'  
22. *.core_dump_dest='C:\oracle\product\10.2.0\admin\dbserver\cdump'  
23. *.db_block_size=8192  
24. *.db_domain=''  
25. *.db_file_multiblock_read_count=16  
26. *.db_name='dbserver'  
27. *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'  
28. *.job_queue_processes=10  
29. *.log_archive_dest_1='LOCATION=c:\arch'  
30. *.log_archive_format='ARC%S_%R.%T'  
31. *.nls_language='SIMPLIFIED CHINESE'  
32. *.nls_territory='CHINA'  
33. *.open_cursors=300  
34. *.pga_aggregate_target=203423744  
35. *.processes=500  
36. *.remote_login_passwordfile='EXCLUSIVE'  
37. *.sessions=555  
38. *.sga_target=612368384  
39. *.undo_management='AUTO'  
40. *.undo_tablespace='UNDOTBS1'  
41. *.user_dump_dest='C:\oracle\product\10.2.0\admin\dbserver\udump'  

SQL> create pfile from spfile;

文件已创建。

SQL> show parameter spfile;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      C:\ORACLE\PRODUCT\10.2.0\DB_1\
                                                 DATABASE\SPFILEORCL.ORA


orcl.__db_cache_size=436207616
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=159383552
orcl.__streams_pool_size=0
*.audit_file_dest='C:\oracle\product\10.2.0\admin\dbserver\adump'
*.background_dump_dest='C:\oracle\product\10.2.0\admin\dbserver\bdump'
*.compatible='10.2.0.3.0'
*.control_files='C:\oracle\product\10.2.0\oradata\dbserver\control01.ctl','C:\oracle\product\10.2.0\oradata\dbserver\control02.ctl','C:\oracle\product\10.2.0\oradata\dbserver\control03.ctl'
*.core_dump_dest='C:\oracle\product\10.2.0\admin\dbserver\cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='dbserver'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=c:\arch'
*.log_archive_format='ARC%S_%R.%T'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=555
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:\oracle\product\10.2.0\admin\dbserver\udump'

[plain] view plaincopyprint?

1. orcl.__db_cache_size=436207616  
2. orcl.__java_pool_size=4194304  
3. orcl.__large_pool_size=4194304  
4. orcl.__shared_pool_size=159383552  
5. orcl.__streams_pool_size=0  
6. *.audit_file_dest='/u01/app/oracle/admin/dbserver/adump'  
7. *.background_dump_dest='/u01/app/oracle/admin/dbserver/bdump'  
8. *.compatible='10.2.0.3.0'  
9. *.control_files='/u01/app/oracle/oradata/dbserver/control01.ctl','/u01/app/oracle/oradata/dbserver/control02.ctl','/u01/app/oracle/oradata/dbserver/control03.ctl'  
10. *.core_dump_dest='/u01/app/oracle/admin/dbserver/cdump'  
11. *.db_block_size=8192  
12. *.db_domain=''  
13. *.db_file_multiblock_read_count=16  
14. *.db_name='dbserver'  
15. *.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'  
16. *.job_queue_processes=10  
17. *.log_archive_dest_1='LOCATION=/arch'  
18. *.log_archive_format='ARC%S_%R.%T'  
19. *.nls_language='SIMPLIFIED CHINESE'  
20. *.nls_territory='CHINA'  
21. *.open_cursors=300  
22. *.pga_aggregate_target=203423744  
23. *.processes=500  
24. *.remote_login_passwordfile='EXCLUSIVE'  
25. *.sessions=555  
26. *.sga_target=612368384  
27. *.undo_management='AUTO'  
28. *.undo_tablespace='UNDOTBS1'  
29. *.user_dump_dest='/u01/app/oracle/admin/dbserver/udump'  

orcl.__db_cache_size=436207616
orcl.__java_pool_size=4194304
orcl.__large_pool_size=4194304
orcl.__shared_pool_size=159383552
orcl.__streams_pool_size=0
*.audit_file_dest='/u01/app/oracle/admin/dbserver/adump'
*.background_dump_dest='/u01/app/oracle/admin/dbserver/bdump'
*.compatible='10.2.0.3.0'
*.control_files='/u01/app/oracle/oradata/dbserver/control01.ctl','/u01/app/oracle/oradata/dbserver/control02.ctl','/u01/app/oracle/oradata/dbserver/control03.ctl'
*.core_dump_dest='/u01/app/oracle/admin/dbserver/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='dbserver'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORCLXDB)'
*.job_queue_processes=10
*.log_archive_dest_1='LOCATION=/arch'
*.log_archive_format='ARC%S_%R.%T'
*.nls_language='SIMPLIFIED CHINESE'
*.nls_territory='CHINA'
*.open_cursors=300
*.pga_aggregate_target=203423744
*.processes=500
*.remote_login_passwordfile='EXCLUSIVE'
*.sessions=555
*.sga_target=612368384
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/app/oracle/admin/dbserver/udump'

[plain] view plaincopyprint?

1. [oracle@vzwc bak]$ rman target /  
2.   
3. Recovery Manager: Release 10.2.0.4.0 - Production on Mon Feb 10 22:22:16 2014  
4.   
5. Copyright (c) 1982, 2007, Oracle.  All rights reserved.  
6.   
7. connected to target database (not started)  
8.   
9. RMAN> set dbid=66428446  
10.   
11. executing command: SET DBID  
12.   
13. RMAN> startup nomount pfile='/bak/initorcl.ora'  
14.   
15. Oracle instance started  
16.   
17. Total System Global Area     612368384 bytes  
18.   
19. Fixed Size                     2085872 bytes  
20. Variable Size                167775248 bytes  
21. Database Buffers             436207616 bytes  
22. Redo Buffers                   6299648 bytes  
23.   
24. RMAN>   

[oracle@vzwc bak]$ rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Feb 10 22:22:16 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> set dbid=66428446

executing command: SET DBID

RMAN> startup nomount pfile='/bak/initorcl.ora'

Oracle instance started

Total System Global Area     612368384 bytes

Fixed Size                     2085872 bytes
Variable Size                167775248 bytes
Database Buffers             436207616 bytes
Redo Buffers                   6299648 bytes

RMAN> 

[plain] view plaincopyprint?

1. RMAN> restore controlfile from '/bak/0JP0A78U_1_1_BAK_CTL';  
2.   
3. Starting restore at 10-FEB-14  
4. using target database control file instead of recovery catalog  
5. allocated channel: ORA_DISK_1  
6. channel ORA_DISK_1: sid=540 devtype=DISK  
7.   
8. channel ORA_DISK_1: restoring control file  
9. channel ORA_DISK_1: restore complete, elapsed time: 00:00:03  
10. output filename=/u01/app/oracle/oradata/dbserver/control01.ctl  
11. output filename=/u01/app/oracle/oradata/dbserver/control02.ctl  
12. output filename=/u01/app/oracle/oradata/dbserver/control03.ctl  
13. Finished restore at 10-FEB-14  
14.   
15. RMAN> alter database mount;  
16.   
17. database mounted  
18. released channel: ORA_DISK_1  

RMAN> restore controlfile from '/bak/0JP0A78U_1_1_BAK_CTL';

Starting restore at 10-FEB-14
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=540 devtype=DISK

channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output filename=/u01/app/oracle/oradata/dbserver/control01.ctl
output filename=/u01/app/oracle/oradata/dbserver/control02.ctl
output filename=/u01/app/oracle/oradata/dbserver/control03.ctl
Finished restore at 10-FEB-14

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

[plain] view plaincopyprint?

1. RMAN> catalog start with '/bak/';  
2.   
3. searching for all files that match the pattern /bak/  
4.   
5. List of Files Unknown to the Database  
6. =====================================  
7. File Name: /bak/20140210_18_1_BAK_ARC  
8. File Name: /bak/0JP0A78U_1_1_BAK_CTL  
9. File Name: /bak/20140210_17_1_BAK_DATA  
10. File Name: /bak/20140210_16_1_BAK_DATA  
11. File Name: /bak/initorcl.ora  
12.   
13. Do you really want to catalog the above files (enter YES or NO)? YES  
14. cataloging files...  
15. cataloging done  
16.   
17. List of Cataloged Files  
18. =======================  
19. File Name: /bak/20140210_18_1_BAK_ARC  
20. File Name: /bak/0JP0A78U_1_1_BAK_CTL  
21. File Name: /bak/20140210_17_1_BAK_DATA  
22. File Name: /bak/20140210_16_1_BAK_DATA  
23.   
24. List of Files Which Where Not Cataloged  
25. =======================================  
26. File Name: /bak/initorcl.ora  
27.   RMAN-07517: Reason: The file header is corrupted  
28.   
29. RMAN>   

RMAN> catalog start with '/bak/';

searching for all files that match the pattern /bak/

List of Files Unknown to the Database
=====================================
File Name: /bak/20140210_18_1_BAK_ARC
File Name: /bak/0JP0A78U_1_1_BAK_CTL
File Name: /bak/20140210_17_1_BAK_DATA
File Name: /bak/20140210_16_1_BAK_DATA
File Name: /bak/initorcl.ora

Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done

List of Cataloged Files
=======================
File Name: /bak/20140210_18_1_BAK_ARC
File Name: /bak/0JP0A78U_1_1_BAK_CTL
File Name: /bak/20140210_17_1_BAK_DATA
File Name: /bak/20140210_16_1_BAK_DATA

List of Files Which Where Not Cataloged
=======================================
File Name: /bak/initorcl.ora
  RMAN-07517: Reason: The file header is corrupted

RMAN> 

[plain] view plaincopyprint?

1. RMAN> list backup;  
2.   
3.   
4. List of Backup Sets  
5. ===================  
6.   
7. BS Key  Type LV Size  
8. ------- ---- -- ----------  
9. 10      Full    710.09M  
10.   List of Datafiles in backup set 10  
11.   File LV Type Ckp SCN    Ckp Time  Name  
12.   ---- -- ---- ---------- --------- ----  
13.   1       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSTEM01.DBF  
14.   2       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\UNDOTBS01.DBF  
15.   3       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSAUX01.DBF  
16.   4       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\USERS01.DBF  
17.   5       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\EXAMPLE01.DBF  
18.   6       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF  
19.   
20.   Backup Set Copy #1 of backup set 10  
21.   Device Type Elapsed Time Completion Time Compressed Tag  
22.   ----------- ------------ --------------- ---------- ---  
23.   DISK        00:00:04     10-FEB-14       NO         TAG20140210T215842  
24.   
25.     List of Backup Pieces for backup set 10 Copy #1  
26.     BP Key  Pc# Status      Piece Name  
27.     ------- --- ----------- ----------  
28.     10      1   AVAILABLE   C:\BAK\20140210_16_1_BAK_DATA  
29.   
30.   Backup Set Copy #2 of backup set 10  
31.   Device Type Elapsed Time Completion Time Compressed Tag  
32.   ----------- ------------ --------------- ---------- ---  
33.   DISK        00:00:04     10-FEB-14       NO         TAG20140210T215842  
34.   
35.     List of Backup Pieces for backup set 10 Copy #2  
36.     BP Key  Pc# Status      Piece Name  
37.     ------- --- ----------- ----------  
38.     16      1   AVAILABLE   /bak/20140210_16_1_BAK_DATA  
39.   
40. BS Key  Type LV Size  
41. ------- ---- -- ----------  
42. 11      Full    6.80M  
43.   Control File Included: Ckp SCN: 644268       Ckp time: 10-FEB-14  
44.   SPFILE Included: Modification time: 10-FEB-14  
45.   
46.   Backup Set Copy #1 of backup set 11  
47.   Device Type Elapsed Time Completion Time Compressed Tag  
48.   ----------- ------------ --------------- ---------- ---  
49.   DISK        00:00:02     10-FEB-14       NO         TAG20140210T215842  
50.   
51.     List of Backup Pieces for backup set 11 Copy #1  
52.     BP Key  Pc# Status      Piece Name  
53.     ------- --- ----------- ----------  
54.     11      1   AVAILABLE   C:\BAK\20140210_17_1_BAK_DATA  
55.   
56.   Backup Set Copy #2 of backup set 11  
57.   Device Type Elapsed Time Completion Time Compressed Tag  
58.   ----------- ------------ --------------- ---------- ---  
59.   DISK        00:00:02     10-FEB-14       NO         TAG20140210T215842  
60.   
61.     List of Backup Pieces for backup set 11 Copy #2  
62.     BP Key  Pc# Status      Piece Name  
63.     ------- --- ----------- ----------  
64.     15      1   AVAILABLE   /bak/20140210_17_1_BAK_DATA  
65.   
66. BS Key  Size  
67. ------- ----------  
68. 12      2.50K  
69.   
70.   List of Archived Logs in backup set 12  
71.   Thrd Seq     Low SCN    Low Time  Next SCN   Next Time  
72.   ---- ------- ---------- --------- ---------- ---------  
73.   1    19      644196     10-FEB-14 644256     10-FEB-14  
74.   1    20      644256     10-FEB-14 644274     10-FEB-14  
75.   
76.   Backup Set Copy #1 of backup set 12  
77.   Device Type Elapsed Time Completion Time Compressed Tag  
78.   ----------- ------------ --------------- ---------- ---  
79.   DISK        00:00:01     10-FEB-14       NO         TAG20140210T215852  
80.   
81.     List of Backup Pieces for backup set 12 Copy #1  
82.     BP Key  Pc# Status      Piece Name  
83.     ------- --- ----------- ----------  
84.     12      1   AVAILABLE   C:\BAK\20140210_18_1_BAK_ARC  
85.   
86.   Backup Set Copy #2 of backup set 12  
87.   Device Type Elapsed Time Completion Time Compressed Tag  
88.   ----------- ------------ --------------- ---------- ---  
89.   DISK        00:00:01     10-FEB-14       NO         TAG20140210T215852  
90.   
91.     List of Backup Pieces for backup set 12 Copy #2  
92.     BP Key  Pc# Status      Piece Name  
93.     ------- --- ----------- ----------  
94.     13      1   AVAILABLE   /bak/20140210_18_1_BAK_ARC  
95.   
96. BS Key  Type LV Size       Device Type Elapsed Time Completion Time  
97. ------- ---- -- ---------- ----------- ------------ ---------------  
98. 13      Full    6.77M      DISK        00:00:00     10-FEB-14        
99.         BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20140210T215854  
100.         Piece Name: /bak/0JP0A78U_1_1_BAK_CTL  
101.   Control File Included: Ckp SCN: 644281       Ckp time: 10-FEB-14  
102.   
103. RMAN>   

RMAN> list backup;


List of Backup Sets
===================

BS Key  Type LV Size
------- ---- -- ----------
10      Full    710.09M
  List of Datafiles in backup set 10
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSTEM01.DBF
  2       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\UNDOTBS01.DBF
  3       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\SYSAUX01.DBF
  4       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\USERS01.DBF
  5       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\EXAMPLE01.DBF
  6       Full 644266     10-FEB-14 C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\ZWC.DBF

  Backup Set Copy #1 of backup set 10
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:04     10-FEB-14       NO         TAG20140210T215842

    List of Backup Pieces for backup set 10 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    10      1   AVAILABLE   C:\BAK\20140210_16_1_BAK_DATA

  Backup Set Copy #2 of backup set 10
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:04     10-FEB-14       NO         TAG20140210T215842

    List of Backup Pieces for backup set 10 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    16      1   AVAILABLE   /bak/20140210_16_1_BAK_DATA

BS Key  Type LV Size
------- ---- -- ----------
11      Full    6.80M
  Control File Included: Ckp SCN: 644268       Ckp time: 10-FEB-14
  SPFILE Included: Modification time: 10-FEB-14

  Backup Set Copy #1 of backup set 11
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     10-FEB-14       NO         TAG20140210T215842

    List of Backup Pieces for backup set 11 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    11      1   AVAILABLE   C:\BAK\20140210_17_1_BAK_DATA

  Backup Set Copy #2 of backup set 11
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:02     10-FEB-14       NO         TAG20140210T215842

    List of Backup Pieces for backup set 11 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    15      1   AVAILABLE   /bak/20140210_17_1_BAK_DATA

BS Key  Size
------- ----------
12      2.50K

  List of Archived Logs in backup set 12
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    19      644196     10-FEB-14 644256     10-FEB-14
  1    20      644256     10-FEB-14 644274     10-FEB-14

  Backup Set Copy #1 of backup set 12
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     10-FEB-14       NO         TAG20140210T215852

    List of Backup Pieces for backup set 12 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    12      1   AVAILABLE   C:\BAK\20140210_18_1_BAK_ARC

  Backup Set Copy #2 of backup set 12
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:01     10-FEB-14       NO         TAG20140210T215852

    List of Backup Pieces for backup set 12 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    13      1   AVAILABLE   /bak/20140210_18_1_BAK_ARC

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
13      Full    6.77M      DISK        00:00:00     10-FEB-14      
        BP Key: 14   Status: AVAILABLE  Compressed: NO  Tag: TAG20140210T215854
        Piece Name: /bak/0JP0A78U_1_1_BAK_CTL
  Control File Included: Ckp SCN: 644281       Ckp time: 10-FEB-14

RMAN> 

[plain] view plaincopyprint?

1. RMAN> run{  
2. 2> allocate channel c1 type disk;  
3. 3> set newname for datafile 1 to '/u01/app/oracle/oradata/dbserver/system01.dbf';  
4. 4> set newname for datafile 2 to '/u01/app/oracle/oradata/dbserver/undotbs01.dbf';  
5. set newname for datafile 3 to '/u01/app/oracle/oradata/dbserver/sysaux01.dbf';  
6. set newname for datafile 4 to '/u01/app/oracle/oradata/dbserver/users01.dbf';  
7. set newname for datafile 5 to '/u01/app/oracle/oradata/dbserver/example01.dbf';  
8. set newname for datafile 6 to '/u01/app/oracle/oradata/dbserver/zwc.dbf';  
9. 9> restore database;  
10. 10> switch datafile all;  
11. 11> release channel c1;  
12. 12> }  
13.   
14. allocated channel: c1  
15. channel c1: sid=540 devtype=DISK  
16.   
17. executing command: SET NEWNAME  
18.   
19. executing command: SET NEWNAME  
20.   
21. executing command: SET NEWNAME  
22.   
23. executing command: SET NEWNAME  
24.   
25. executing command: SET NEWNAME  
26.   
27. executing command: SET NEWNAME  
28.   
29. Starting restore at 10-FEB-14  
30.   
31. channel c1: restoring datafile 00006  
32. input datafile copy recid=5 stamp=839198158 filename=/u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERZWC.DBF  
33. destination for restore of datafile 00006: /u01/app/oracle/oradata/dbserver/zwc.dbf  
34. channel c1: copied datafile copy of datafile 00006  
35. output filename=/u01/app/oracle/oradata/dbserver/zwc.dbf recid=13 stamp=839198270  
36. channel c1: starting datafile backupset restore  
37. channel c1: specifying datafile(s) to restore from backup set  
38. restoring datafile 00001 to /u01/app/oracle/oradata/dbserver/system01.dbf  
39. restoring datafile 00002 to /u01/app/oracle/oradata/dbserver/undotbs01.dbf  
40. restoring datafile 00003 to /u01/app/oracle/oradata/dbserver/sysaux01.dbf  
41. restoring datafile 00004 to /u01/app/oracle/oradata/dbserver/users01.dbf  
42. restoring datafile 00005 to /u01/app/oracle/oradata/dbserver/example01.dbf  
43. channel c1: reading from backup piece C:\BAK\20140210_16_1_BAK_DATA  
44. channel c1: restored backup piece 1  
45. failover to piece handle=/bak/20140210_16_1_BAK_DATA tag=TAG20140210T215842  
46. channel c1: restore complete, elapsed time: 00:00:25  
47. Finished restore at 10-FEB-14  
48.   
49. datafile 1 switched to datafile copy  
50. input datafile copy recid=19 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/system01.dbf  
51. datafile 2 switched to datafile copy  
52. input datafile copy recid=20 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/undotbs01.dbf  
53. datafile 3 switched to datafile copy  
54. input datafile copy recid=21 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/sysaux01.dbf  
55. datafile 4 switched to datafile copy  
56. input datafile copy recid=22 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/users01.dbf  
57. datafile 5 switched to datafile copy  
58. input datafile copy recid=23 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/example01.dbf  
59. datafile 6 switched to datafile copy  
60. input datafile copy recid=24 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/zwc.dbf  
61.   
62. released channel: c1  
63.   
64. RMAN>   

RMAN> run{
2> allocate channel c1 type disk;
3> set newname for datafile 1 to '/u01/app/oracle/oradata/dbserver/system01.dbf';
4> set newname for datafile 2 to '/u01/app/oracle/oradata/dbserver/undotbs01.dbf';
set newname for datafile 3 to '/u01/app/oracle/oradata/dbserver/sysaux01.dbf';
set newname for datafile 4 to '/u01/app/oracle/oradata/dbserver/users01.dbf';
set newname for datafile 5 to '/u01/app/oracle/oradata/dbserver/example01.dbf';
set newname for datafile 6 to '/u01/app/oracle/oradata/dbserver/zwc.dbf';
9> restore database;
10> switch datafile all;
11> release channel c1;
12> }

allocated channel: c1
channel c1: sid=540 devtype=DISK

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 10-FEB-14

channel c1: restoring datafile 00006
input datafile copy recid=5 stamp=839198158 filename=/u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERZWC.DBF
destination for restore of datafile 00006: /u01/app/oracle/oradata/dbserver/zwc.dbf
channel c1: copied datafile copy of datafile 00006
output filename=/u01/app/oracle/oradata/dbserver/zwc.dbf recid=13 stamp=839198270
channel c1: starting datafile backupset restore
channel c1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /u01/app/oracle/oradata/dbserver/system01.dbf
restoring datafile 00002 to /u01/app/oracle/oradata/dbserver/undotbs01.dbf
restoring datafile 00003 to /u01/app/oracle/oradata/dbserver/sysaux01.dbf
restoring datafile 00004 to /u01/app/oracle/oradata/dbserver/users01.dbf
restoring datafile 00005 to /u01/app/oracle/oradata/dbserver/example01.dbf
channel c1: reading from backup piece C:\BAK\20140210_16_1_BAK_DATA
channel c1: restored backup piece 1
failover to piece handle=/bak/20140210_16_1_BAK_DATA tag=TAG20140210T215842
channel c1: restore complete, elapsed time: 00:00:25
Finished restore at 10-FEB-14

datafile 1 switched to datafile copy
input datafile copy recid=19 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/system01.dbf
datafile 2 switched to datafile copy
input datafile copy recid=20 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/undotbs01.dbf
datafile 3 switched to datafile copy
input datafile copy recid=21 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/sysaux01.dbf
datafile 4 switched to datafile copy
input datafile copy recid=22 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/users01.dbf
datafile 5 switched to datafile copy
input datafile copy recid=23 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/example01.dbf
datafile 6 switched to datafile copy
input datafile copy recid=24 stamp=839198299 filename=/u01/app/oracle/oradata/dbserver/zwc.dbf

released channel: c1

RMAN> 

[plain] view plaincopyprint?

1. RMAN> recover database;  
2.   
3. Starting recover at 10-FEB-14  
4. allocated channel: ORA_DISK_1  
5. channel ORA_DISK_1: sid=540 devtype=DISK  
6.   
7. starting media recovery  
8.   
9. channel ORA_DISK_1: starting archive log restore to default destination  
10. channel ORA_DISK_1: restoring archive log  
11. archive log thread=1 sequence=20  
12. channel ORA_DISK_1: reading from backup piece C:\BAK\20140210_18_1_BAK_ARC  
13. channel ORA_DISK_1: restored backup piece 1  
14. failover to piece handle=/bak/20140210_18_1_BAK_ARC tag=TAG20140210T215852  
15. channel ORA_DISK_1: restore complete, elapsed time: 00:00:01  
16. archive log filename=/arch/ARC0000000020_0839181856.0001 thread=1 sequence=20  
17. unable to find archive log  
18. archive log thread=1 sequence=21  
19. RMAN-00571: ===========================================================  
20. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============  
21. RMAN-00571: ===========================================================  
22. RMAN-03002: failure of recover command at 02/10/2014 22:40:08  
23. RMAN-06054: media recovery requesting unknown log: thread 1 seq 21 lowscn 644274  
24.   
25. RMAN>   

RMAN> recover database;

Starting recover at 10-FEB-14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=540 devtype=DISK

starting media recovery

channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=20
channel ORA_DISK_1: reading from backup piece C:\BAK\20140210_18_1_BAK_ARC
channel ORA_DISK_1: restored backup piece 1
failover to piece handle=/bak/20140210_18_1_BAK_ARC tag=TAG20140210T215852
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=/arch/ARC0000000020_0839181856.0001 thread=1 sequence=20
unable to find archive log
archive log thread=1 sequence=21
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/10/2014 22:40:08
RMAN-06054: media recovery requesting unknown log: thread 1 seq 21 lowscn 644274

RMAN> 

提示介质恢复到一个未知的SCN，可以使用set until scn或者set until time解决

查看源端windows的sequence#

[plain] view plaincopyprint?

1. [oracle@vzwc ~]$ sqlplus sys/oracle@192.168.1.8:1521/dbserver as sysdba  
2.   
3. SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 10 22:42:56 2014  
4.   
5. Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.  
6.   
7.   
8. Connected to:  
9. Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production  
10. With the Partitioning, OLAP, Data Mining and Real Application Testing options  
11.   
12. SQL> select sequence# from v$archived_log;  
13.   
14.  SEQUENCE#  
15. ----------  
16.          2  
17.          3  
18.          4  
19.          5  
20.          6  
21.          7  
22.          8  
23.          9  
24.         10  
25.         11  
26.         12  
27.   
28.  SEQUENCE#  
29. ----------  
30.         13  
31.         14  
32.         15  
33.         16  
34.         17  
35.         18  
36.         19  
37.         20  
38.   
39. 19 rows selected.  
40.   
41. SQL> archive log list  
42. Database log mode              Archive Mode  
43. Automatic archival             Enabled  
44. Archive destination            c:\arch  
45. Oldest online log sequence     19  
46. Next log sequence to archive   21  
47. Current log sequence           21  

[oracle@vzwc ~]$ sqlplus sys/oracle@192.168.1.8:1521/dbserver as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 10 22:42:56 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select sequence# from v$archived_log;

 SEQUENCE#
----------
         2
         3
         4
         5
         6
         7
         8
         9
        10
        11
        12

 SEQUENCE#
----------
        13
        14
        15
        16
        17
        18
        19
        20

19 rows selected.

SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            c:\arch
Oldest online log sequence     19
Next log sequence to archive   21
Current log sequence           21

[plain] view plaincopyprint?

1. RMAN> run{  
2. 2> set until sequence 21;  
3. 3> recover database;  
4. 4> }  
5.   
6. executing command: SET until clause  
7.   
8. Starting recover at 10-FEB-14  
9. using channel ORA_DISK_1  
10.   
11. starting media recovery  
12. media recovery complete, elapsed time: 00:00:01  
13.   
14. Finished recover at 10-FEB-14  
15.   
16. RMAN>   

RMAN> run{
2> set until sequence 21;
3> recover database;
4> }

executing command: SET until clause

Starting recover at 10-FEB-14
using channel ORA_DISK_1

starting media recovery
media recovery complete, elapsed time: 00:00:01

Finished recover at 10-FEB-14

RMAN> 

SQL> alter database open resetlogs migrate; 
SQL> @?/rdbms/admin/utlirp.sql 
SQL> @?/rdbms/admin/utlrp.sql 
SQL> shutdown immediate; 
SQL> startup

open数据库resetlogs

[plain] view plaincopyprint?

1. RMAN> alter database open resetlogs;  
2.   
3. database opened  

RMAN> alter database open resetlogs;

database opened

[plain] view plaincopyprint?

1. SQL> select member from v$logfile;  
2.   
3. MEMBER  
4. ----------------------------------------------------------------------------------------------------  
5. /u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERREDO03.LOG  
6. /u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERREDO02.LOG  
7. /u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERREDO01.LOG  
8.   
9. SQL> select group#,sequence#,bytes/1024/1024,members,status from v$log;  
10.   
11.     GROUP#  SEQUENCE# BYTES/1024/1024    MEMBERS STATUS  
12. ---------- ---------- --------------- ---------- ----------------  
13.          1          1              50          1 CURRENT  
14.          2          0              50          1 UNUSED  
15.          3          0              50          1 UNUSED  
16.   
17. SQL> alter database drop logfile group 2;  
18.   
19. Database altered.  
20.   
21. SQL> alter database add logfile group 2('/u01/app/oracle/oradata/dbserver/redo02.log') size 50M;  
22.   
23. Database altered.  
24.   
25. SQL> alter database drop logfile group 3;  
26.   
27. Database altered.  
28.   
29. SQL> alter database add logfile group 3('/u01/app/oracle/oradata/dbserver/redo03.log') size 50M;  
30.   
31. Database altered.  
32.   
33. SQL> alter system switch logfile;  
34.   
35. System altered.  
36.   
37. SQL> alter database drop logfile group 1;  
38.   
39. Database altered.  
40.   
41. SQL> alter database add logfile group 1('/u01/app/oracle/oradata/dbserver/redo01.log') size 50M;  
42.   
43. Database altered.  
44.   
45. SQL> select a.group#,a.bytes/1024/1024,a.members,a.status,b.member from v$log a,v$logfile b where a.group#=b.group#;  
46.   
47.     GROUP# A.BYTES/1024/1024    MEMBERS STATUS           MEMBER  
48. ---------- ----------------- ---------- ---------------- --------------------------------------------------------------------------------  
49.          3                50          1 INACTIVE         /u01/app/oracle/oradata/dbserver/redo03.log  
50.          2                50          1 CURRENT          /u01/app/oracle/oradata/dbserver/redo02.log  
51.          1                50          1 UNUSED           /u01/app/oracle/oradata/dbserver/redo01.log  

SQL> select member from v$logfile;

MEMBER
----------------------------------------------------------------------------------------------------
/u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERREDO03.LOG
/u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERREDO02.LOG
/u01/app/oracle/product/10.2.0/db_1/dbs/C:ORACLEPRODUCT10.2.0ORADATADBSERVERREDO01.LOG

SQL> select group#,sequence#,bytes/1024/1024,members,status from v$log;

    GROUP#  SEQUENCE# BYTES/1024/1024    MEMBERS STATUS
---------- ---------- --------------- ---------- ----------------
         1          1              50          1 CURRENT
         2          0              50          1 UNUSED
         3          0              50          1 UNUSED

SQL> alter database drop logfile group 2;

Database altered.

SQL> alter database add logfile group 2('/u01/app/oracle/oradata/dbserver/redo02.log') size 50M;

Database altered.

SQL> alter database drop logfile group 3;

Database altered.

SQL> alter database add logfile group 3('/u01/app/oracle/oradata/dbserver/redo03.log') size 50M;

Database altered.

SQL> alter system switch logfile;

System altered.

SQL> alter database drop logfile group 1;

Database altered.

SQL> alter database add logfile group 1('/u01/app/oracle/oradata/dbserver/redo01.log') size 50M;

Database altered.

SQL> select a.group#,a.bytes/1024/1024,a.members,a.status,b.member from v$log a,v$logfile b where a.group#=b.group#;

    GROUP# A.BYTES/1024/1024    MEMBERS STATUS           MEMBER
---------- ----------------- ---------- ---------------- --------------------------------------------------------------------------------
         3                50          1 INACTIVE         /u01/app/oracle/oradata/dbserver/redo03.log
         2                50          1 CURRENT          /u01/app/oracle/oradata/dbserver/redo02.log
         1                50          1 UNUSED           /u01/app/oracle/oradata/dbserver/redo01.log

[plain] view plaincopyprint?

1. SQL> select name from v$tempfile;  
2.   
3. NAME  
4. -------------------------------------------------------------------------------------------------------------------------------  
5. C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\TEMP01.DBF  
6.   
7. SQL> create temporary tablespace temptbs tempfile '/u01/app/oracle/oradata/dbserver/temptbs01.dbf' size 100M autoextend on;  
8.   
9. Tablespace created.  
10.   
11. SQL> alter database default temporary tablespace temptbs;  
12.   
13. Database altered.  
14.   
15. SQL> drop tablespace temp including contents and datafiles;  
16.   
17. Tablespace dropped.  
18.   
19. SQL> select name from v$tempfile;  
20.   
21. NAME  
22. --------------------------------------------------------------------------------------------------------------------------------  
23. /u01/app/oracle/oradata/dbserver/temptbs01.dbf  
24.   
25. SQL>   

SQL> select name from v$tempfile;

NAME
-------------------------------------------------------------------------------------------------------------------------------
C:\ORACLE\PRODUCT\10.2.0\ORADATA\DBSERVER\TEMP01.DBF

SQL> create temporary tablespace temptbs tempfile '/u01/app/oracle/oradata/dbserver/temptbs01.dbf' size 100M autoextend on;

Tablespace created.

SQL> alter database default temporary tablespace temptbs;

Database altered.

SQL> drop tablespace temp including contents and datafiles;

Tablespace dropped.

SQL> select name from v$tempfile;

NAME
--------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/dbserver/temptbs01.dbf

SQL> 

[plain] view plaincopyprint?

1. SQL> show parameter spfile  
2.   
3. NAME                                 TYPE        VALUE  
4. ------------------------------------ ----------- ------------------------------  
5. spfile                               string  
6. SQL>   
7. SQL>   
8. SQL> create spfile from pfile='/bak/initorcl.ora';  
9.   
10. File created.  
11.   
12. SQL> shutdown immediate  
13. Database closed.  
14. Database dismounted.  
15. ORACLE instance shut down.  
16. SQL> startup  
17. ORACLE instance started.  
18.   
19. Total System Global Area  612368384 bytes  
20. Fixed Size                  2085872 bytes  
21. Variable Size             167775248 bytes  
22. Database Buffers          436207616 bytes  
23. Redo Buffers                6299648 bytes  
24. Database mounted.  
25. Database opened.  
26. SQL> show parameter spfile  
27.   
28. NAME                                 TYPE        VALUE  
29. ------------------------------------ ----------- ------------------------------  
30. spfile                               string      /u01/app/oracle/product/10.2.0  
31.                                                  /db_1/dbs/spfileORCL.ora  
32. SQL>   

SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string
SQL> 
SQL> 
SQL> create spfile from pfile='/bak/initorcl.ora';

File created.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  612368384 bytes
Fixed Size                  2085872 bytes
Variable Size             167775248 bytes
Database Buffers          436207616 bytes
Redo Buffers                6299648 bytes
Database mounted.
Database opened.
SQL> show parameter spfile

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                               string      /u01/app/oracle/product/10.2.0
                                                 /db_1/dbs/spfileORCL.ora
SQL> 

[plain] view plaincopyprint?

1. [oracle@vzwc admin]$ cat listener.ora   
2. # listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora  
3. # Generated by Oracle configuration tools.  
4.   
5. SID_LIST_LISTENER =  
6.   (SID_LIST =  
7.     (SID_DESC =  
8.       (GLOBAL_DBNAME = dbserver)  
9.       (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)  
10.       (SID_NAME = ORCL)  
11.     )  
12.   )  
13.   
14. LISTENER =  
15.   (DESCRIPTION =  
16.     (ADDRESS = (PROTOCOL = TCP)(HOST = vzwc)(PORT = 1521))  
17.   )  
18.   
19. [oracle@vzwc admin]$ cat tnsnames.ora   
20. # tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora  
21. # Generated by Oracle configuration tools.  
22.   
23. DBSERVER =  
24.   (DESCRIPTION =  
25.     (ADDRESS_LIST =  
26.       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1521))  
27.     )  
28.     (CONNECT_DATA =  
29.       (SERVICE_NAME = dbserver)  
30.     )  
31.   )  
32.   
33. [oracle@vzwc admin]$   
34. [oracle@vzwc admin]$   
35. [oracle@vzwc admin]$   
36. [oracle@vzwc admin]$   
37. [oracle@vzwc admin]$   
38. [oracle@vzwc admin]$ lsnrctl start  
39.   
40. LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 10-FEB-2014 23:18:27  
41.   
42. Copyright (c) 1991, 2007, Oracle.  All rights reserved.  
43.   
44. Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...  
45.   
46. TNSLSNR for Linux: Version 10.2.0.4.0 - Production  
47. System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora  
48. Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log  
49. Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=1521)))  
50.   
51. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vzwc)(PORT=1521)))  
52. STATUS of the LISTENER  
53. ------------------------  
54. Alias                     LISTENER  
55. Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production  
56. Start Date                10-FEB-2014 23:18:28  
57. Uptime                    0 days 0 hr. 0 min. 0 sec  
58. Trace Level               off  
59. Security                  ON: Local OS Authentication  
60. SNMP                      OFF  
61. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora  
62. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log  
63. Listening Endpoints Summary...  
64.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=1521)))  
65. Services Summary...  
66. Service "dbserver" has 1 instance(s).  
67.   Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...  
68. The command completed successfully  
69. [oracle@vzwc admin]$   
70. [oracle@vzwc admin]$   
71. [oracle@vzwc admin]$   
72. [oracle@vzwc admin]$   
73. [oracle@vzwc admin]$   
74. [oracle@vzwc admin]$   
75. [oracle@vzwc admin]$ lsnrctl status  
76.   
77. LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 10-FEB-2014 23:19:00  
78.   
79. Copyright (c) 1991, 2007, Oracle.  All rights reserved.  
80.   
81. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vzwc)(PORT=1521)))  
82. STATUS of the LISTENER  
83. ------------------------  
84. Alias                     LISTENER  
85. Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production  
86. Start Date                10-FEB-2014 23:18:28  
87. Uptime                    0 days 0 hr. 0 min. 32 sec  
88. Trace Level               off  
89. Security                  ON: Local OS Authentication  
90. SNMP                      OFF  
91. Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora  
92. Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log  
93. Listening Endpoints Summary...  
94.   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=1521)))  
95. Services Summary...  
96. Service "ORCLXDB" has 1 instance(s).  
97.   Instance "ORCL", status READY, has 1 handler(s) for this service...  
98. Service "dbserver" has 2 instance(s).  
99.   Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...  
100.   Instance "ORCL", status READY, has 1 handler(s) for this service...  
101. Service "dbserver_XPT" has 1 instance(s).  
102.   Instance "ORCL", status READY, has 1 handler(s) for this service...  
103. The command completed successfully  
104. [oracle@vzwc admin]$   
105. [oracle@vzwc admin]$   
106. [oracle@vzwc admin]$   
107. [oracle@vzwc admin]$   
108. [oracle@vzwc admin]$ lsnrctl service  
109.   
110. LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 10-FEB-2014 23:19:09  
111.   
112. Copyright (c) 1991, 2007, Oracle.  All rights reserved.  
113.   
114. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vzwc)(PORT=1521)))  
115. Services Summary...  
116. Service "ORCLXDB" has 1 instance(s).  
117.   Instance "ORCL", status READY, has 1 handler(s) for this service...  
118.     Handler(s):  
119.       "D000" established:0 refused:0 current:0 max:1022 state:ready  
120.          DISPATCHER   
121.          (ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=47521))  
122. Service "dbserver" has 2 instance(s).  
123.   Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...  
124.     Handler(s):  
125.       "DEDICATED" established:0 refused:0  
126.          LOCAL SERVER  
127.   Instance "ORCL", status READY, has 1 handler(s) for this service...  
128.     Handler(s):  
129.       "DEDICATED" established:0 refused:0 state:ready  
130.          LOCAL SERVER  
131. Service "dbserver_XPT" has 1 instance(s).  
132.   Instance "ORCL", status READY, has 1 handler(s) for this service...  
133.     Handler(s):  
134.       "DEDICATED" established:0 refused:0 state:ready  
135.          LOCAL SERVER  
136. The command completed successfully  

[oracle@vzwc admin]$ cat listener.ora 
# listener.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = dbserver)
      (ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1)
      (SID_NAME = ORCL)
    )
  )

LISTENER =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = vzwc)(PORT = 1521))
  )

[oracle@vzwc admin]$ cat tnsnames.ora 
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

DBSERVER =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.7)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = dbserver)
    )
  )

[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ lsnrctl start

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 10-FEB-2014 23:18:27

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 10.2.0.4.0 - Production
System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vzwc)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                10-FEB-2014 23:18:28
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=1521)))
Services Summary...
Service "dbserver" has 1 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ lsnrctl status

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 10-FEB-2014 23:19:00

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vzwc)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for Linux: Version 10.2.0.4.0 - Production
Start Date                10-FEB-2014 23:18:28
Uptime                    0 days 0 hr. 0 min. 32 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=1521)))
Services Summary...
Service "ORCLXDB" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "dbserver" has 2 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
  Instance "ORCL", status READY, has 1 handler(s) for this service...
Service "dbserver_XPT" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ 
[oracle@vzwc admin]$ lsnrctl service

LSNRCTL for Linux: Version 10.2.0.4.0 - Production on 10-FEB-2014 23:19:09

Copyright (c) 1991, 2007, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=vzwc)(PORT=1521)))
Services Summary...
Service "ORCLXDB" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
    Handler(s):
      "D000" established:0 refused:0 current:0 max:1022 state:ready
         DISPATCHER 
         (ADDRESS=(PROTOCOL=tcp)(HOST=vzwc)(PORT=47521))
Service "dbserver" has 2 instance(s).
  Instance "ORCL", status UNKNOWN, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0
         LOCAL SERVER
  Instance "ORCL", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
Service "dbserver_XPT" has 1 instance(s).
  Instance "ORCL", status READY, has 1 handler(s) for this service...
    Handler(s):
      "DEDICATED" established:0 refused:0 state:ready
         LOCAL SERVER
The command completed successfully

[plain] view plaincopyprint?

1. [oracle@vzwc admin]$ sqlplus / as sysdba  
2.   
3. SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 10 23:19:43 2014  
4.   
5. Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.  
6.   
7.   
8. Connected to:  
9. Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production  
10. With the Partitioning, OLAP, Data Mining and Real Application Testing options  
11.   
12. SQL> show parameter _name  
13.   
14. NAME                                 TYPE        VALUE  
15. ------------------------------------ ----------- ------------------------------  
16. db_file_name_convert                 string  
17. db_name                              string      dbserver  
18. db_unique_name                       string      dbserver  
19. global_names                         boolean     FALSE  
20. instance_name                        string      ORCL  
21. lock_name_space                      string  
22. log_file_name_convert                string  
23. service_names                        string      dbserver  
24. SQL>   
25. SQL> conn zwc@dbserver  
26. Enter password:   
27. Connected.  
28. SQL> select tname from tab;  
29.   
30. TNAME  
31. ------------------------------  
32. TAB01  
33.   
34. SQL> select * from tab01 where rownum=1;  
35.   
36. OWNER  
37. ------------------------------  
38. OBJECT_NAME  
39. --------------------------------------------------------------------------------  
40. SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE  
41. ------------------------------ ---------- -------------- -------------------  
42. CREATED      LAST_DDL_TIM TIMESTAMP           STATUS  T G S  
43. ------------ ------------ ------------------- ------- - - -  
44. SYS  
45. ICOL$  
46.                                        20              2 TABLE  
47. 08-MAY-08    08-MAY-08    2008-05-08:00:53:58 VALID   N N N  
48.   
49.   
50. SQL> select count(*) from tab01;  
51. select count(*) from tab01  
52.                      *  
53. ERROR at line 1:  
54. ORA-01578: ORACLE data block corrupted (file # 6, block # 1129)  
55. ORA-01110: data file 6: '/u01/app/oracle/oradata/dbserver/zwc.dbf'  

[oracle@vzwc admin]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.4.0 - Production on Mon Feb 10 23:19:43 2014

Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter _name

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert                 string
db_name                              string      dbserver
db_unique_name                       string      dbserver
global_names                         boolean     FALSE
instance_name                        string      ORCL
lock_name_space                      string
log_file_name_convert                string
service_names                        string      dbserver
SQL> 
SQL> conn zwc@dbserver
Enter password: 
Connected.
SQL> select tname from tab;

TNAME
------------------------------
TAB01

SQL> select * from tab01 where rownum=1;

OWNER
------------------------------
OBJECT_NAME
--------------------------------------------------------------------------------
SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
------------------------------ ---------- -------------- -------------------
CREATED      LAST_DDL_TIM TIMESTAMP           STATUS  T G S
------------ ------------ ------------------- ------- - - -
SYS
ICOL$
                                       20              2 TABLE
08-MAY-08    08-MAY-08    2008-05-08:00:53:58 VALID   N N N


SQL> select count(*) from tab01;
select count(*) from tab01
                     *
ERROR at line 1:
ORA-01578: ORACLE data block corrupted (file # 6, block # 1129)
ORA-01110: data file 6: '/u01/app/oracle/oradata/dbserver/zwc.dbf'

[plain] view plaincopyprint?

1. [oracle@vzwc ~]$ dbv file=/u01/app/oracle/oradata/dbserver/zwc.dbf  
2.   
3. DBVERIFY: Release 10.2.0.4.0 - Production on Mon Feb 10 23:24:05 2014  
4.   
5. Copyright (c) 1982, 2007, Oracle.  All rights reserved.  
6.   
7. DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/dbserver/zwc.dbf  
8.   
9. DBV-00200: Block, DBA 25166953, already marked corrupt  
10.   
11. DBV-00200: Block, DBA 25166956, already marked corrupt  
12.   
13.   
14. DBVERIFY - Verification complete  
15.   
16. Total Pages Examined         : 12800  
17. Total Pages Processed (Data) : 12137  
18. Total Pages Failing   (Data) : 0  
19. Total Pages Processed (Index): 0  
20. Total Pages Failing   (Index): 0  
21. Total Pages Processed (Other): 662  
22. Total Pages Processed (Seg)  : 0  
23. Total Pages Failing   (Seg)  : 0  
24. Total Pages Empty            : 1  
25. Total Pages Marked Corrupt   : 2  
26. Total Pages Influx           : 0  
27. Highest block SCN            : 639878 (0.639878)  

[oracle@vzwc ~]$ dbv file=/u01/app/oracle/oradata/dbserver/zwc.dbf

DBVERIFY: Release 10.2.0.4.0 - Production on Mon Feb 10 23:24:05 2014

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

DBVERIFY - Verification starting : FILE = /u01/app/oracle/oradata/dbserver/zwc.dbf

DBV-00200: Block, DBA 25166953, already marked corrupt

DBV-00200: Block, DBA 25166956, already marked corrupt


DBVERIFY - Verification complete

Total Pages Examined         : 12800
Total Pages Processed (Data) : 12137
Total Pages Failing   (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 662
Total Pages Processed (Seg)  : 0
Total Pages Failing   (Seg)  : 0
Total Pages Empty            : 1
Total Pages Marked Corrupt   : 2
Total Pages Influx           : 0
Highest block SCN            : 639878 (0.639878)

[plain] view plaincopyprint?

1. SQL> l  
2.   1  select name from v$datafile  
3.   2  union all  
4.   3  select name from v$tempfile  
5.   4  union all  
6.   5  select name from v$controlfile  
7.   6  union all  
8.   7* select member from v$logfile  
9. SQL> /  
10.   
11. NAME  
12. --------------------------------------------------------------------------------  
13. /u01/app/oracle/oradata/dbserver/system01.dbf  
14. /u01/app/oracle/oradata/dbserver/undotbs01.dbf  
15. /u01/app/oracle/oradata/dbserver/sysaux01.dbf  
16. /u01/app/oracle/oradata/dbserver/users01.dbf  
17. /u01/app/oracle/oradata/dbserver/example01.dbf  
18. /u01/app/oracle/oradata/dbserver/zwc.dbf  
19. /u01/app/oracle/oradata/dbserver/temptbs01.dbf  
20. /u01/app/oracle/oradata/dbserver/control01.ctl  
21. /u01/app/oracle/oradata/dbserver/control02.ctl  
22. /u01/app/oracle/oradata/dbserver/control03.ctl  
23. /u01/app/oracle/oradata/dbserver/redo03.log  
24. /u01/app/oracle/oradata/dbserver/redo02.log  
25. /u01/app/oracle/oradata/dbserver/redo01.log  
26.   
27. 13 rows selected.  
28.   
29. SQL>   

SQL> l
  1  select name from v$datafile
  2  union all
  3  select name from v$tempfile
  4  union all
  5  select name from v$controlfile
  6  union all
  7* select member from v$logfile
SQL> /

NAME
--------------------------------------------------------------------------------
/u01/app/oracle/oradata/dbserver/system01.dbf
/u01/app/oracle/oradata/dbserver/undotbs01.dbf
/u01/app/oracle/oradata/dbserver/sysaux01.dbf
/u01/app/oracle/oradata/dbserver/users01.dbf
/u01/app/oracle/oradata/dbserver/example01.dbf
/u01/app/oracle/oradata/dbserver/zwc.dbf
/u01/app/oracle/oradata/dbserver/temptbs01.dbf
/u01/app/oracle/oradata/dbserver/control01.ctl
/u01/app/oracle/oradata/dbserver/control02.ctl
/u01/app/oracle/oradata/dbserver/control03.ctl
/u01/app/oracle/oradata/dbserver/redo03.log
/u01/app/oracle/oradata/dbserver/redo02.log
/u01/app/oracle/oradata/dbserver/redo01.log

13 rows selected.

SQL>