This article will introduce to you how to back up and delete the scripts for archiving logs of the dg standby database on the win platform rman. I hope this method will be helpful to you.
I always think that using windows to run oracle is unreliable. But there are always many people in the world who like to do something like this. There are two common things about databases: rman and delete the archive logs of the dg slave database. It is very easy to
Archiving Implementation of inherited object models in ios
Previously, archive technology was used in the project, and MJExtension was also used.
But the problem is that this public database has encountered some problems that cannot be archived, which makes it quite painful. What should I do.
For parts that cannot be archived, the function is manually archived, Which is speechless.
Find the cause:
It turns out that for two models, how does A inherit
/file.bz2bzcat/path/to/file.bz24.xz/unxz/xzdec/xzcat: The compression format is XZXZ [OPTION]/path/to/file-#: 1-9, default is 6-K: Keep the original file when compressing-D: UnzipUnxz|xzdec/path/to/file.xzXzcat/path/to/file.xz5.zip: A tool that can be archived and compressedZip file.zip file1 file2 ... : The original file is not deleted after default compression-r:recurse all files within the directory are compressed, zip-r foo.zip foo-v|verbose: Show instruction execution processUnzip File.zip-
//The JP directory is packaged as a Jp.tar format file.Example: TAR–ZCVF jp.tar.gz JP//package and compress the JP directoryExample: TAR–JCVF jp.tar.bz2 JP//package and compress the JP directoryExample: tar–jcvf/tmp/jp.tar.bz2 jp1 JP2//Packaging compressed multiple folders to a specified directory2. UnpackingFormat: TAR–XVF package file nameOptions:-Z: Unzip. GZ formatted files-j: Compressing files in tar.bz2 format-X: Unpacking-T: View file contentsExample: TAR–XVF Jp.tar//Unpacking the Jp.tarE
1, gzip/bzip2/xz [-#] file, can only compress files, non-compressible directory.Common parameters:-#: Specify compression ratio 1-9, default is 6-D: Expand, unzipA. gzip,gunzip=gzip-d, the default compression has the original file deletion, decompression after the compressed file deletion.-C: Output compression results to the screen, which can be saved as a compressed file using redirection, preserving the original file.Gzip-c mmm > mmm.gzGzip mmmGzip-d mmm.gzDo not press to view compressed file
Nsarraycontroller, and the two columns of the Tab_view control are bound to the 2 properties in the Person class, respectively. Each row is naturally a person object in the Everyone array. The representation of the data in each view (Tab_view) is connected by the controller to the pattern, and the change of the view content (via the Add and Remove buttons) also leads to changes in the pattern data, and the change of the pattern itself (through the Read file operation) also updates the display o
1, Gzip/gunzipgzip [OPTION] ... FILE ...-D: Uncompressed, equivalent to Gunzip-C: Outputs the result to standard output-#:1-9, specifying the compression ratioZcat: View text file contents without explicit expansion2, Bzip2/bunzip2/bzcatbzip2 [OPTION] ... FILE ...-k:keep, keep the original file-D: Unzip-#:1-9, compression ratio, default = 6Bzcat: View text file contents without explicit expansion3, Xz/unxz/xzcatbzip2 [OPTION] ... FILE ...-k:keep, keep the original file-D: Unzip-#:1-9, compressio
different, compression ratio (before compression size-compression size/pre-compression size = Compression ratio) is different.Third, practice1. Write a script that allows the user to enter several files from the keyboard, which enables the script to compress several files entered by the user into a single file. 650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M01/49/62/wKioL1QTpxeCRT_KAAFvo5qJmlI525.jpg "title=" 1.jpg " alt= "Wkiol1qtpxecrt_kaafvo5qjmli525.jpg"/>This article is from the "
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.
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.