To enable and disable oracle archive, if the OPSRAC environment is used, You Need To comment out parallel_servertrue first, then perform the following steps, and use this parameter to restart 1. Enable archive. disable shutdownimmediateb. startupmountc. alterdatabasearchivelogd. alterdatabaseopne
How to enable/disable oracle Archiving
In the OPS/RAC environment, You Need To comment out parallel_server = true first, then perform the following steps
An example of solution to system downtime caused by full archiving logs of Oracle databases
When the first downtime occurs, the system memory overflows. Therefore, the application server is restarted and an error is reported when the application server is started. The error is that the Oracle database cannot be connected. Connect to the database server, open EM, and the system reports an error.The error message "archive log writing failed" is display
Database performance exception and slowness caused by full archiving of Oracle logs
When the database performance is abnormal and slow due to full archiving of Oracle logs, I did not view the alarm log and thought it was because the lock blocking of the database affected the performance. The archived log is full only when you view the log. This problem occurs:Errors in file/DBBK/oracle/diag/rdbms/orcl/trace
deleted.Format: xz/PATH/TO/SOMEFILE-D: Extract-#: 1-9; default value: 6-K: the original file is retained during compression.Unxz: ExtractXzdec: view the content of a text file without any pressureXzcat: view the content of a text file without any pressure
2. archive does not mean compression.1. tar: archive tool that generates. tar archive files-F FILE.tar: the archived file for the operation.-Cf: Create an archive file-Xf: Expand the archive-- Xattrs: retains the extended attributes of an obje
Tar
[Syntax] tar [option] tarfile filename
[Command description]
The file name must be followed by the-f parameter and used as the last parameter;
[Parameter description]
-C. Create a new archive file;
-F specifies the file name;
-R: append an object to an archive object;
-X Extract files from archive files;
-V and-vv display progress information;
-T list the information of the archive file (not extracted );
-C specifies the directory extracted from the file;
-A: Merge multiple tar files;
-- Pri
In ORACLE10G, the default archiving path is $ ORACLE_BASE/flash_recovery_area. For this path,ORACLE has a limit that only 2 GB of space can be used for archiving logs by default. You can use the following two SQL statements to view the limit.1. select * fromv $ recovery_file_dest;
SQL> showparameterdb_recovery_file_dest (this is more user-friendly and intuitive)When the number of archived logs is greater t
1. File archivingDefined:
File archiving, which is to turn multiple files into an archive file
2.Tar C # #创建
-j XZ Format Compression
F Specify the archive file name
T Display the contents of the archive file
R to add a file to an archive file
--get Remove a single file
--delete Delete a single file
x Remove all content from the
order: Only the root is 1, the other can be 2 0: indicates no check
Fuser: Verifying that the process is using a file or socket file-V: Viewing a running process on a file-k-m: Terminating all processes that are accessing this mount point
Compression decompression
Compression format:. gz. bz2. xz. zip
Compression algorithms are different, the compression ratio will be different
Gzip bzip2 XZ can only compress files cannot be compressed directory by default source delete files
Gzip:g
. Only files can be compressed.[OPTION]-D unzip the file.-num compression ratio. 1-9, default is 6.-K--keep Keep the source file when compressing.#unxz filename.xz The source file is deleted when the decompression is complete.#xzcat FILENAME to view the contents of a text file without being pressed.#xzdec usage is similar to XZ.Zip:The compression ratio is small, but the files within the directory and directory can be compressed. is both compressed and archived, and the source files are not dele
bytes after the archive is completeTAR-CZVVF file.tar.gz file1 file2 ... #创建经由gzip压缩过的归档文件TAR-CAVVF file.tar.gz file1 file2 ... #同上gzip filename #压缩文件. Delete the original file and generate filename.gzGzip-l test.txt.gz #列出压缩文件的属性信息Gunzip filename.gz #解压文件. Remove filename.gz and generate an uncompressed form of filename.gzZip file.zip file #压缩file文件, generate File.zip compressed files, do not delete the original file after compressionZip-r file.zip folder File #对目录和文件进行递归操作Contents of Zip file
File transfer between different systems1. File archiving1.File archiving, which is to turn multiple files into an archive file2.Tarc# #创建F# #指定归档文件名称T# #显示归档文件中的内容R# #向归档文件中添加文件--get# #取出单个文件--delete# #删除单个文件x# #取出归档文件中的所有内容-C # #指定解档目录-Z # #gz格式压缩-j# #bz2格式压缩-j# #xz格式压缩650) this.width=650; "src=" Https://s4.51cto.com/wyfs02/M01/9C/A0/wKioL1lzXvyQE187AABw_U_Ef9I972.png "style=" float : none; "title=" screenshot from 2017-07-22 14-43-57.png "alt=" Wkio
This paper mainly from the following several convenient to explain file archiving and compression, while comparing the compression ratios and characteristics of several different compression methods.
File Archive command tar,tar.gz source package installation Management
Create a Tar Package-extract-Query the contents of the TAR Package
Zip Use of Commands
why compress?1. easy to use, query, read2. Easy to manage (delete files in
Label:About Database archiving--See if the database is in archive modeSql> select Name,log_mode from V$database;NAME Log_mode--------- ------------Enmo Noarchivelogsql> archive log list;Database log mode No Archive modeAutomatic Archival DisabledArchive Destination/u01/app/oracle/product/11.2.0/dbhome_1/dbs/archOldest online log sequence 6Current Log Sequence 8--To shut down the database start the database under Mountsql> shutdown ImmediateDatabase cl
Archiving and compression of Linux:1. Space saving2. Facilitate the management of fragmented documentsTar Integrated Backup tool:-C: Create an archive-X: Release Archive-F: Specify the Archive file name-Z,-j,-j: Call the GZ, bz2, XZ format tools for processing-C: Specify the release location-P: Maintain absolute path to files within archive-TAR-ZCF backup files. tar.gz files that are backed up-TAR-JCF backup files. tar.bz2 files that are backed up-TAR
Tags: ima. com technology Sharing network devices through the Microsoft Ya Black set mod usingToday the Data group someone response website can not open normally, after checking Oracle database remote connection is not on, message: Ora-00257:archiver error. Connect internal only, until freed. Maybe the archivelog is full . Before learning SQL only to focus on crud, the log understand very little, although the outage on the generation did not have a bad impact, but also because the business is no
One, file merge operation1. Overlay symbols and append symbolsA) ">" means to overwrite the contents of the left file with the contents of the right file, and create this file if the right file does not exist.b) ">>" represents the contents of the left file appended to the right file, if the right file does not exist, create this file2.echo echo Command1 Echo "I am a little shame" >t.txt2echo" I am a little ruin ">>tbak.txt3. File Merging1 Cat File a file B > file C4. Number of statistics file l
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
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.