Rman Database recovery failed a

Problem:

This is an operation that restores a ramn backup of a database from a RAC environment to a single stand-alone database.

When the data file is recovered and returned to normal, the following error is reported in the Open database.

--rman Backup Recovery operations

#创建参数文件

CD $ORACLE _home/dbs

$cat Initntracdb.ora

*.archive_lag_target=0

*.compatible= ' 11.2.0.4.0 '

*.control_files= '/u01/oracle/oradata/ntracdb/controlfile1.dbf ', '/u01/oracle/oradata/ntracdb/controlfile2.dbf '

*.db_block_size=8192

*.db_create_file_dest= '/u01/oracle/oradata/ntracdb '

*.db_name= ' ntracdb '

*.db_recovery_file_dest= '/u01/oracle/fast_recovery_area '

*.db_recovery_file_dest_size=299000m

*.db_unique_name= ' ntracdb '

*.dg_broker_start=true

*.local_listener= ' (address= (PROTOCOL=TCP) (Host=nticket3) (port=1521)) '

*.log_archive_format= '%t_%s_%r.dbf '

*.log_archive_max_processes=4

*.log_archive_min_succeed_dest=1

*.log_archive_trace=0

*.log_file_name_convert= ' null ', ' null '

*.nls_language= ' SimplifiedChinese '

*.nls_territory= ' China '

*.open_cursors=300

*.pga_aggregate_target=429496729

*.processes=600

*.remote_login_passwordfile= ' Exclusive '

*.sga_max_size=3435973836

*.sga_target=3221225472

*.standby_file_management= ' Auto '

*.undo_tablespace= ' UNDOTBS1 '

Rman Target/

Startup Nomount;

Restore Controlfile from '/home/oracle/rmanbak/ncnnf0_tag20141110t011010_0.1205.863228449 '; --Restore the control file first

ALTER DATABASE Mount;

Catalog start with '/home/oracle/rmanbak/'; --Batch registration of the copied Rman backup, assuming that the copied back to the/u01/rmanbak/directory

List backup; --Check to see if this backup file is to be restored

Run {

Set newname for datafile ' +data01/ntracdb/datafile/users.295.855410331 ' to '/u01/oracle/oradata/ntracdb/ users.295.855410331 ';

Set newname for datafile ' +data01/ntracdb/datafile/undotbs1.263.855410331 ' to '/u01/oracle/oradata/ntracdb/ undotbs1.263.855410331 ';

Set newname for datafile ' +data01/ntracdb/datafile/sysaux.264.855410331 ' to '/u01/oracle/oradata/ntracdb/ sysaux.264.855410331 ';

Set newname for datafile ' +data01/ntracdb/datafile/system.265.855410331 ' to '/u01/oracle/oradata/ntracdb/ system.265.855410331 ';

Set newname for datafile ' +data01/ntracdb/datafile/undotbs2.293.855410453 ' to '/u01/oracle/oradata/ntracdb/ undotbs2.293.855410453 ';

Set newname for datafile ' +data01/ntracdb/datafile/undotbs3.292.855410453 ' to '/u01/oracle/oradata/ntracdb/ undotbs3.292.855410453 ';

Set newname for datafile ' +data01/ntracdb/datafile/sysaux.257.857772301 ' to '/u01/oracle/oradata/ntracdb/ sysaux.257.857772301 ';

Set newname for datafile ' +data01/ntracdb/datafile/strategy.256.858008275 ' to '/u01/oracle/oradata/ntracdb/ strategy.256.858008275 '

Restore database;

Switch datafile all;

Recover database;

}

--Open database times wrong

$sqlplus/as SYSDBA

sql> ALTER DATABASE open;

ALTER DATABASE Open

*

Section 1 An error occurred in the row

ORA-03113 : End of file for communication channel

Process ID : 6988

Come back ID : 191 Serial Number: 3

--View Log

Thu Nov 13 10:13:20 2014

