No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7000
3 P. Wisse 5600
4 B. Vroman 5400
5 J. Péran 1900
6 . Lauri 1500
7 T. P 500
7 R. Pattyn 500
9 T. Boles 400
10 A. Chavan 300
10 J. Schnackenberg 300
10 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48454
Total active users1499
Act. users last 24h5
Act. users last hour0
Registered user hits last week216
Registered user hits last month950
Go up

restore database
Next thread: PGA usage
Prev thread: CPU usage measured using top on Linux

Message Score Author Date
Hi Guys We are running Oracle 11gR2 (11.2.0.4.0...... Tso P Aug 22, 2019, 12:32
Hi Tso, You need to restore your control file f...... Joël Péran Aug 23, 2019, 09:41
Thanks Joël Péran I had some space issues then ...... Tso P Aug 26, 2019, 10:28
Hi Tso, You say you have restored your datab...... Joël Péran Aug 26, 2019, 11:05
I have created controlfile with resetlogs but I ge...... Tso P Aug 26, 2019, 16:01
Hi Tso, what exactly did you restore with your ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Ales Kavsek Aug 26, 2019, 23:04
Hi, I do agree with Ales. I'm not sure you ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Joël Péran Aug 27, 2019, 07:42
Hi, The error message you got refers to somethi...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Lauri Aug 27, 2019, 14:12
Thanks Everyone I don't have a backup, I relied...... Tso P Aug 28, 2019, 10:51
As feedback: I have asked my Netbackup team to ...... Tso P Aug 29, 2019, 10:13
Hi Tso, According to MOS, you have this bug : ...... Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts Joël Péran Aug 29, 2019, 11:06
Thanks Joël I will have a look and update the t...... Tso P Aug 29, 2019, 18:40
Thanks guys... I followe the below document fro...... Tso P Sep 02, 2019, 21:09

Follow up by mail Click here


Subject: restore database
Author: Tso P, South Africa
Date: Aug 22, 2019, 12:32, 89 days ago
Os info: Red Hat Enterprise Linux Server release 5.11 (Tikanga)
Oracle info: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
Message: Hi Guys

We are running Oracle 11gR2 (11.2.0.4.0) running on RHEL 5, the database is running on noarchivelog mode.

We had a hardware failure and we had to use the Netbackup to restore the database.

Now I am trying to open the database but I do get the following errors:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01122: database file 3 failed verification check
ORA-01110: data file 3: '/ora/orcl/orcldb01/dmkrdev/undotbs01.dbf'
ORA-01207: file is more recent than control file - old control file

I don't have archivelogs and the redos timestamp is earlier than the undotbs01.dbf file.

See below:


18:01 redo02.log
19:48 redo03.log
19:53 dmkr_admin.dbf
19:53 corradmin.dbf
20:56 temp01.dbf
21:23 control01.ctl
21:23 redo01.log
21:24 sysaux01.dbf
21:44 system01.dbf
21:52 users01.dbf
21:20 dmkr_asline.dbf
21:52 dmkr_asline_01.dbf
22:11 undotbs01.dbf


How should I approach this issues...?

Please help...

Thanks in advance...
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore database
Author: Joël Péran, France
Date: Aug 23, 2019, 09:41, 88 days ago
Message: Hi Tso,

You need to restore your control file first. Then you restore your backup and do a recover finally. It normally should work. But why don't you use archivelog for this database precisely ?
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore database
Author: Tso P, South Africa
Date: Aug 26, 2019, 10:28, 85 days ago
Message: Thanks Joël Péran

I had some space issues then I switch the db to no archivelog.

Now, I am faced with this issue.

I don't have a backup of the control file the one I am trying to start the db is the one I have.

Maybe I should recreate the controlfile with resetlogs.

Then try to open the database with resetlogs.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore database
Author: Joël Péran, France
Date: Aug 26, 2019, 11:05, 85 days ago
Message: Hi Tso,

You say you have restored your database. So you may had a backup controlfile ? In this case, the recover operation must be "recover database using backup controlfile until cancel". Then you cancel and do a "open resetlogs"... I think you have no choice but to do this ...
Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore database
Author: Tso P, South Africa
Date: Aug 26, 2019, 16:01, 85 days ago
Message: I have created controlfile with resetlogs but I get the below errors:


Control file created.

SQL> RECOVER DATABASE USING BACKUP CONTROLFILE;
ORA-00279: change 24417808303 generated at 08/26/2019 15:04:32 needed for
thread 1
ORA-00289: suggestion :
/app/oracle/fast_recovery_area/dmkrdev/archivelog/2019_08_26/o1_mf_1_1_%u_.arc
ORA-00280: change 24417808303 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/ora/orcl/dmkrdev/dmkrdev/redo01.log
Log applied.
Media recovery complete.
SQL> ALTER DATABASE OPEN RESETLOGS;
ALTER DATABASE OPEN RESETLOGS
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [5], [2942971835], [5],
[2942998069], [12583040], [], [], [], [], [], []
Process ID: 1527
Session ID: 234 Serial number: 1

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

>sqlplus "/as sysdba";

SQL*Plus: Release 11.2.0.4.0 Production on Mon Aug 26 15:31:00 2019

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 6933520384 bytes
Fixed Size 2194784 bytes
Variable Size 1426064032 bytes
Database Buffers 5486149632 bytes
Redo Buffers 19111936 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/ora/orcl/dmkrdev/dmkrdev/system01.dbf'



Thanks

Please help !!!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore database
Author: Ales Kavsek, Slovenia
Date: Aug 26, 2019, 23:04, 85 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

what exactly did you restore with your Netbackup? Do you have a valid cold backup, the only backup that you can have if you run db in noarchivelog mode. Please check that:
- you have a valid cold backup of the database (if your backup run while database was opened, you don’t have a backup, you lost a database),
- that you restored every database file from your cold backup (changes made to a database after your backup are lost)

From what you posted it seems that you either don’t have a valid cold bsckup, or that you’re trying to recover beyond what is recoverable....

Regards,
Ales
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: restore database
Author: Joël Péran, France
Date: Aug 27, 2019, 07:42, 84 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi,

I do agree with Ales. I'm not sure you have a cold backup. Without archivelog mode, only cold backup is needed to restore and recover.


Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re-restore database
Author: Lauri, Netherlands
Date: Aug 27, 2019, 14:12, 84 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi,

The error message you got refers to something like:

- A shutdown abort
or
- Bad permissions on some ket database directories
or
- Missing datafiles
or
Renaming files when Oracle is down

Having in mind that your database runs in NOARCHIVELOG mode, you need a valid cold backup to open your database for normal usage.

Would you be so kind to post what you have done after that?

Kind Regards
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-restore database
Author: Tso P, South Africa
Date: Aug 28, 2019, 10:51, 83 days ago
Message: Thanks Everyone

I don't have a backup, I relied heavily on my netbackup team for backups. So I just learned that this is not a cold backup as such I have lost the database.

Thanks for all the replies.

Much appreciated !!!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-restore database
Author: Tso P, South Africa
Date: Aug 29, 2019, 10:13, 82 days ago
Message: As feedback:

I have asked my Netbackup team to restore a backup from a different date.

Using that backup I managed to open the database with the startup command, but now I have the below error, of which I think its better than the database not opening.

ORA-00600: internal error code, arguments: [4194], [#], [#], [], [], [], [], []


I will do the investigation and see if I can resolve the issue or open the SR with Oracle if I don't win.

Thanks, for the support.

Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-restore database
Author: Joël Péran, France
Date: Aug 29, 2019, 11:06, 82 days ago
Score:   Score: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 PtsScore: 200 Pts
Message: Hi Tso,

According to MOS, you have this bug :
[i]Format: ORA-600 [4194] [a] [b]

VERSIONS:
versions 6.0 to 12.1

DESCRIPTION:

A mismatch has been detected between Redo records and rollback (Undo)
records.
[/i]

You may have to recover your database another time ... But look at the solutions provided by Oracle version, may be you will be Lucky enough to find a solution :)

Regards,
Joel
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-restore database
Author: Tso P, South Africa
Date: Aug 29, 2019, 18:40, 82 days ago
Message: Thanks Joël

I will have a look and update the thread.

Thanks
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Re-restore database
Author: Tso P, South Africa
Date: Sep 02, 2019, 21:09, 78 days ago
Message: Thanks guys...

I followe the below document from my support and that resolved the issue.

Step by step to resolve ORA-600 4194 4193 4197 on database crash (Doc ID 1428786.1).

The database is up and running.

Thanks a lot for the help...

Much appreciated !!!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here