14.3. File compression and archiving
Sometimes we need to store a set of files in a single file for backup or transfer to another directory or even another computer. Sometimes we also need to compress files into one file, so they use only a small amount of disk space and can be downloaded faster over the Internet.
Understanding the differences between archive files (archive file) and compressed files (compressed file) is important to users. An archiv
How to turn on/off Oracle archiving
If it is a OPS/RAC environment, you need to first comment out Parallel_server = True, and then perform the following steps, and then restart with this parameter
1, open the archive
A. Close the database shutdown immediate
B. Startup mount
C. ALTER DATABASE Archivelog
d. Alter DATABASE Opne
2. No filing
A. Close the database shutdown immediate
B. Startup mount
C. ALTER DATABASE Noarchivelog
d. ALTER DATABA
It's not good to look at Doc.
sql> shutdown Immediate
The database has been closed.
The database has been unloaded.
The ORACLE routine has been closed.
Sql> Startup Mount
The ORACLE routine has started.
Total System Global area 104857600 bytes
Fixed Size 1247540 bytes
Variable Size 96470732 bytes
Database buffers 4194304 bytes
Redo buffers 2945024 bytes
Database loading complete.
--Enable manual archiving
sql> ALTER DATABASE Archivelog m
The previous article basically confirms our mail server normal use, below we have some common operation.
This article mainly describes the creation of user mailboxes and arbitration mailboxes and archiving configuration
Nouns: Quorum mailbox and archive configuration
The brief introduction is as follows: For example, an employee to send mail to boss or external, then the mail must be arbitrated after the arbitration mailbox to reach the boss or out
testdb_archivepartitionrange (bit) as RANGE right for VALUES (1)Create a new partition scheme where archived data is saved to the TestDB_Part2 partition fileCREATE Partition Scheme Testdb_archivepatitionscheme as Partition testdb_archivepartitionrangeto ([PRIMARY], testdb_ PART2);Create a test data table, bind a partition schemeCREATE TABLE testarchivetable (archived Bit not NULL, Date DATETIME) on Testdb_archivepatitionscheme (archived)Insert some new data, ready for testingINSERT into testarc
Log_archive_max_processes Integer 2 Log_archive_min_succeed_dest Integer 1 Log_archive_start Boolean FALSE Log_archive_trace integer 0 To switch the archive mode: Note: All nodes must be in the Mount state. Modify the mode in one of the nodes, and then start the other node normally. sql> startup Mount; ORACLE instance started. Total System Global area 184549376 bytes Fixed Size 1218412 bytes Variable Size 113248404 bytes Database buffers 67108864 bytes Redo buffers 2973696 bytes Database mou
another nodeStartup17. Switch the archive log to determine if the switch is successful.sql> alter system switch logfile;
System altered.18, query the data in the archiveasmcmd> pwd
+dgrecovery/rac/archivelog/2017_06_13
asmcmd> ls
thread_1_seq_37.256.946542069
thread_1_seq_38.257.946542129
thread_1_seq_39.258.946542133
thread_1_seq_40.260.946542135
thread_1_seq_41.261.946543367
thread_1_seq_42.262.946543369
thread_1_seq_43.264.946543373
thread_ 1_seq_44.265.946543375
thread_1_seq_45.266.94654337
Tags: oracel archive flash backFirst, the archived switch1. Check if the archive is open:sql> archive log list;2. Set the archive pathSql> alter system set log_archive_dest_1= ' LOCATION=D:\ARCH2 ';3. Open Archivesql> shutdown immediate; --Close the databasesql> startup Mount; --Boot to Mount statesql> ALTER DATABASE Archivelog; --Open Archivesql> ALTER DATABASE open; --Open Database4. Close the Database archivesql> shutdown immediate;sql> startup Mount;sql> ALTER DATABASE Noarchivelog;sql> ALTE
file security or run sshd SSH-based services for data copying between systems from a remote system SSH [emailprotected] [[emailprotected] ~]# SCP Roo T @server0:/root/etc.tar.xz./ [[emailprotected] ~]# SCP etc.tar.gz [emailprotected]:/root [email protected] ~]# scp-r etc [emailprotected]:/root//-r recursive replication ssh [emailprotected] hostname SSH [emailprotected] Poweroff//Remote Execute command sftp SSH-based file Transfer Protocol Desktop0 SFTP Server0 Sftp> ; Get etc.tar.
specified file.[Readhandle Seektofileoffset:0]; //Readdataoflength: Reads 10 of the length of the Readhandle document.NSData *data1 = [Readhandle readdataoflength:Ten]; //The binary file data1 is stored in the NSString object str2 with UTF8 encoding.NSString *STR2 =[[NSString alloc]initwithdata:data1 encoding:nsutf8stringencoding]; //Close FileNSLog (@"%@", STR2); [Readhandle CloseFile];}- (void) didreceivememorywarning {[Super didreceivememorywarning]; //Dispose of any resources the can be rec
-
User: redhat: rwx # valid tive: r-x at this time, the system has automatically indicated that the message is affected by the mask.
Group: r --
Mask: r-x
Other: r --
Default acl:
The default acl is only valid for directory files, indicating that all files created in the directory inherit the acl of the Directory.
[Root @ server28 tmp] # setfacl-m d: u: redhat: rwx redhat. c/
[Root @ server28 tmp] # getfacl redhat. c/
# File: redhat. c
# Owner: root
# Group: root
User: rwx
Group: r-x
Other: r-x
well implemented by the program:Need 1 implementation), I use an FTP tool to download the file directly to the local, and then use other tools to distribute to other computers. Or just write a multi-threaded download program to distribute the downloaded files to the designated computer.Requirements 2 Implementation), plus barcode, QR Code is C # 's strengths. But you just have to write the code.3 implementation), the program is also possible.But I use Enfocus switch to handle all of the above r
It is still necessary to archive WordPress articles. especially when there are too many articles, you can easily find the articles you want to find using archive. There are many plug-ins on the Internet to implement this function, however, we like to do so, so we don't need plug-ins, but use code to implement them.
It is still necessary to archive WordPress articles. especially when there are too many articles, you can easily find the articles you want to find using archive. There are many plug-
();A.show ();}}Class father{String name;{Name= "Father";}}Class Son extends father{int age=20;void Show (){System.out.println (" name " +name);System.out.println (" Age " +age);}}3. Static methods only allow access to static data, so how do you access the instance members of the class in a static method (that is , a field or methodthat does not have the static keyword attached)? please write code to verify your idea. CodeClass exercise{int a=0;static int b;static public int Getb (int newb){B=NE
These two days to do a QQ landing systemWhen registering, the user enters various information (Name,age,password,gender. Avatar ...) stored in a user object, and then wants to put this object in a. txt file every time you register.This is used in the following way:Convert user to NSData (object archive), then append data to the end of file with Nsfilehandle, then readBut every time the first time to write to the file and read no problem, the second write is no problem, but again to read the time
/flash_recovery_area ). ORACLE has a limit on this path, that is, it only has 2 GB space by default. It is not only the default path for archiving logs, but also the default address for backup files and flash back logs, in this way, the space used by the archive log lock cannot reach 2 GB. If the path size is not set, many systems have encountered the problem that the database cannot be archived because the archive logs are full and the space for the
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.