豚鼠特工队国语:进入RMAN,确认控制文件备份情况
来源:百度文库 编辑:九乡新闻网 时间:2024/05/01 14:52:02
[pedbsv01:/oracle] rman target / nocatalog Recovery Manager: Release 10.2.0.4.0 - Production on Mon Apr 18 16:37:04 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.connected to target database: PEDBDB (DBID=3787013398)
using target database control file instead of recovery catalogRMAN> list backupset;
List of Backup Sets
===================BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7142 Full 21.25M SBT_TAPE 00:00:54 14-MAR-11
BP Key: 7142 Status: AVAILABLE Compressed: NO Tag: TAG20110314T022713
Handle: c-3787013398-20110314-00 Media:
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7143 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7143 Status: AVAILABLE Compressed: NO Tag: TAG20110314T084726
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-01 ---> 控制文件备份位置
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7144 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7144 Status: AVAILABLE Compressed: NO Tag: TAG20110314T085005
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-02
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7145 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7145 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090057
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-03
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7146 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7146 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090244
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-04
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7147 Full 21.17M DISK 00:00:03 14-MAR-11
BP Key: 7147 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090358
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-05
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7148 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7148 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090658
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-06
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7149 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7149 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090843
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-07
SPFILE Included: Modification time: 12-MAR-11
using target database control file instead of recovery catalogRMAN> list backupset;
List of Backup Sets
===================BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7142 Full 21.25M SBT_TAPE 00:00:54 14-MAR-11
BP Key: 7142 Status: AVAILABLE Compressed: NO Tag: TAG20110314T022713
Handle: c-3787013398-20110314-00 Media:
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7143 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7143 Status: AVAILABLE Compressed: NO Tag: TAG20110314T084726
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-01 ---> 控制文件备份位置
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7144 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7144 Status: AVAILABLE Compressed: NO Tag: TAG20110314T085005
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-02
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7145 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7145 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090057
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-03
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7146 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7146 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090244
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-04
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7147 Full 21.17M DISK 00:00:03 14-MAR-11
BP Key: 7147 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090358
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-05
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7148 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7148 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090658
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-06
SPFILE Included: Modification time: 12-MAR-11BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7149 Full 21.17M DISK 00:00:02 14-MAR-11
BP Key: 7149 Status: AVAILABLE Compressed: NO Tag: TAG20110314T090843
Piece Name: /oracle/OraHome_1/dbs/c-3787013398-20110314-07
SPFILE Included: Modification time: 12-MAR-11
进入RMAN,确认控制文件备份情况
RMAN备份脚本
RMAN 系列(四) ---- RMAN 备份 5
rman备份rman-00554 ,rman-04005错误的解决 - Oracle - ...
Windows下RMAN备份脚本
Windows下RMAN备份脚本 ...
如何 搭建 RMAN 备份平台 12
使用rman nocatalog方式备份Oracle
rman备份方式-备份恢复-Oracle频道-中国IT实验室
拥有所有归档文件,但没有备份情况下的数据文件恢复
文件备份与同步
如何简单测试Rman的备份恢复功能?
RMAN
rman备份方式半功略 -备份恢复-Oracle频道-中国IT实验室
文件同步备份工具介绍
Oracle 控制文件
Oracle 控制文件 -
RMAN-06023找不到备份集处理一例--rainnyzhong的博客
Linux 平台下 RMAN 全备 和 增量备份 shell 脚本 11
使用Oracle可传输表空间的特性复制数据(6)RMAN备份也创建
备份几个文件,重装系统安全又快捷-
备份几个文件,重装系统安全又快捷
股票软件目录文件结构,方便备份数据【全攻略】
各股票软件目录文件结构,方便备份数据