Thursday, May 08, 2014

To restore only Online redo log and control files.

If you see offline database backup log file, will show entry similar to below

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

BRBACKUP Action Log for Database PIP

From: 01.05.2014 00:13:07

LogFile: benteodf.aft

Return Code: 0000 Success

Database Host: XXXXX

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

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

|010514| 4 |01.05.2014 00:15:11| | 4 | | 41,852 |PSAPSR3 |ONLINE |ONLINE |/oracle/PIP/sapdata1/sr3_1/sr3.data1 |

|010514| 5 |01.05.2014 00:16:27| | 5 | | 41,852 |PSAPSR3 |ONLINE |ONLINE |/oracle/PIP/sapdata2/sr3_2/sr3.data2 |

|010514| 158 |01.05.2014 04:13:00| | 1 | | 41,852 | | | |/oracle/PIP/origlogA/log_g11m1.dbf |

|010514| 159 |01.05.2014 04:13:12| | 2 | | 41,852 | | | |/oracle/PIP/origlogB/log_g12m1.dbf |

|010514| 160 |01.05.2014 04:13:23| | 3 | | 41,852 | | | |/oracle/PIP/origlogA/log_g13m1.dbf |

|010514| 161 |01.05.2014 04:13:33| | 4 | | 41,852 | | | |/oracle/PIP/origlogB/log_g14m1.dbf |

|010514| 162 |01.05.2014 04:13:42| | 0 | | 41,852 | | | |/oracle/PIP/origlogA/cntrl/cntrlPIP.dbf |

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

Based on above can able to idenfity online log file starting from position (DF ID) 1 to 4 while control file position (DF ID) 0

Execute brrestore command i.e. brrestore -b <backuplogfile name> -m <starting position DF ID>-<ending posistion DF ID>,<0 for control file DF ID>

ipldia10:orapip 20> brrestore -b benteodf.aft -m 01-04,0

BR0401I BRRESTORE 7.20 (29)

BR0405I Start of file restore: rentklfs.rsb 2014-05-02 04.58.00

BR0484I BRRESTORE log file: /oracle/PIP/sapbackup/rentklfs.rsb

BR0280I BRRESTORE time stamp: 2014-05-02 04.58.00

BR0407I Restore of database: PIP

BR0408I BRRESTORE action ID: rentklfs

BR0409I BRRESTORE function ID: rsb

BR0449I Restore mode: partial

BR0411I Database files for restore:

/oracle/PIP/origlogA/log_g11m1.dbf

/oracle/PIP/mirrlogA/log_g11m2.dbf

/oracle/PIP/origlogB/log_g12m1.dbf

/oracle/PIP/mirrlogB/log_g12m2.dbf

/oracle/PIP/origlogA/log_g13m1.dbf

/oracle/PIP/mirrlogA/log_g13m2.dbf

/oracle/PIP/origlogB/log_g14m1.dbf

/oracle/PIP/mirrlogB/log_g14m2.dbf

/oracle/PIP/origlogA/cntrl/cntrlPIP.dbf

/oracle/PIP/origlogB/cntrl/cntrlPIP.dbf

/oracle/PIP/sapdata1/cntrl/cntrlPIP.dbf

BR0419I Files will be restored from backup: benteodf.aft 2014-05-01 00.13.07

BR0416I 5 files found to restore, total size 824.988 MB

BR0424I Files will not be decompressed

BR0421I Restore device type: tape

BR0102I Following backup device will be used: /dev/rmt/3mn

BR0103I Following backup volume will be used: 010514 (2014-05-01 00.13.07)

BR0280I BRRESTORE time stamp: 2014-05-02 04.58.00

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

BR0280I BRRESTORE time stamp: 2014-05-02 04.58.11

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0208I Volume with name 010514 (2014-05-01 00.13.07) required in device /dev/rmt/3mn

BR0210I Please mount BRBACKUP volume, if you have not already done so

