Hi,
I would like to know abt AI file switch.we will follow below procedure for taking offline backup and start databases
1 ) Shutdown database
2) Ai disable
3) offline backup
4) start AI
5) Start Database
Questions
1) If we take offline backup during last extent is in "busy" state" database is not getting shutdown.
2) If we take offline backup after that once AI enabled all Busy extent getting empty and first extent in "Busy" State.I not able to find where the Ai files has been copied.
3) If last Ai extent reached 2Gb limit only database will be shutdown or whatever space in disk occupies then only Database goes down?
Fyi........... we dont have largefile enabled to our database
Progress Version : 9.1E ( Client is more interested using old version only)
IBM AIX 5.1
And also how to monitor Ai file growth using VST?
JackDBA......
I would like to know abt AI file switch.we will follow below procedure for taking offline backup and start databases
1 ) Shutdown database
2) Ai disable
3) offline backup
4) start AI
5) Start Database
Questions
1) If we take offline backup during last extent is in "busy" state" database is not getting shutdown.
2) If we take offline backup after that once AI enabled all Busy extent getting empty and first extent in "Busy" State.I not able to find where the Ai files has been copied.
3) If last Ai extent reached 2Gb limit only database will be shutdown or whatever space in disk occupies then only Database goes down?
Fyi........... we dont have largefile enabled to our database
Progress Version : 9.1E ( Client is more interested using old version only)
IBM AIX 5.1
And also how to monitor Ai file growth using VST?
JackDBA......