Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Tablespace recovering in User managed

Tablespace recovering in User managed

Tablespace recovering in User managed

I'll appreciate if somebody can help me. PLEASE!!! I can't find something to solve this issue:

Database in NoArchive, Tablespace USERDATA dropped included Datafiles, I keep the last cold backup only.
What are the correct steps to restore and recover the tablespace included datafiles WORKING IN USER MANAGED MODE?

Thanks so much in advance. warm Regards.


RE: Tablespace recovering in User managed


If your database is in NOARCHIVE LOG MODE, then you cannot recover the database, you can only restore the entire database to the state of the last FULL backup (including the control files, the database data files, and the on-line redo log files).

The steps I would follow to bring up a database composed of the above files is:

  • Backup the current, existing files (just in case).
  • Restore to their original locations the backed up (three) sets of files (control files, database data files, and on-line redo log files).
  • Startup the database.
The database should be in the state at which you performed the last cold backup.

Let us know how this works for you.

(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel."

RE: Tablespace recovering in User managed

Being in noarchive mode it's likely that you can't fully recover your tablespace, but it all depends on whether the online redo logs contain all of the updates that have happened since you took your last cold backup. If they do, then you have a full record of all the changes that have happened since the backup and can, indeed, fully recover. With this in mind, it's a big mistake to overwrite either the control files or the online redo logs with backup files. You should replace only the online data files from the backup, mount the database, and issue a "recover database" command. With luck this will work. Otherwise Oracle will ask for achivelog files that don't exist and you will have to give up and issue an "alter database open resetlogs" command to start the database as it was at the time of the cold backup.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close