Solved: While running Control.sql error ORA-27091: unable ...

Hello Friends,

We are doing system copy as backup restore, restore is completed 100% and when i am running @Control.sql i am getting below error.

SQL> @Control.sql

ORA-27091: unable to queue I/O

ORA-27070: async read/write failed

OSD-04006: ReadFile() failure, unable to read from file

O/S-Error: (OS 38) Reached the end of the file.

CREATE CONTROLFILE SET DATABASE "SID" RESETLOGS NOARCHIVELOG

Some background info

this is online Backup belongs to quality system which i am restoring on test server

when i took backup fo quality using brtools backup completed successfully 100% and i can see all the datafile on my backup location (local drive) except

G:\oracle\SID\sapdata3\SR3701.DATA1 like this there are 14 datafiles which were not backed up or i cannot find that in my backup folder

But backup completed successfully 100% then why these files are not copied??

i can see other files M:\oracle\FNQ\sapdata3\SR3701X.DATA1 but cannot find G:\oracle\SID\sapdata3\SR3701.DATA1.

Kindly help me to solve this issue.

Thanks

Tabrayz

SAP Managed Tags:
Oracle Database

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

*.control_files='D:\oracle\FNQ\origlogA\cntrl\cntrlFNQ.dbf','D:\oracle\FNQ\origlogB\cntrl\cntrlFNQ.dbf','D:\oracle\FNQ\sapdata1\cntrl\cntrlFNQ.dbf'

Do you have these files present at the OS level ?

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Restart the server

Start Oracle database

Start sapinst and continue with the installation.

Regards

Hi Benjamin,

I restarted the server and database but sapints gives same errror.

one more thing when i start db by command startup its giving error but when i use below command db is up.

startup pfile=D:\oracle\FNQ\102\database\INITFNQ.ORA

Thanks

Tabrayz

Hi Benjamin,

Problem is solved after creating spfile from pfile

SQL> create spfile from pfile='D:\oracle\FNQ\102\database\initFNQ.ora';

now DB is up and sapint moved ahead.

Thanks for your support.

Thanks

Tabrayz

Answers (3)

Hi,

Seems you are not using same source and target FS structure, It seems creating confusion.

Regards,

Nick Loy

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Loy,

Yes directory structure on target system is diffrent than source and i have edited the location in backup log file hence restore happned successfully but while running controle.sql i am facing issue.

Thanks

Tabrayz

Hello

Provide the control.sql file and the ORA- error from the alert log when you execute this script.

Regards

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi,

Please find below control.sql and alert log

control.sql

STARTUP NOMOUNT

CREATE CONTROLFILE SET DATABASE "FNQ" RESETLOGS NOARCHIVELOG

MAXLOGFILES 255

MAXLOGMEMBERS 3

MAXDATAFILES 254

MAXINSTANCES 50

MAXLOGHISTORY 11680

LOGFILE

GROUP 1 (

'D:\ORACLE\FNQ\ORIGLOGA\LOG_G11M1.DBF',

'D:\ORACLE\FNQ\MIRRLOGA\LOG_G11M2.DBF'

) SIZE 50M,

GROUP 2 (

'D:\ORACLE\FNQ\ORIGLOGB\LOG_G12M1.DBF',

'D:\ORACLE\FNQ\MIRRLOGB\LOG_G12M2.DBF'

) SIZE 50M,

GROUP 3 (

'D:\ORACLE\FNQ\ORIGLOGA\LOG_G13M1.DBF',

'D:\ORACLE\FNQ\MIRRLOGA\LOG_G13M2.DBF'

) SIZE 50M,

GROUP 4 (

'D:\ORACLE\FNQ\ORIGLOGB\LOG_G14M1.DBF',

'D:\ORACLE\FNQ\MIRRLOGB\LOG_G14M2.DBF'

) SIZE 50M

-- STANDBY LOGFILE

DATAFILE

'D:\ORACLE\FNQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1',

'D:\ORACLE\FNQ\SAPDATA1\UNDO_1\UNDO.DATA1',

'D:\ORACLE\FNQ\SAPDATA1\SYSAUX_1\SYSAUX.DATA1',

'D:\ORACLE\FNQ\SAPDATA2\SR3_1\SR3.DATA1',

'D:\ORACLE\FNQ\SAPDATA2\SR3_2\SR3.DATA2',

'D:\ORACLE\FNQ\SAPDATA2\SR3_3\SR3.DATA3',

'D:\ORACLE\FNQ\SAPDATA2\SR3_4\SR3.DATA4',

'D:\ORACLE\FNQ\SAPDATA2\SR3_5\SR3.DATA5',

'D:\ORACLE\FNQ\SAPDATA2\SR3_6\SR3.DATA6',

'D:\ORACLE\FNQ\SAPDATA2\SR3_7\SR3.DATA7',

'D:\ORACLE\FNQ\SAPDATA2\SR3_8\SR3.DATA8',

'D:\ORACLE\FNQ\SAPDATA2\SR3_9\SR3.DATA9',

'D:\ORACLE\FNQ\SAPDATA2\SR3_10\SR3.DATA10',

'D:\ORACLE\FNQ\SAPDATA2\SR3_11\SR3.DATA11',

'D:\ORACLE\FNQ\SAPDATA2\SR3_12\SR3.DATA12',

'D:\ORACLE\FNQ\SAPDATA2\SR3_13\SR3.DATA13',

'D:\ORACLE\FNQ\SAPDATA2\SR3_14\SR3.DATA14',

'D:\ORACLE\FNQ\SAPDATA2\SR3_15\SR3.DATA15',

'D:\ORACLE\FNQ\SAPDATA2\SR3_16\SR3.DATA16',

'D:\ORACLE\FNQ\SAPDATA2\SR3_17\SR3.DATA17',

'D:\ORACLE\FNQ\SAPDATA2\SR3_18\SR3.DATA18',

'D:\ORACLE\FNQ\SAPDATA2\SR3_19\SR3.DATA19',

'D:\ORACLE\FNQ\SAPDATA2\SR3_20\SR3.DATA20',

'D:\ORACLE\FNQ\SAPDATA2\SR3_21\SR3.DATA21',

'D:\ORACLE\FNQ\SAPDATA2\SR3_22\SR3.DATA22',

'D:\ORACLE\FNQ\SAPDATA2\SR3_23\SR3.DATA23',

'D:\ORACLE\FNQ\SAPDATA2\SR3_24\SR3.DATA24',

'D:\ORACLE\FNQ\SAPDATA2\SR3_25\SR3.DATA25',

'D:\ORACLE\FNQ\SAPDATA2\SR3_26\SR3.DATA26',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_1\SR3701X.DATA1',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_2\SR3701X.DATA2',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_3\SR3701X.DATA3',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_4\SR3701X.DATA4',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_5\SR3701X.DATA5',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_6\SR3701X.DATA6',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_7\SR3701X.DATA7',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_8\SR3701X.DATA8',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_9\SR3701X.DATA9',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_10\SR3701X.DATA10',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_11\SR3701X.DATA11',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_12\SR3701X.DATA12',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_13\SR3701X.DATA13',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_14\SR3701X.DATA14',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_15\SR3701X.DATA15',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_16\SR3701X.DATA16',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_17\SR3701X.DATA17',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_18\SR3701X.DATA18',

'D:\ORACLE\FNQ\SAPDATA3\SR3701X_19\SR3701X.DATA19',

'D:\ORACLE\FNQ\SAPDATA4\SR3USR_1\SR3USR.DATA1'

CHARACTER SET UTF8

;

