ORA-00280 [message #663900] |
Fri, 23 June 2017 09:28  |
zeeshan047
Messages: 99 Registered: June 2010 Location: PAKISTAN
|
Member |

|
|
hi,
i am restoring a particular tablesapce from rman backup to a single instance while Rman backup is performed on production 2 node rac instance got below error.
Quote:
run {
restore tablespace system;
restore tablespace sysaux;
restore tablespace undotbs3;
restore tablespace undotbs5;
restore tablespace ETIAL_TBS04;
restore tablespace ETSAL_UNDO_NODE1_03;
switch datafile all;
}
sql> alter database datafile 19 offline drop;
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 9493585274 generated at 06/20/2017 07:18:12 needed for
thread
5
ORA-00289: suggestion :
/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch5_51023_778337977.dbf
ORA-00280: change 9493585274 for thread 5 is in sequence #51023
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
ORA-10879: error signaled in parallel recovery slave
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '+DATA/etisldb/datafile/system.1673.947341481'
|
|
|
|
|
Re: ORA-00280 [message #663903 is a reply to message #663902] |
Fri, 23 June 2017 10:22   |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
It is a guess from Oracle from your log_archive_format parameter and the current values of its parameters.
Edit: use "code" tags and not "quote" tags for code.
[Updated on: Fri, 23 June 2017 10:23] Report message to a moderator
|
|
|
|
|
|
Re: ORA-00280 [message #663907 is a reply to message #663906] |
Fri, 23 June 2017 11:55  |
 |
Michel Cadot
Messages: 68737 Registered: March 2007 Location: Saint-Maur, France, https...
|
Senior Member Account Moderator |
|
|
You said you have it, so you have it somewhere, so tell it where it is, this is what it asks you ("Specify log").
|
|
|