ALTER DATABASE Open

Data Guard brokerinitializing ...

Data Guard brokerinitialization Complete

Data guard:verifying databaseprimary role ...

Thu Nov 13 10:13:20 2014

Lgwr:starting ARCH PROCESSES

Thu Nov 13 10:13:20 2014

ARC0 started with pid=21, osid=26949

Arc0:archival started

Lgwr:starting ARCH Processescomplete

Arc0:starting ARCH PROCESSES

Lgwr:primary database is inmaximum availability mode

Lgwr:destinationlog_archive_dest_1 isn't serviced by LGWR

Lgwr:minimum of 1 LGWR standbydatabase required

Errors in FILE/U01/ORACLE/DIAG/RDBMS/NTRACDB/NTRACDB/TRACE/NTRACDB_LGWR_26870.TRC:

ORA-16072:A minimum of Onestandby database destination is required

Thu Nov 13 10:13:21 2014

ARC1 started with pid=22, osid=26953

LGWR (ospid:26870): Terminating the instance due to error 16072

Thu Nov 13 10:13:21 2014

System Statedump requested by (Instance=1, osid=26870 (LGWR)), Summary=[abnormal Instancetermination].

System statedumped to trace file/u01/oracle/diag/rdbms/ntracdb/ntracdb/trace/ntracdb_diag_26846_20141113101321.trc

Dumpingdiagnostic data in directory=[cdmp_20141113101321], requested by (instance=1,osid=26870 (LGWR)), summary=[ Abnormal instance termination].

Instanceterminated by LGWR, PID = 26870

Reason:

May be caused by a failure to control file backups

Workaround:

Rebuild the control file, and then open the database

STARTUP Nomount

CREATE controlfile reusedatabase "ntracdb" noresetlogs Force LOGGING ARCHIVELOG

Maxlogfiles 16

Maxlogmembers 3

Maxdatafiles 100

Maxinstances 8

Maxloghistory 9344

LOGFILE

GROUP 1 '/u01/oracle/oradata/ntracdb/ntracdb/onlinelog/o1_mf_1_b682j5nk_.log ' SIZE 200M,

GROUP 2 '/u01/oracle/oradata/ntracdb/ntracdb/onlinelog/o1_mf_2_b682j7gw_.log ' SIZE 200M,

GROUP 3 '/u01/oracle/oradata/ntracdb/ntracdb/onlinelog/o1_mf_3_b682j98k_.log ' SIZE 200M,

GROUP 4 '/u01/oracle/oradata/ntracdb/ntracdb/onlinelog/o1_mf_4_b682jc2t_.log ' SIZE 200M

--STANDBY LOGFILE

DataFile

'/u01/oracle/oradata/ntracdb/users.295.855410331 ',

'/u01/oracle/oradata/ntracdb/undotbs1.263.855410331 ',

'/u01/oracle/oradata/ntracdb/sysaux.264.855410331 ',

'/u01/oracle/oradata/ntracdb/system.265.855410331 ',

'/u01/oracle/oradata/ntracdb/undotbs2.293.855410453 ',

'/u01/oracle/oradata/ntracdb/undotbs3.292.855410453 ',

'/u01/oracle/oradata/ntracdb/sysaux.257.857772301 ',

'/u01/oracle/oradata/ntracdb/strategy.256.858008275 ',

'/u01/oracle/oradata/ntracdb/strategy.302.858008423 '

CHARACTER SET ZHS16GBK;

Sql> RECOVER DATABASE;

ORA-00283: Recovery session canceled due to an error

ORA-00264: No Recovery required

--The database can be opened normally at this time

sql> ALTER DATABASE open;

The database has changed.

#创建临时表空间

CREATE Temporary tablespace temp tempfile '/u01/oracle/oradata/ntracdb/temp01.dbf '

SIZE 20M Reuse

EXTENT MANAGEMENT LOCAL UNIFORM SIZE 16M;

Rman Database recovery failed a