Alert log

ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes                = 80
sessions                 = 160
sga_max_size             = 1358954496
shared_pool_size         = 654311424
shared_pool_reserved_size= 64141393
filesystemio_options     = NONE
control_file_record_keep_time= 30
db_block_size            = 8192
db_cache_size            = 654311424
compatible               = 10.2.0
log_archive_dest         = D:\oracle\FNQ\oraarch\FNQarch
log_buffer               = 14262272
log_checkpoint_interval = 0
db_files                 = 254
log_checkpoints_to_alert = TRUE
dml_locks                = 4000
replication_dependency_tracking= FALSE
undo_management          = AUTO
undo_tablespace          = PSAPUNDO
_in_memory_undo          = FALSE
undo_retention           = 43200
recyclebin               = off
remote_os_authent        = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes      = 1
parallel_execution_message_size= 16384
_table_lookup_prefetch_size= 0
background_dump_dest     = D:\ORACLE\FNQ\SAPTRACE\BACKGROUND
user_dump_dest           = D:\ORACLE\FNQ\SAPTRACE\USERTRACE
core_dump_dest           = D:\ORACLE\FNQ\SAPTRACE\BACKGROUND
sort_area_size           = 2097152
sort_area_retained_size = 0
db_name                  = FNQ
open_cursors             = 800
_sort_elimination_cost_ratio= 10
_b_tree_bitmap_plans     = FALSE
star_transformation_enabled= true
query_rewrite_enabled    = false
_index_join_enabled      = FALSE
_optim_peek_user_binds   = FALSE
pga_aggregate_target     = 629145600
_optimizer_mjc_enabled   = FALSE
PMON started with pid=2, OS id=6372
PSP0 started with pid=3, OS id=6240
MMAN started with pid=4, OS id=6460
DBW0 started with pid=5, OS id=4308
LGWR started with pid=6, OS id=5972
CKPT started with pid=7, OS id=7948
SMON started with pid=8, OS id=1568
RECO started with pid=9, OS id=4872
CJQ0 started with pid=10, OS id=7480
MMON started with pid=11, OS id=7776
MMNL started with pid=12, OS id=6712
Mon Jan 20 12:18:47 2014
ALTER DATABASE   MOUNT
Mon Jan 20 12:18:47 2014
ORA-00202: control file: 'D:\ORACLE\FNQ\102\DATABASE\CTL1FNQ.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Mon Jan 20 12:18:47 2014
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Mon Jan 20 12:22:56 2014
Shutting down instance: further logons disabled
Mon Jan 20 12:22:56 2014
Stopping background process MMNL
Mon Jan 20 12:22:57 2014
Stopping background process CJQ0
Mon Jan 20 12:22:57 2014
Background process MMNL not dead after 10 seconds
Mon Jan 20 12:22:57 2014
Stopping background process MMON
Mon Jan 20 12:22:59 2014
Background process MMON not dead after 30 seconds
Mon Jan 20 12:22:59 2014
Shutting down instance (immediate)
License high water mark = 1
Mon Jan 20 12:22:59 2014
Stopping Job queue slave processes, flags = 7
Mon Jan 20 12:22:59 2014
Job queue slave processes stopped
Mon Jan 20 12:22:59 2014
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Jan 20 12:23:36 2014
Adjusting the default value of parameter parallel_max_servers
from 80 to 65 due to the value of parameter processes (80)
Mon Jan 20 12:23:36 2014
Starting ORACLE instance (normal)
Mon Jan 20 12:23:36 2014
Specified value of sga_max_size is too small, bumping to 1358954496
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes                = 80
sessions                 = 160
sga_max_size             = 1358954496
shared_pool_size         = 654311424
shared_pool_reserved_size= 64141393
filesystemio_options     = NONE
control_file_record_keep_time= 30
db_block_size            = 8192
db_cache_size            = 654311424
compatible               = 10.2.0
log_archive_dest         = D:\oracle\FNQ\oraarch\FNQarch
log_buffer               = 14262272
log_checkpoint_interval = 0
db_files                 = 254
log_checkpoints_to_alert = TRUE
dml_locks                = 4000
replication_dependency_tracking= FALSE
undo_management          = AUTO
undo_tablespace          = PSAPUNDO
_in_memory_undo          = FALSE
undo_retention           = 43200
recyclebin               = off
remote_os_authent        = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes      = 1
parallel_execution_message_size= 16384
_table_lookup_prefetch_size= 0
background_dump_dest     = D:\ORACLE\FNQ\SAPTRACE\BACKGROUND
user_dump_dest           = D:\ORACLE\FNQ\SAPTRACE\USERTRACE
core_dump_dest           = D:\ORACLE\FNQ\SAPTRACE\BACKGROUND
sort_area_size           = 2097152
sort_area_retained_size = 0
db_name                  = FNQ
open_cursors             = 800
_sort_elimination_cost_ratio= 10
_b_tree_bitmap_plans     = FALSE
star_transformation_enabled= true
query_rewrite_enabled    = false
_index_join_enabled      = FALSE
_optim_peek_user_binds   = FALSE
pga_aggregate_target     = 629145600
_optimizer_mjc_enabled   = FALSE
PMON started with pid=2, OS id=7688
PSP0 started with pid=3, OS id=4856
MMAN started with pid=4, OS id=908
DBW0 started with pid=5, OS id=6852
LGWR started with pid=6, OS id=6700
CKPT started with pid=7, OS id=412
SMON started with pid=8, OS id=3492
RECO started with pid=9, OS id=7636
CJQ0 started with pid=10, OS id=4860
MMON started with pid=11, OS id=5132
MMNL started with pid=12, OS id=3960
Mon Jan 20 12:23:38 2014
ALTER DATABASE   MOUNT
Mon Jan 20 12:23:38 2014
ORA-00202: control file: 'D:\ORACLE\FNQ\102\DATABASE\CTL1FNQ.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Mon Jan 20 12:23:38 2014
ORA-205 signalled during: ALTER DATABASE   MOUNT...
Mon Jan 20 12:29:41 2014
Shutting down instance: further logons disabled
Mon Jan 20 12:29:41 2014
Stopping background process MMNL
Mon Jan 20 12:29:42 2014
Stopping background process CJQ0
Mon Jan 20 12:29:42 2014
Background process MMNL not dead after 10 seconds
Mon Jan 20 12:29:42 2014
Stopping background process MMON
Mon Jan 20 12:29:43 2014
Background process MMON not dead after 30 seconds
Mon Jan 20 12:29:43 2014
Shutting down instance (immediate)
License high water mark = 1
Mon Jan 20 12:29:43 2014
Stopping Job queue slave processes, flags = 7
Mon Jan 20 12:29:43 2014
Job queue slave processes stopped
Mon Jan 20 12:29:43 2014
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon Jan 20 12:32:03 2014
Adjusting the default value of parameter parallel_max_servers
from 80 to 65 due to the value of parameter processes (80)
Mon Jan 20 12:32:03 2014
Starting ORACLE instance (normal)
Mon Jan 20 12:32:03 2014
Specified value of sga_max_size is too small, bumping to 1358954496
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 3
Autotune of undo retention is turned on.
LICENSE_MAX_USERS = 0
SYS auditing is disabled
ksdpec: called for event 13740 prior to event group initialization
Starting up ORACLE RDBMS Version: 10.2.0.4.0.
System parameters with non-default values:
processes                = 80
sessions                 = 160
sga_max_size             = 1358954496
shared_pool_size         = 654311424
shared_pool_reserved_size= 64141393
filesystemio_options     = NONE
control_file_record_keep_time= 30
db_block_size            = 8192
db_cache_size            = 654311424
compatible               = 10.2.0
log_archive_dest         = D:\oracle\FNQ\oraarch\FNQarch
log_buffer               = 14262272
log_checkpoint_interval = 0
db_files                 = 254
log_checkpoints_to_alert = TRUE
dml_locks                = 4000
replication_dependency_tracking= FALSE
undo_management          = AUTO
undo_tablespace          = PSAPUNDO
_in_memory_undo          = FALSE
undo_retention           = 43200
recyclebin               = off
remote_os_authent        = TRUE
remote_login_passwordfile= EXCLUSIVE
job_queue_processes      = 1
parallel_execution_message_size= 16384
_table_lookup_prefetch_size= 0
background_dump_dest     = D:\ORACLE\FNQ\SAPTRACE\BACKGROUND
user_dump_dest           = D:\ORACLE\FNQ\SAPTRACE\USERTRACE
core_dump_dest           = D:\ORACLE\FNQ\SAPTRACE\BACKGROUND
sort_area_size           = 2097152
sort_area_retained_size = 0
db_name                  = FNQ
open_cursors             = 800
_sort_elimination_cost_ratio= 10
_b_tree_bitmap_plans     = FALSE
star_transformation_enabled= true
query_rewrite_enabled    = false
_index_join_enabled      = FALSE
_optim_peek_user_binds   = FALSE
pga_aggregate_target     = 629145600
_optimizer_mjc_enabled   = FALSE
PMON started with pid=2, OS id=5532
PSP0 started with pid=3, OS id=4216
MMAN started with pid=4, OS id=7540
DBW0 started with pid=5, OS id=5672
LGWR started with pid=6, OS id=1212
CKPT started with pid=7, OS id=3736
SMON started with pid=8, OS id=5252
RECO started with pid=9, OS id=1932
CJQ0 started with pid=10, OS id=7388
MMON started with pid=11, OS id=5888
MMNL started with pid=12, OS id=6028
Mon Jan 20 12:32:04 2014
ALTER DATABASE   MOUNT
Mon Jan 20 12:32:04 2014
ORA-00202: control file: 'D:\ORACLE\FNQ\102\DATABASE\CTL1FNQ.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Mon Jan 20 12:32:04 2014
ORA-205 signalled during: ALTER DATABASE MOUNT...
Mon Jan 20 12:40:19 2014
Shutting down instance: further logons disabled
Mon Jan 20 12:40:19 2014
Stopping background process MMNL
Mon Jan 20 12:40:20 2014
Stopping background process CJQ0
Mon Jan 20 12:40:20 2014
Background process MMNL not dead after 10 seconds
Mon Jan 20 12:40:20 2014
Stopping background process MMON
Mon Jan 20 12:40:21 2014
Background process MMON not dead after 30 seconds
Mon Jan 20 12:40:21 2014
Shutting down instance (immediate)
License high water mark = 1
Mon Jan 20 12:40:21 2014
Stopping Job queue slave processes, flags = 7
Mon Jan 20 12:40:21 2014
Job queue slave processes stopped
Mon Jan 20 12:40:21 2014
ALTER DATABASE CLOSE NORMAL
ORA-1507 signalled during: ALTER DATABASE CLOSE NORMAL...
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archival disabled due to shutdown: 1089
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active


