我简单的做个一个全恢复
RMAN>backup
full
tag db_full
format '/home/oracle/orabak/full_bk_%s_%p_%t_%T'
(database include current controlfile);
sql 'alter system archive log current';
backup
format '/home/oracle/orabak/log_bk_%s_%p_%t_%T'
archivelog all delete input;
在/home/oracle/orabak下生成三个备份文件
log_bk_3_1_701022488_20091023
full_bk_2_1_701022424_20091023
full_bk_1_1_701022146_20091023
启动rman
我的恢复步骤如下:
RMAN>startup nomount
RMAN>restore controlfile from '/home/oracle/orabak/full_bk_2_1_701022424_20091023;
RMAN>shutdown
RMAN>startup mount
RMAN>catalog start with '/home/oracle/orabak';
RMAN>restore database;
RMAN>recover database;
最后一步出错:
RMAN>alter database open resetlogs;
提示ORA-01152错误
file 1 was not restored from a sufficiently old backup
data file 1: '/home/oracle/product/10.2.0/oradata/orcl/system01.dbf'
照着网上的方法试过很多遍,还是这个错误。
有人知道怎么解决吗?感激不尽
RMAN>backup
full
tag db_full
format '/home/oracle/orabak/full_bk_%s_%p_%t_%T'
(database include current controlfile);
sql 'alter system archive log current';
backup
format '/home/oracle/orabak/log_bk_%s_%p_%t_%T'
archivelog all delete input;
在/home/oracle/orabak下生成三个备份文件
log_bk_3_1_701022488_20091023
full_bk_2_1_701022424_20091023
full_bk_1_1_701022146_20091023
启动rman
我的恢复步骤如下:
RMAN>startup nomount
RMAN>restore controlfile from '/home/oracle/orabak/full_bk_2_1_701022424_20091023;
RMAN>shutdown
RMAN>startup mount
RMAN>catalog start with '/home/oracle/orabak';
RMAN>restore database;
RMAN>recover database;
最后一步出错:
RMAN>alter database open resetlogs;
提示ORA-01152错误
file 1 was not restored from a sufficiently old backup
data file 1: '/home/oracle/product/10.2.0/oradata/orcl/system01.dbf'
照着网上的方法试过很多遍,还是这个错误。
有人知道怎么解决吗?感激不尽
解决方案 »
- oracle index基础问题立马给分 !!!
- 很简单一个存储过程,目的是想在第一条语句触发异常后,继续执行下面语句,不知道如何实现这样的功能。
- UPDATE问题 请教了~~~~
- 求sql语句
- 问:如何向oracle9i中插入日期???
- 我无知
- 深圳软件项目求高手合作(做查询Oracle数据的网站)
- 我用联机备份后,不知如何恢复,那儿有这方面的资料,谢谢!
- 在oracle中怎样建立两个表之间的关联?
- 请问:“IMP-00020: long column too large for column buffer size (22)”
- 如何通过replace将target="_blank"替换成target='_blank'?急
- oracle shell编程什么意思啊?
RMAN>restore database;
RMAN>recover database;
试试
recover database noredo;
没有问题
怎么修改,改为什么
能具体点吗
我用recover database;
替代recover database noredo;
alter database open resetlogs;
可以open
但是通过pl/sql连接过去,打开table,竟然是空的,也就是过没恢复成功
http://topic.csdn.net/u/20090812/20/befb90ba-337e-423f-9d6c-5f33488530dc.html
1. 以sysdba登陆,导出控制文件,执行
alter database backup controlfile to trace;
2. 在%oracle_base%\oradata\%oracle_sid%\udump下找到刚刚创建的trc文件,打开它。可以看到里面包含了两段sql脚本。
.....trc文件很多省略了
第一段sql是在所有online redolog没有丢失,以noresetlogs选项打开数据库的情况下使用的。第二段则是在丢失了online redolog需要resetlogs的情况下使用。
3. 把"Set #1. NORESETLOGS case"下的sql拷贝出来,存为reCreateCtl.sql
4. 以sysdba登陆,shutdown immediate。然后删除所有控制文件。再运行reCreateCtl.sql。
5. 成功创建了控制文件,数据库也正常打开。再没有使用Recovery Catalog的情况下,RMAN的备份资料是存在控制文件中的,重建控制文件会导致丢失备份资料库。
你想参考的是不是这个文章
http://www.inthirties.com/thread-344-1-1.html
和你上面的RMAN是一个步骤么。
原库的IDRMAN> backup incremental level 0 format='/backup/rman_bk/0_%d_%s_%p.bak'
2> database include current controlfile;Starting backup at 2009-08-15 06:30:14
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf
input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf
input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf
input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:30:15
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:31:00
piece handle=/backup/rman_bk/0_SINGLE_8_1.bak tag=TAG20090815T063014 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting incremental level 0 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:31:00
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:31:01
piece handle=/backup/rman_bk/0_SINGLE_9_1.bak tag=TAG20090815T063014 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2009-08-15 06:31:01Starting Control File and SPFILE Autobackup at 2009-08-15 06:31:02
piece handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:31:03RMAN> sql 'alter system archive log current';sql statement: alter system archive log currentRMAN> backup incremental level 2 format='/backup/rman_bk/2_%d_%s_%p.bak'
2> database ;Starting backup at 2009-08-15 06:37:15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 2 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf
input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf
input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf
input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:37:16
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:37:41
piece handle=/backup/rman_bk/2_SINGLE_12_1.bak tag=TAG20090815T063715 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25
Finished backup at 2009-08-15 06:37:41Starting Control File and SPFILE Autobackup at 2009-08-15 06:37:41
piece handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:37:44RMAN> sql 'alter system archive log current';sql statement: alter system archive log currentRMAN> backup incremental level 2 format='/backup/rman_bk/2_%d_%s_%p.bak'
2> database ;Starting backup at 2009-08-15 06:38:56
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 2 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/database/oracle/oradata/single/system01.dbf
input datafile fno=00002 name=/database/oracle/oradata/single/undotbs01.dbf
input datafile fno=00003 name=/database/oracle/oradata/single/sysaux01.dbf
input datafile fno=00004 name=/database/oracle/oradata/single/users01.dbf
channel ORA_DISK_1: starting piece 1 at 2009-08-15 06:38:56
channel ORA_DISK_1: finished piece 1 at 2009-08-15 06:39:21
piece handle=/backup/rman_bk/2_SINGLE_14_1.bak tag=TAG20090815T063856 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26
Finished backup at 2009-08-15 06:39:22Starting Control File and SPFILE Autobackup at 2009-08-15 06:39:22
piece handle=/database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x_.bkp comment=NONE
Finished Control File and SPFILE Autobackup at 2009-08-15 06:39:25RMAN> sql 'alter system archive log current';sql statement: alter system archive log current0级备份和2级增量备份都有了
之后我用dbca把原库删掉,这个跟你的条件基本一样了
然后我重建了init文件看下我的备份目录都有什么
-bash-3.1$ ls -l /backup/rman_bk
total 830772
-rw-r----- 1 oracle dba 405405696 Aug 15 06:30 0_SINGLE_8_1.bak
-rw-r----- 1 oracle dba 7110656 Aug 15 06:31 0_SINGLE_9_1.bak
-rw-r----- 1 oracle dba 7110656 Aug 15 06:36 2_SINGLE_11_1.bak
-rw-r----- 1 oracle dba 647168 Aug 15 06:37 2_SINGLE_12_1.bak
-rw-r----- 1 oracle dba 335872 Aug 15 06:39 2_SINGLE_14_1.bak
-rw-r----- 1 oracle dba 24004096 Jul 14 19:09 SINGLE_1_1.bak
-rw-r----- 1 oracle dba 11776 Jul 14 19:10 SINGLE_4_1.bak
-rw-r----- 1 oracle dba 405184512 Aug 15 06:24 SINGLE_6_1.bak之后我用rman连接Recovery Manager: Release 10.2.0.1.0 - Production on Sat Aug 15 06:48:50 2009Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database (not started)RMAN> startup nomountOracle instance startedTotal System Global Area 167772160 bytesFixed Size 1218316 bytes
Variable Size 83888372 bytes
Database Buffers 79691776 bytes
Redo Buffers 2973696 bytesRMAN> set dbid=3664176175executing command: SET DBIDRMAN> restore controlfile from '/backup/rman_bk/0_SINGLE_9_1.bak';Starting restore at 2009-08-15 06:55:24
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISKchannel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:04
output filename=/database/oracle/oradata/single/control01.ctl
output filename=/database/oracle/oradata/single/control02.ctl
output filename=/database/oracle/oradata/single/control03.ctl
Finished restore at 2009-08-15 06:55:29RMAN> sql 'alter database mount';sql statement: alter database mount
released channel: ORA_DISK_1
先看一下备份集都有什么
RMAN> list backup;
List of Backup Sets
===================BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1 22.89M DISK 00:00:03 2009-07-14 19:09:29
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190926
Piece Name: /backup/rman_bk/SINGLE_1_1.bak List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 11 173335 2009-07-13 15:55:13 180113 2009-07-14 19:09:23BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 356.73M DISK 00:00:41 2009-07-14 19:10:12
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name: /database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_nnndf_TAG20090714T190930_55rsvcg8_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/system01.dbf
2 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/undotbs01.dbf
3 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/sysaux01.dbf
4 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/users01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 6.77M DISK 00:00:01 2009-07-14 19:10:17
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name: /database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_ncnnf_TAG20090714T190930_55rsws06_.bkp
Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4 11.00K DISK 00:00:01 2009-07-14 19:10:19
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191018
Piece Name: /backup/rman_bk/SINGLE_4_1.bak List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 12 180113 2009-07-14 19:09:23 180144 2009-07-14 19:10:18BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 6.80M DISK 00:00:01 2009-07-14 19:10:21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191020
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_07_14/o1_mf_s_692219420_55rswxkm_.bkp
Control File Included: Ckp SCN: 180150 Ckp time: 2009-07-14 19:10:20
SPFILE Included: Modification time: 2009-07-14 19:06:08BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 386.41M DISK 00:00:42 2009-08-15 06:24:27
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062345
Piece Name: /backup/rman_bk/SINGLE_6_1.bak
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/system01.dbf
2 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/undotbs01.dbf
3 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/sysaux01.dbf
4 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/users01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Full 6.80M DISK 00:00:02 2009-08-15 06:24:34
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062432
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938272_58cs11tf_.bkp
Control File Included: Ckp SCN: 265880 Ckp time: 2009-08-15 06:24:32
SPFILE Included: Modification time: 2009-08-15 06:17:15BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
8 Incr 0 386.62M DISK 00:00:41 2009-08-15 06:30:55
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063014
Piece Name: /backup/rman_bk/0_SINGLE_8_1.bak
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/system01.dbf
2 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/undotbs01.dbf
3 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/sysaux01.dbf
4 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/users01.dbf没有增量备份,追加一下
RMAN> catalog start with '/backup/rman_bk';Starting implicit crosscheck backup at 2009-08-15 06:58:14
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=159 devtype=DISK
Crosschecked 8 objects
Finished implicit crosscheck backup at 2009-08-15 06:58:15Starting implicit crosscheck copy at 2009-08-15 06:58:15
using channel ORA_DISK_1
Crosschecked 1 objects
Finished implicit crosscheck copy at 2009-08-15 06:58:16searching for all files in the recovery area
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n_.bkp
File Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x_.bkp
File Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn_.bkpsearching for all files that match the pattern /backup/rman_bkList of Files Unknown to the Database
=====================================
File Name: /backup/rman_bk/2_SINGLE_12_1.bak
File Name: /backup/rman_bk/0_SINGLE_9_1.bak
File Name: /backup/rman_bk/2_SINGLE_11_1.bak
File Name: /backup/rman_bk/2_SINGLE_14_1.bakDo you really want to catalog the above files (enter YES or NO)? yes
cataloging files...
cataloging doneList of Cataloged Files
=======================
File Name: /backup/rman_bk/2_SINGLE_12_1.bak
File Name: /backup/rman_bk/0_SINGLE_9_1.bak
File Name: /backup/rman_bk/2_SINGLE_11_1.bak
File Name: /backup/rman_bk/2_SINGLE_14_1.bak
再看一下备份集
RMAN> list backup;
List of Backup Sets
===================BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
1 22.89M DISK 00:00:03 2009-07-14 19:09:29
BP Key: 1 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190926
Piece Name: /backup/rman_bk/SINGLE_1_1.bak List of Archived Logs in backup set 1
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 11 173335 2009-07-13 15:55:13 180113 2009-07-14 19:09:23BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
2 Full 356.73M DISK 00:00:41 2009-07-14 19:10:12
BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name: /database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_nnndf_TAG20090714T190930_55rsvcg8_.bkp
List of Datafiles in backup set 2
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/system01.dbf
2 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/undotbs01.dbf
3 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/sysaux01.dbf
4 Full 180120 2009-07-14 19:09:31 /database/oracle/oradata/single/users01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
3 Full 6.77M DISK 00:00:01 2009-07-14 19:10:17
BP Key: 3 Status: AVAILABLE Compressed: NO Tag: TAG20090714T190930
Piece Name: /database/oracle/flash_recovery_area/SINGLE/backupset/2009_07_14/o1_mf_ncnnf_TAG20090714T190930_55rsws06_.bkp
Control File Included: Ckp SCN: 180141 Ckp time: 2009-07-14 19:10:16BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
4 11.00K DISK 00:00:01 2009-07-14 19:10:19
BP Key: 4 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191018
Piece Name: /backup/rman_bk/SINGLE_4_1.bak List of Archived Logs in backup set 4
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- ------------------- ---------- ---------
1 12 180113 2009-07-14 19:09:23 180144 2009-07-14 19:10:18BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
5 Full 6.80M DISK 00:00:01 2009-07-14 19:10:21
BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20090714T191020
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_07_14/o1_mf_s_692219420_55rswxkm_.bkp
Control File Included: Ckp SCN: 180150 Ckp time: 2009-07-14 19:10:20
SPFILE Included: Modification time: 2009-07-14 19:06:08BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6 Full 386.41M DISK 00:00:42 2009-08-15 06:24:27
BP Key: 6 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062345
Piece Name: /backup/rman_bk/SINGLE_6_1.bak
List of Datafiles in backup set 6
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/system01.dbf
2 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/undotbs01.dbf
3 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/sysaux01.dbf
4 Full 265852 2009-08-15 06:23:45 /database/oracle/oradata/single/users01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
7 Full 6.80M DISK 00:00:02 2009-08-15 06:24:34
BP Key: 7 Status: AVAILABLE Compressed: NO Tag: TAG20090815T062432
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938272_58cs11tf_.bkp
Control File Included: Ckp SCN: 265880 Ckp time: 2009-08-15 06:24:32
SPFILE Included: Modification time: 2009-08-15 06:17:15BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
8 Incr 0 386.62M DISK 00:00:41 2009-08-15 06:30:55
BP Key: 8 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063014
Piece Name: /backup/rman_bk/0_SINGLE_8_1.bak
List of Datafiles in backup set 8
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/system01.dbf
2 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/undotbs01.dbf
3 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/sysaux01.dbf
4 0 Incr 266106 2009-08-15 06:30:15 /database/oracle/oradata/single/users01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
9 Full 6.80M DISK 00:00:00 2009-08-15 06:37:41
BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063741
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939061_58cssp0n_.bkp
Control File Included: Ckp SCN: 266935 Ckp time: 2009-08-15 06:37:41
SPFILE Included: Modification time: 2009-08-15 06:17:15BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
10 Full 6.80M DISK 00:00:00 2009-08-15 06:39:22
BP Key: 10 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063922
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694939162_58cswv6x_.bkp
Control File Included: Ckp SCN: 267025 Ckp time: 2009-08-15 06:39:22
SPFILE Included: Modification time: 2009-08-15 06:17:15BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
11 Full 6.80M DISK 00:00:00 2009-08-15 06:31:02
BP Key: 11 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063102
Piece Name: /database/oracle/flash_recovery_area/SINGLE/autobackup/2009_08_15/o1_mf_s_694938662_58csf6hn_.bkp
Control File Included: Ckp SCN: 266133 Ckp time: 2009-08-15 06:31:02
SPFILE Included: Modification time: 2009-08-15 06:17:15BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
12 Incr 2 624.00K DISK 00:00:00 2009-08-15 06:37:16
BP Key: 12 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063715
Piece Name: /backup/rman_bk/2_SINGLE_12_1.bak
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/system01.dbf
2 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/undotbs01.dbf
3 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/sysaux01.dbf
4 2 Incr 266922 2009-08-15 06:37:16 /database/oracle/oradata/single/users01.dbfBS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
13 Incr 0 6.77M DISK 00:00:00 2009-08-15 06:31:00
BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063014
Piece Name: /backup/rman_bk/0_SINGLE_9_1.bak
Control File Included: Ckp SCN: 266129 Ckp time: 2009-08-15 06:31:00BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
14 Incr 2 6.77M DISK 00:00:00 2009-08-15 06:36:27
BP Key: 14 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063626
Piece Name: /backup/rman_bk/2_SINGLE_11_1.bak
Control File Included: Ckp SCN: 266897 Ckp time: 2009-08-15 06:36:27BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
15 Incr 2 320.00K DISK 00:00:00 2009-08-15 06:38:56
BP Key: 15 Status: AVAILABLE Compressed: NO Tag: TAG20090815T063856
Piece Name: /backup/rman_bk/2_SINGLE_14_1.bak
List of Datafiles in backup set 15
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ------------------- ----
1 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/system01.dbf
2 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/undotbs01.dbf
3 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/sysaux01.dbf
4 2 Incr 266977 2009-08-15 06:38:56 /database/oracle/oradata/single/users01.dbf全都有了,开始恢复操作
RMAN> run {
2> restore database;
3> recover database;
4> sql 'alter database open';
5> }
命令执行下来都没有问题,
但是通过pl/sql 连接过去
table里面没有数据
查了资料:造成这种报错的大部分原因是因为controlfile里所记录的scn与datafile里的scn不一致。
RMAN>startup nomout;
RMAN>restore controlfile from '备份文件'
RMAN>shutdown immediate
RMAN>startup mount
RMAN>catalog start with '备份文件路径'
RMAN>restore database;
RMAN>recover database noredo;
RMAN>alter database open resetlogs;
还是提示ORA-01152错误
然后,我试了一下
RMAN>recover database;
下面提示了: media recovery requesting unknown log: thread 1 seq 1075 lowscn 20537661
字面意思应该是介质恢复不识别这个日志
RMAN>run {
2> set until scn 20537661;
3> restore database;
4> recover databse;
5> alter database open resetlogs;
6> }
成功open,成功恢复。但是据资料说这样有可能照成数据丢失
接着我把上面run里面的 recover database换成recover database noredo;
就不能执行alternativedatabase open resetlogs了
有高人能指点下吗?
RMAN>
RMAN>
我的例子我试过好几次了,都没问题(只有一次是当前redo未归档的情况下删库导致不能完全恢复)