- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Error After Oracle Incomplete recovery
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2004 04:41 PM
тАО06-06-2004 04:41 PM
Error After Oracle Incomplete recovery
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2004 05:12 PM
тАО06-06-2004 05:12 PM
Re: Error After Oracle Incomplete recovery
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
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2004 05:37 PM
тАО06-06-2004 05:37 PM
Re: Error After Oracle Incomplete recovery
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2004 05:48 PM
тАО06-06-2004 05:48 PM
Re: Error After Oracle Incomplete recovery
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-06-2004 11:43 PM
тАО06-06-2004 11:43 PM
Re: Error After Oracle Incomplete recovery
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-07-2004 03:42 AM
тАО06-07-2004 03:42 AM
Re: Error After Oracle Incomplete recovery
I didn't understood the following: "After oracle incomplete recovery of online database recovery..."? Have you a online or offline backup?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2004 06:23 PM
тАО06-08-2004 06:23 PM
Re: Error After Oracle Incomplete recovery
Oracle Incomplete Recovery term refers to having online database backup for all data files and control files with online redolog files.
Regards,
Ashraf
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2004 06:30 PM
тАО06-08-2004 06:30 PM
Re: Error After Oracle Incomplete recovery
To correct the above.
All Data files and control files without online redologs.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО06-08-2004 08:32 PM
тАО06-08-2004 08:32 PM
Re: Error After Oracle Incomplete recovery
Did you backed up as following?
SQL> alter tablespace
SQL> host 'cp...';
SQL> alter tablespace
SQL> alter system archive log current;
...
SQL> alter tablespace
SQL> host 'cp...';
SQL> alter tablespace
SQL> alter system archive log current;
Including the undo (Rollback) and system segment tablespaces??