ORA-00202: control file: 'D:\ORACLE\FNQ\102\DATABASE\CTL1FNQ.ORA'
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 2) The system cannot find the file specified.

Is there a file like this ?

What is the value for the parameter CONTROL_FILES ?

Regards

as per the log provide, no issues with backup. but see below error in alert log file.

ORA-00202: control file: 'D:\ORACLE\FNQ\102\DATABASE\CTL1FNQ.ORA'

ORA-27041: unable to open file

OSD-04002: unable to open file

File is not available at this location becasue i am building a fresh system with quality backup

i have CTL1FNQ.ORA file in my backup which i manully copy pasted but no success.

Thanks

Tabrayz

Hi Benjamin

control_files paramter in initsid.ora is commented as below

#control_files = @SAPDATA1@/cntrl/cntrlFNQ.dbf @SAPDATA2@/cntrl/cntrlFNQ.dbf @SAPDATA3@/cntrl/cntrlFNQ.dbf

Thanks

Tabrayz

Hello

To put the database into mount state you need the control files to be present at the OS level and the database should be able to access it.

Check pfile/spfile for the value of the parameter CONTROL_FILES ?

Regards

Hi Benjamin,

Control_files parameter is avaible in initsid.ora as i mention earlier

i am trying to build a test system with qas backup hence i run sapints and then system copy with back restore method and sapint is stoped and ask to restore hence i did restore using brrestore and restore was 100% then we run control.sql to start db and then do recovery and then open database and control file automaticaly comes in the required location pls correct me if i am missing anything

but when i am running control.sql to start db its giving error

Thanks

Tabrayz

Hi sunil,

As you mention backup is fine then why those files(G:\oracle\FNQ\sapdata3\sr3701_1\SR3701.DATA1) are not copied even though these files are present os leve any idea??

Thanks

Tabrayz

Hello Tabrayz


control_files paramter in initsid.ora is commented  as below
#control_files = @SAPDATA1@/cntrl/cntrlFNQ.dbf @SAPDATA2@/cntrl/cntrlFNQ.dbf @SAPDATA3@/cntrl/cntrlFNQ.dbf

The script you are executing is creating the control file.

But I see that the parameter is disabled.

Once the control files are created then the database will be mount state.

The backup log says this location for the control file.

H:\oracle\FNQ\origlogA\cntrl\cntrlFNQ.dbf

H:\oracle\FNQ\origlogB\cntrl\cntrlFNQ.dbf

J:\oracle\FNQ\sapdata1\cntrl\cntrlFNQ.dbf

Create a pfile from spfile and modify the control_files parameter with the correct location and execute the script.

Regards

i have edited the backuplog as per target location.

but unable to create pfile form spfile

SQL> create pfile from spfile='D:\oracle\FNQ\102\database\SPFILEFNQ.ORA';

create pfile from spfile='D:\oracle\FNQ\102\database\SPFILEFNQ.ORA'

ERROR at line 1:

ORA-27091: unable to queue I/O

ORA-27070: async read/write failed

OSD-04006: ReadFile() failure, unable to read from file

O/S-Error: (OS 38) Reached the end of the file.

Thanks

Tabrayz

You shouldn't edit the backup log.

You need to modify the control_files parameter in the pfile with the correct location and start the database with the pfile in nomount status and execute the control.sql script.

Provide me the pfile please

Regards

i mean i have edited the backup log at the time of restore as per target directory structure.

i have also added

*.control_files='D:\oracle\FNQ\origlogA\cntrl\cntrlFNQ.dbf','D:\oracle\FNQ\origlogB\cntrl\cntrlFNQ.dbf','D:\oracle\FNQ\sapdata1\cntrl\cntrlFNQ.dbf' in initsid.ora but same issue.

Thanks

tabrayz

and did you start the database with the pfile ?

startup nomount pfile=D:\oracle\FNQ\102\database\INITFNQ.ORA

Regards

Hi Benjamin,

as you said db is started as below

SQL> startup nomount pfile=D:\oracle\FNQ\102\database\initfnq.ora
ORACLE instance started.

Total System Global Area 1358954496 bytes
Fixed Size                  2065600 bytes
Variable Size             687868736 bytes
Database Buffers          654311424 bytes
Redo Buffers               14708736 bytes
SQL>

Now what will be the next step.

Thanks

Tabrayz

@control.sql

Regards

i have excuted controle file created but error is same please see below.

SQL> @Control.sql
ORA-27091: unable to queue I/O
ORA-27070: async read/write failed
OSD-04006: ReadFile() failure, unable to read from file
O/S-Error: (OS 38) Reached the end of the file.

Control file created.

Thanks

Tabrayz

Is it possible to provide the pfile ?

Regards

please find below

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

# (c)Copyright SAP AG, Walldorf #

# @(#) $Id: //bc/701-1_REL/src/ins/SAPINST/impl/tpls/ora/ind/INITSIDBASE.ORA#1 $

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

# PART I, TUNING PARAMETERS #

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

#### SYSTEM GLOBAL AREA BUFFERS

# Total System Global Area = sum(bytes) of all caches

# Variable Size = shared_pool_size (approx.)

# Database Buffers = db_block_buffers * db_block_size

# Redo Buffers = log_buffer

# unit of shared_pool_size: bytes

# unit of db_block_buffers: number of cached blocks

# unit of log_buffer: bytes

shared_pool_size = 641413939

# 10% of shared_pool_size

shared_pool_reserved_size = 64141393

log_buffer = 1048576

#### MANAGING SORTS

# A small sort requires sort_area_retained_size in

# memory. Larger sorts are allocating segments in

# PSAPTEMP. They are using sort_area_size in memory.

sort_area_retained_size = 0

sort_area_size = 2097152

#sort_spacemap_size = 512

#### PGA-PARAMETERS

open_cursors = 800

#cursor_space_for_time = true