BR0280I BRRESTORE time stamp: 2014-05-02 04.58.11

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRRESTORE:

BR0280I BRRESTORE time stamp: 2014-05-02 04.58.14

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRRESTORE time stamp: 2014-05-02 04.58.14

BR0226I Rewinding tape volume in device /dev/rmt/3m ...

BR0351I Restoring /oracle/PIP/sapreorg/.tape.hdr0

BR0355I from /dev/rmt/3mn ...

BR0241I Checking label on volume in device /dev/rmt/3mn

BR0209I Volume in device /dev/rmt/3mn has name 010514 (2014-05-01 00.13.07)

BR0280I BRRESTORE time stamp: 2014-05-02 04.59.46

BR0199I Volume label checked successfully

BR0351I Restoring /oracle/PIP/origlogA/log_g11m1.dbf

BR0355I from /dev/rmt/3mn ...

#FILE..... /oracle/PIP/origlogA/log_g11m1.dbf

#RESTORED. log_g11m1.dbf 010514/158

BR0280I BRRESTORE time stamp: 2014-05-02 05.01.23

BR0418I 1 of 5 files restored - 200.001 of 824.988 MB done

BR0204I Percentage done: 24.24%, estimated end time: 5:11

BR0001I ************______________________________________

BR0351I Restoring /oracle/PIP/origlogB/log_g12m1.dbf

BR0355I from /dev/rmt/3mn ...

#FILE..... /oracle/PIP/origlogB/log_g12m1.dbf

#RESTORED. log_g12m1.dbf 010514/159

BR0280I BRRESTORE time stamp: 2014-05-02 05.01.25

BR0418I 2 of 5 files restored - 400.002 of 824.988 MB done

BR0204I Percentage done: 48.49%, estimated end time: 5:04

BR0001I ************************__________________________

BR0351I Restoring /oracle/PIP/origlogA/log_g13m1.dbf

BR0355I from /dev/rmt/3mn ...

#FILE..... /oracle/PIP/origlogA/log_g13m1.dbf

#RESTORED. log_g13m1.dbf 010514/160

BR0280I BRRESTORE time stamp: 2014-05-02 05.01.26

BR0418I 3 of 5 files restored - 600.003 of 824.988 MB done

BR0204I Percentage done: 72.73%, estimated end time: 5:02

BR0001I ************************************______________

BR0351I Restoring /oracle/PIP/origlogB/log_g14m1.dbf

BR0355I from /dev/rmt/3mn ...

#FILE..... /oracle/PIP/origlogB/log_g14m1.dbf

#RESTORED. log_g14m1.dbf 010514/161

BR0280I BRRESTORE time stamp: 2014-05-02 05.01.27

BR0418I 4 of 5 files restored - 800.004 of 824.988 MB done

BR0204I Percentage done: 96.97%, estimated end time: 5:01

BR0001I ************************************************__

BR0351I Restoring /oracle/PIP/origlogA/cntrl/cntrlPIP.dbf

BR0355I from /dev/rmt/3mn ...

#FILE..... /oracle/PIP/origlogA/cntrl/cntrlPIP.dbf

#RESTORED. cntrlPIP.dbf 010514/162

BR0280I BRRESTORE time stamp: 2014-05-02 05.01.27

BR0418I 5 of 5 files restored - 824.988 of 824.988 MB done

BR0204I Percentage done: 100.00%, estimated end time: 5:01

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

BR0351I Restoring /oracle/PIP/mirrlogA/log_g11m2.dbf

BR0355I from /oracle/PIP/origlogA/log_g11m1.dbf ...

BR0351I Restoring /oracle/PIP/mirrlogB/log_g12m2.dbf

BR0355I from /oracle/PIP/origlogB/log_g12m1.dbf ...

BR0351I Restoring /oracle/PIP/mirrlogA/log_g13m2.dbf

BR0355I from /oracle/PIP/origlogA/log_g13m1.dbf ...

BR0351I Restoring /oracle/PIP/mirrlogB/log_g14m2.dbf

BR0355I from /oracle/PIP/origlogB/log_g14m1.dbf ...

BR0351I Restoring /oracle/PIP/origlogB/cntrl/cntrlPIP.dbf

BR0355I from /oracle/PIP/origlogA/cntrl/cntrlPIP.dbf ...

BR0351I Restoring /oracle/PIP/sapdata1/cntrl/cntrlPIP.dbf

BR0355I from /oracle/PIP/origlogA/cntrl/cntrlPIP.dbf ...

BR0280I BRRESTORE time stamp: 2014-05-02 05.01.39

BR0226I Rewinding tape volume in device /dev/rmt/3m ...

BR0406I End of file restore: rentklfs.rsb 2014-05-02 05.03.20

BR0280I BRRESTORE time stamp: 2014-05-02 05.03.20

BR0402I BRRESTORE completed successfully

ipldia10:orapip 21>

To restore selecting data file, online redo log and control files.

Execute brrestore command i.e. brrestore -b <backuplogfile name> -m <staring position DF ID of datafile>,<ending position DF ID of data file> <starting position DF ID>-<ending posistion DF ID>,<0 for control file DF ID>

Restoring data file from DF ID 1 to 15 with online redo log 4 files and control file.

ipldia10:orapip 20> brrestore -b benteodf.aft -m 1,15 01-04,0

To restore only data file.

Execute brrestore command i.e. brrestore -b <backuplogfile name> -m all

Restoring data file from DF ID 1 to 15 with online redo log 4 files and control file.

ipldia10:orapip 20> brrestore -b benteodf.aft -m all

Restore full backup including data, online log and control file

Execute brrestore command i.e. brrestore -b <backuplogfile name> -m full

ipldia10:orapip 20> brrestore -b benteodf.aft -m full

Examples of BRRESTORE Runs

1. brrestore -b last -m all

Restore all tablespaces without the control file and online redo log files from the last successful backup

2. brrestore -b bcnmhluz.aft -m full

Restores all the files from backup bcnmhluz.aft, including the control file and the online redo log files

Restores the mirror copies of the control file and the online redo log files

3. brrestore -m /usr/sap/C11/SYS/profile

Restores the SAP profiles

4. brrestore -m /oracle/C11/sapdata1=/oracle/C11/sapdata5

Restores all the database data files that were originally stored in the subdirectories of /oracle/C11/sapdata1 in directory /oracle/C11/sapdata5

brrestore -b last -m 1-10,01-04,0

Restores all the database data files with Oracle file IDs from 1 through 10, the four online redo log files, and the control file starting from the last successful backup

Restores the mirror copies of the control file and the online redo log files

5. brrestore -m 0

Restores the control file. Restore the mirror copies of the control file

6. brrestore -b last -m /oracle/C11/sapdata2/ddicd_5/ddicd.data5

Restores a database data file starting from the last successful backup

7. brrestore -a 200-220

Restores the archived redo log files with the log sequence numbers from 200 through 220 into the archiving directory

8. brrestore -a 40-70=/oracle/C11/sapbackup 71-90=/oracle/C11/sapreorg

Restores the archived redo log files with the log sequence numbers from 40 through 70 in directory sapbackup and those with the log sequence numbers from 71

through 90 in directory /oracle/C11/sapreorg

9. brrestore -a 40-69,70-100=/oracle/C11/sapbackup

Restores the archived redo log files with the log sequence numbers from 40 through 69 in the archiving directory, and those with the log sequence numbers from 70 through 100 in directory sapbackup

10. brrestore -n det_log

Restores a detail log to the local working directory

Friday, April 11, 2014

Opatch apply come across file in use

During Opatch apply come across below error message.

D:\>cd oracle\MIS\11204\Patches.11204\18069285\

