rman 恢复system tablespace

问题:

SQL> startup;
ORACLE instance started.

Total System Global Area 4999610368 bytes
Fixed Size            8803024 bytes
Variable Size         1040190768 bytes
Database Buffers     3942645760 bytes
Redo Buffers            7970816 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file
ORA-01110: data file 1: '/oracle/lu8db/oradata/lu8db/system01.dbf'


SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.

恢复:

RMAN> startup mount;

Oracle instance started
database mounted

Total System Global Area    4999610368 bytes

Fixed Size                     8803024 bytes
Variable Size               1040190768 bytes
Database Buffers            3942645760 bytes
Redo Buffers                   7970816 bytes

RMAN> restore tablespace system;

Starting restore at 2020-06-19 16:07:41
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=135 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=262 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=379 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=2 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00001 to /oracle/lu8db/oradata/lu8db/system01.dbf
channel ORA_DISK_1: reading from backup piece /oracle/lu8db/12c/dbs/0ov35bqb_1_1
channel ORA_DISK_1: piece handle=/oracle/lu8db/12c/dbs/0ov35bqb_1_1 tag=TAG20200619T153746
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:35
Finished restore at 2020-06-19 16:08:17

RMAN> recover tablespace system;

Starting recover at 2020-06-19 16:10:45
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4

starting media recovery

archived log for thread 1 with sequence 4 is already on disk as file /oracle/lu8db/12c/dbs/arch1_4_1043341011.dbf
archived log file name=/oracle/lu8db/12c/dbs/arch1_4_1043341011.dbf thread=1 sequence=4
media recovery complete, elapsed time: 00:00:00
Finished recover at 2020-06-19 16:10:46

RMAN> alter database open;

Statement processed

RMAN> alter pluggable database all open;

Statement processed
原文地址:https://www.cnblogs.com/tingxin/p/13163631.html