This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost;
This article describes how to use the Rman tool to automatically back up the control file dump and reply to the database when all the control files are lost;
This article describes how to use the Rman tool to automatically back up the control
=%backpath_full%. DMP SET backpath= SET backpath_full= EXITRecommendation IV:RMAN target=rman/[email protected] Recommendation Five: Edit the cmd command in the text. Then save it as a bat file. When you define a task schedule in Windows, you It can be executed automatically. Cases: Edit a text file Del c:\exp\*.dmp Exp userid=cw/[email protected] file= ' c:\
open state, use the alter database backup controlfile to trace command to back up the control file to the trace file
Two methods are available to control file recovery.
1) Use recover database using backup controlfile in the moun
1. Backup by file name 2 and backup by I-node
FirstLet's take a look at backup by name: Smitty backfile or use the command in the top directory of the file system: backup to tape find. -print |
MongoDB data file backup and recovery backup and recovery data are important for managing any data storage system. 1, cold backup and recovery-Create a copy of the data file (if you want to stop the MongoDB server), that is, direct copy MongoDB will store all the data in the
CP +data/ora11g/backup/control01.ctl +data/ora11g/controlfile/control01.ctlAlter system set control_files= ' +data/ora11g/controlfile/control01.ctl ' scope=spfile;Shutdown immediateStartup MountSelect Group#,status from V$log;Select Group#,member from V$logfile;Select group#,thread#,sequence# from V$archive;Recover database using Backup controlfile until cancel;A
WORD2013 has the ability to automatically create backup files, and you can automatically create a backup file each time you modify a Word document and save it, helping users easily recover to an older version of the Word document. The following steps are described in detail:
Step 1th, open the Word2013 document window
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
with backup control file recovery, the control file does not contain data files, but the online log hasALTER DATABASE backup Controlfile to ' D:\control.ctl ';Create tablespace tp1 datafile ' d:/tp1.dbf ' size 10M;CREATE TABLE t1 (ID int,name varchar2 (Ten)) tablespace TP1;INSERT INTO T1 values (1, ' pl1 ');commit;stop
/wKiom1ViltKzBddIAAEjUaKazLU982.jpg "title=" Picture 10.jpg "alt=" Wkiom1viltkzbddiaaejuakazlu982.jpg "/>
(This is what you've backed up before-you can check it if you need to recover)And then restore success is also a hint!
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/6D/5F/wKiom1ViltzzsDHmAAEPvfElIeQ805.jpg "title=" Picture 11.jpg "alt=" Wkiom1viltzzsdhmaaepvfelieq805.jpg "/>
Overall this software is good, when enc
Fix for Linux file system error Ddrescue replace DD Recovery software backup Super blockA recently processed Linux server power outage causes the file system to not read and write, the data is not availableExample, now summarizes the Linux file system error repair method.EXT3-FS error (device Hda3) in Start_transaction
.===========================================================================================================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
/wyfs02/M02/6C/6C/wKioL1VJfxPA_tgLAAFt30ms_N8824.jpg "title=" Picture 5.png "alt=" Wkiol1vjfxpa_tglaaft30ms_n8824.jpg "/>
After selecting the contents of the file you want to back up, click "Finish" to start the backup.
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M01/6C/70/wKiom1VJfjKghwc-AAHgcvgsDgM582.jpg "title=" Picture 6.png "alt=" Wkiom1vjfjkghwc-aahgcvgsdgm582.jpg "/>
Aft
One, backup snapshot1>1. Click the Quick Backup button above the virtual machine2. Fill in the snapshot name and commentThe snapshot is generated.2> Recovery1. Click the Recover button, the function of this button is to restore directly to the node of the last backup.2. Or choose the Next button, you can select the nod
Most system administrators have used a single key restore. Indeed, a single key backup and restore can help the administrator recover the questionable operating system in the shortest time content. You can also configure multiple restore points for the operating system.
But then a key backup and restore operation is more complex, such as the need to restart the
To ensure that Word documents are damaged or illegally modified to recover losses more effectively, users can enable Word2007 to automatically create backup files. By enabling the automatic Create backup file feature, you can automatically create a backup
Migrating an Oracle database using Rman's level0 backup file-incomplete recovery-20160811Migrating an Oracle database from one machine A to another machine B (same as Linux platform), set to a different path, different instance nameSOURCE side:Oracle_base=/u01/app/oracleOracle_home=/u01/app/oracle/product/12.1.0.2/db_1Oracle_sid=scpdbData File location:/u01/app/o
OS:Oracle Linux Server Release 5.7Db:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0-64bit ProductionFirst create the Yoon databasesql> Create Tablespace Yoon datafile '/u01/oracle/oradata/yoon/yoon01.dbf ' size 50m;Tablespace created.Sql> create user Yoon identified by Yoon Default Tablespace yoon;User created.Sql> Grant DBA to Yoon;Grant succeeded.Sql> CREATE TABLE Yoon.yoon as SELECT * from Scott.emp;Table created.Accidental deletion of data files in operation YOON01.DBFRM-RF yoon01
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.