Tablespace recovering in User managed 3

[Gonfer]

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?
BUT NOT USING RMAN!!!.

Thanks so much in advance. warm Regards.

GonFer

 

[SantaMufasa]

GonFer,

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:

[ul][li]Backup the current, existing files (just in case).[/li][li]Restore to their original locations the backed up (three) sets of files (control files, database data files, and on-line redo log files).[/li][li]Startup the database.[/li][/ul]

The database should be in the state at which you performed the last cold backup.

Let us know how this works for you.

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

 

[karluk]

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.