Database scheduled backup script

To prevent damage to the database server, you need to back up data to the client every day. The data is stored in the export directory. The following is a backup script:

To prevent damage to the database server, you need to back up data to the client every day. The data is stored in the export directory. The following is a backup script:

To prevent damage to the database server, you need to back up data to the client every day. The data is stored in the export directory. The following is a backup script:

Cd export

Setlocal
Set NLS_LANG = AMERICAN_AMERICA.AL32UTF8
Set rq = % date :~ 0, 4% % date :~ 5, 2% % date :~ 8, 2%

Exp system/manager @ clienttns file = all _ % rq %. dmp rows = y log = all _ % rq %. log owner = (user1, user2, user3)