1.启动数据库失败
oracle@zxyybak:~ (zxyybak)$ sq
SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 21 21:31:59 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 5.5051E+10 bytes
Fixed Size 2266344 bytes
Variable Size 6039800600 bytes
Database Buffers 4.8989E+10 bytes
Redo Buffers 19292160 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 7479
Session ID: 1134 Serial number: 3
SQL>```
## 2.启动到Mount状态
```bash
oracle@zxyybak:~ (zxyybak)$ sq
SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 21 21:36:26 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 5.5051E+10 bytes
Fixed Size 2266344 bytes
Variable Size 6039800600 bytes
Database Buffers 4.8989E+10 bytes
Redo Buffers 19292160 bytes
Database mounted.
SQL>
3. rman
oracle@zxyybak:~ (zxyybak)$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Thu Nov 21 21:36:42 2019
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1407307953, not open)
RMAN> crosscheck archivelog all;
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=1982 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=2266 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=2549 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=2832 device type=DISK
validation succeeded for archived log
archived log file name=/u01/app/oracle/archive/ORCL/archivelog/2019_11_16/o1_mf_1_32583_gwxlw3df_.arc RECID=403932 STAMP=1024444805
RMAN> delete archivelog all;
文章评论