oracle备份单个数据文件,oracle 备份恢复篇(一)---rman 单个数据文件

[]$ rman target /Recovery Manager: Release11.2.0.4.0 - Production on Fri Mar 1 14:27:57 2019Copyright (c)1982, 2011, Oracle and/or its affiliates. Allrights reserved.

connectedto target database (notstarted)

RMAN>startup mount

Oracle instance starteddatabasemounted

Total System Global Area1803841536bytes

Fixed Size2254144bytes

Variable Size1577061056bytesDatabase Buffers 218103808bytes

Redo Buffers6422528bytes

RMAN> restore datafile 1;

Startingrestore at 01-MAR-19using targetdatabase control file instead ofrecovery catalog

allocated channel: ORA_DISK_1

channel ORA_DISK_1: SID=572 device type=DISKallocated channel: ORA_DISK_2

channel ORA_DISK_2: SID=1141 device type=DISKallocated channel: ORA_DISK_3

channel ORA_DISK_3: SID=1711 device type=DISKallocated channel: ORA_DISK_4

channel ORA_DISK_4: SID=6 device type=DISKchannel ORA_DISK_1: starting datafilebackup set restorechannel ORA_DISK_1: specifying datafile(s)to restore from backup setchannel ORA_DISK_1: restoring datafile00001 to /data/oradata/prod/system01.dbf

channel ORA_DISK_1: readingfrom backup piece /u01/backup/full_PROD_20190301_737_1

channel ORA_DISK_1: piece handle=/u01/backup/full_PROD_20190301_737_1 tag=TAG20190301T111548

channel ORA_DISK_1: restoredbackup piece 1channel ORA_DISK_1:restore complete, elapsed time: 00:00:45Finishedrestore at 01-MAR-19RMAN> recover datafile 1;

Starting recover at01-MAR-19using channel ORA_DISK_1

using channel ORA_DISK_2

using channel ORA_DISK_3

using channel ORA_DISK_4

starting media recovery

archivedlog for thread 1 with sequence 2 is already on disk as file /data/oradata/arch1_2_1001760804.dbf

archivedlog for thread 1 with sequence 3 is already on disk as file /data/oradata/arch1_3_1001760804.dbf

archivedlog for thread 1 with sequence 4 is already on disk as file /data/oradata/arch1_4_1001760804.dbf

archivedlog for thread 1 with sequence 5 is already on disk as file /data/oradata/arch1_5_1001760804.dbf

archivedlog for thread 1 with sequence 6 is already on disk as file /data/oradata/arch1_6_1001760804.dbf

archivedlog for thread 1 with sequence 7 is already on disk as file /data/oradata/arch1_7_1001760804.dbf

archivedlog for thread 1 with sequence 8 is already on disk as file /data/oradata/arch1_8_1001760804.dbf

archivedlog for thread 1 with sequence 9 is already on disk as file /data/oradata/arch1_9_1001760804.dbf

archivedlog for thread 1 with sequence 10 is already on disk as file /data/oradata/arch1_10_1001760804.dbf

archivedlog for thread 1 with sequence 11 is already on disk as file /data/oradata/arch1_11_1001760804.dbf

archivedlog file name=/data/oradata/arch1_2_1001760804.dbf thread=1 sequence=2archivedlog file name=/data/oradata/arch1_3_1001760804.dbf thread=1 sequence=3archivedlog file name=/data/oradata/arch1_4_1001760804.dbf thread=1 sequence=4archivedlog file name=/data/oradata/arch1_5_1001760804.dbf thread=1 sequence=5archivedlog file name=/data/oradata/arch1_6_1001760804.dbf thread=1 sequence=6archivedlog file name=/data/oradata/arch1_7_1001760804.dbf thread=1 sequence=7archivedlog file name=/data/oradata/arch1_8_1001760804.dbf thread=1 sequence=8archivedlog file name=/data/oradata/arch1_9_1001760804.dbf thread=1 sequence=9media recovery complete, elapsed time:00:00:00Finished recover at01-MAR-19RMAN> alter database open

2>;databaseopened---完成恢复-----这里主要是在关机的时候知道了哪个文件丢失或者损坏,通过rman指定序号恢复