#### LOCKS

# dml_locks = processes * 50

dml_locks = 4000

#enqueue_resources = 8000

#### CPU-PARAMETERS

#spin_count = 200

#_cpu_count = 4

#### TUNING ARCHIVING

#log_archive_buffer_size 127

#log_archive_buffers 4

#### USE VECTOR READ

#use_readv = true

#### OTHER TUNING PARAMETERS

#sequence_cache_entries = 100

#sequence_cache_hash_buckets = 89

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

# PART II, CHANGEABLE PARAMETERS #

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

#### CONTROL-FILES

# the controlfiles should be mirrored to every new

# database mount point @SAPDATA_HOME@/sapdata<#>

#control_files = @SAPDATA1@/cntrl/cntrlFNQ.dbf @SAPDATA2@/cntrl/cntrlFNQ.dbf @SAPDATA3@/cntrl/cntrlFNQ.dbf

#### AUTOMATICLY STARTED BACKGROUND PROCESSES

#### MANAGING LOG SWITCHES

# checkpoints occur only when switching logs, if

# log_checkpoint_interval * size of OS blocks > size of

# the actual redo log

log_checkpoint_interval = 0

#log_checkpoint_timeout = 0

#### PROCESS-PARAMETERS

# The number of allocated semaphores is equal to the

# number of processes

# sessions = 1.2 * processes

processes = 80

sessions = 160

#### AUDITING AND STATISTICS

# sql_trace=TRUE

# audit_trail = true

# db_block_lru_extended_statistics = 1000

# db_block_lru_statistics = true

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

# PART III, STATIC PARAMETERS #

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

#### DB-NAME

db_name = FNQ

#### DB-BLOCKSIZE

db_block_size = 8192

#### DB-FILES

db_files = 254

#### OPTIMIZER MODE

#optimizer_mode = choose

#optimizer_search_limit = 3

#### PATHS / DESTINATIONS / TRACES

# D:\oracle\FNQ\saptrace\background: trace files of the background

# processes

# D:\oracle\FNQ\saptrace\usertrace: trace files of the user processes

# log_archive_dest is a destination, not a path.

# The archivefiles get the name

# C:\oracle\FNQ\oraarch\FNQarch<thread#>_<log#>

background_dump_dest = D:\oracle\FNQ\saptrace\background

user_dump_dest = D:\oracle\FNQ\saptrace\usertrace

core_dump_dest = D:\oracle\FNQ\saptrace\background

log_archive_dest = D:\oracle\FNQ\oraarch\FNQarch

#log_archive_format = %t_%s

#### OTHER

# reduce_alarm only supported on HP

#reduce_alarm = TRUE

#### ORACLE OPS PARAMETER

remote_os_authent = true

# retention time for RMAN backup information in control file

*.control_files='D:\oracle\FNQ\origlogA\cntrl\cntrlFNQ.dbf','D:\oracle\FNQ\origlogB\cntrl\cntrlFNQ.dbf','D:\oracle\FNQ\sapdata1\cntrl\cntrlFNQ.dbf'

control_file_record_keep_time = 30

#see SAP note 124361

#db_file_multiblock_read_count = 8

log_checkpoints_to_alert = true

#### OPTIMIZER MODE

#optimizer_index_cost_adj = 10

#### AUDITING AND STATISTICS

#timed_statistics = true

compatible = 10.2.0

parallel_execution_message_size = 16384

query_rewrite_enabled = false

replication_dependency_tracking = false

star_transformation_enabled = true

undo_retention = 43200

undo_tablespace = PSAPUNDO

undo_management = AUTO

pga_aggregate_target = 629145600

sga_max_size = 1282827878

db_cache_size = 641413939

job_queue_processes = 1

remote_login_passwordfile = exclusive

recyclebin = off

event = "10191 trace name context forever, level 1"

FILESYSTEMIO_OPTIONS = setall

_OPTIM_PEEK_USER_BINDS = FALSE

_B_TREE_BITMAP_PLANS = FALSE

_INDEX_JOIN_ENABLED = FALSE

_IN_MEMORY_UNDO = FALSE

_OPTIMIZER_MJC_ENABLED = FALSE

_SORT_ELIMINATION_COST_RATIO = 10

_TABLE_LOOKUP_PREFETCH_SIZE = 0

well after running control.sql file got created but as error was there

then i tried to open the db it asked me for recovery then i did reocvery by

recover database using backup controlfile until cancel;

then it asked for some archive file hence i provided the same and database open now!!

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'D:\ORACLE\FNQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1'

SQL> recover database using backup controlfile until cancel;
ORA-00279: change 186608596 generated at 01/16/2014 15:05:06 needed for thread
1
ORA-00289: suggestion : D:\ORACLE\FNQ\ORAARCH\FNQARCHARC11188_0779565053.001
ORA-00280: change 186608596 for thread 1 is in sequence #11188

SQL> Alter database open resetlogs;

Database altered.

SQL> select status from v$instance;

STATUS
------------
OPEN

but sapints give error as

n error occurred while processing option SAP ERP 6.0 EHP4 Ready - Support Release 1 > Software Life-Cycle Options > System Copy > Oracle > Target System Installation > Central System > Based on AS ABAP > Central System( Last error reported by the step :SQL statement or script failed. DIAGNOSIS: Error message: ORA-27091: unable to queue I/O ORA-27070: async read/write failed OSD-04006: ReadFile() failure, unable to read from file O/S-Error: (OS 38) Reached the end of the file. ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist ORA-27091: unable to queue I/O ORA-27070: async read/write failed OSD-04006: ReadFile() failure, unable to read from file O/S-Error: (OS 38) Reached the end of the file. ALTER DATABASE ARCHIVELOG * ERROR at line 1: ORA-01034: ORACLE not available ALTER DATABASE OPEN * ERROR at line 1: ORA-01034: ORACLE not available ORA-01034: ORACLE not available ORA-27101: shared memory realm does not exist Disconnected . SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.). You can now:

hm! can you please paste the online backup log? if the backup is 100% successful then all the file should be in the location you mentioned during the backup.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

backupSID.log

bejuqgye and 2012-11-04 13.21.48 2012-11-04 13.21.56 3 ............... 50 0 0 9012 94003999 0 0 ALL online disk -----c 7.20 (22) FNQ @Z:\FNQ_BKP

bejuqhgv and 2012-11-04 13.25.33 2012-11-04 13.25.54 2 ............... 50 0 0 9012 94003999 0 0 ALL online disk -----c 7.20 (22) FNQ @Z:\FNQ_BKP

bejuqhmk and 2012-11-04 13.27.58 2012-11-04 16.38.57 0 ............... 50 49 0 9012 94003999 9013 94034052 ALL online disk -----c 7.20 (22) FNQ @Z:\FNQ_BKP

bekjjipj and 2013-01-21 11.33.59 2013-01-21 14.45.41 0 ............... 50 49 0 9405 111160189 9407 111184604 ALL online disk -----c 7.20 (22) FNQ @Z:\FNQ_BKP

beklwkja and 2013-02-03 17.14.26 2013-02-03 20.25.36 0 ............... 50 49 0 9494 114109369 9496 114134711 ALL online disk -----c 7.20 (22) FNQ @Z:\FNQ_BKP

bemzltay afd 2014-01-16 15.03.40 2014-01-16 15.03.45 3 ............... 0 0 0 0 0 0 0 ............ ............... ................ ...... 7.20 (29)

bemzltcu and 2014-01-16 15.04.28 2014-01-16 18.16.34 9 ............... 50 49 0 11188 186595648 11191 186627937 ALL online disk -----c 7.20 (29) FNQ @Z:\FNQ_BKP

bemzltcu.and

BR0051I BRBACKUP 7.20 (29)
BR0055I Start of database backup: bemzltcu.and 2014-01-16 15.04.28
BR0484I BRBACKUP log file: J:\oracle\FNQ\sapbackup\bemzltcu.and
BR0477I Oracle pfile E:\oracle\FNQ\102\database\initFNQ.ora created from spfile E:\oracle\FNQ\102\database\spfileFNQ.ora

