用rman恢复数据文件

最新推荐文章于 2024-02-26 21:13:10 发布
HodyYau
最新推荐文章于 2024-02-26 21:13:10 发布
阅读量827
点赞数
分类专栏： oracle
本文链接：https://blog.csdn.net/yaohongdi1987/article/details/19425905
版权
oracle 专栏收录该内容
24 篇文章 0 订阅
订阅专栏
 [root@orahost ~]# su - oracle
[oracle@orahost ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Mon May 5 01:19:46 2008

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


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> 
SQL> 
SQL> 
SQL> 
SQL> desc dba_data_files
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER
 ONLINE_STATUS                                      VARCHAR2(7)

SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
/oracle/oradata/orcl/testbak.dbf
/oracle/oradata/orcl/users01.dbf
/oracle/oradata/orcl/undotbs01.dbf
/oracle/oradata/orcl/sysaux01.dbf
/oracle/oradata/orcl/system01.dbf

SQL> !
[oracle@orahost ~]$ cd /oracle/oradata/orcl/
[oracle@orahost orcl]$ ls
control01.ct1.bak  control01.ct3.bak  control02.ctl  redo01.log  redo03.log    system01.dbf  test1.dbf    undotbs01.dbf
control01.ct2.bak  control01.ctl      control03.ctl  redo02.log  sysaux01.dbf  temp01.dbf    testbak.dbf  users01.dbf
[oracle@orahost orcl]$ mv test
test1.dbf    testbak.dbf  
[oracle@orahost orcl]$ mv testbak.dbf test111
[oracle@orahost orcl]$ exit
exit

SQL> l 
  1* select file_name from dba_data_files
SQL> r
  1* select file_name from dba_data_files

FILE_NAME
--------------------------------------------------------------------------------
/oracle/oradata/orcl/testbak.dbf
/oracle/oradata/orcl/users01.dbf
/oracle/oradata/orcl/undotbs01.dbf
/oracle/oradata/orcl/sysaux01.dbf
/oracle/oradata/orcl/system01.dbf

SQL> shutdown abort
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  285212672 bytes
Fixed Size                  1218968 bytes
Variable Size              71304808 bytes
Database Buffers          205520896 bytes
Redo Buffers                7168000 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 5 - see DBWR trace file
ORA-01110: data file 5: '/oracle/oradata/orcl/testbak.dbf'


SQL> recover datafile 5;
ORA-00279: change 785213 generated at 02/18/2014 04:27:53 needed for thread 1
ORA-00289: suggestion :
/oracle/flash_recovery_area/ORCL/archivelog/2008_05_05/o1_mf_1_3_%u_.arc
ORA-00280: change 785213 for thread 1 is in sequence #3


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/oracle/oradata/orcl/redo01.log
ORA-00310: archived log contains sequence 5; sequence 3 required
ORA-00334: archived log: '/oracle/oradata/orcl/redo01.log'


SQL> select status from v$instance;

STATUS
------------
MOUNTED



[oracle@orahost ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Mon May 5 01:32:20 2008

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

connected to target database: ORCL (DBID=1327540369, not open)

RMAN> recover datafile 5;

Starting recover at 05-MAY-08
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=232 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 05/05/2008 01:32:36
RMAN-06094: datafile 5 must be restored

RMAN> restore datafile 5;

Starting restore at 05-MAY-08
using channel ORA_DISK_1

channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00005 to /oracle/oradata/orcl/testbak.dbf
channel ORA_DISK_1: reading from backup piece /oracle_backup/db_2014-02-18/ORCL_1327540369_8_1_20140218.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle_backup/db_2014-02-18/ORCL_1327540369_8_1_20140218.bkp tag=TAG20140218T042753
channel ORA_DISK_1: restore complete, elapsed time: 00:00:07
Finished restore at 05-MAY-08

RMAN> recover datafile 5;

Starting recover at 05-MAY-08
using channel ORA_DISK_1

starting media recovery

archive log thread 1 sequence 5 is already on disk as file /oracle/flash_recovery_area/ORCL/archivelog/2014_02_19/o1_mf_1_5_9j756d24_.arc
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=3
channel ORA_DISK_1: reading from backup piece /oracle_backup/db_2014-02-18/archivelog_ORCL_1327540369_13_1_20140218.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle_backup/db_2014-02-18/archivelog_ORCL_1327540369_13_1_20140218.bkp tag=TAG20140218T042852
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2008_05_05/o1_mf_1_3_41vx4wtf_.arc thread=1 sequence=3
channel default: deleting archive log(s)
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2008_05_05/o1_mf_1_3_41vx4wtf_.arc recid=6 stamp=653881116
media recovery complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting archive log restore to default destination
channel ORA_DISK_1: restoring archive log
archive log thread=1 sequence=4
channel ORA_DISK_1: reading from backup piece /oracle_backup/db_2014-02-18/archivelog_ORCL_1327540369_14_1_20140218.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/oracle_backup/db_2014-02-18/archivelog_ORCL_1327540369_14_1_20140218.bkp tag=TAG20140218T042852
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
channel default: deleting archive log(s)
archive log filename=/oracle/flash_recovery_area/ORCL/archivelog/2008_05_05/o1_mf_1_4_41vx50lj_.arc recid=7 stamp=653881120
Finished recover at 05-MAY-08