 | |
| ORA-00279 | | ORA-00279: | change string generated at string needed for thread string | | Cause: | The requested log is required to proceed with recovery. | | Action: | Please supply the requested log with "ALTER DATABASE RECOVER LOGFILE <file_name>" or cancel recovery with "ALTER DATABASE RECOVER CANCEL".
|
|
|
| Posts about ORA-00279 | | No not RAC. Here 's the transcript of my latest attempt. Any suggestions/corrections welcomed.
Note that I have also tried this without specifying "using backup controlfile "--same result.
SQL > recFolks
I am running some time-based database instance recovery tests in the lab
on a three-node RAC environment. The following command was issued from
one RAC instance while the others were down. I amHi
Did you copy ALL your tablespaces using your method or just some?
The v$log_history contents are read from (standby) controlfile.
When you start recovery Oracle checks the checkpoint_change# fI 'm ready to apply the archived log #599 on the standby db
When I issue
- recover standby database he ask me for the archive log #546 !!!!
SQL > recover standby database
ORA-00279 change 82413819 gNEW pop.tiscali.de wrote
>You shouldn 't be copying the online redo logs in any case backup or
>restore. You only need to backup archived redo logs.
>
>Try step 4 without copying back the online redhi all
We have got one oracle 9i rel 2 on windows 2000 running in no-archive log
mode. the problem is one of the dba of the other team has deleted some of
the dbf files while the database was runn
On 09/18/2005 01 46 33 PM Chirag DBA wrote
> But after that getting following error.
> My original db was not in Archivelog mode still this DB asks for the
> archive file. I have copied redo loHi
I am trying to clone a DB on windows.
Created a controlfile with
ALTER DATABASE BACKUP CONTROLFILE TO TRACE
I have taken a cold backup of the DB. copy all files in another folder.
I have crea Hi
I practice backup and recovery and experience weird result oh may Oracle
bug or may be my method is incorrect.
Here is what I have
Fact
Time 1 - > Cold backup
Time 2 - > Create table
THello all
while doing recovery on a test database we issue "recover database
using backup controlfile "
and Oracle responds with "ORA-00279 change 79332404433 generated at
09/08/2004 04 32 0Thanks for the replies Ian and Ruth.
Ruth 's suggestion below results in the following
SVRMGR > recover using backup controlfile until cancel
ORA-00279 change 3668927078 generated at 07/02/200I 'm trying to make a copy of a database (running SAP Oracle 9.2.0.4 64-bit
AIX 5.1) and running into some difficulty with the system tablespace. It
doesn 't seem to matter if I shut the database dSQL > alter database recover tablespace netstats_hourly_data5m1
alter database recover tablespace netstats_hourly_data5m1
*
ERROR at line 1
ORA-00279 change 6641427117202 generated at 02/24/2004
I am recovering from hot backup alert log says one of file corrupted! and I checked with dbv utility no corruption!! My environment is AIX Oracle 8174. Any ideas?
SVRMGR > recover database un |
|
| Oracle Database Server Error Codes | |
|