recover database using backup controlfile until

(1) Create an OS directory for storing backup database-Related Files (2) create a routine service (3) configure the listener and Network Service name (4) Prepare the parameter file of the primary database (5) Prepare backup database parameter files (6) Enable the standby rou

Note:I originally wanted to create a replica uard test for the no target database by using the backup set of the target database. I found that it could not be implemented in principle, but it has a very useful function, allows you to quickly recover data from different rman

database containing the MyISAM and InnoDB tables will be backed up;--uncompressUnzip the backed up data file, support Ibbackup,xtrabackup has not implemented this function;--slave-info,Backup from the library, plus the--slave-info backup directory will generate more than one Xtrabackup_slave_info file, here will save the main log file and offset, the file conten

:\ORACLE\ORADATA\USERS01. DBF'; SetUntil sequence -; Restore database; Switchdatafile All; Recover database; } Sequence can be found from the Rman backup log, or view V$backup_redolog Six. Renaming the Redo file Set $ Col member format A60 Select a.thread#,a.group#,b.type,b.member,a.bytes/1048576 from

. SQL> host Copy D: \ demo \ undotbs01.dbf D: \ backup1 file has been copied. SQL> host Copy D: \ demo \ sysaux01.dbf D: \ backup 1 file has been copied. SQL> host Copy D: \ demo \ users01.dbf D: \ backup1 file has been copied. SQL> alter Database End backup; The database has been changed. SQL> alter system archive log

to 09 RMAN> Backup current controlfile for standby format = 'd: \ backup \ % d _ % S. Bak '; Start backup from 17-2 to 09Use channel ora_disk_1Channel ora_disk_1: Start all data file backup SetsChannel ora_disk_1: Specifies the data file in the

I have paid a lot of effort to improve it ........ You only need to define the following basic variables in the batch processing to generate clone instances of any Sid to any directory. Set oracle_base = D: \ Oracle10g \ app \ oracle \ product \ 10.2.0Set oracle_sid = tempSet syspwd = OracleSet data_base = D: \ data Not blow: study my scripts and you will get a lot! Known problems: you must understand the backup content before you can write a

This article mainly describes the MySQL attack tampering data, using the backup from the library and the Binlog of the main library for incomplete recovery. Welcome to reprint, please indicate the author, source.Author: Zhangqq:176036317If you have questions, please contact. First, the discovery of problemsToday is 2014-09-26, development early in the morning that the

MySQL database under attack tampering (using backup and binlog for data recovery), mysqlbinlog This article mainly describes how MySQL is attacked and tampered with data, and uses slave database backup and binlog of the master database