Oracle自动备份批处理
set rq=%date:~0,10% rem exp dlsjzs/dlsjzs@orcl file=d:\dbbak\dlsjzs%date:~0,4%%date:~5,2%%date:~8,2%.dmp expdp dlsjzs/dlsjzs@orcl logfile=log.log directory=expdp_dmp dumpfile
set rq=%date:~0,10% rem exp dlsjzs/dlsjzs@orcl file=d:\dbbak\dlsjzs%date:~0,4%%date:~5,2%%date:~8,2%.dmp expdp dlsjzs/dlsjzs@orcl logfile=log.log directory=expdp_dmp dumpfile
生成数据库快照declare @query varchar(1000) declare @DatabaseName varchar(128) declare @snapshotName varchar(128) declare @snapDataName varchar(128) declare @snapFileName varchar(128) declare @snapFilePath va
SQL Server中获取所有数据库名Select Name FROM Master.dbo.SysDatabases orDER BY Name方式一(多库备份):--使用拼凑SQL的方式 DECLARE @SQL VARCHAR(MAX) SELECT @SQL = COALESCE(@SQL,'') + ' BACKUP DATABASE '+ QUOTENAME(name,'[]') /
https://blog.csdn.net/orchidcat/article/details/60574315