Cannot uncompress .S files after RMAN+brtools backup

[yrk_tkm]

Hello guys,

Trying to backup and restore with RMAN + brtools. So changed my initNWW.sap file as:

backup_mode = full

restore_mode = full

backup_type = online

backup_dev_type = disk

backup_root_dir = C:\backup

stage_root_dir = C:\oracle\NWW\sapbackup

compress_dir = C:\oracle\NWW\sapreorg

archive_function = save_delete

archive_copy_dir = C:\backup

archive_stage_dir = C:\backup

disk_copy_cmd = rman_set

rman_compress = yes

exec_parallel = 16

Online database & archive log backup ran successfully thru DB13.

So tried to restore. Control file and data files where uncompressed and restored automatically by brtools, but archive logs didn't. I have files like NWWARCH1_1_852473867.DBF.S, that I cannot decompress.

Brtools indicates that it couldn't find NWWARCH1_1_852473867.DBF (without .S)

What am I supposed to do?

Thnx in advance!

[yrk_tkm · Accepted solution]

Problem is solved.

C:\oracle\NWW\saparch\archNWW.log file was containing odd data, so corrected it as follows, and it worked!

#

#DISK..... 1  C:\oracle\NWW\oraarch\NWWARCH1_1_852473867.DBF  2014-07-09 14:47:59  28711936           6721876  1

#DISKSAV.. aeogiqbh svd  C:\backup\NWWARCH1_1_852473867.DBF.S 2014-07-09 14:48:08         $21      8682496

#DISKDEL.. aeogiqbh svd  2014-07-09 14:48:08

#DELDISK.. ........ ...  .......... ........

#

#* NWW  disk  aeogiqbh svd  2014-07-09 14:48:01  2014-07-09 14:48:10  1  ...........         1        1        0        0  -a----s 7.40 (6)  @0852473867@0852308187

#

#DISK..... 2  C:\oracle\NWW\oraarch\NWWARCH1_2_852473867.DBF  2014-07-09 15:29:55  175923200           6746699  1

#DISKSAV.. aeogivsb svd  C:\backup\NWWARCH1_2_852473867.DBF.S 2014-07-09 15:51:56         $22     53019648

#DISKDEL.. aeogivsb svd  2014-07-09 15:51:56

#DELDISK.. ........ ...  .......... ........

#

#* NWW  disk  aeogivsb svd  2014-07-09 15:51:37  2014-07-09 15:51:57  0  ...........         2        2        0        0  ------s 7.40 (6)  @0852473867

#

[yrk_tkm · Accepted solution]

brtools uncompressed files automatically. Anyway, it's strange that there are no tools to uncompress .S files manually.

[Former Member · Accepted solution]

Hi

brrecover seems not to uncompress archivelog files included in an online brbackup rman online_cons.

But you can uncompress those archivelog file (*.dbf.S) with brrestore first and then use brrecover to restore everything (full + archivelog (already restored) application or full + incr + archivelog (already restored) application).

Here is what I have used :

GQA00520:rootint# su - oraqb1

GQA00520:oraqb1 1> brrestore -b beoxugpl.fnd -m archive_logs -c force -p /oracle/QB1/112_64/dbs/initQB1_rmanonline.sap -e 5 -u /

BR0401I BRRESTORE 7.20 (18)

BR0405I Start of file restore: repcstbz.rsb 2014-11-04 19.49.19

BR0484I BRRESTORE log file: /oracle/QB1/sapbackup/repcstbz.rsb

BR0280I BRRESTORE time stamp: 2014-11-04 19.49.20

BR0407I Restore of database: QB1

BR0408I BRRESTORE action ID: repcstbz

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: partial

BR0411I Database files for restore: ARCHIVE_LOGS

BR0414I Offline redolog file for restore of database instance QB1: 4193

BR0419I Files will be restored from backup: beoxugpl.fnd 2014-10-09 17.33.13

BR0416I 1 file found to restore, size 6.873 MB

BR1398I Files will be decompressed by RMAN

BR0421I Restore device type: disk

BR0420I Files will be restored from directory: /backup_shared2/QB1/beoxugpl

BR0134I Unattended mode with 'force' active - no operator confirmation allowed

BR0351I Restoring /oracle/QB1/oraarch/QB1arch1_4193_816690937.dbf

BR0355I from /backup_shared2/QB1/beoxugpl/QB1arch1_4193_816690937.dbf.S ...

#ARCHIVE.. /oracle/QB1/oraarch/QB1arch1_4193_816690937.dbf

#RESTORED. /backup_shared2/QB1/beoxugpl/QB1arch1_4193_816690937.dbf.S  #1/7