BR0280I BRBACKUP time stamp: 2014-01-16 15.04.36
BR0319I Control file copy created: J:\oracle\FNQ\sapbackup\CNTRLFNQ.DBF 24461312

BR0101I Parameters

Name Value

oracle_sid                     FNQ
oracle_home                    E:\oracle\FNQ\102
oracle_profile                 E:\oracle\FNQ\102\database\initFNQ.ora
sapdata_home                   J:\oracle\FNQ
sap_profile                    E:\oracle\FNQ\102\database\initFNQ.sap
backup_mode                    ALL
backup_type                    online
backup_dev_type                disk
backup_root_dir                Z:\FNQ_BKP
compress                       no
disk_copy_cmd                  copy
cpio_disk_flags                -pdcu
exec_parallel                  0
system_info                    fnqadm FNGQATEST Windows 6.0 Build 6001 Service Pack 1 AMD64
oracle_info                    FNQ 10.2.0.4.0 8192 11188 186595648 FNGQATEST UTF8 UTF8 4118183869 &FNQ
sap_info                       701 SAPSR3 0002LK0003FNQ0011Z08427006500015Maintenance_ORA
make_info                      NTAMD64 OCI_10201_SHARE Jan 16 2013
command_line                   E:\usr\sap\FNQ\SYS\exe\uc\NTAMD64\brbackup.exe -p initFNQ.sap -d disk -t online -m all -k no -e 0 -l E -U

BR0116I ARCHIVE LOG LIST before backup for database instance FNQ

Parameter Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            J:\oracle\FNQ\oraarch\FNQarch
Archive format                 ARC%S_%R.%T
Oldest online log sequence     11185
Next log sequence to archive   11188
Current log sequence           11188            SCN: 186595648
Database block size            8192             Thread: 1
Current system change number   186608543        ResetId: 779565053

BR0118I Tablespaces and data files

Tablespace TS-Status F-Status File Size Id. Device Link Type MaxSize IncrSize BlkSize CrtSize CrtScn

PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_15\SR3.DATA15             9521078272   18           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163606
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_23\SR3.DATA23             8619302912   26           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163848
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_13\SR3.DATA13             7927242752   16           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163535
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_12\SR3.DATA12             7990157312   15           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163504
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_11\SR3.DATA11             7927242752   14           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163474
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_10\SR3.DATA10             7927242752   13           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163443
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_9\SR3.DATA9               8032100352   12           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163413
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_8\SR3.DATA8               8115986432   11           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163382
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_7\SR3.DATA7               8283758592   10           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163352
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_6\SR3.DATA6               8178900992    9           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163323
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_5\SR3.DATA5               8325701632    8           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163294
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_4\SR3.DATA4               8367644672    7           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163265
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_3\SR3.DATA3               8304730112    6           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163235
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_2\SR3.DATA2               8409587712    5           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163205
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_1\SR3.DATA1               8870961152    4           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163175
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_26\SR3.DATA26             8095014912   29           5 NOLINK FILE   10485760000     20971520     8192   1698693120         163937
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_25\SR3.DATA25             8388616192   28           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163908
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_24\SR3.DATA24             8451530752   27           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163878
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_16\SR3.DATA16             8703188992   19           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163635
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_17\SR3.DATA17             8346673152   20           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163666
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_18\SR3.DATA18            10255081472   21           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163697
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_19\SR3.DATA19            10213138432   22           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163728
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_20\SR3.DATA20             8975818752   23           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163758
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_21\SR3.DATA21             8766103552   24           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163787
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_22\SR3.DATA22             8808046592   25           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163818
PSAPSR3        ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA2\SR3_14\SR3.DATA14            10338967552   17           5 NOLINK FILE   10485760000     20971520     8192   2097152000         163576
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_15\SR3701X.DATA15     4110426112   44          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164640
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_14\SR3701X.DATA14     4278198272   43          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164598
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_13\SR3701X.DATA13     4592771072   42          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164548
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_12\SR3701X.DATA12     4341112832   41          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164501
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_11\SR3701X.DATA11     5893005312   40          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164452
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_10\SR3701X.DATA10     4781514752   39          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164401
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_9\SR3701X.DATA9      10066337792   38          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164351
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_8\SR3701X.DATA8       4424998912   37          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164183
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_7\SR3701X.DATA7       4341112832   36          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164153
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_6\SR3701X.DATA6       4445970432   35          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164124
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_5\SR3701X.DATA5       4466941952   34          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164094
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_4\SR3701X.DATA4       4949286912   33          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164065
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_3\SR3701X.DATA3       5096087552   32          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164035
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_2\SR3701X.DATA2       5138030592   31          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164004
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_1\SR3701X.DATA1       4928315392   30          12 NOLINK FILE   10485760000     20971520     8192   2097152000         163973
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_17\SR3701X.DATA17     4173340672   46          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164718
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_16\SR3701X.DATA16     4068483072   45          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164680
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_19\SR3701X.DATA19     3407880192   48          12 NOLINK FILE   10485760000     20971520     8192    576716800         164787
PSAPSR3701X    ONLINE*    ONLINE+   M:\ORACLE\FNQ\SAPDATA3\SR3701X_18\SR3701X.DATA18     4299169792   47          12 NOLINK FILE   10485760000     20971520     8192   2097152000         164754
PSAPSR3USR     ONLINE*    ONLINE+   G:\ORACLE\FNQ\SAPDATA4\SR3USR_1\SR3USR.DATA1           31465472   49           6 NOLINK FILE   10485760000     20971520     8192     31457280         164818
PSAPTEMP       ONLINE#    ONLINE+   F:\ORACLE\FNQ\SAPDATA1\TEMP_1\TEMP.DATA1             3617595392   -1           5 NOLINK FILE   10485760000     20971520     8192   1835008000           7382
PSAPUNDO       ONLINE-    ONLINE+   F:\ORACLE\FNQ\SAPDATA1\UNDO_1\UNDO.DATA1             8829018112    2           5 NOLINK FILE   10485760000     20971520     8192    734003200           6524
SYSAUX         ONLINE*    ONLINE+   F:\ORACLE\FNQ\SAPDATA1\SYSAUX_1\SYSAUX.DATA1          272637952    3           5 NOLINK FILE   10485760000     20971520     8192    209715200           6693
SYSTEM         ONLINE*    SYSTEM+   F:\ORACLE\FNQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1          954212352    1           5 NOLINK FILE   10485760000     20971520     8192    367001600              5

BR0119I Redolog files

File Size Group Device Status Link Type

I:\ORACLE\FNQ\MIRRLOGA\LOG_G11M2.DBF                 52429312    1            8 INUSE     NOLINK FILE
H:\ORACLE\FNQ\ORIGLOGA\LOG_G11M1.DBF                 52429312    1            7 INUSE     NOLINK FILE
I:\ORACLE\FNQ\MIRRLOGB\LOG_G12M2.DBF                 52429312    2            8 INUSE     NOLINK FILE
H:\ORACLE\FNQ\ORIGLOGB\LOG_G12M1.DBF                 52429312    2            7 INUSE     NOLINK FILE
I:\ORACLE\FNQ\MIRRLOGA\LOG_G13M2.DBF                 52429312    3            8 INUSE     NOLINK FILE
H:\ORACLE\FNQ\ORIGLOGA\LOG_G13M1.DBF                 52429312    3            7 INUSE     NOLINK FILE
I:\ORACLE\FNQ\MIRRLOGB\LOG_G14M2.DBF                 52429312    4            8 INUSE     NOLINK FILE
H:\ORACLE\FNQ\ORIGLOGB\LOG_G14M1.DBF                 52429312    4            7 INUSE     NOLINK FILE

BR0120I Control files

File Size Id. Device Link Type

H:\oracle\FNQ\origlogA\cntrl\cntrlFNQ.dbf            24461312    0            7 NOLINK FILE
H:\oracle\FNQ\origlogB\cntrl\cntrlFNQ.dbf            24461312    0            7 NOLINK FILE
J:\oracle\FNQ\sapdata1\cntrl\cntrlFNQ.dbf            24461312    0            9 NOLINK FILE

