How can I restore files in the SYSTEM tablespace?

    Requires Free Membership to View

How you restore the file depends on the backup methodology you used. If you do not have a backup, then your entire database is lost. If you are not running in Archive log mode, then you'll have to shut down the database and restore all of the datatabase files from your backup, then start your database. You will have lost all transactions since your last backup.

If you are running in Archive log mode, then shut down your database, restore just the SYSTEM tablespace's datafile, then do START MOUNT in SQL*Plus. Issue RECOVER DATABASE followed by ALTER DATABASE OPEN, and you are ready to go.

If your backup was performed with RMAN, then let RMAN perform the recovery. RMAN will make all of the decisions for you and perform the requisite actions.

This was first published in March 2006

There are Comments. Add yours.

TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: