Link to home
Start Free TrialLog in
Avatar of xoxomos
xoxomos

asked on

ora-01190



While moving some files around, i must have overwritten som log files.   I can startup mount, but if i try opne i get error messages.  How can i open the database even with  with that 'before last reset logs' problem?
 SQL> startup
ORACLE instance started.

Total System Global Area  466618336 bytes
Fixed Size                   731104 bytes
Variable Size             352321536 bytes
Database Buffers          100663296 bytes
Redo Buffers               12902400 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done


SQL> recover database using backup controlfile;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u02/app/oracle/oradata/haypsdmd/system01.dbf'


SQL>
Avatar of seazodiac
seazodiac
Flag of United States of America image

The error message "ORA-01190: controlfile or data file 1 is from before the last RESETLOGS" means that controlfile backup is made before the last incomplete recovery.

to fix this, try

SQL> alter database open resetlogs;


then shutdown the database, do a complete database backup
Avatar of xoxomos
xoxomos

ASKER

Ok.  Thought I'd tried that!
Avatar of xoxomos

ASKER

Yep,  gives the error:

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01190: controlfile or data file 1 is from before the last RESETLOGS
ORA-01110: data file 1: '/u02/app/oracle/oradata/haypsdmd/system01.dbf'


SQL>
In that case, you have to resort to the last backup.

Use RMAN to recover the database to the last full backup.

Avatar of xoxomos

ASKER

Oh Boy.  I don't have the last backup from rman.  All I have are the copies from a backup i made with system commands.
Any hope?
ASKER CERTIFIED SOLUTION
Avatar of seazodiac
seazodiac
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Yes, that will work too.

Put the copies from that backup to the exact location where database data files are.

and mount the database and open it.


you will need the control file, database data files from the backup.
Avatar of xoxomos

ASKER

Back to the original problem.  The files are from a backup I made from cp commands.  Then I started experimenting with rman backups.  Then I tried to wipe out all the rman recovered files and put the original files back.

This is what happens

Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area  466618336 bytes
Fixed Size                   731104 bytes
Variable Size             352321536 bytes
Database Buffers          100663296 bytes
Redo Buffers               12902400 bytes
Database mounted.
SQL> alter database open
  2  ;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open


SQL>
Avatar of xoxomos

ASKER

Is it possible creating a controlfile from a trace file would get it to open?
Avatar of xoxomos

ASKER

I do have a rman backup that I made.  At that time there was no catalog I just typed in run {
....
...
backup include current controlfile
...

Is there any way to catalog the two files that produced and use it?  
I put out another question.
Did you perform a resetlogs?

If so, you will need to use controlfiles & datafiles prior to the resetlogs and then issue recover until cancel.
We have te error:

SVRMGR> startup
ORACLE instance started.
Total System Global Area                        768128064 bytes
Fixed Size                                          50240 bytes
Variable Size                                   154988544 bytes
Database Buffers                                612032512 bytes
Redo Buffers                                      1056768 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SVRMGR>

but, don't have the backup, what can i do??
Try open with resetlogs...