Repair method of building files to local storage in rac archive mode / non-archive mode-ORA-01157
Repair method of building files to local storage in rac archiving mode (the following is testing and careful operation in production environment)
Simulated misoperation
Node 1 add data file
Click (here) to collapse or open
SQL > alter tablespace netdata add datafile 'netdata03.dbf' size 20m
Node 2 query
Click (here) to collapse or open
SQL > select file_name from dba_data_files
ERROR:
ORA-01157: cannot identify/lock data file 7-see DBWR trace file
ORA-01110: data file 7:'/ u01 *
Add errors to datafile offline
Click (here) to collapse or open
SQL > alter database datafile 7 offline
Database altered. Modify file path
Click (here) to collapse or open
SQL > alter database rename file'/ u01ActionActionActionActionproduct 11.2.0anddbAction1According to dbsUniplex netdata02.dbf'to'+ DATA1/DEVDB/DATAFILE/netdata02.dbf'
Database altered.recovery datafile
Click (here) to collapse or open
SQL > recover datafile 7
Media recovery complete.datafile online
Click (here) to collapse or open
SQL > alter database datafile 7 online
Database altered.
Node 2 query is normal
Click (here) to collapse or open
SQL > select file_name from dba_data_files
FILE_NAME
+ DATA1/devdb/datafile/users.269.937046643
+ DATA1/devdb/datafile/undotbs1.276.937046643
+ DATA1/devdb/datafile/sysaux.277.937046643
+ DATA1/devdb/datafile/system.268.937046635
+ DATA1/devdb/datafile/undotbs2.267.937047083
+ DATA1/devdb/datafile/netdata.284.937049537
+ DATA1/devdb/datafile/netdata02.dbf
7 repair method of building files to local storage in rows selected.rac non-archiving mode
Click (here) to collapse or open
SQL > archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 175
Current log sequence 177
SQL >
SQL > show parameters cluster
NAME TYPE VALUE
-
Cluster_database boolean TRUE
Cluster_database_instances integer 2
Cluster_interconnects string misoperation simulation
Click (here) to collapse or open
SQL > alter tablespace netdata add datafile 'netdata03.dbf' size 20m
Tablespace altered.
SQL > select file_name from dba_data_files
ERROR:
ORA-01157: cannot identify/lock data file 8-see DBWR trace file
ORA-01110: data file 8:'/ u01 *
Click (here) to collapse or open
SQL > alter database datafile 8 offline
Alter database datafile 8 offline
*
ERROR at line 1:
ORA-01145: offline immediate disallowed unless media recovery enabled
Close the library
Click (here) to collapse or open
[grid@rac1-213-11 ~] $srvctl stop database-d devdb-o immediatecp file to asm
Click (here) to collapse or open
[grid@rac1-213-11] $asmcmd
ASMCMD > pwd
+ DATA1/DEVDB/DATAFILE
ASMCMD > cp / u01/app/oracle/product/11.2.0/db_1/dbs/netdata03.dbf.
Copying / u01/app/oracle/product/11.2.0/db_1/dbs/netdata03.dbf-> + DATA1/DEVDB/DATAFILE/netdata03.dbf
ASMCMD > quit Boot to mount
Click (here) to collapse or open
[grid@rac1-213-11] $srvctl start database-d devdb-o mount
、
Modify file path
Click (here) to collapse or open
[root@rac1-213-11] # su-oracle
[oracle@rac1-213-11] $sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Sun Jul 1 22:02:50 2018
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, Real Application Clusters, Automatic Storage Management, OLAP
Data Mining and Real Application Testing options
SQL > alter database rename file'/ u01ActionApplicationoracleUniplicationproduct 11.2.0anddbAction1According to dbsAction1According to netdata03.dbf'to'+ DATA1/DEVDB/DATAFILE/netdata03.dbf'
Database altered. Node 2 query is normal
Click (here) to collapse or open
SQL > select open_mode from v$database
OPEN_MODE
-
READ WRITE
