thread1ora-00289:suggestion:/u01/oracle/product/flash_recovery_area/orcl/archivelog/ 2016_10_20/o1_mf_1_47_%u_.arcora-00280:change1995899forthread1isin sequence #47Specify log:{Found control file inside can't find sequence#47, and then only a redo log location to try, and finally succeededsql> ALTER DATABASE Open;alter database Open*error at line 1:ora-01589:must use Resetlogs or noresetlogs option for DA Tabase opensql> ALTER DATABASE open Resetlogs;database altered.Finally open the database,
Tags: height tools space href send address recommended install one keyIf our site update is not very frequent, we can regularly manually make backup site files and MySQL database export. If our site data update frequently, and the data is particularly important, it is recommended to use regular automatic backup, at least the need to
uses the transport tablespace command that specifies the datapump directory, dump file, export log, and import script file name to execute table space transmission.
-------------------------------------- Recommended reading --------------------------------------
RMAN: Configure an archive log deletion policy
Basic Oracle tutorial-copying a database through RMAN
Reference for RMAN backup policy formulation
*
$ --authorizing users to use the Import Export directory
Panax Notoginseng Grant Read, write onDirectory Satpimp toSATP; -
the --Import empty table under Settings oracle11g
+ AlterSystemSetDeferred_segment_creation=False scope=both; A
the show parameter deferred_segment_creation; +
- --Modify the default parameters of Rman to automatically back up control files
$CONFIGURE Controlfile Autobackup on;
$
- --Modify the default parameters of Rman to back up the path of the control f
When Mac users connect the ipad and the iphone to the computer, itunes automatically backs up some of the data on the phone, which takes up some of the Mac's disk space, so how do we remove the backup files in order to increase the MAC's disk space?
Workaround:
1. Open itunes and click "Preferences".
2. Switch to the "Device" module, select the
from dba_segments s where s.tablespace_name = ' Lhmz_oa '; Where Lhmz_oa is the table space name Database backup1) View the Management Manager directory SELECT * from Dba_directories; 2) Create a logical directory (created with system) Create directory Dir_work as ' C:\Test '; 3) Export by user Example: EXPDP Lhmz_oa/[email protected] Schemas=lhmz_oa directory=dir_work dumpfile=lhmz_oa.dmp logfile=lhmz_oa.log 4) Import by user Example: IMPDP S
database is compressed too large, please comment this line echo "Subject: Database Backup" |mutt-a/home/backup/$ databakname-s "Content: Database Backup" $MAIL _to #压缩网站数据 tarzcf/home/backup/$WebBakName $WEB _ Data #上传到FTP空间, delete ftp space 5 days ago ftp-v-n $FTP _ipTo
First, install LFTP environment
Because we need to use the LFTP environment when uploading FTP files, we can't make sure all the systems are installed, so we'd better reinstall them first.
The code is as follows
Copy Code
#CentOS Yum Install lftp
#Debian Apt-get Install Lftp
Second, create a backup directory
The code is as follows
Co
Microsoft My mobile phone space can synchronize information between your mobile phone and your online account.:
Back up and restore the information on your mobile phone to a password-protected website.
Access and update your contacts and appointments from a Web account
View and download photos shared with family members and friends
I recently used this on the WM mobile phone and found it very convenient, but I only do text message
1, turn off the unnecessary protection drive
Click on the "Control Panel"-"System, and then select System Protection, the default is all drive system protection, to turn off some unnecessary drive protection, to reduce the backup space footprint. However, Windows 7 does not allow you to protect only the non-system drives, not the system drives, so as long as you turn on system protection, you must first tu
When Mac users connect the ipad and the iphone to the computer, itunes automatically backs up some of the data on the phone, which takes up some of the Mac's disk space, so how do we remove the backup files in order to increase the MAC's disk space?
Workaround:
1. Open itunes and click "Preferences".
2. Switch to the "Device" module, select the
Tags: shallow the Oracle Hot backup users table spaceDatabase to run in archive mode:Archive Log ListShutdown immediateStartup MountALTER DATABASE Archivelog;ALTER DATABASE open;Archive Log ListHot Backup Users Table space:(1) Test environment related Information viewCreate a backup pathMkdir-p/home/oracle/hotbk/Here i
Tags: oracle rman optimizationORACLE11GR1 's new feature, Rman backs up the undo tablespace to exclude data from the sessions that have already been submitted, improving the efficiency of Rman backup.Official Document: http://docs.oracle.com/cd/B28359_01/server.111/b28279/chapter1.htm#AREANO02323We know that the undo table space is primarily used to store pre-mirrored data that may be used during rollback and recovery. However, the undo table
==================================== Please note ======================================
If the tool does not work on your computer, please confirm that the following two Windows components are already installed on your computer
1. Microsoft Windows Installer 3.1 simplified version download address:
Http://dl.pconline.com.cn/html_2/1/82/id=4713pn=0.html
2. NET Framework version 2.0 redistributable Package (x64) 2.0
Http://down1.tech.sina.com.cn/download/downContent/2006-03-31/17550.shtml
In the Linux system, the file can be transferred to the FPT space through SSH, some important data backup, then how to achieve the transfer of the file? Small series to give you a detailed introduction to Linux using SSH to transfer files to the FTP space method.
Steps:
Suppose the directory to be backed up is/home/wwwroot/aaa/, and the IP for the remote
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.