- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- DBA - I AM NOT -- Oracle 9i
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
тАО03-09-2005 09:35 AM
тАО03-09-2005 09:35 AM
in short ...
I dropped a table and tried a recover with RMAN . (testing a recovery method - the process seemed hung on a table)
now when I try to get back to RMAN
rman TARGET /
Recovery Manager: Release 9.2.0.4.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database (not started)
RMAN> STARTUP
Oracle instance started
database mounted
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 03/09/2005 14:18:44
ORA-01092: ORACLE instance terminated. Disconnection forced
anyway ... the alertlog showing ...
Dictionary check beginning
Wed Mar 9 13:27:03 2005
Errors in file /orca/oracle/admin/ORX/udump/rx_ora_2649.trc:
ORA-01177: data file does not match dictionary - probably old incarnation
ORA-01110: data file 12: '/orca/oracle/oradata/ORX/RX.dbf'
Error 1177 happened during db open, shutting down database
USER: terminating instance due to error 1177
Instance terminated by USER, pid = 2649
ORA-1092 signalled during: ALTER DATABASE OPEN...
Tried RMAN> RESTORE DATABASE;
cannot get Oracle started. What should I do now? This is important that I get this database back up and running quickly.
Sorry for the inconvenient timing of this
Steve
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2005 11:53 AM
тАО03-09-2005 11:53 AM
Re: DBA - I AM NOT -- Oracle 9i
It seems that you recovery the database partially, by restoring datafile '/orca/oracle/oradata/ORX/RX.dbf'.
You must make a recovery in this database ir order to open it.
Which commands did you issue when you first called RMAN?
By the way, RMAN is not the right tool to make a table recover.
Regards,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2005 12:07 PM
тАО03-09-2005 12:07 PM
Re: DBA - I AM NOT -- Oracle 9i
rman TARGET /
SHUTDOWN IMMEDIATE
STARTUP MOUNT
RESTORE DATABASE;
never got to RECOVER DATABASE;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2005 12:22 PM
тАО03-09-2005 12:22 PM
SolutionIf you had accedently droped a table and wants to restore this table, then the simplest way would be to import this single table from an export dump file. Then again it depends if the table was as read-only table like reference, so that the data will be unchanged since the last export backup. This will be the simplest.
To recover a drop table using RMAN there are three options available:
1. Restore and recover the primary database to a point in time before the drop. This is an extreme measure for one table as the entire database goes back in time.
2. Restore and recover the tablespace to a point in time before the drop. This is a better option, but again, it takes the entire tablespace back in time.
3. Restore and recover a subset of the database as a DUMMY database to export the table data and import it into the primary database. This is the best option as only the dropped table goes back in time to before the drop.
Attached is a document that provides general view and steps of recovering from a drop/delete/truncate table using RMAN.
Wish you good luck
Indira A
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2005 12:38 PM
тАО03-09-2005 12:38 PM
Re: DBA - I AM NOT -- Oracle 9i
What you were trying to do is an incomplete recovery.
This king of recovery is used when you lose datafile(s) and have archivelogs, at least to recover to a point in time.
You must recover your database in order to use it again.
If you can make an incomplete recovery, let├В┬┤s say until 1 minute before dropping the table, you will have your table again, but you will lose all changes after this time until you made the restore (to this datafile/tablespace).
Do you have all archivelogs from the last backup?
You will need this to make this recovery
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2005 12:42 PM
тАО03-09-2005 12:42 PM
Re: DBA - I AM NOT -- Oracle 9i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-09-2005 12:55 PM
тАО03-09-2005 12:55 PM
Re: DBA - I AM NOT -- Oracle 9i
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2005 04:44 AM
тАО03-14-2005 04:44 AM
Re: DBA - I AM NOT -- Oracle 9i
Thank you, Option 3 was a great option.
thank you,
Steve
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-14-2005 04:50 AM
тАО03-14-2005 04:50 AM
Re: DBA - I AM NOT -- Oracle 9i
Thanks for moving me in the right direction
Steve