recover database using backup controlfile until sequence

using scripts to recover a database in SQL Author : CC Abba 2014-6-15 in Daily SQL How to recover a database in the operation of a database Use Master Drop Database SCS1 RESTOR

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

Execute SQL Server database backup and SQL database backup using Windows batch processing commands Create mybackup. bat and enter the following content to directly run the script to start automatic database

Cross-platform cross-version database migration using RMAN in the same byte sequence Cross-platform transmission DatabaseRMAN's convert database command is used to move the entire database from one platform to another. When the source platform and the target platform are in

(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) copy relevant files to

. 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

Tags: style blog io os using strong for file dataLet the novice understand the backup order--1, tower Build environment (generate test data and backup files)/* Test environment: Microsoft SQL Server R2 (RTM)-10.50.1600.1 (X64) APR 2 15:48:46 Copyright (c) Microsoft Corporatio N Enterprise Edition (64-bit) on Windows NT 6.1 2. Restore sequenceUse Mastergo--1. Rest

rolls back the data that has been modified but not committed.2. Xtrabackup remembers log sequence number (LSN) at startup, and copies all data files. The copy process takes some time, so if the data file changes during this period, the database will be at a different point in time. At this point, Xtrabackup runs a background process that monitors the transaction log and copies the latest modifications from

:\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 $

transferred from the HP-UX to the Linux platform. However, you can create a new database on the target platform and use the tablespace transfer function to transmit the required tablespace from the source database to the target database using cross-platform and cross-byte sequence