Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Error After Oracle Incomplete recovery

Ashraf_1
Frequent Advisor

Error After Oracle Incomplete recovery

Hi All,

After oracle incomplete recovery of online database recovery we restored all oracle data files and control files. The problem started when I tried to startup open the database I face the following problem and the database didnâ t start:

SVRMGR> startup
ORACLE instance started.
Total System Global Area 331676344 bytes
Fixed Size 38984 bytes
Variable Size 260031088 bytes
Database Buffers 71278592 bytes
Redo Buffers 327680 bytes
Database mounted.
ORA-00604: error occurred at recursive SQL level 1
ORA-01555: snapshot too old: rollback segment number 4 with name "PRS_3" too small
SVRMGR>

Anybody knows how to solve this problem.

Regards,
Ashr
ASHRAFM
8 REPLIES
Joseph Loo
Honored Contributor

Re: Error After Oracle Incomplete recovery

hi,

read Oracle Metalink Doc: 1063408.6, if you have access.

else:

-----------------------------------
Problem Explanation:
====================

The System Change Number (SCN) is not synchronized. A transaction has been
trapped without the ability to rollback (rollback tablespace dropped), causing
a commit to take place without finishing the transaction.

Solution Description:
=====================

1. There should be an offline rollback segment in the system tablespace
that is not the system rollback segment.

To find the name and status of this rollback segment, use the following select
statement (logged into the system as internal):

SELECT SEGMENT_NAME, TABLESPACE_NAME, OWNER, STATUS FROM
DBA_ROLLBACK_SEGS WHERE TABLESPACE_NAME = 'SYSTEM';

SEGMENT_NAME TABLESPACE_NAME OWNER
STATUS
-------------------------------- ---------------------------------
--------- --------------------
SYSTEM
SYSTEM SYS ONLINE

RB_TEMP
SYSTEM SYS OFFLINE

The rollback segment named SYSTEM should be online. The second
rollback segment should be offline. Bring the second rollback segment online:

ALTER ROLLBACK SEGMENT ONLINE;
Statement Processed.

2. Now, try to log on as user SYSTEM. A new error should occur when logging
on as SYSTEM:

ORA-600 with arguments of [2662] [a] [b] [c] [d] [] []

This error tells you that the SCNs are no longer synchronized. This is a
serious internal error.

Solution Explanation:
=====================

The ORA-604 and ORA-1555 errors are misreported because there are no rollback
segments except for the system rollback segment online. Once another rollback
segment is brought online, then the true source of the problem is revealed, the
ORA-600 [2662].

-----------------------------------

hope it helps.

regards.
what you do not see does not mean you should not believe
Sanjay Kumar Suri
Honored Contributor

Re: Error After Oracle Incomplete recovery

The most common reasons for error are:
1. A long running query due to a poorly qualified data access.
2. A high processing time between fetches of the same query.
3. Incorrect rollback segment setup.

Adjust the rollback segment setup by adding more rollback segments or making them larger.

sks
A rigid mind is very sure, but often wrong. A flexible mind is generally unsure, but often right.
Ashraf_1
Frequent Advisor

Re: Error After Oracle Incomplete recovery

Thanks all,
The database actually are in mounted state this problem occur only during the startup open of database.

I tried KVS Raju solution on
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=251706

and got the database opened. Unfurtantely after openning the database server manager will kick me off and then give you status connected to an idle instance.

So know i a mtrying to restore the database again. and i will reply you to the status as soon as the incomplete backup finish.

Regards,
Ashraf
ASHRAFM
Volker Borowski
Honored Contributor

Re: Error After Oracle Incomplete recovery

Hi,

if you are restoreing an offline backup, you might need to re-create the online redologs before you open the database. Your current ones might be not in sync with the rest of the database.

If you are restoring an online backup, you still need to recover the database after that. In addition since you also restored the controlfiles, I think you might need to "open resetlogs" the database.

Good luck
Volker

Eric Antunes
Honored Contributor

Re: Error After Oracle Incomplete recovery

Hi Ashr,

I didn't understood the following: "After oracle incomplete recovery of online database recovery..."? Have you a online or offline backup?
Each and every day is a good day to learn.
Ashraf_1
Frequent Advisor

Re: Error After Oracle Incomplete recovery

HI,

Oracle Incomplete Recovery term refers to having online database backup for all data files and control files with online redolog files.

Regards,
Ashraf
ASHRAFM
Ashraf_1
Frequent Advisor

Re: Error After Oracle Incomplete recovery

Sorry again,

To correct the above.

All Data files and control files without online redologs.

Regards,
ASHRAFM
Eric Antunes
Honored Contributor

Re: Error After Oracle Incomplete recovery

Hi Ashraf,

Did you backed up as following?

SQL> alter tablespace begin backup;
SQL> host 'cp...';
SQL> alter tablespace end backup;
SQL> alter system archive log current;
...
SQL> alter tablespace begin backup;
SQL> host 'cp...';
SQL> alter tablespace end backup;
SQL> alter system archive log current;

Including the undo (Rollback) and system segment tablespaces??
Each and every day is a good day to learn.