Re: Backup Script, Stored Procedure check
Oh well, I decided to create a table in a separate database which will be writable during the read lock on my database backup.
The shell script will execute 'update maint.backup_status set active=1' and my stored procedure which flush tables with read lock and waits in a loop for the active value to change in the maint.backup_status table.
When the loop completes it will unlock tables setting the database in read/write mode once again.
Subject
Views
Written By
Posted
1204
June 26, 2018 06:19PM
506
June 27, 2018 07:45AM
505
June 27, 2018 11:07AM
456
June 27, 2018 02:28PM
Re: Backup Script, Stored Procedure check
531
June 27, 2018 02:46PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.