D:\oracle\MIS\11204\Patches.11204\18069285>d:\oracle\MIS\11204\OPatch\opatch app
ly
========================================================
GENERIC OPATCH VERSION - FOR USE IN SAP ENVIRONMENT ONLY
========================================================
Oracle Interim Patch Installer version 11.2.0.3.6
Copyright (c) 2013, Oracle Corporation. All rights reserved.

Oracle Home       : D:\ORACLE\MIS\11204
Central Inventory : C:\Program Files\Oracle\Inventory
   from           : n/a
OPatch version    : 11.2.0.3.6
OUI version       : 11.2.0.4.0
Log file location : D:\ORACLE\MIS\11204\cfgtoollogs\opatch\18069285_Apr_10_2014_
18_51_57\apply2014-04-10_18-51-57PM_1.log

Applying interim patch '18069285' to OH 'D:\ORACLE\MIS\11204'
Verifying environment and performing prerequisite checks...
Patch 18069285: Optional component(s) missing : [ oracle.sysman.agent, 10.2.0.4.
3, higher version 10.2.0.4.5 found. ] , [ oracle.has.cfs, 11.2.0.4.0 ] , [ oracl
e.has.crs, 11.2.0.4.0 ] , [ oracle.has.cvu, 11.2.0.4.0 ]
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following files are active :
D:\ORACLE\MIS\11204\bin\orapls11.dll
D:\ORACLE\MIS\11204\bin\orageneric11.dll
D:\ORACLE\MIS\11204\bin\oraclient11.dll
D:\ORACLE\MIS\11204\bin\oracommon11.dll
D:\ORACLE\MIS\11204\bin\oraxml11.dll
D:\ORACLE\MIS\11204\bin\orahasgen11.dll
D:\ORACLE\MIS\11204\bin\oraocr11.dll
D:\ORACLE\MIS\11204\bin\oraocrb11.dll
D:\ORACLE\MIS\11204\bin\oraocrutl11.dll
Log file location: D:\ORACLE\MIS\11204\cfgtoollogs\opatch\18069285_Apr_10_2014_1
8_51_57\apply2014-04-10_18-51-57PM_1.log

Recommended actions: OPatch needs to modify files which are being used by some p
rocesses.

OPatch failed with error code = 41

D:\oracle\MIS\11204\Patches.11204\18069285>

To resolve need to stop Windows Management Instrumentation service service.

Also during stopping Windows Management Instrumentation service service also stopped below.
    IP Helper
    HP ProLiant Agentless Management Service

Monday, March 24, 2014

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []

Getting below error message post restarting server after abnormal power off.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1319546880 bytes
Fixed Size                  2254904 bytes
Variable Size             671090632 bytes
Database Buffers          637534208 bytes
Redo Buffers                8667136 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

To resolve followed below steps. post getting above error.

SQL> alter database recover database;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1319546880 bytes
Fixed Size                  2254904 bytes
Variable Size             671090632 bytes
Database Buffers          637534208 bytes
Redo Buffers                8667136 bytes
Database mounted.
Database opened.
SQL>

Tuesday, February 11, 2014

move tables to different tablespace using Brtools i.e. TTREE tables during EHP update

IPLQLS:oraqls 3> brtools

BR0651I BRTOOLS 7.20 (31)

BR0280I BRTOOLS time stamp: 2014-02-11 12.44.31
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2014-02-11 12.44.37
BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2014-02-11 12.44.37
BR0656I Choice menu 7 - please make a selection
-------------------------------------------------------------------------------
Database segment management

1 = Reorganize tables
2 - Rebuild indexes
3 - Export tables
4 - Import tables
5 - Alter tables
6 - Alter indexes
7 - Additional segment functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1
BR0280I BRTOOLS time stamp: 2014-02-11 12.44.42
BR0663I Your choice: '1'

BR0280I BRTOOLS time stamp: 2014-02-11 12.44.42
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables

