Home » RDBMS Server » Backup & Recovery » not able to do 'alter database open resetlogs;'
not able to do 'alter database open resetlogs;' [message #524907] Tue, 27 September 2011 06:03 Go to next message
swaorclser
Messages: 56
Registered: August 2011
Member
Hello All,

I am trying to open my Mounted database with

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'F:\APP\ADMINISTRATOR\ORADATA\THIRDB\SYSTEM01.DBF'

To get rid of this , I tried following,

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1004739 generated at 09/26/2011 10:31:34 needed for thre
ORA-00289: suggestion :
F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\THIRDB\ARCHIVELOG\2011_09_27\O1_M

%U_.ARC
ORA-00280: change 1004739 for thread 1 is in sequence #9


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\THIRDB\ARCHIVELOG\2011_09_27\O1_

_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error b
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'F:\APP\ADMINISTRATOR\ORADATA\THIRDB\SYSTEM01.DBF'


SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1004739 generated at 09/26/2011 10:31:34 needed for thre
ORA-00289: suggestion :
F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\THIRDB\ARCHIVELOG\2011_09_27\O1_M

%U_.ARC
ORA-00280: change 1004739 for thread 1 is in sequence #9


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log
'F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\THIRDB\ARCHIVELOG\2011_09_27\O1_

_%U_.ARC'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.


ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error b
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: 'F:\APP\ADMINISTRATOR\ORADATA\THIRDB\SYSTEM01.DBF'

Googled a lot! but, no success! Please help.

Thanks & regards,
swaorclser
Re: not able to do 'alter database open resetlogs;' [message #524909 is a reply to message #524907] Tue, 27 September 2011 06:10 Go to previous messageGo to next message
swaorclser
Messages: 56
Registered: August 2011
Member
I applied the redo logs as follows which solved my problem.

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 1004739 generated at 09/26/2011 10:31:34 needed for thread 1
ORA-00289: suggestion :
F:\APP\ADMINISTRATOR\FLASH_RECOVERY_AREA\THIRDB\ARCHIVELOG\2011_09_27\O1_MF_1_9_

%U_.ARC
ORA-00280: change 1004739 for thread 1 is in sequence #9


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
F:\app\Administrator\oradata\THIRDB\REDO03.LOG
Log applied.
Media recovery complete.
SQL> alter database open resetlogs;

Database altered.

SQL>


Thanks & Regards,
swaorclser
Re: not able to do 'alter database open resetlogs;' [message #524912 is a reply to message #524909] Tue, 27 September 2011 06:23 Go to previous message
Michel Cadot
Messages: 68051
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Summary:
0/ Restore all missing files
1/ Apply all archived logs
2/ Apply all online redo logs after the last archived logs
3/ open reset logs

Regards
Michel
Previous Topic: can a control file backed up be present in multiple backup pieces?
Next Topic: rman backup restoration
Goto Forum:
  


Current Time: Tue Dec 07 00:38:04 CST 2021