At present, there are several open-source distributed log systems in the industry, such as notify + rsync, Facebook's scribe, Apache's chukwa, linkin's kafa, and cloudera's flume. For more information about these open-source distributed log systems, see this article. Article 1. Although these open-source log systems provide real-time
Windows Server system disk if it is a 2003 system, then we default to 10G of space is enough, but sometimes we inadvertently to check the system disk when found to have used 9.9G, in fact, most of the garbage log files occupy the system disk space, using the following batch processing to delete these files.Create a new text document on the desktop and copy the following code:@echo Offecho is cleaning up the
;
Path:D:\app\Administrator\diag\rdbms\orcl\orcl\trace\alert_orcl.log
A large number of errors are found by viewing the log:tns-12537: TNS: Connection off 12560 0 0 0By Baidu error keyword "Tns-12537:tns: Connection Close", found an article:http://blog.itpub.net/23169974/viewspace-1067401/This article describes the problem that the Listener.log log file is too large
Event Type: Error
Event Source: Userenv
Event Type: None
Event ID: 1500
Date: 2009-8-11
Event: 11:25:13
User: nt authority \ NETWORK SERVICE
COMPUTER: YFT
Description:
Windows does not allow you to log on, because you cannot load your configuration file. Check whether you are connected to the network or whether the network is working properly. If this problem per
Windows Server system disk if it is a 2003 system, then we default to 10G of space is enough, but sometimes we inadvertently to check the system disk when found to have used 9.9G, in fact, most of the garbage log files occupy the system disk space, using the following batch processing to delete these files.Create a new text document on the desktop and copy the following code:@echo Offecho is cleaning up the
function: The tail command outputs the end of the file, which, by default, displays the last ten lines of the file.Displays the last 10 lines of each specified file to the standard output. If more than one file is specified, the program adds the corresponding file name as th
log backup (other articles later), only the last backup, so choose the latest one, or you can not restore. Here is another note, remember to choose: Then restore the log file, which is one of the most important steps: And then: Due to some problems in the experiment, after the redo, so the time to choose 22:19 minutes, I was in the 22:20 minutes to d
much here, just assign the time point to the time you accidentally deleted. And since the tail of the log is the last backup file, the Red-box section can be selected here:Now check again:As you can see, the data has been restored successfully.Summarize:Usually do not do backup, the problem to shout urgent, this is Gou have to pick up, there are some people like
tail of the log is the last backup file, the Red-box section can be selected here: Now check again: As you can see, the data has been restored successfully. Summary: Usually do not do backup, the problem to shout urgent, this is Gou have to pick up, there are some people like to see the big head of LDF directly deleted, after the problem will not blame Mi
The following error occurs when you restore a database file group:
MSG 3159, level 16, state 1, line 1The tail of the log for the database "testfile" has not been backedup. use backup log with norecovery to backup the log if it contains work you donot want to lose. use the
it.
Then continue the backup.
Then make a restore, as shown in figure:
To restore the full backup first, select the most recent, due to the characteristics of the log backup (later other articles), only to recognize the last backup, so choose the latest one, otherwise not restore.
Here's another note, remember to choose:
Then restore the log file, which
= N' E:\AdventureWorks.bak ' with FILE = @backupSetId, nounload, Norewind
GO
At this point, the database is in the "Restoring" stateIf you do not see the backup can be viewed with the following statement, and the SPID killed: [SQL] view plaincopyprint?
SELECT * from sys.sysprocesses WHERE dbid=db_id (' AdventureWorks ')
Execution Result:and kill.Then continue with the backup.And then restore,To restore the full backup, select the
following statement, and the SPID killed:
SELECT * from sys.sysprocesses WHERE dbid=db_id (' AdventureWorks ')
Execution Result:and kill.Then continue with the backup.And then restore,To restore the full backup, select the most recent, because of the characteristics of the log backup (other articles later), only the last backup, so choose the latest one, or you can not restore.Here is another note, remember to choose:Then restore the
Interview Topics:1. Use Python to implement TAIL-F function, display the last 15 lines by default, and output new lines in real time?Problem Solving Ideas:1. This requirement has been encountered in many scenarios, and has been discussed in various groups, although there are ready-made templates such as pyinotify and other modules to achieve, but the interview would like to use your problem-solving ideas to judge the interview, specific to
damaged, you will not be able to take a backup of the transaction log from the disk. Another problem is that when your data is using the bulk-logged recovery model, the current transaction log includes only the minimized log transactions. In this case, a transaction log backup needs to store the modification of the d
This article lists the tail commands in the linux file creation command to teach you how to use the tail command to create a self-decompressed tar file. The Tail command parameter has a parameter-n, -- linesN, which can be directly output by
This article lists the
files in the directory must be deleted before the empty directory can be deleted using RmDir. You can use the Rm-ri command parameter to delete files under the directory and the directory itself. Delete file1/log/1.txt all directories and files below, use Rm-ri to complete five. View Files 5.1 View File Types filesBefore displaying the contents of a file,
Zhanhailiang Date: 2014-09-28You can use the Tail-f tool to view the logs of the output in real time under Linux. Recently switched to the local Windows development environment, a bit uncomfortable. Baidu took the next, finally found tail of the implementation version of Windows.1. Download
Zhanhailiang Date: 2014-09-28You can use the Tail-f tool to view the logs of the output in real time under Linux. Recently switched to the local Windows development environment, a bit uncomfortable. Baidu down, finally found tail the implementation version number of Windows.1. Download
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.