Simpler Navigation for Servers and Operating Systems
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
cancel
Showing results for 
Search instead for 
Did you mean: 

DBA - I AM NOT -- Oracle 9i

SOLVED
Go to solution
Stephen Badgett
Regular Advisor

DBA - I AM NOT -- Oracle 9i

good product till a non-dba person like me does a number on it ...
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
Not as is, is now
8 REPLIES
Julio Yamawaki
Esteemed Contributor

Re: DBA - I AM NOT -- Oracle 9i

Hi,

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,
Stephen Badgett
Regular Advisor

Re: DBA - I AM NOT -- Oracle 9i

The rman commands

rman TARGET /
SHUTDOWN IMMEDIATE
STARTUP MOUNT
RESTORE DATABASE;

never got to RECOVER DATABASE;
Not as is, is now
Indira Aramandla
Honored Contributor
Solution

Re: DBA - I AM NOT -- Oracle 9i

Hi Steve,

If 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

Never give up, Keep Trying
Julio Yamawaki
Esteemed Contributor

Re: DBA - I AM NOT -- Oracle 9i

Well, Steve:

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
A. Clay Stephenson
Acclaimed Contributor

Re: DBA - I AM NOT -- Oracle 9i

Yours is a perfect example of why everyone needs a test environment and even better a sandbox environment in which to play. Don't never ever do this sort of thing in the production environment (or even in a test environment where development costs might be thousands of dollars per hour). Kids, don't try this at home.
If it ain't broke, I can fix that.
Stephen Badgett
Regular Advisor

Re: DBA - I AM NOT -- Oracle 9i

I would agree
Not as is, is now
Stephen Badgett
Regular Advisor

Re: DBA - I AM NOT -- Oracle 9i

Indira

Thank you, Option 3 was a great option.

thank you,

Steve
Not as is, is now
Stephen Badgett
Regular Advisor

Re: DBA - I AM NOT -- Oracle 9i

I had to look hard but I did find a solution to this issue.

Thanks for moving me in the right direction

Steve

Not as is, is now