1 - BRSPACE profile (profile) ...... [initQLS.sap]
2 - Database user/password (user) .. [/]
3 ~ Reorganization action (action) . []
4 ~ Tablespace names (tablespace) .. []
5 ~ Table owner (owner) ............ []
6 ~ Table names (table) ............ []
7 ~ Table partitions (tabpart) ..... []
8 - Confirmation mode (confirm) .... [yes]
9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initQLS.sap -s 20 -l E -f tbreorg]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
6
BR0280I BRTOOLS time stamp: 2014-02-11 12.44.48
BR0663I Your choice: '6'
BR0681I Enter string value for "table" []:
TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK
BR0280I BRTOOLS time stamp: 2014-02-11 12.46.08
BR0683I New value for "table": 'TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK'

BR0280I BRTOOLS time stamp: 2014-02-11 12.46.08
BR0657I Input menu 91 - please enter/check input values
-------------------------------------------------------------------------------
BRSPACE options for reorganization of tables

1 - BRSPACE profile (profile) ...... [initQLS.sap]
2 - Database user/password (user) .. [/]
3 ~ Reorganization action (action) . []
4 ~ Tablespace names (tablespace) .. []
5 ~ Table owner (owner) ............ []
6 ~ Table names (table) ............ [TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK]
7 ~ Table partitions (tabpart) ..... []
8 - Confirmation mode (confirm) .... [yes]
9 - Extended output (output) ....... [no]
10 - Scrolling line count (scroll) .. [20]
11 - Message language (language) .... [E]
12 - BRSPACE command line (command) . [-p initQLS.sap -s 20 -l E -f tbreorg -t "TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK"]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2014-02-11 12.46.16
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0291I BRSPACE will be started with options '-p initQLS.sap -s 20 -l E -f tbreorg -t "TTREE,TTREEI,TTREEP,TTREET,TTREE_APPL,TTREE_FLNK"'

BR0280I BRTOOLS time stamp: 2014-02-11 12.46.16
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2014-02-11 12.46.18
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

###############################################################################

BR1001I BRSPACE 7.20 (31)
BR1002I Start of BRSPACE processing: seneityh.tbr 2014-02-11 12.46.19
BR0484I BRSPACE log file: /oracle/QLS/sapreorg/seneityh.tbr

BR0280I BRSPACE time stamp: 2014-02-11 12.46.19
BR1009I Name of database instance: QLS
BR1010I BRSPACE action ID: seneityh
BR1011I BRSPACE function ID: tbr
BR1012I BRSPACE function: tbreorg

BR0280I BRSPACE time stamp: 2014-02-11 12.46.19
BR1039I Selecting information about tables and indexes...
BR0285I This action can take several seconds/minutes - be patient...

BR0280I BRSPACE time stamp: 2014-02-11 12.46.38
BR0814I Number of tables in schema of owner SAPSR3: 84397

BR0280I BRSPACE time stamp: 2014-02-11 12.47.05
BR0815I Number of indexes in schema of owner SAPSR3: 101127

BR0280I BRSPACE time stamp: 2014-02-11 12.47.07
BR0660I List display 352 - no selection possible
-------------------------------------------------------------------------------
List of tables for reorganization

Pos. Owner    Table                Pt. DgPk.     Rows   Used[KB] Data[KB:%]

    1 - SAPSR3   TTREEI               NO   1     1378200    146864     91521:62
    2 - SAPSR3   TTREEP               NO   1      439270     42736     35605:83
    3 - SAPSR3   TTREET               NO   1       56890      6528      5167:79
    4 - SAPSR3   TTREE_APPL           NO   1       16943      2000      1241:62
    5 - SAPSR3   TTREE_FLNK           NO   1        2382       584       235:40

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.47.56
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2014-02-11 12.47.56
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREEI,... (5 tables)

