Forum Stats

  • 3,827,089 Users
  • 2,260,740 Discussions
  • 7,897,163 Comments

Discussions

Failed upgrade from 11.2.0.4 to 18c release (18.7.0.0)

4089468
4089468 Member Posts: 1
edited Sep 23, 2019 2:09PM in Social Groups

Hello,

I am trying to upgrade my Oracle 11.2.0.4 database to 18c on a SAP system.

After following all of the recommended steps i started the DBUA and the upgrade process started.

During the upgrade I have picked the GRP (Guaranteed Restore Point) backup strategy. What I did not know is that during the upgrade DBUA creates a lot of flashback logs which filled the file system where the upgrade was happening. That caused my upgrade progress to freeze. I read on some forum post that I could possibly delete some of the logs and that DBUA would recognize the newly made free space and that it would continue the upgrade. Unfortunately, when I deleted the files, nothing happened and DBUA stayed frozen for about 36 hours. After that I decided to cancel the update and try running DBUA again.

Funny thing is that I can not run DBUA again because database is not in WRITE / READ (open) mode. I can not alter the database because during the startup instance crashes because flashback database fails (because of the manualy deleted logs). GRP also does not work because of the deleted logs. GRP can not be dropped either because the instance is failing. The biggest problem is that I do not have any recent complete database backup. So my question here is, is there any way to make the database avaliable again?

Here are the errors I get in the shells:

brrecover -type reset -rpt GRP_BEFORE_UPGRADE_18

BR0280I BRRECOVER time stamp: 2019-09-18 22:26:43

BR0663I Your choice: '1'

BR0614I Database instance DBSID is mounted

BR0280I BRRECOVER time stamp: 2019-09-18 22:26:43

BR0301E SQL error -38701 at location BrRpntListGet-1, SQL statement:

'OPEN curs_123 CURSOR FOR'

'SELECT NAME, TO_CHAR(TIME, 'YYYYMMDDHH24MISS'), SCN, GUARANTEE_FLASHBACK_DATABASE, STORAGE_SIZE FROM V$RESTORE_POINT ORDER BY SCN'

ORA-38701: Flashback database log 1 seq 1 thread 1: "oraclePathOfMyDatabase/flashback/o1_mf_gqpw30vx_.flb"

ORA-27037: unable to obtain file status

HPUX-ia64 Error: 2: No such file or directory

Additional information: 3

BR0280I BRRECOVER time stamp: 2019-09-18 22:26:43

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

When trying to startup without running restore point.

SQL> startup

ORACLE instance started.

Total System Global Area 3407413248 bytes

Fixed Size                  2210224 bytes

Variable Size            2365589072 bytes

Database Buffers         1023410176 bytes

Redo Buffers               16203776 bytes

Database mounted.

ORA-38760: This database instance failed to turn on flashback database

SQL>

Answers

  • BPeaslandDBA
    BPeaslandDBA Member Posts: 4,615 Blue Diamond
    edited Sep 23, 2019 12:06PM

    See Note 1554596.1 for more info.

    But basically, Oracle is trying to flashback the database on startup, but you removed flashback logs it needs. Hence the ORA-38760 error. 

    Look at that note I linked and check Case 2 as it applies to you. You have a Guaranteed Restore point defined so you need to remove it. You'll have to dump the control file as show in step 2.3 and then use the restore point name found in the control file and drop it. Then you should be able to open the dataase.

    Cheers,
    Brian