Find in this Blog

Thursday, March 22, 2018

ORA-27046: file size is not a multiple of logical block siz

Detail log:                    beybzphm.anf
BR0051I BRBACKUP 7.20 (42)
BR0055I Start of database backup: beybzphm.anf 2018-03-22 16.47.18
BR0484I BRBACKUP log file: C:\oracle\SOL\sapbackup\beybzphm.anf
BR0280I BRBACKUP time stamp: 2018-03-22 16.47.18
BR0301E SQL error -1565 at location BrInitOraCreate-5, SQL statement:
'/* BRBACKUP AT PROF_CONN */ CREATE PFILE = 'C:\oracle\SOL\11203\database\sapSOL.ora' FROM SPFILE = 'C:\oracle\SOL\11203\database\spfileSOL.ora''
ORA-01565: error in identifying file 'C:\oracle\SOL\11203\database\spfileSOL.ora'
ORA-27046: file size is not a multiple of logical block size
OSD-04012: file size mismatch (OS 5678)
BR0303E Determination of Oracle version failed
BR0056I End of database backup: beybzphm.anf 2018-03-22 16.47.18
BR0280I BRBACKUP time stamp: 2018-03-22 16.47.18
BR0054I BRBACKUP terminated with errors
BR0280I BRBACKUP time stamp: 2018-03-22 16.47.18
BR0291I BRARCHIVE will be started with options '+beybzphm.anf -U  -sd -d util_file -r C:\oracle\SOL\11203\database\tmp_6328.utl -p C:\oracle\SOL\11203\database\initSOL.sap -c for
BR0280I BRBACKUP time stamp: 2018-03-22 16.47.19
BR0292E Execution of BRARCHIVE finished with return code 3



Solution:


SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> create spfile from pfile;

File created.
SQL> startup
ORACLE instance started.

Total System Global Area 1369653248 bytes
Fixed Size                  2255024 bytes
Variable Size             687867728 bytes
Database Buffers          654311424 bytes
Redo Buffers               25219072 bytes
Database mounted.
Database opened.
SQL>

No comments:

Post a Comment

Ask Your Questions ?#