Solved

Recover sysaux file

Posted on 2013-01-08
5
308 Views
Last Modified: 2013-01-08
How do I recover sysaux since I don't have backup for it?
0
Comment
Question by:lium1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38756307
You don't.  Without a backup to start from, you are sort of out-of-luck.

You can recreate the tablespace but you will need to rebuild any objects housed in the old one.

Here is the doc link that talks about it:
http://docs.oracle.com/cd/E11882_01/server.112/e25494/create004.htm#i1011308

You can then look at the list of normal occupants of it to see if you were using any of them.
0
 

Author Comment

by:lium1
ID: 38757079
Any suggestions?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38757099
None that I didn't post already: rebuild it.

This is why backups are a good thing.

As noted in the docs, sysaux normally is for Oracle add-ons and utilities.  If you aren't using them then you should be OK.  Just offline/drop the tablespace.

If you think you might need it, export the important schemas in the database, then create a new database and import the data back in.

You will lose any data that was in sysaux but since you have no backups, I have to assume this was a test or dev database so it shoudn't matter.
0
 

Author Comment

by:lium1
ID: 38757337
Can you explain a little bit more in details by meaning of export the important schemas in the database, then create a new database and import the data back in?

Syntax and procedure, please?
0
 
LVL 77

Accepted Solution

by:
slightwv (䄆 Netminder) earned 500 total points
ID: 38757367
I assume there are 'important' tables/procedures/etc... in the database?

Those are owned by some user.  This is a schema in Oracle (a database users that owns objects).

You can use classic exp or the new expdp to export those users/schemas you want to keep/migrate over to the new database.

The docs have everything you need to do this. Even examples.  There are also a TON of links out there on these utilities.

expdp:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_export.htm#i1007466

classic exp:
http://docs.oracle.com/cd/E11882_01/server.112/e22490/original_export.htm#BABBHCIE

To create a new database, run dbca.  This should be the same steps you ran when you created the database you currently have.

Again, the online docs should have everything you need.

Creating a Database with DBCA
http://docs.oracle.com/cd/E11882_01/server.112/e25494/create002.htm#ADMIN12479

Creating and Managing a Database with DBCA
http://docs.oracle.com/cd/E11882_01/server.112/e10897/install.htm#ADMQS023
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
Via a live example, show how to take different types of Oracle backups using RMAN.

729 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question