- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: redo log corrupted
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
тАО02-19-2003 05:22 AM
тАО02-19-2003 05:22 AM
redo log corrupted
any help would be really appreciated,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 05:23 AM
тАО02-19-2003 05:23 AM
Re: redo log corrupted
Pete
Pete
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 06:52 AM
тАО02-19-2003 06:52 AM
Re: redo log corrupted
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 09:39 AM
тАО02-19-2003 09:39 AM
Re: redo log corrupted
I have 4 groups mirrored everyone of them in different disks.
At certain moment, the oracle's log shows that there was an inconsistency in one redo log.
Then, I shutdown the database, after when it was been restarted with the resetlogs option, the following message was shown.
alter database open resetlog
*
ORA-01194: El fichero 1 necesita mas recuperacion para ser consistente.
ORA-01110: Fichero de datos 1 :"/opt/oracle8/...."
It's not matter if I lost the data, I would be really pleased if someone could help me to put it working again.
Thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 10:37 AM
тАО02-19-2003 10:37 AM
Re: redo log corrupted
presuming you lost the current redolog, then this is what i would do,
1. restore all datafiles from recent backup
2. mount the db
3. do a cancel based recovery (recover database until cancel)
4. open the db with resetlogs (alter database open resetlogs)
5. take an immediate backup of the database (hotbackup), as your previous backup becomes useless due to step #4.
hth,
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 11:22 AM
тАО02-19-2003 11:22 AM
Re: redo log corrupted
So the only I want to save is the database structure, no matter if the stored data is lost.
thanks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 11:41 AM
тАО02-19-2003 11:41 AM
Re: redo log corrupted
do you have any export dumps ?
Stan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 12:14 PM
тАО02-19-2003 12:14 PM
Re: redo log corrupted
can I edit the init.ora and use this?
_allow_resetlogs_corruption=TRUE
Could it be an option to get back my database?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 12:23 PM
тАО02-19-2003 12:23 PM
Re: redo log corrupted
so go ahead, set this parameter in init
immediately, take an export dump of the entire database or at least the schemas that your concerned of and rebuild the database.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-19-2003 12:39 PM
тАО02-19-2003 12:39 PM
Re: redo log corrupted
alter database clear logfile '
You might have to do:
alter database clear unarchived logfile '
The last option that you could try, is to copy the valid member from the group over the corrupted member from the group, and bring the database up. This should allow the database to come up as well.
Brian