1 * Reorganization action (action) ............ [reorg]
2 - Reorganization mode (mode) ................ [online]
3 - Create DDL statements (ddl) ............... [yes]
4 ~ New destination tablespace (newts) ........ []
5 ~ Separate index tablespace (indts) ......... []
6 - Parallel threads (parallel) ............... [1]
7 ~ Table/index parallel degree (degree) ...... []
8 ~ Category of initial extent size (initial) . []
9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... [ora_proc]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRSPACE time stamp: 2014-02-11 12.48.01
BR0663I Your choice: '4'
BR0681I Enter string value for "newts" []:
PSAPSR3731
BR0280I BRSPACE time stamp: 2014-02-11 12.48.11
BR0683I New value for "newts": 'PSAPSR3731'

BR0280I BRSPACE time stamp: 2014-02-11 12.48.11
BR0657I Input menu 353 - please enter/check input values
-------------------------------------------------------------------------------
Options for reorganization of tables: SAPSR3.TTREEI,... (5 tables)

1 * Reorganization action (action) ............ [reorg]
2 - Reorganization mode (mode) ................ [online]
3 - Create DDL statements (ddl) ............... [yes]
4 ~ New destination tablespace (newts) ........ [PSAPSR3731]
5 ~ Separate index tablespace (indts) ......... []
6 - Parallel threads (parallel) ............... [1]
7 ~ Table/index parallel degree (degree) ...... []
8 ~ Category of initial extent size (initial) . []
9 ~ Sort by fields of index (sortind) ......... []
10 # Index for IOT conversion (iotind) ......... [FIRST]
11 - Compression action (compress) ............. [none]
12 # LOB compression degree (lobcompr) ......... [medium]
13 # Index compression method (indcompr) ....... [ora_proc]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.48.15
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...

BR1098W Tablespace PSAPSR3731 should be auto-extensible for reorganization
BR0691W Warning by checking input value for 'newts'

BR0280I BRSPACE time stamp: 2014-02-11 12.48.15
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 BRSPACE time stamp: 2014-02-11 12.48.17
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR1108I Checking tables for reorganization...

BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR1112I Number of tables selected/skipped for reorganization: 5/0

BR0280I BRSPACE time stamp: 2014-02-11 12.48.17
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRSPACE time stamp: 2014-02-11 12.48.24
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0370I Directory /oracle/QLS/sapreorg/seneityh created

BR0280I BRSPACE time stamp: 2014-02-11 12.48.25
BR1101I Starting 'online' table reorganization...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.25
BR1124I Starting 'online' reorganization of table SAPSR3.TTREEI ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.47
BR1105I Table SAPSR3.TTREEI reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.47
BR1141I 1 of 5 tables processed - 1378200 of 1893685 rows done
BR0204I Percentage done: 71.42%, estimated end time: 12:48
BR0001I ************************************______________
BR0280I BRSPACE time stamp: 2014-02-11 12.48.47
BR1124I Starting 'online' reorganization of table SAPSR3.TTREEP ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.54
BR1105I Table SAPSR3.TTREEP reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.54
BR1141I 2 of 5 tables processed - 1817470 of 1893685 rows done
BR0204I Percentage done: 94.54%, estimated end time: 12:48
BR0001I ***********************************************___
BR0280I BRSPACE time stamp: 2014-02-11 12.48.54
BR1124I Starting 'online' reorganization of table SAPSR3.TTREET ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.56
BR1105I Table SAPSR3.TTREET reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.56
BR1141I 3 of 5 tables processed - 1874360 of 1893685 rows done
BR0204I Percentage done: 97.98%, estimated end time: 12:48
BR0001I *************************************************_
BR0280I BRSPACE time stamp: 2014-02-11 12.48.56
BR1124I Starting 'online' reorganization of table SAPSR3.TTREE_APPL ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.57
BR1105I Table SAPSR3.TTREE_APPL reorganized successfully
BR0280I BRSPACE time stamp: 2014-02-11 12.48.57
BR1124I Starting 'online' reorganization of table SAPSR3.TTREE_FLNK ...
BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR1105I Table SAPSR3.TTREE_FLNK reorganized successfully

BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR1141I 5 of 5 tables processed - 1893685 of 1893685 rows done
BR0204I Percentage done: 100.00%, estimated end time: 12:48
BR0001I **************************************************

BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR1102I Number of tables reorganized successfully: 5

BR0280I BRSPACE time stamp: 2014-02-11 12.48.59
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
s
BR0280I BRSPACE time stamp: 2014-02-11 12.42.34
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:
y
BR0280I BRSPACE time stamp: 2014-02-11 12.42.37
BR0257I Your reply: 'y'
BR0260E BRSPACE cancelled by user

BR1008I End of BRSPACE processing: seneithh.tbr 2014-02-11 12.42.37
BR0280I BRSPACE time stamp: 2014-02-11 12.42.37
BR1007I BRSPACE terminated with errors

###############################################################################

BR0292I Execution of BRSPACE finished with return code 2

BR0280I BRTOOLS time stamp: 2014-02-11 12.42.37
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:
s
BR0280I BRTOOLS time stamp: 2014-02-11 12.42.38
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2014-02-11 12.42.40
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2014-02-11 12.42.40
BR0654I BRTOOLS terminated with errors

Thursday, January 30, 2014

Change oracle parameter for process and sessions

Above parameter can’t be changed directly through ALTER command.

SQL> select name,value,ISSES_MODIFIABLE,ISSYS_MODIFIABLE from v$parameter where NAME in ('sessions','processes');

NAME VALUE ISSES ISSYS_MOD

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

processes 190 FALSE FALSE

sessions 384 FALSE FALSE

SQL>

SQL> ALTER SYSTEM SET processes=600 SCOPE=BOTH;

ALTER SYSTEM SET processes=600 SCOPE=BOTH

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

SQL> alter system set sessions=1200 scope=both;

alter system set sessions=1200 scope=both

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

Follow below step to change.

1. Create Pfile from SPFILE.

SQL> create pfile from spfile;

File created.

SQL>

Will create file init<SAPSID>.ora (initQLS.ora) inside /oracle/QLS/112_64/dbs directory.

2. Open Pfile with ora<sapsid> user

vi /oracle/QLS/112_64/dbs/initQLS.ora

Change above parameter as per your requirement.

3. In SQL plus shutdown database.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

4. Start database using Pfile.

SQL> startup pfile='/oracle/QLS/112_64/dbs/initQLS.ora';

ORA-32006: REMOTE_OS_AUTHENT initialization parameter has been deprecated

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size 2188952 bytes

Variable Size 2348812648 bytes

Database Buffers 2315255808 bytes

Redo Buffers 10530816 bytes

Database mounted.

Database opened.

5. Create SPfile from Pfile.

SQL> create spfile from pfile;

File created.

SQL>

6. Shutdown database.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

7. Start database with SPFILE.

SQL> startup;

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance

ORACLE instance started.

Total System Global Area 4676788224 bytes

Fixed Size 2188952 bytes

Variable Size 2348812648 bytes

Database Buffers 2315255808 bytes

Redo Buffers 10530816 bytes

Database mounted.

Database opened.

SQL>

Wednesday, January 08, 2014

How to import transport request of other system into SAP system

Having multiple transport requested exported from other system in compress file.

1. Login with <SAPSID>adm user create folder /tmp/transportrequest
2. Copy all extracted file into /tmp/transportrequest folder
3. move data files into data directory of transport
    cd /tmp/transportrequest
    mv R* /usr/sap/trans/data
4. move data files into data directory of transport
    cd /tmp/transportrequest
    mv K* /usr/sap/trans/cofiles
5. Login into SAP system
6. call transaction stms_import
7. follow below steps for all request
    choose extras -> Other Requests -> Add
Enter transport request number i.e. D11K901027
choose right arrow
8. To import request choose request and choose import request and your client on which would like to import.

Wednesday, November 20, 2013