BR0280I BRRESTORE time stamp: 2014-11-04 19.49.24

BR0418I 1 of 1 file restored - 6.873 of 6.873 MB done

BR0204I Percentage done: 100.00%, estimated end time: 19:49

BR0001I **************************************************

BR0406I End of file restore: repcstbz.rsb 2014-11-04 19.49.24

BR0280I BRRESTORE time stamp: 2014-11-04 19.49.24

BR0402I BRRESTORE completed successfully

cheers

Naguy / Hacene

[yrk_tkm]

Didn't anybody face this issue?

[former_member188883]

Hi Yerk,

Which command have you used to restore the backup including logs ?

Regards,

Deepak Kori

[yrk_tkm]

I used brtools

[former_member188883]

I mean to say can you please share the full command which is displayed under brtools menu.

[yrk_tkm]

U mean this?

BR0291I BRRESTORE will be started with options '-p initNWW.sap -b beogioxq.and -d disk -m all -k no -e 16 -l E -i 30'

This is for data file restore.

[former_member188883]

Thanks Yerkebutaln,

The command which has been used will not restore control files and online redo log files.

Can you try to restore using option "-m full" and check the results.

Regards,

Deepak Kori

[yrk_tkm]

Deepak,

I started restore with parameters:

BR0291I BRRESTORE will be started with options '-p initNWW.sap -b beogioxq.and -d disk -m full -k no -e 16 -l E -i 30'

After data files and control file were restored, I continued to restore archivelogs with parameters:

BR0291I BRRESTORE will be started with options '-p initNWW.sap -a 1-2=C:\oracle\NWW\oraarch -d disk -k no -l E -i 30'

But it didn't succeed. Any ideas?

[former_member188883]

Hi Yerkebulan,

The command does not contain any backup file using which restoration should begin

BR0291I BRRESTORE will be started with options '-p initNWW.sap -a 1-2=C:\oracle\NWW\oraarch -d disk -k no -l E -i 30'

Can you please check and add backup file name as well.

Regards,

Deepak Kori

[yrk_tkm]

It doesn't accept parameter "-b beogioxq.and"

Here are my actions:

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:36

BR0655I Control menu 103 - please decide how to proceed

-------------------------------------------------------------------------------

Database point-in-time recovery main menu

1 + Set point-in-time for recovery

2 + Select database backup or flashback

3 + Check the status of database files

4 + Restore control files

5 + Restore data files

6 # Restore split incremental control files

7 # Restore and apply incremental backup

8 = Restore and apply archivelog files

9 # Restore archivelog files and flashback

10 * Open database and post-processing

11 * Exit program

12 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

8

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:41

BR0663I Your choice: '8'

BR0614I Database instance NWW is mounted

BR0750I Database instance NWW will be remounted now in mode 'IMMEDIATE'

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:41

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

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:44

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:44

BR0307I Shutting down database instance NWW ...

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:49

BR0308I Shutdown of database instance NWW successful

BR0280I BRRECOVER time stamp: 2014-07-15 17:19:49

BR0330I Starting and mounting database instance NWW ...

BR0280I BRRECOVER time stamp: 2014-07-15 17:20:02

BR0331I Start and mount of database instance NWW successful

BR0776I First redolog file sequence to apply for database instance NWW: 1

BR0777I Last redolog file sequence to apply for database instance NWW: 2

BR0699I Reading log file C:\oracle\NWW\saparch\archNWW.log for device type 'disk

'...

BR0699I Reading log file C:\oracle\NWW\saparch\archNWW.log for device type 'tape

/backint/rman'...

BR0699I Reading log file C:\oracle\NWW\saparch\archNWW.log for device type 'stag

e'...

BR0280I BRRECOVER time stamp: 2014-07-15 17:20:04

BR0660I List display 113 - no selection possible

-------------------------------------------------------------------------------

Archivelog files to apply of database instance NWW

Pos.  Sequence   Status    Apply   From    Disk    Tape    Util.  Rman   Stage

   1 -        1   on_disk    yes    disk    yes$    ....    ....   ....   ....

   2 -        2   on_disk    yes    disk    yes$    ....    ....   ....   ....

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:20:41

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:20:41

BR0657I Input menu 117 - please enter/check input values

-------------------------------------------------------------------------------

Applying archivelog files of database instance NWW

1 - First sequence number (first_seq) .. [1]

2 - Last sequence number (last_seq) .... [2]

3 - Use backup control file (back_ctl) . [yes]

4 ~ Parallel recovery (degree) ......... []

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:20:58

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:20:58

BR0657I Input menu 115 - please enter/check input values

-------------------------------------------------------------------------------

