• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

Recover sysaux file

How do I recover sysaux since I don't have backup for it?
0
lium1
Asked:
lium1
  • 3
  • 2
1 Solution
 
slightwv (䄆 Netminder) Commented:
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
 
lium1Author Commented:
Any suggestions?
0
 
slightwv (䄆 Netminder) Commented:
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
 
lium1Author Commented:
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
 
slightwv (䄆 Netminder) Commented:
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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now