Problem after database restore

[Former Member]

Dear All,

One file system of my server had crashed due to hardware failure.

so i have restored the databse by full online + redolog backup. Now,

after successfully restoration of database with upto online redolog, my

databse is ok. But i am getting two problems.

First one is that its temporary tablespace PSAPTEMP is not showing any

datafile in Db02 which is physically avaliable on hardisk. So, i have

added one more datafile in that but tell me what should i do now with

old datafile.

Second one is that my redolog number is now started from 1. Is there

any issue in that as previously it was ended upto 30478.

Please help.

Thanks with Regards,

Ankit Kr. Gupta

[stefan_koehler · Accepted solution]

Hello Ankit,

> Second one is that my redolog number is now started from 1. Is there any issue in that as previously it was ended upto 30478.

That's normal. You have performed an incomplete recovery and opened your database with RESETLOGS.

As the word "RESETLOGS" says .. it resets the online redolog files and starts from 1.

Regards

Stefan

[Former Member · Accepted solution]

Thanks to both of you.

Shambo : But why these didn't added automatically. What may be the reason ? And may i delete the old temp files as i have already added a new one temp file of the required size.

Ankit

[stefan_koehler · Accepted solution]

Hello Ankit,

> But why these didn't added automatically. What may be the reason ?

This depends on the way how you have performed the recovery. Did you use brrecover or RMAN? Normally these tools should do such stuff automatically.

If you have done a manual recovery with SQL*Plus - you have to do it on your own.

> And may i delete the old temp files as i have already added a new one temp file of the required size.

As you have said .. your PSAPTEMP was empty after the restore .. yes you can delete that file on OS level.

Regards

Stefan

[Former Member · Accepted solution]

Hello Stefan,

I have done a recovery from brrestore command from a whole database online+redolg backup with all the redologs. after that i recover database from sqlplus only.

Ankit

[Former Member]

Hi,

Execute the below query on SQL prompt to reuse the temporary data file.

ALTER TABLESPACE PSAPTEMP ADD TEMPFILE '<TEMP_DATA_FILE_PATH>' SIZE <2120M> REUSE AUTOEXTEND ON NEXT <20971520>  MAXSIZE <10000M>;

Check the size values in < > applicable for your scenario

OR

You can find this statement in generated Control file.

Thanks,

Shambo