Database Administration (MOSC)

MOSC Banner

BACKUP_TAPE_IO_SLAVES and DBWR_IO_SLAVES

edited Jun 26, 2013 5:56AM in Database Administration (MOSC) 8 commentsAnswered
I've been reading Oracle documentation regarding those 2 parameters and their role in synchronous and asynchronous I/O. However I did not understand exactly how the 2 parameters work together. My question is:

1) What happens if BACKUP_TAPE_IO_SLAVES=FALSE and DBWR_IO_SLAVES=0

(I believe synchronous I/O is performed.).

2) What happens if BACKUP_TAPE_IO_SLAVES=FALSE and DBWR_IO_SLAVES=1

3) What happens if BACKUP_TAPE_IO_SLAVES=TRUE and DBWR_IO_SLAVES=0

4) What happens if BACKUP_TAPE_IO_SLAVES=TRUE and DBWR_IO_SLAVES=1

5) What happens if DBWR_IO_SLAVES=2

6) In my pc I have BACKUP_TAPE_IO_SLAVES=FALSE and DBWR_IO_SLAVES=0. However when I issue backup command I see rows in V$BACKUP_ASYNC_IO meaning that asynchronous I/O is performed. Is it because my O/S supports it and there is no need to set anything in Oracle?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center