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
1108
June 26, 2018 06:19PM
473
June 27, 2018 07:45AM
479
June 27, 2018 11:07AM
429
June 27, 2018 02:28PM
Re: Backup Script, Stored Procedure check
499
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.