it's a lot of files, you need to use the following commandLsof |grep deleted Note: This deleted represents the deleted file, but the file handle is not released, and this command lists all the processes that have not disposed of the file handle.Note: Some systems you do not configure the environment variables, direct lsof will be an error without the command, yo
the control file is lost. Therefore, you have not set many custom settings for RMAN in the past, including automatic backup.
RMAN> set DBID=1316499950executing command: SET DBIDRMAN> restore controlfile from '/u01/app/oracle/flash_recovery_area/ORCL/backupset/2012_08_08/o1_mf_ncnnf_TAG20120808T101321_823lt24m_.bkp';Starting restore at 08-AUG-12using target database control file instead of
system user, and OI after the user name indicates that the object is inherited (ACE will be inherited by the Directory ), (CI) indicates that the container inherits (ACE will be inherited by the file), and other IO means only inherit (ACE is not applicable to the current file/directory ).Cacls D: est/t/c/e/g small: FWhen we use the/c parameter, some directories may need to be input Y/N. now xcacls can solv
have been thinking about a problem recently, if hand shake accidentally execute command chmod 777-r/, just no system backup, it is really tragic. The backup of production system is really the most heavy.This session only discusses how to back up system file permissions.1. Create a file for testing.[email protected] ~]# ll testfacl.txt-rw-r--r--1 root root 0 Mar 05:27 testfacl.txtYou can see that the Testfac
Label:Oracle Database Logic export EXP DMP file corruption, extracting data from the table in the DMP file through unconventional recovery In some cases, the exp DMP file is damaged for some reason (such as a disk exception, exp process corruption, etc.), resulting in IMP import cannot continue, the following processin
.===========================================================================================================4. Compare SnapshotsCompare snapshots to see the difference between backup files between two snapshotsExecute commandHDFs Snapshotdiff Execute command HDFs Snapshotdiff Results Results:
+
The file/directory has been created.
-
The file/directory has been delet
Environment: centos7.2Software: redis-3.2.10 (yum installation)Scenario One: Before the company's Redis does not open aof mode, has been an RDB mode, but the data is very important, the data can not be lost, so need to open aof, but Redis default is to load data from appendonly.aof, Systemctl start Redis, the database is empty because we don't have a appendonly.aof file, and when you close Redis, the Dump.rdb is emptiedScenario Two: Redis database mig
to try to recover the data in the database by rebuilding the transaction log. If you only have MDF files, the problem is more complicated and we need to rebuild the transaction log directly:1. Create a new database with the same name in SQL Server, and then stop the SQL Server service.2. Overwrite the. mdf file for the new database with the original LDF file and delete its log
ServerMSSQLDatatest_data.mdf'
2. Only mdf file Restoration Technology
For various reasons, if we only backed up the mdf file at that time, it would be very troublesome to restore it.
If your mdf file is generated by the current database, you may be lucky to use sp_attach_db or sp_attach_single_file_db to restore the database, but the following prompt will appear
Recently because of the busy work, plus the end of many projects, there is no time to write Bo, today a friend asked about the Windows 2003 shadow copies of the function, said that only a full disk restore, from itself, when we look at the disk properties of the time, this and Windows 2008 R2, Windows R2 different, in the Windows 2008 R2 we can restore the file directly in the disk properties, in fact, under Windows 2003 can also achieve
Recovery | data | database
Method One1. Create a new database with the same name2. Stop SQL Server again (be careful not to detach the database)3. Overwrite the new database with the data file of the original database4. Restart SQL Server5. When you open Enterprise Manager, there will be doubt, regardless, execute the following statement (note modify the database name)6. After the completion of the general
Oracle non-critical file recovery, redo, temporary files, index files, password files, and oracleredo
The Application of Incremental backup is in the rediscovery stage and is no longer in the restore stage.
Learn about the database settings table:SQL> desc database_propertiesName Null? Type-----------------------------------------------------------------------------PROPERTY_NAME not null VARCHAR2 (30)PROPER
The function of binary log files
The MySQL binary log file is used to record all users ' operations on the database, that is, the SQL statements that record user operations on the database. If you have this file, when the database is an accident, you can see through this file to the user in this file recorded in the t
Error when you open IIS Manager or configure a Web site: The XML format of the configuration file is incorrectand is the applicationhost.config problem, then it must be ApplicationHost.config is destroyed, IIS crashes.The solution is to restore applicationhost.config.Check the ApplicationHost.config file in the C:\Windows\System32\inetsrv\config directory first, it is best to back up a copyUse the AppCmd.ex
To back up the database:pg_dump-h localhost-u root demo02 >/home/arno/dumps/demo02.bakTo recover a database:psql-h localhost-u root-d Demo Backup table:pg_dump-h localhost-u root demo02-t books >/home/arno/dumps/books.bakRecovery table:psql-h localhost-u root-d demo-t Books Psql Copy to/from usage:1. Need to log in to the database using Postgres Super User psql-u postgres-d demo022. Saved/Read folders need to give Postgres user permission to read and write3. Exporting data to a
Tags: future guide Configuration Space project Development ace round OBA HowBackgroundMySQL in the process of use, inevitably encountered database table error operation, based on this, the author pro-Pro, the MySQL data table ibd File Recovery To do the following detailed description of the development or the primary DBA to provide some guidance, if there are related issues in the blog, please specify, mutu
Prepare toolsPrepare u-depth USB flash drive firstSolution1. u deep U disk boot insert into the computer and then set the u disk boot after entering the interface we select "[02] U deep WIN8 PE Standard edition (New Machine)", as shown in the following figure:2. After entering the pe System, click "windows-hard disk partition-bootice (partition, boot, BCD edit, G4D Edit)", as shown in the following figure:3. In this interface, click "physical disk" and find the targ
Basic Linux and UNIX program development tutorial----- Reading Notes
Chapter 4 backup and recovery of the file system1, # tar-CF all.tar *. jpgThis command is to pack all. jpg files into a package named all.tar. -C indicates that a new package is generated.-F specifies the package file name.# Tar-RF all.tar *. gifThis command adds all .gif files to the package of
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.