BRRESTORE main options for restore of archivelog files

1 - BRRESTORE main profile (profile) ..... [initNWW.sap]

2 # Profile for cpio (prof_cpio) ......... []

3 # Profile for dd (prof_dd) ............. []

4 # Profile for rman (prof_rman) ......... []

5 # Profile for rman_dd (prof_rman_dd) ... []

6 - Profile for rman_set (prof_rman_set) . [initNWW.sap]

7 # Profile for brtools (prof_brtools) ... [initNWW.sap]

8 # BACKINT/Mount profile (parfile) ...... []

9 - Database user/password (user) ........ [/]

10 - Destination directory (dest_dir) ..... [C:\oracle\NWW\oraarch]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:21:22

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:21:22

BR0657I Input menu 116 - please enter/check input values

-------------------------------------------------------------------------------

Additional BRRESTORE options for restore of archivelog files

1 - Confirmation mode (confirm) . [yes]

2 - Additional output (output) .. [no]

3 - Message language (language) . [E]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:21:38

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:21:38

BR0657I Input menu 118 - please enter/check input values

-------------------------------------------------------------------------------

BRRESTORE command line for restore of archivelog group

1 - Restore unattended (unattend) .... [no]

2 - BRRESTORE command line (command) . [-p initNWW.sap -a 1-2=C:\oracle\NWW\ora

arch -d disk -k no -l E -i 30]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

2

BR0280I BRRECOVER time stamp: 2014-07-15 17:33:07

BR0663I Your choice: '2'

BR0681I Enter string value for "command" [-p initNWW.sap -a 1-2=C:\oracle\NWW\or

aarch -d disk -k no -l E -i 30]:

-p initNWW.sap -b beogioxq.and -a 1-2=C:\oracle\NWW\oraarch -d disk -k no -l E -

i 30

BR0280I BRRECOVER time stamp: 2014-07-15 17:33:44

BR0683I New value for "command": '-p initNWW.sap -b beogioxq.and -a 1-2=C:\oracl

e\NWW\oraarch -d disk -k no -l E -i 30'

BR0280I BRRECOVER time stamp: 2014-07-15 17:33:44

BR0657I Input menu 118 - please enter/check input values

-------------------------------------------------------------------------------

BRRESTORE command line for restore of archivelog group

1 - Restore unattended (unattend) .... [no]

2 - BRRESTORE command line (command) . [-p initNWW.sap -a 1-2=C:\oracle\NWW\ora

arch -d disk -k no -l E -i 30]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:22:06

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRRESTORE will be started with options '-p initNWW.sap -a 1-2=C:\oracle\

NWW\oraarch -d disk -k no -l E -i 30'

BR0280I BRRECOVER time stamp: 2014-07-15 17:22:06

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

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:24:38

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRRESTORE will be started with options '-p initNWW.sap -a 1-2=C:\oracle\

NWW\oraarch -d disk -k no -l E -i 30'

BR0280I BRRECOVER time stamp: 2014-07-15 17:24:38

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

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:24:58

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

===============================================================================

BR0401I BRRESTORE 7.40 (6)

BR0405I Start of file restore: reohmqvy.rsa 2014-07-15 17:24:58

BR0484I BRRESTORE log file: C:\oracle\NWW\sapbackup\reohmqvy.rsa

BR0461W Redolog sequence number in line 19 of C:\oracle\NWW\saparch\archNWW.log

not ascending

BR0462W All lines in C:\oracle\NWW\saparch\archNWW.log till line 19 will be igno

red

BR0469W Line 20 in C:\oracle\NWW\saparch\archNWW.log rejected for C:\oracle\NWW\

oraarch\NWWARCH1_1_852473867.DBF because of different disk copy command types

BR0469W Line 27 in C:\oracle\NWW\saparch\archNWW.log rejected for C:\oracle\NWW\

oraarch\NWWARCH1_2_852473867.DBF because of different disk copy command types

BR0465E Wrong value of disk_copy_cmd for the first offline redolog file found

BR0439E No offline redolog files found in C:\oracle\NWW\saparch\archNWW.log for

processing for device type DISK in recovery interval of 30 days

BR0406I End of file restore: reohmqvy.rsa 2014-07-15 17:24:58

BR0280I BRRESTORE time stamp: 2014-07-15 17:24:58

BR0404I BRRESTORE terminated with errors

===============================================================================

BR0292I Execution of BRRESTORE finished with return code 3

BR0280I BRRECOVER time stamp: 2014-07-15 17:24:58

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:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:25:32

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:25:32

BR0657I Input menu 119 - please enter/check input values

-------------------------------------------------------------------------------

