backup ost file

Test environment: Windows Azure Shanghai Room, virtual machine configured for large (quad core, 7 GB memory), the disk situation is shown in the figure below. The database backup compression file is greater than 12.0 GB (12,914,327,552 bytes), placed in temporary Storage (D:). The database restore operation commands are as follows: RESTORE DATABASE [Cnblogstext] from DISK = N ' D:\cnblogstext.bak '

Before restoring the control file, you must know the dbid of the target database. As a DBA, you must back up the dbid of the database when taking over the database! 1) backup control file RMAN> list backup of controlfile; 2) Test Data hr@ORCL> create table t (name varchar2(20));Table created.hr@ORCL> insert into t valu

Atitit. Improved Backup File Replication speed (4) --- data mining to obtain the list of recycle bin files 1. Principle of putting data into the recycle bin and 1 2. info2 file structure 1 3. Obtain the file list. Two Methods: regular expression or parsing 1. 4. Path regular expression [A-Za-Z] \: [\ a-zA-Z0-9 \ xb0-\

Inotify + rsync implements real-time file backup 1. inotify inotify is a powerful fine-grained and asynchronous file system event monitoring mechanism. The Linux kernel has been added to Inotify since 2.6.13, inotify can be used to monitor various events in the file system, such as adding, deleting, modifying, and movi

may need to be input Y/N. Now xcacls can solve this problem. It has a good parameter, that is,/Y indicates that confirmation is prompted when the user access is replaced.For example, type XCACLS * at the command prompt *. */G administrator: RW/Y, and then press Enter to replace the ACL of all files and folders in the current folder, without scanning the subfolders and confirming them.However, if we have many users with many directories and their permissions are different, setting them one by on

Tags: MoS unique oracl product Memory server app not strEnvironment is 12.2.0.1 version, Oracle Data guard Main Library patrol found alert with abnormal error: 2018-07-10t13:24:04.710366+08:00Errors in FILE/U01/APP/ORACLE/DIAG/RDBMS/DWDB/DWDB1/TRACE/DWDB1_M000_4455.TRC:Ora-00245:control file backup failed; In Oracle RAC, Target might not is on shared storageRemov

First, upload the backup files to the server one by one, pay attention to the evaluation of the volume label, and then perform the import operation. // If you want to publish this article, please indicate the exit, no outgoing copyright notice, I do not like to see this kind of website. My work website does not indicate the person who is serving seven {see7di # gmail.com} /*---------------------------------*/Function _ doimport (){$ F1 = _ r ($

#filename; backup_ver3.pyImportOSImportTimeSource= ['/home/book/desktop/happy','/home/book/desktop/new']target_dir='/home/book/desktop/backup'Today= Target_dir + time.strftime ('%y%m%d') Now= Time.strftime ('%h%m%s') Comment= Raw_input ('Enter a comment-->')ifLen (comment) = =0:target= today + Os.sep + now +'. zip'Else: Target= today + Os.sep + now +'_'+ Comment.replace (' ','_') +'. zip'if notos.path.exists (today): Os.mkdir (today)Print 'successfully created directory', Todayzip_command="zip-

@echo offREM ###########################################################REM # Windows Server 2003 Automatic backup batch script for Oracle databaseREM ###########################################################REM takes the current system time and may be different depending on the operating systemSet curdate=%date:~0,4%%date:~5,2%%date:~8,2%Set curtime=%time:~0,2%REM hours if less than 10, then fill 0 in frontIf "%curtime%" = = "0" Set curtime=00If "%

Today only found that the original position variable can also play so cool!! This is a file directory backup using the location variable: #!/bin/bash Date= ' Date +%f '//date output from year to month Tar Czf $ $DATE. tar.gz $ >/dev/null 2>>/opt/$1.bak.log//pack variable package, append error to log, tar package will keep original directory, better If [$?-eq 0] The return value is 0 for packing OK, not

Atitit. Improve backup file copy speed (4)---Data mining get a list of Recycle Bin files 1. How to put the Recycle Bin and 1 2. info2 File Structure 1 3. Get a list of files 2 methods: Regular expression or parsing 1 4. Path regular expression [a-za-z]\:[\\a-za-z0-9\xb0-\xf7\xa1-\xfe_.~]+ 2 5. Reference 2 1. How to put the Recycle Bin and The Info2

According to company requirements, delete the server 30 days before the file, the following is the script:#vi del-30.sh#!/bin/bashlocation= "/mpgdata/"Find $location-type f-mtime +30-exec rm-f {} \;#chmod +x del-30.shDescription:/mpgdata/is the path to the find backup file.-type f is the specified file type as a normal

This article mainly introduces how to implement the backup file in Python, which can be used to back up files with various common extensions, for more information about how to use Python to back up files, see the example in this article. Share it with you for your reference. The specific method is as follows: This instance is used to read a task file and automat

Concurrent execution of Oracle RMAN backup of a single file If a file is a file of several gigabytes or tens of thousands of megabytes, You Need To parallelize the backup of the file. Generally, one channel can only read one

The software for network file synchronization has already introduced two free tools, Dropbox and syncplicity, in different dimensions. Today, I will continue to introduce sugarsync, another excellent synchronization software. In addition to not supporting Linux, it has gathered almost all directors and is a highly recommended service. Sugarsync is a product from sharpcast network storage company in California. It provides 2g free network hard disk spa

The principle of the backup control file is to back up the control file after the physical structure of the database changes. 1. trace: used to control file reconstruction (the generated trace file is in udump)SQL> alter database backup