BR0280I BRBACKUP time stamp: 2014-01-16 15.04.36
BR0057I Backup of database: FNQ
BR0058I BRBACKUP action ID: bemzltcu
BR0059I BRBACKUP function ID: and
BR0110I Backup mode: ALL
BR0077I Database file for backup: J:\oracle\FNQ\sapbackup\CNTRLFNQ.DBF
BR0061I 50 files found for backup, total size 310953.711 MB
BR0143I Backup type: online
BR0112I Files will not be compressed
BR0130I Backup device type: disk
BR0106I Files will be saved on disk in directory: Z:\FNQ_BKP\bemzltcu

BR0280I BRBACKUP time stamp: 2014-01-16 15.04.36
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRBACKUP:
BR0280I BRBACKUP time stamp: 2014-01-16 15.05.04
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...

BR0370I Directory Z:\FNQ_BKP\bemzltcu created
BR0370I Directory Z:\FNQ_BKP\FNQ created

BR0202I Saving init_ora
BR0203I to Z:\FNQ_BKP\FNQ ...

BR0202I Saving E:\oracle\FNQ\102\database\initFNQ.sap
BR0203I to Z:\FNQ_BKP\FNQ ...

BR0280I BRBACKUP time stamp: 2014-01-16 15.05.04
BR0198I Profiles saved successfully

BR0280I BRBACKUP time stamp: 2014-01-16 15.05.06
BR0315I 'Alter tablespace PSAPSR3 begin backup' successful

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_15\SR3.DATA15
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA15 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_15\SR3.DATA15
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA15 #1/1

BR0280I BRBACKUP time stamp: 2014-01-16 15.10.45
BR0063I 1 of 50 files processed - 9080.008 of 310953.711 MB done
BR0204I Percentage done: 2.92%, estimated end time: 18:19
BR0001I *_________________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_23\SR3.DATA23
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA23 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_23\SR3.DATA23
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA23 #1/2

BR0280I BRBACKUP time stamp: 2014-01-16 15.15.48
BR0063I 2 of 50 files processed - 17300.016 of 310953.711 MB done
BR0204I Percentage done: 5.56%, estimated end time: 18:17
BR0001I ***_______________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_13\SR3.DATA13
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA13 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_13\SR3.DATA13
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA13 #1/3

BR0280I BRBACKUP time stamp: 2014-01-16 15.20.31
BR0063I 3 of 50 files processed - 24860.023 of 310953.711 MB done
BR0204I Percentage done: 7.99%, estimated end time: 18:18
BR0001I ****______________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_12\SR3.DATA12
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA12 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_12\SR3.DATA12
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA12 #1/4

BR0280I BRBACKUP time stamp: 2014-01-16 15.25.12
BR0063I 4 of 50 files processed - 32480.031 of 310953.711 MB done
BR0204I Percentage done: 10.45%, estimated end time: 18:17
BR0001I *****_____________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_11\SR3.DATA11
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA11 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_11\SR3.DATA11
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA11 #1/5

BR0280I BRBACKUP time stamp: 2014-01-16 15.29.50
BR0063I 5 of 50 files processed - 40040.039 of 310953.711 MB done
BR0204I Percentage done: 12.88%, estimated end time: 18:17
BR0001I ******____________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_10\SR3.DATA10
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA10 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_10\SR3.DATA10
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA10 #1/6

BR0280I BRBACKUP time stamp: 2014-01-16 15.34.29
BR0063I 6 of 50 files processed - 47600.047 of 310953.711 MB done
BR0204I Percentage done: 15.31%, estimated end time: 18:17
BR0001I ********__________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_9\SR3.DATA9
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA9 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_9\SR3.DATA9
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA9 #1/7

BR0280I BRBACKUP time stamp: 2014-01-16 15.39.13
BR0063I 7 of 50 files processed - 55260.055 of 310953.711 MB done
BR0204I Percentage done: 17.77%, estimated end time: 18:17
BR0001I *********_________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_8\SR3.DATA8
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA8 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_8\SR3.DATA8
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA8 #1/8

BR0280I BRBACKUP time stamp: 2014-01-16 15.43.59
BR0063I 8 of 50 files processed - 63000.063 of 310953.711 MB done
BR0204I Percentage done: 20.26%, estimated end time: 18:17
BR0001I **********________________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_7\SR3.DATA7
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA7 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_7\SR3.DATA7
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA7 #1/9

BR0280I BRBACKUP time stamp: 2014-01-16 15.48.51
BR0063I 9 of 50 files processed - 70900.070 of 310953.711 MB done
BR0204I Percentage done: 22.80%, estimated end time: 18:17
BR0001I ***********_______________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_6\SR3.DATA6
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA6 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_6\SR3.DATA6
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA6 #1/10

BR0280I BRBACKUP time stamp: 2014-01-16 15.53.40
BR0063I 10 of 50 files processed - 78700.078 of 310953.711 MB done
BR0204I Percentage done: 25.31%, estimated end time: 18:17
BR0001I *************_____________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_5\SR3.DATA5
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA5 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_5\SR3.DATA5
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA5 #1/11

BR0280I BRBACKUP time stamp: 2014-01-16 15.58.34
BR0063I 11 of 50 files processed - 86640.086 of 310953.711 MB done
BR0204I Percentage done: 27.86%, estimated end time: 18:17
BR0001I **************____________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_4\SR3.DATA4
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA4 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_4\SR3.DATA4
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA4 #1/12

BR0280I BRBACKUP time stamp: 2014-01-16 16.03.30
BR0063I 12 of 50 files processed - 94620.094 of 310953.711 MB done
BR0204I Percentage done: 30.43%, estimated end time: 18:17
BR0001I ***************___________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_3\SR3.DATA3
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA3 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_3\SR3.DATA3
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA3 #1/13

BR0280I BRBACKUP time stamp: 2014-01-16 16.08.21
BR0063I 13 of 50 files processed - 102540.102 of 310953.711 MB done
BR0204I Percentage done: 32.98%, estimated end time: 18:16
BR0001I ****************__________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_2\SR3.DATA2
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA2 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_2\SR3.DATA2
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA2 #1/14

BR0280I BRBACKUP time stamp: 2014-01-16 16.13.20
BR0063I 14 of 50 files processed - 110560.109 of 310953.711 MB done
BR0204I Percentage done: 35.56%, estimated end time: 18:17
BR0001I ******************________________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_1\SR3.DATA1
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA1 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_1\SR3.DATA1
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA1 #1/15

BR0280I BRBACKUP time stamp: 2014-01-16 16.18.31
BR0063I 15 of 50 files processed - 119020.117 of 310953.711 MB done
BR0204I Percentage done: 38.28%, estimated end time: 18:16
BR0001I *******************_______________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_26\SR3.DATA26
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA26 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_26\SR3.DATA26
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA26 #1/16

BR0280I BRBACKUP time stamp: 2014-01-16 16.23.15
BR0063I 16 of 50 files processed - 126740.125 of 310953.711 MB done
BR0204I Percentage done: 40.76%, estimated end time: 18:16
BR0001I ********************______________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_25\SR3.DATA25
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA25 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_25\SR3.DATA25
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA25 #1/17

BR0280I BRBACKUP time stamp: 2014-01-16 16.28.10
BR0063I 17 of 50 files processed - 134740.133 of 310953.711 MB done
BR0204I Percentage done: 43.33%, estimated end time: 18:16
BR0001I **********************____________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_24\SR3.DATA24
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA24 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_24\SR3.DATA24
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA24 #1/18

BR0280I BRBACKUP time stamp: 2014-01-16 16.33.06
BR0063I 18 of 50 files processed - 142800.141 of 310953.711 MB done
BR0204I Percentage done: 45.92%, estimated end time: 18:16
BR0001I ***********************___________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_16\SR3.DATA16
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA16 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_16\SR3.DATA16
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA16 #1/19