Applying archivelog group of database instance NWW

1 - Apply unattended (unattend) ....... [no]

2 - First sequence number (first_seq) . [1]

3 - Last sequence number (last_seq) ... [2]

4 - SQLPLUS command (command) ......... [recover from 'C:\oracle\NWW\oraarch\NW

Warch' database until cancel using backup controlfile]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:25:49

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0783I Archivelog files with sequence number 1-2 of database instance NWW will

be applied now

BR0280I BRRECOVER time stamp: 2014-07-15 17:25:49

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

c

BR0280I BRRECOVER time stamp: 2014-07-15 17:26:00

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRECOVER time stamp: 2014-07-15 17:26:00

BR0336I Applying offline redolog file C:\oracle\NWW\oraarch\NWWARCH1_1_852473867

.DBF ...

BR0336I Applying offline redolog file C:\oracle\NWW\oraarch\NWWARCH1_2_852473867

.DBF ...

BR0278E Command output of 'C:\oracle\NWW\11203\BIN\sqlplus /nolog < C:\oracle\NW

W\sapbackup\.veohljjx.spi':

SQL*Plus: Release 11.2.0.3.0 Production on Tue Jul 15 17:26:01 2014

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

SQL> Connected.

SQL>

SQL> SQL> SQL> SQL> SQL> SQL> ORA-00279: change 6744689 generated at 07/09/2014

14:35:19 needed for thread 1

ORA-00289: suggestion : C:\ORACLE\NWW\ORAARCH\NWWARCH1_1_852473867.DBF

ORA-00280: change 6744689 for thread 1 is in sequence #1

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log 'C:\oracle\NWW\oraarch\NWWARCH1_1_852473867.

DBF'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-00308: cannot open archived log 'C:\oracle\NWW\oraarch\NWWARCH1_2_852473867.

DBF'

ORA-27041: unable to open file

OSD-04002: unable to open file

O/S-Error: (OS 2) The system cannot find the file specified.

Specify log: {<RET>=suggested | filename | AUTO | CANCEL}

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01152: file 1 was not restored from a sufficiently old backup

ORA-01110: data file 1: 'C:\ORACLE\NWW\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

ORA-01112: media recovery not started

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

- 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

BR0280I BRRECOVER time stamp: 2014-07-15 17:26:02

BR0279E Return code from 'C:\oracle\NWW\11203\BIN\sqlplus /nolog < C:\oracle\NWW

\sapbackup\.veohljjx.spi': 0

BR0302E SQLPLUS call for database instance NWW failed

BR0200I BR_TRACE: location BrDbRecover-26, commands for SQLPLUS in: C:\oracle\NW

W\sapbackup\.veohljjx.spi

@C:\oracle\NWW\sapbackup\.veohljjx.spu

host C:\usr\sap\NWW\SYS\exe\uc\NTAMD64\brtools.exe -f delete C:\oracle\NWW\sapba

ckup\.veohljjx.spu;

set linesize 1000;

set pagesize 1000;

set sqlprompt "SQL> ";

set tab off;

set autorecovery off;

recover from 'C:\oracle\NWW\oraarch\NWWarch' database until cancel using backup

controlfile;

C:\oracle\NWW\oraarch\NWWARCH1_1_852473867.DBF

C:\oracle\NWW\oraarch\NWWARCH1_2_852473867.DBF

cancel

exit;

BR0338E Applying offline redolog file C:\oracle\NWW\oraarch\NWWARCH1_1_852473867

.DBF failed

BR0338E Applying offline redolog file C:\oracle\NWW\oraarch\NWWARCH1_2_852473867

.DBF failed

BR0548I Check Oracle alert log C:\oracle\NWW\saptrace\diag\rdbms\nww\NWW\trace\a

lert_NWW.log for further information about this error

BR0280I BRRECOVER time stamp: 2014-07-15 17:26:02

BR0669I Cannot continue due to previous warnings or errors - you can go back and

repeat the last action

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

[former_member188883]

Hi Yerkebulan,

Can you try unzipping the archive log files using windows winzip utility ?

Regards,

Deepak Kori

[yrk_tkm]

U must be joking, my friend

I've tried everything

[former_member188883]

Hi Yerkebulan,

Have you tried updating brtools and checking the results.

Refer SAP note below

Note 1101530 - Support for RMAN savesets for backups on hard disk

Regards,

Deepak Kori

[yrk_tkm]

Hi Deepak,

My brtools version is higher than stated in note 1101530.

It is BRTOOLS 7.40 (6)

[former_member188883]

Hi Yerkebulan,

May be you need to raise OSS message to get support.

Regards,

Deepak Kori