3 Replies Latest reply: Jul 19, 2012 7:26 AM by Ratnajit Dey RSS

Backup duration takes longer after CIO Mounting

ricadonna ricadonna
Currently Being Moderated

Dear Expert,

 

I have Oracle 11.2.0.2 run in AIX 5.3, so I mount the file system with cio option.

According to this, I set database parameter as recommended :

1. filesystemio_options -> to be 'SETALL'

2. optimizer_mode -> to be deleted

 

After that, our backup duration takes 2 longer.

I run database check and optimizer statistic check, there is no error/warning result.

 

Is there any relation between cio mounting/this database parameter changes and database backup?

Is anyone ever encounter this and find the solution to shorten backup duration like before?

 

Thank you in advance,

 

Best Regards,

Rica