Home » RDBMS Server » Backup & Recovery » ORA-00280 (oracle 11g r2 ,linux 5)
ORA-00280 [message #663900] Fri, 23 June 2017 09:28 Go to next message
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 #663901 is a reply to message #663900] Fri, 23 June 2017 09:34 Go to previous messageGo to next message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
If it was an open backup you will have to do some recovery: you can't cancel immediately.
Re: ORA-00280 [message #663902 is a reply to message #663901] Fri, 23 June 2017 10:05 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

Thanks for your reply , i have check the below file for recovery but its not found. Cant understand why this new instance archive log file required? and from where i get this

Quote:


/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch5_51023_778337977.dbf

Re: ORA-00280 [message #663903 is a reply to message #663902] Fri, 23 June 2017 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 65201
Registered: March 2007
Location: Nanterre, France, http://...
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 #663904 is a reply to message #663903] Fri, 23 June 2017 11:14 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

so how i restore my database i have full rman backup with archive log, still its asking for unknown archive log file?
Re: ORA-00280 [message #663905 is a reply to message #663904] Fri, 23 June 2017 11:24 Go to previous messageGo to next message
Michel Cadot
Messages: 65201
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Give it the name of the next archived log to use to recover (the one for change 9493585274 of thread 5).

Re: ORA-00280 [message #663906 is a reply to message #663905] Fri, 23 June 2017 11:44 Go to previous messageGo to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

but its not found in archive log location.
Re: ORA-00280 [message #663907 is a reply to message #663906] Fri, 23 June 2017 11:55 Go to previous message
Michel Cadot
Messages: 65201
Registered: March 2007
Location: Nanterre, France, http://...
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").

Previous Topic: Retention Policy with RMAN Incremental Backups
Next Topic: Retention Policy for Control File Auto Backups
Goto Forum:
  


Current Time: Tue Nov 21 23:29:10 CST 2017

Total time taken to generate the page: 0.01538 seconds