Oracle实例迁移_真实场景实操

Last login: Tue Sep 20 04:59:33 2016 from 10.45.22.168
oracle@entel2:[/oracle]$sqlplus sys/****** as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 20 05:43:15 2016

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


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
^CORA-01013: user requested cancel of current operation

shutdown immediate无反应......取消，改用abort

SQL> shutdown abort;
ORACLE instance shut down.
SQL> 

scp -r /oracle/product/112/dbs oracle@10.45.7.197:/oracle/product/112/

scp -r  /oradata/instance1/ oracle@10.45.7.197:/oradata/

scp -r  /oradata/instance2/ oracle@10.45.7.197:/oradata/

oracle@entel1:[/oracle]$sqlplus sys/system as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Sep 20 11:52:02 2016

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

Connected to an idle instance.

SQL> shutdown immediate
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory
SQL> 
SQL> startup force
ORACLE instance started.

Total System Global Area 6530822144 bytes
Fixed Size          2265384 bytes
Variable Size        1140854488 bytes
Database Buffers     5368709120 bytes
Redo Buffers           18993152 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 85000 of file 5
ORA-01151: use media recovery to recover block, restore backup if needed


SQL> show parameter audit_file_dest

NAME                     TYPE    VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest              string  /oracle/admin/instance1/adump
SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 6530822144 bytes
Fixed Size          2265384 bytes
Variable Size        1140854488 bytes
Database Buffers     5368709120 bytes
Redo Buffers           18993152 bytes
Database mounted.
ORA-01172: recovery of thread 1 stuck at block 85000 of file 5
ORA-01151: use media recovery to recover block, restore backup if needed

解决：
SQL> select file#,name from v$datafile where file#=5;

     FILE#
----------
NAME
--------------------------------------------------------------------------------
     5
/oradata/instance1/tab_instance1_01.dbf


SQL>  recover datafile 5;
Media recovery complete.


从损坏的磁盘中恢复可读取的信息。

--------------------------------------------------------------------------------

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 6530822144 bytes
Fixed Size          2265384 bytes
Variable Size        1140854488 bytes
Database Buffers     5368709120 bytes
Redo Buffers           18993152 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []


看日志： /oracle/diag/rdbms/instance1/instance1/trace/alert_instance1.log
Reread (file 3, block 2136) found same corrupt data (logically corrupt)
******** WRITE VERIFICATION FAILED ********
出现了逻辑坏块 (logically corrupt)，因此需要进行介质恢复。

SQL> shutdown immediate
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> startup mount ;
ORACLE instance started.

Total System Global Area 6530822144 bytes
Fixed Size          2265384 bytes
Variable Size        1140854488 bytes
Database Buffers     5368709120 bytes
Redo Buffers           18993152 bytes
Database mounted.
SQL> recover database ;
Media recovery complete.
SQL> alter database open ;

Database altered.