on 05-15-2016 4:12 AM
Hi All,
i have done file system backup restore process. while opening the database i am getting following error.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.
Total System Global Area 7031889920 bytes
Fixed Size 2195936 bytes
Variable Size 3523218976 bytes
Database Buffers 3489660928 bytes
Redo Buffers 16814080 bytes
Database mounted.
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/PDR/sapdata1/system_1/system.data1'
SQL> alter database recover datafile '/oracle/PDR/sapdata1/system_1/system.data1';
alter database recover datafile '/oracle/PDR/sapdata1/system_1/system.data1'
*
ERROR at line 1:
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/PDR/sapdata1/system_1/system.data1'
Please advise
Regards
Sunil
Hi Sunil,
When system is asking for recovery please use below command and provide required archive logs.
recover database using backup controlfile until cancel;
then system will ask path for archive log kindly provide the path
once recovery is completed (all the archive log applied)
alter database open resetlogs;
Thanks
Tabrayz
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Tabrayz,
thanks for your reply.
i tried but not able to make it.
SQL> select status from v$instance;
STATUS
------------
MOUNTED
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/oracle/PDR/sapdata1/system_1/system.data1'
SQL> recover datafile '/oracle/PDR/sapdata1/system_1/system.data1'
ORA-00283: recovery session canceled due to errors
ORA-01610: recovery using the BACKUP CONTROLFILE option must be done
SQL> recover database using backup controlfile;
ORA-00279: change 335225391 generated at 05/15/2016 07:57:39 needed for thread
1
ORA-00289: suggestion : /oracle/PDR/oraarch/PDRarch1_1_911894250.dbf
ORA-00280: change 335225391 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oracle/PDR/sapdata1/system_1/system.data1'
SQL>
please advise. or is there any way to bypass this error and open the database.
Regards
Sunil
Hi Sunil,
SQL> recover database using backup controlfile;
ORA-00279: change 335225391 generated at 05/15/2016 07:57:39 needed for thread
1
ORA-00289: suggestion : /oracle/PDR/oraarch/PDRarch1_1_911894250.dbf
ORA-00280: change 335225391 for thread 1 is in sequence #1
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
(HERE PROVIDE THE PATH FOR FILE PDRarch1_1_911894250.dbf)
I can see its working when you hit recover database using backup controlfile until cancel; system is asking you for archive log suggestion : /oracle/PDR/oraarch/PDRarch1_1_911894250.dbf
do you have this file at this location?? if yes provide the path like I mention d:/oracle/PDR/oraarch/PDRarch1_1_911894250.dbf then it will ask for more archive if needed keep providing path once all archive log provided type cancel and then hit alter database open;
Thanks
Tabrayz
OK .
Why are you facing this issue?
Are you building as new system with backup (system copy) ??
or existing system crashed and when you are trying to start its asking for recovery?
If this is a restore with a online backup then you must have archive logs to open the system.
answer above questions then we can think of next action.
Thanks
Tabrayz
You cannot bypass this error when ever you try to open database it will ask for recovery and you need to archive logs to open the database.
Copy the required archive log from production system and apply here.
Best practice is take backup of database using brtools and also take backup of archivelogs (offline redologs) then us the same in restore.
Thanks
Tabrayz
Hi,
If "everythign" was properly closed, you should not get the mentioned error.
If you are getting the mentioned error then the copy was done while the database was still running.
You have to take a proper "OFFLINE" backup of the database or a "consistent" ONLINE backup and roll forward/recover it until it can be opened.
Fidel
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.