OraFAQ Forum: Backup & Recovery » not able to do 'alter database open resetlogs;'

Home » RDBMS Server » Backup & Recovery » not able to do 'alter database open resetlogs;'

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

not able to do 'alter database open resetlogs;' [message #524907]

Tue, 27 September 2011 06:03

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

Report message to a moderator

Re: not able to do 'alter database open resetlogs;' [message #524909 is a reply to message #524907]

Tue, 27 September 2011 06:10

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

Report message to a moderator

Re: not able to do 'alter database open resetlogs;' [message #524912 is a reply to message #524909]

Tue, 27 September 2011 06:23

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 22:32:56 CST 2025