BR0280I BRBACKUP time stamp: 2014-01-16 16.38.13
BR0063I 19 of 50 files processed - 151100.148 of 310953.711 MB done
BR0204I Percentage done: 48.59%, estimated end time: 18:16
BR0001I ************************__________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_17\SR3.DATA17
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA17 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_17\SR3.DATA17
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA17 #1/20

BR0280I BRBACKUP time stamp: 2014-01-16 16.43.03
BR0063I 20 of 50 files processed - 159060.156 of 310953.711 MB done
BR0204I Percentage done: 51.15%, estimated end time: 18:16
BR0001I **************************________________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_18\SR3.DATA18
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA18 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_18\SR3.DATA18
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA18 #1/21

BR0280I BRBACKUP time stamp: 2014-01-16 16.49.00
BR0063I 21 of 50 files processed - 168840.164 of 310953.711 MB done
BR0204I Percentage done: 54.30%, estimated end time: 18:16
BR0001I ***************************_______________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_19\SR3.DATA19
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA19 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_19\SR3.DATA19
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA19 #1/22

BR0280I BRBACKUP time stamp: 2014-01-16 16.54.53
BR0063I 22 of 50 files processed - 178580.172 of 310953.711 MB done
BR0204I Percentage done: 57.43%, estimated end time: 18:16
BR0001I *****************************_____________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_20\SR3.DATA20
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA20 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_20\SR3.DATA20
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA20 #1/23

BR0280I BRBACKUP time stamp: 2014-01-16 17.00.10
BR0063I 23 of 50 files processed - 187140.180 of 310953.711 MB done
BR0204I Percentage done: 60.18%, estimated end time: 18:16
BR0001I ******************************____________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_21\SR3.DATA21
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA21 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_21\SR3.DATA21
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA21 #1/24

BR0280I BRBACKUP time stamp: 2014-01-16 17.05.19
BR0063I 24 of 50 files processed - 195500.188 of 310953.711 MB done
BR0204I Percentage done: 62.87%, estimated end time: 18:16
BR0001I *******************************___________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_22\SR3.DATA22
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA22 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_22\SR3.DATA22
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA22 #1/25

BR0280I BRBACKUP time stamp: 2014-01-16 17.10.31
BR0063I 25 of 50 files processed - 203900.195 of 310953.711 MB done
BR0204I Percentage done: 65.57%, estimated end time: 18:16
BR0001I *********************************_________________

BR0202I Saving F:\ORACLE\FNQ\SAPDATA2\SR3_14\SR3.DATA14
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3.DATA14 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA2\SR3_14\SR3.DATA14
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3.DATA14 #1/26

BR0280I BRBACKUP time stamp: 2014-01-16 17.16.35
BR0063I 26 of 50 files processed - 213760.203 of 310953.711 MB done
BR0204I Percentage done: 68.74%, estimated end time: 18:16
BR0001I **********************************________________

BR0280I BRBACKUP time stamp: 2014-01-16 17.16.38
BR0317I 'Alter tablespace PSAPSR3 end backup' successful

BR0280I BRBACKUP time stamp: 2014-01-16 17.16.39
BR0315I 'Alter tablespace PSAPSR3701X begin backup' successful

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_15\SR3701X.DATA15
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA15 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_15\SR3701X.DATA15
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA15 #1/27

BR0280I BRBACKUP time stamp: 2014-01-16 17.19.04
BR0063I 27 of 50 files processed - 217680.211 of 310953.711 MB done
BR0204I Percentage done: 70.00%, estimated end time: 18:16
BR0001I ***********************************_______________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_14\SR3701X.DATA14
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA14 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_14\SR3701X.DATA14
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA14 #1/28

BR0280I BRBACKUP time stamp: 2014-01-16 17.21.35
BR0063I 28 of 50 files processed - 221760.219 of 310953.711 MB done
BR0204I Percentage done: 71.32%, estimated end time: 18:16
BR0001I ************************************______________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_13\SR3701X.DATA13
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA13 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_13\SR3701X.DATA13
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA13 #1/29

BR0280I BRBACKUP time stamp: 2014-01-16 17.24.16
BR0063I 29 of 50 files processed - 226140.227 of 310953.711 MB done
BR0204I Percentage done: 72.72%, estimated end time: 18:16
BR0001I ************************************______________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_12\SR3701X.DATA12
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA12 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_12\SR3701X.DATA12
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA12 #1/30

BR0280I BRBACKUP time stamp: 2014-01-16 17.26.48
BR0063I 30 of 50 files processed - 230280.234 of 310953.711 MB done
BR0204I Percentage done: 74.06%, estimated end time: 18:16
BR0001I *************************************_____________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_11\SR3701X.DATA11
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA11 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_11\SR3701X.DATA11
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA11 #1/31

BR0280I BRBACKUP time stamp: 2014-01-16 17.30.17
BR0063I 31 of 50 files processed - 235900.242 of 310953.711 MB done
BR0204I Percentage done: 75.86%, estimated end time: 18:16
BR0001I **************************************____________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_10\SR3701X.DATA10
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA10 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_10\SR3701X.DATA10
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA10 #1/32

BR0280I BRBACKUP time stamp: 2014-01-16 17.33.04
BR0063I 32 of 50 files processed - 240460.250 of 310953.711 MB done
BR0204I Percentage done: 77.33%, estimated end time: 18:16
BR0001I ***************************************___________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_9\SR3701X.DATA9
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA9 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_9\SR3701X.DATA9
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA9 #1/33

BR0280I BRBACKUP time stamp: 2014-01-16 17.38.58
BR0063I 33 of 50 files processed - 250060.258 of 310953.711 MB done
BR0204I Percentage done: 80.42%, estimated end time: 18:16
BR0001I ****************************************__________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_8\SR3701X.DATA8
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA8 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_8\SR3701X.DATA8
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA8 #1/34

BR0280I BRBACKUP time stamp: 2014-01-16 17.41.35
BR0063I 34 of 50 files processed - 254280.266 of 310953.711 MB done
BR0204I Percentage done: 81.77%, estimated end time: 18:16
BR0001I *****************************************_________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_7\SR3701X.DATA7
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA7 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_7\SR3701X.DATA7
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA7 #1/35

BR0280I BRBACKUP time stamp: 2014-01-16 17.44.08
BR0063I 35 of 50 files processed - 258420.273 of 310953.711 MB done
BR0204I Percentage done: 83.11%, estimated end time: 18:16
BR0001I ******************************************________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_6\SR3701X.DATA6
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA6 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_6\SR3701X.DATA6
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA6 #1/36

BR0280I BRBACKUP time stamp: 2014-01-16 17.46.43
BR0063I 36 of 50 files processed - 262660.281 of 310953.711 MB done
BR0204I Percentage done: 84.47%, estimated end time: 18:16
BR0001I ******************************************________

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_5\SR3701X.DATA5
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA5 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_5\SR3701X.DATA5
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA5 #1/37

BR0280I BRBACKUP time stamp: 2014-01-16 17.49.20
BR0063I 37 of 50 files processed - 266920.289 of 310953.711 MB done
BR0204I Percentage done: 85.84%, estimated end time: 18:16
BR0001I *******************************************_______

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_4\SR3701X.DATA4
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA4 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_4\SR3701X.DATA4
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA4 #1/38

BR0280I BRBACKUP time stamp: 2014-01-16 17.52.14
BR0063I 38 of 50 files processed - 271640.297 of 310953.711 MB done
BR0204I Percentage done: 87.36%, estimated end time: 18:16
BR0001I ********************************************______

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_3\SR3701X.DATA3
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA3 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_3\SR3701X.DATA3
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA3 #1/39

BR0280I BRBACKUP time stamp: 2014-01-16 17.55.14
BR0063I 39 of 50 files processed - 276500.305 of 310953.711 MB done
BR0204I Percentage done: 88.92%, estimated end time: 18:16
BR0001I ********************************************______

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_2\SR3701X.DATA2
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA2 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_2\SR3701X.DATA2
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA2 #1/40