Drop datafile of temp tablespace

ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata3/temp_5/temp.data5';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_6/temp.data6';
ALTER TABLESPACE PSAPTEMP DROP TEMPFILE '/oracle/PIP/sapdata6/temp_7/temp.data7';

cd /oracle/PIP/sapdata3/
rmdir temp_5

cd /oracle/PIP/sapdata6/
rmdir temp_6

cd /oracle/PIP/sapdata6/
rmdir temp_7

Tuesday, November 19, 2013

Switching oracle database archive to non archive mode and vice versa.

switching off archive mode.

    shutdown immediate;
    startup mount;
    alter database noarchivelog;
    alter database open;

switching on archive mode.

    shutdown immediate;
    startup mount;
    alter database archivelog;
    alter database open;

Tuesday, May 14, 2013

Mount windows share into HP-UX

Create mount point
mkdir winshare

Mount H drive of windows server 10.32.0.164 where nikunj is local user of that server and having rights on shared drive H

# cifsmount //10.32.0.164/h /winshare -U nikunj -P testing
The CIFS Client is not running.
#

Start CIFS Client

# cifsclient
CIFS Client started; process id: 14102

Mount H drive of windows server 10.32.0.164
# cifsmount //10.32.0.164/h /winshare -U nikunj -P testing
LOC: Netbios session refused
LOC: Netbios session refused

To resolve LOC: Netbios session refused error do the entry into /etc/hosts
10.32.0.164     BACKUPSRV.domain.com

Mount H drive of windows server 10.32.0.164
# cifsmount //BACKUPSRV.domain.com/h /winshare -U nikunj -P testing

Check file system mounted
# bdf
Filesystem          kbytes    used   avail %used Mounted on
backupsrv.domain.com:/h
                   2711840 2711840       0 100% /winshare
#

Unmount mounted windows shared
cifsumount /winshare

Stop CIFS Client
# cifsclient stop
No CIFS filesystems to unmount.
The CIFS Client has been shut down.
#

Thursday, December 27, 2012

R3trans -d failed when oracle archiver get stuck

archiver location is full.
# bdf
Filesystem             kbytes    used            avail %used Mounted on
/dev/vg00/lvol12   20971520 20947873   22276 100% /oracle/PIP/oraarch

test R3trans -d which failed with return code 0012.
tstmig:pipadm 42> R3trans -d
This is R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).
unicode enabled version
2EETW169 no connect possible: "DBMS = ORACLE                           --- dbs_o                                                                                        ra_tnsname = 'PIP'"
R3trans finished (0012).

archiver location free
tstmig:pipadm 43> bdf
Filesystem          kbytes    used   avail %used Mounted on
/dev/vg00/lvol12   20971520 1151649 18581263    6% /oracle/PIP/oraarch

test R3trans -d which success with return code 0000.
tstmig:pipadm 44> R3trans -d
This is R3trans version 6.14 (release 700 - 19.01.11 - 11:44:00).
unicode enabled version
R3trans finished (0000).
tstmig:pipadm 45>

Welcome to Nikunj's Blog

Thursday, May 08, 2014

brrestore backup restoration options

To restore only Online redo log and control files.

To restore selecting data file, online redo log and control files.

To restore only data file.

Restore full backup including data, online log and control file

Examples of BRRESTORE Runs

Friday, April 11, 2014

Opatch apply come across file in use

Monday, March 24, 2014

ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [], [], [], [], [], [], [], [], []

Tuesday, February 11, 2014

move tables to different tablespace using Brtools i.e. TTREE tables during EHP update

Thursday, January 30, 2014

Change oracle parameter for process and sessions

Wednesday, January 08, 2014

How to import transport request of other system into SAP system

Wednesday, November 20, 2013

Drop datafile of temp tablespace

Tuesday, November 19, 2013

Switching oracle database archive to non archive mode and vice versa.

Tuesday, May 14, 2013

Mount windows share into HP-UX

Thursday, December 27, 2012

R3trans -d failed when oracle archiver get stuck

About Me

Blog Archive