Recovery | data | database
Recently, by doing experiments to summarize a database recovery method for future work is very helpful:
The database is not in the archived state, only a week ago the data file backup, no Redolog, archive logs and Controlfile backup, in this case a database failure can only do incomplete recovery, will lose a week ago to do backup to the failure of all the data, the specific recovery methods are as follows:
Operating system for SOLARIS8, memory 2g,2 CPU.
Experiment
.
Some information about the exported discovery is empty.
command to check this machine, it is indeed a null value.
Investigation. An error was found.
View the details of the interface: sudo smartctl-d scsi-a/dev/sda
The array card needs to be installed special tools MegaRAID view.
Download: Ftp://download2.boulder.ibm.com/ecc/sar/CMA/XSA/ibm_utl_sraidmr_megacli-8.00.48_linux_32-64.zip. (If the connection is not available, or if it is slow, you can find me)
Installation.#un
On the Linux platform, there are several steps to manually create a database: 1. Confirm the unique instance and database name; 2. Select the character set of the database; 3. Set the OS environment variables; 4. Create the initialization parameter file; 5. Start the instance to the nomount state;
6. Execute the create database Command. 7. run at least two script files. test condition description: a database orcl has been created at the beginning of Oracle creation ), here we will create a Kwen
command aborted prematurely1 track 000 not found0 dam not found (always 0 for CP-3022)Seealso: # p0513, # p0514
Bitfields for hard disk controller drive/head specifier:Bit (s) Description (Table p0513)7 = 16 LBA mode enabled, rather than default CHS Mode5 = 14 drive select (0 = drive 0, 1 = drive 1)
3-0 head select bits (CHS Mode)Logical Block address, BITs 27-24 (LBA Mode)Seealso: # p0512, # p0514
Bitfields for hard disk controller status register:Bit (s) Description (Table p0514)7 controller
Create database manuallyAs a DBA, you must always remember what to use or prohibit the use of RM commands. If you are never able to use them, you must be careful and careful when you press Enter!Red Hat Enterprise 3 + Oracle 10g Release 2$ Su-Oracle1 --- set system environment variables:ORACLE_HOME =/opt/Oracle/product/10.2Oracle_base =/opt/OracleOracle_sid = dbtest......2 --- system planning:Instance name
# Alpinelinux with a glibc-2.26-r0 and Oracle Java 7From alpine:3.6Maintainer Anastas Dancha # Thanks to Vladimir Krivosheev # and Victor Palma # Java Version and other ENVENV java_version_major=7 \JAVA_VERSION_MINOR=80 \JAVA_VERSION_BUILD=15 \JAVA_PACKAGE=SERVER-JRE \Java_jce=standard \JAVA_HOME=/OPT/JDK \Path=${path}:/opt/jdk/bin \GLIBC_REPO=HTTPS://GITHUB.COM/SGERRAND/ALPINE-PKG-GLIBC \GLIBC_VERSION=2.26
has failed, began to think that the library support is not enough, it shows the library all cross-compiled, and finally has been reported libpoppler-glib.so wrong format.Many of the online explanations for this problem are 32-bit and 64-bit files that cause the file format to be incorrect, but how can I use a 32-bit system to compile the problem with the wrong format?Later inadvertently in http://www.linuxfromscratch.org/blfs/view/svn/general/poppler.html see Poppler compile need to bring libra
Naxsi is an open source, efficient and low maintenance rule for Nginx Web application Firewall (Web application Firewall) module. The primary goal of Naxsi is to harden Web applications against SQL injection, cross-site scripting, cross-domain forgery requests, and local and remote file containment vulnerabilities.Website address: Https://github.com/nbs-system/naxsiNaxsi does not require any specific dependencies, it requires Libpcre, LIBSSL, zlib, gzip these Nginx have been integrated.
MySQL full backup and restore full backup: Backup of the entire database, database structure and file structure, the database is saved at the time of preparation, is the basis of incremental backup. A backup of the MySQL database can be done in two ways, because the database is actually a file, the database folder is packaged directly, or the mysqldump can be backed up with a dedicated backup tool. MySQL full backup 1. Use tar to package a folder backupMySQL database files by default are saved i
next application interface must use the e-mail reply to the English company information, otherwise it will not succeed, and Apple only accept 3 applications, 3 failures can not apply. It also prompts the need to submit every few days, it is said that Apple and the need to synchronize information between.
Sign up for Enterprise Developer account
Enter https://developer.apple.com/enroll/again select "Company/organization", go to the next page to fill in the registration infor
applied, pop-up prompts, directly submit the application to obtain the code.
After applying for a period of time, there will be an email reply, such as
If there are no phone calls to verify the information, call Apple to confirm that the application was successfully submitted (usually OK). Tel: 400-701-855e-mail to TransUnion: The email content is your request ID, the name of the company to fill in the application, the applicant, contact phon
balancing;
Can realize judgment and allocation at the network layer or application layer;
Mysql enables binary logs to achieve bidirectional replication between databases and maintain data consistency;
# Remind me that no one in the actual production environment will set up this way. we can only use this experiment to understand these concepts and hope that readers can get them;
Serverslave IP = 192.168.5.11
Server2_ip = 192.168.5.12
Server_vip = 192.168.5.111
==============================
Operating System: Redhat Linux AS 4Obtain the installation package:DownloadHttp://subversion.tigris.org/downloads/subversion-1.6.6.tar.gzAnd http://subversion.tigris.org/downloads/subversion-deps-1.6.6.tar.gzCompile:Log on as the root user.Upload subversion-1.6.6.tar.gzand subversion-deps-1.6.6.tar.gz to the server.Tar xfvz subversion-1.6.6.tar.gzTar xfvz subversion-deps-1.6.6.tar.gzThe subversion-deps package has four directories: zlib apr-util neon. All these four directories are dependent pac
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.