[20180202]備庫資料檔案offline.txt

[20180202]備庫資料檔案offline.txt

--//今天測試,不小心導致日誌無法應用.我想把主庫檔案複製過去,做了備庫資料檔案offline.
--//恢復遇到問題,做一個記錄.

1.環境:
SYS@book> @ &r/ver1
PORT_STRING                    VERSION        BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx            11.2.0.4.0     Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

2.測試:
--//備庫:
SYS@bookdg> alter database datafile 6 offline;
alter database datafile 6 offline
*
ERROR at line 1:
ORA-01156: recovery or flashback in progress may need access to files

---//日誌應用時無法offline.

SYS@bookdg> alter database recover managed standby database cancel ;
Database altered.

SYS@bookdg> alter database datafile 6 offline;
alter database datafile 6 offline
*
ERROR at line 1:
ORA-01668: standby database requires DROP option for offline of data file

SYS@bookdg> alter database datafile 6 offline drop ;
Database altered.

--//噩夢開始.....

SYS@bookdg> alter database datafile 6 online ;
alter database datafile 6 online
*
ERROR at line 1:
ORA-01113: file 6 needs media recovery
ORA-01110: data file 6: '/mnt/ramdisk/book/tea01.dbf'

SYS@bookdg> recover automatic standby datafile 6;
ORA-19966: ALTER DATABASE RECOVER STANDBY DATAFILE has been deprecated

--//命令已經廢除..

--//啟動到mount狀態.

RMAN> recover datafile 4 ;

Starting recover at 2018-02-02 11:07:03
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 02/02/2018 11:07:03
RMAN-06067: RECOVER DATABASE required with a backup or created control file

SYS@bookdg> recover databfile 4 using backup controlfile until cancel;
ORA-00905: missing keyword

SYS@bookdg> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01666: control file is for a standby database

--//不行..

3.必須建立新的standby控制檔案:

SYS@book> alter database create standby controlfile as '/tmp/aa.ctl4';
Database altered.

$ scp /tmp/aa.ctl4 oracle@192.168.100.40:/mnt/ramdisk/book/control01.ctl
$ scp /tmp/aa.ctl4 oracle@192.168.100.40:/mnt/ramdisk/book/control02.ctl

SYS@bookdg> startup
ORACLE instance started.
Total System Global Area  634732544 bytes
Fixed Size                  2255792 bytes
Variable Size             197133392 bytes
Database Buffers          427819008 bytes
Redo Buffers                7524352 bytes
Database mounted.
Database opened.

SYS@bookdg> alter database recover managed standby database using current logfile disconnect ;
Database altered.

SYS@bookdg> @ &r/dg/dg
PROCESS       PID STATUS       CLIENT_P GROUP# THREAD#  SEQUENCE#     BLOCK#     BLOCKS DELAY_MINS
--------- ------- ------------ -------- ------ ------- ---------- ---------- ---------- ----------
ARCH        15430 CONNECTED    ARCH     N/A          0          0          0          0          0
ARCH        15432 CONNECTED    ARCH     N/A          0          0          0          0          0
ARCH        15434 CONNECTED    ARCH     N/A          0          0          0          0          0
RFS         15443 IDLE         ARCH     N/A          0          0          0          0          0
RFS         15447 IDLE         UNKNOWN  N/A          0          0          0          0          0
RFS         15445 IDLE         UNKNOWN  N/A          0          0          0          0          0
RFS         15449 IDLE         LGWR     2            1        903         19          1          0
ARCH        15436 CLOSING      ARCH     6            1        902          1        393          0
MRP0        15453 APPLYING_LOG N/A      N/A          1        903         19     102400          0
9 rows selected.

--//實際上操作前看看出錯提示就知道了:
$ oerr ora 01668
01668, 00000, "standby database requires DROP option for offline of data file"
// *Cause:  Attempting to take a datafile offline in a standby database without
//          specifying the DROP option. Files that are offline in a standby
//          database are not recovered, and are likely to be unusable if
//          the standby is activated. Note that specifying DROP does not
//          prevent bringing the file online later.
// *Action: Specify the DROP option or leave the file online.