open database

[Former Member]

Hi,

Is it possible to resetlogs , If the database is inconsistent?

Alter database open resetlogs..

Regards

Ben

[former_member204746 · Accepted solution]

no, you need to recover your database first.

[Former Member]

Hi Ben,

It depends if you're using the archivelog mode in our "source" database.

Oracle verify if the recover process is needed every time you perform the "open database" according to the SCN. If the required data are in online redologs, the changes are applyed, without user intervention.

After you open the database using resetlogs you not be able to made a recover in this database anymore.

I suggest you get the manuals to system copies that are available in SAP Service Marketplace:

- SAP System Landscape Copy for SAP NetWeaver and mySAP Solutions

- Homogeneous and Heterogeneous System Copy for SAP® Systems Based on SAP Web Application Server

If you need more information, let me know.

Regards,

Itamar Marioto

[Former Member]

Hi Ben,

Let me see if I understant your doubt:

You are copying one database to create a new system. But you not shure what option (resetlogs or noresetlogs) you should use when you try to open the database. Is it correct?

I suggest you to use the resetlogs option, because you are creating a new system.

Execute the create controlfile statement and if you receive the information that you need media recover, execute the statement " recover database using backup controlfile; ", and provide the path where the archived files are stored.

Observe that by default the suggest names are defined in oracle profile, maybe you need to rename de archivelog files to the new database definition.

I hope that I can help you.

If you need additional clarification, please let me know.

Regards,

Itamar Marioto

[Former Member]

Hi Itamar Marioto ,

Thanks for your reply.

Why , I will receive the message "you need media recover" for offline backup?

If we resetlogs ... is it possible to revover databse?

Regards

Ben

[former_member204746]

you need to recover database BEFORE resetlogs.

[Former Member]

what do u mean by inconsistent, can you elaborate more or send some log/errors etc.

Regards

Manohar

[Former Member]

hi All,

Thanks for your reply.

We are using the following procedure for system copy (offline backup )

After restore

1.)

create controlfile reuse set database HD1 NORESETLOGS ARCHIVELOG ...

.........

Recover database using backup controlfile

Alter database open resetlogs

-

---

2.)

create controlfile reuse set database HD1 RESETLOGS ARCHIVELOG ...

.........

Alter database open resetlogs

If I use the procedure 2 ....

Does databse will open with correpted data file?

...

Regards

Ben

[former_member204746]

how do you know that a datafile is corrupted?

if it is corrupted, database will never open.

if datafile needs recovery, then this is something else.

please explain your corruption.