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/h
SQL>
ASKER
Ok. Thought I'd tried that!
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/h aypsdmd/sy stem01.dbf '
SQL>
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/h
SQL>
In that case, you have to resort to the last backup.
Use RMAN to recover the database to the last full backup.
Use RMAN to recover the database to the last full backup.
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?
Any hope?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.
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.
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>
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>
ASKER
Is it possible creating a controlfile from a trace file would get it to open?
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.
....
...
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.
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??
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...
to fix this, try
SQL> alter database open resetlogs;
then shutdown the database, do a complete database backup