BR0280I BRBACKUP time stamp: 2014-01-16 17.58.15
BR0063I 40 of 50 files processed - 281400.313 of 310953.711 MB done
BR0204I Percentage done: 90.50%, estimated end time: 18:16
BR0001I *********************************************_____

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_1\SR3701X.DATA1
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA1 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_1\SR3701X.DATA1
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA1 #1/41

BR0280I BRBACKUP time stamp: 2014-01-16 18.01.09
BR0063I 41 of 50 files processed - 286100.320 of 310953.711 MB done
BR0204I Percentage done: 92.01%, estimated end time: 18:16
BR0001I **********************************************____

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_17\SR3701X.DATA17
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA17 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_17\SR3701X.DATA17
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA17 #1/42

BR0280I BRBACKUP time stamp: 2014-01-16 18.03.35
BR0063I 42 of 50 files processed - 290080.328 of 310953.711 MB done
BR0204I Percentage done: 93.29%, estimated end time: 18:16
BR0001I ***********************************************___

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_16\SR3701X.DATA16
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA16 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_16\SR3701X.DATA16
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA16 #1/43

BR0280I BRBACKUP time stamp: 2014-01-16 18.05.59
BR0063I 43 of 50 files processed - 293960.336 of 310953.711 MB done
BR0204I Percentage done: 94.54%, estimated end time: 18:16
BR0001I ***********************************************___

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_19\SR3701X.DATA19
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA19 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_19\SR3701X.DATA19
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA19 #1/44

BR0280I BRBACKUP time stamp: 2014-01-16 18.07.59
BR0063I 44 of 50 files processed - 297210.344 of 310953.711 MB done
BR0204I Percentage done: 95.58%, estimated end time: 18:16
BR0001I ************************************************__

BR0202I Saving M:\ORACLE\FNQ\SAPDATA3\SR3701X_18\SR3701X.DATA18
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3701X.DATA18 ...

#FILE..... M:\ORACLE\FNQ\SAPDATA3\SR3701X_18\SR3701X.DATA18
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3701X.DATA18 #1/45

BR0280I BRBACKUP time stamp: 2014-01-16 18.10.30
BR0063I 45 of 50 files processed - 301310.352 of 310953.711 MB done
BR0204I Percentage done: 96.90%, estimated end time: 18:16
BR0001I ************************************************__

BR0280I BRBACKUP time stamp: 2014-01-16 18.10.32
BR0317I 'Alter tablespace PSAPSR3701X end backup' successful

BR0280I BRBACKUP time stamp: 2014-01-16 18.10.32
BR0315I 'Alter tablespace PSAPSR3USR begin backup' successful

BR0202I Saving G:\ORACLE\FNQ\SAPDATA4\SR3USR_1\SR3USR.DATA1
BR0203I to Z:\FNQ_BKP\bemzltcu\SR3USR.DATA1 ...

#FILE..... G:\ORACLE\FNQ\SAPDATA4\SR3USR_1\SR3USR.DATA1
#SAVED.... Z:\FNQ_BKP\bemzltcu\SR3USR.DATA1 #1/46

BR0280I BRBACKUP time stamp: 2014-01-16 18.10.33
BR0063I 46 of 50 files processed - 301340.359 of 310953.711 MB done
BR0204I Percentage done: 96.91%, estimated end time: 18:16
BR0001I ************************************************__

BR0280I BRBACKUP time stamp: 2014-01-16 18.10.34
BR0317I 'Alter tablespace PSAPSR3USR end backup' successful

BR0280I BRBACKUP time stamp: 2014-01-16 18.10.34
BR0315I 'Alter tablespace PSAPUNDO begin backup' successful

BR0202I Saving F:\ORACLE\FNQ\SAPDATA1\UNDO_1\UNDO.DATA1
BR0203I to Z:\FNQ_BKP\bemzltcu\UNDO.DATA1 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA1\UNDO_1\UNDO.DATA1
#SAVED.... Z:\FNQ_BKP\bemzltcu\UNDO.DATA1 #1/47

BR0280I BRBACKUP time stamp: 2014-01-16 18.15.42
BR0063I 47 of 50 files processed - 309760.367 of 310953.711 MB done
BR0204I Percentage done: 99.62%, estimated end time: 18:16
BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2014-01-16 18.15.43
BR0317I 'Alter tablespace PSAPUNDO end backup' successful

BR0280I BRBACKUP time stamp: 2014-01-16 18.15.43
BR0315I 'Alter tablespace SYSAUX begin backup' successful

BR0202I Saving F:\ORACLE\FNQ\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
BR0203I to Z:\FNQ_BKP\bemzltcu\SYSAUX.DATA1 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA1\SYSAUX_1\SYSAUX.DATA1
#SAVED.... Z:\FNQ_BKP\bemzltcu\SYSAUX.DATA1 #1/48

BR0280I BRBACKUP time stamp: 2014-01-16 18.15.52
BR0063I 48 of 50 files processed - 310020.375 of 310953.711 MB done
BR0204I Percentage done: 99.70%, estimated end time: 18:16
BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2014-01-16 18.15.53
BR0317I 'Alter tablespace SYSAUX end backup' successful

BR0280I BRBACKUP time stamp: 2014-01-16 18.15.54
BR0315I 'Alter tablespace SYSTEM begin backup' successful

BR0202I Saving F:\ORACLE\FNQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
BR0203I to Z:\FNQ_BKP\bemzltcu\SYSTEM.DATA1 ...

#FILE..... F:\ORACLE\FNQ\SAPDATA1\SYSTEM_1\SYSTEM.DATA1
#SAVED.... Z:\FNQ_BKP\bemzltcu\SYSTEM.DATA1 #1/49

BR0280I BRBACKUP time stamp: 2014-01-16 18.16.27
BR0063I 49 of 50 files processed - 310930.383 of 310953.711 MB done
BR0204I Percentage done: 99.99%, estimated end time: 18:16
BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2014-01-16 18.16.28
BR0317I 'Alter tablespace SYSTEM end backup' successful

BR0202I Saving J:\oracle\FNQ\sapbackup\CNTRLFNQ.DBF
BR0203I to Z:\FNQ_BKP\bemzltcu\CNTRLFNQ.DBF ...

#FILE..... J:\oracle\FNQ\sapbackup\CNTRLFNQ.DBF
#SAVED.... Z:\FNQ_BKP\bemzltcu\CNTRLFNQ.DBF #1/50

BR0280I BRBACKUP time stamp: 2014-01-16 18.16.29
BR0063I 50 of 50 files processed - 310953.711 of 310953.711 MB done
BR0204I Percentage done: 100.00%, estimated end time: 18:16
BR0001I **************************************************

BR0280I BRBACKUP time stamp: 2014-01-16 18.16.32
BR0340I Switching to next online redolog file for database instance FNQ ...
BR0321I Switch to next online redolog file for database instance FNQ successful

BR0117I ARCHIVE LOG LIST after backup for database instance FNQ

Parameter Value

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            J:\oracle\FNQ\oraarch\FNQarch
Archive format                 ARC%S_%R.%T
Oldest online log sequence     11188
Next log sequence to archive   11191
Current log sequence           11191            SCN: 186627937
Database block size            8192             Thread: 1
Current system change number   186627940        ResetId: 779565053

BR0202I Saving space_log
BR0203I to Z:\FNQ_BKP\FNQ ...

BR0202I Saving J:\oracle\FNQ\sapbackup\bemzltcu.and
BR0203I to Z:\FNQ_BKP\FNQ ...

Hi sunil

want to add one more thing in quality system db02 i dont see these datafiles which were not copied

G:\oracle\SID\sapdata3\SR3701.DATA1 this i dont see in db02 but os level these files exsist

Thanks

Tabrayz

Ask a Question

Top Q&A Solution Author

User

Count

While running Control.sql error ORA-27091: unable to queue I/O

Accepted Solutions (1)

Accepted Solutions (1)

Answers (3)

Answers (3)

iFlow ODATA POST API_CV_ATTACHMENT_SRV

Re: Can SAP's OData Framework be used as API endpo...

Re: FB60 does not post. No error message is displa...

Re: generating qrcode using image url in crystal r...

Re: How to add dynamically formcell or button tabl...