oracle recover database using backup controlfile

the source database practice to the D: \ oracle \ product \ 10.1.0 \ db_1 \ databas \ directory, and name the file initclne. ora, open the file and replace "practice" with "clne" After modification, see: C) Database Password FileCreate a file by using the command line and place it in D: \

Three methods of Oracle database backup and recovery Oracle database has three standard backup methods: Export/Import (EXP/IMP), hot backup, and cold

;;connect/as SYSDBASql>;shutdown Normal;(2) use copy command to back up all time files, redo log files, control files, initialization parameter filesSQLGT;;CP (3) Restart Oracle databaseSql>;startup Third, hot backupHot backup is a way to back up the database in Archivelog mode, in case the database is running. So if y

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

Label:First, why need data backup The main reasons for data loss: 1, media failure. 2, the user's error operation. 3, the server's complete collapse. 4, computer viruses. 5. Unforeseen factors. The fault types in Oracle are divided into the following 4 categories. 　　1. Statement failure: A logical failure to execute a SQL statement procedure can cause a statement failure. If a user writes an invalid SQL st

database. The Hot Backup command file consists of three parts:1. Backup of one tablespace and one tablespace in a data file.(1) set the tablespace to the backup state.(2) back up the data files in the tablespace(3) restore the tablespace to the normal state.2. Back up archive log files(1) temporarily stop the archivin

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

it is to back up the database. The following describes how to back up and restore the database with ORACLE7 as an example. ORACLE databases have three standard backup methods: EXPORT/IMPORT, cold backup, and hot backup. Exporting

and frm files, thus adding convenience and functionality. Innobackupex starts xtrabackup until xtrabackup copies the data file, then executes flush TABLES with READ lock to block the new write-in and brushes the MyISAM table data to the hard disk. Then copy the MyISAM data file and finally release the lock.4. The backup MyISAM and InnoDB tables will eventually be consistent, and at the end of the preparation (prepare) process, the InnoDB table data h

, but we still have to back up 50g.This is the disadvantage of Lengbei.A condition where the backup may be incomplete or the junk data is backed up when the cold standby is being made. Therefore, we must be in the database to see whichever.Typically, the main object of Lengbei is datafile,controlfile and redo log file. We can use a few views to seewhere they hide

The following articles mainly introduce how to automatically back up Oracle databases under UNIX. The following describes the specific solutions, such as tape backup and remote backup, I hope this will help you in your future studies. The following describes the specific content of the text.I believe that many system administrators are doing the same job every da

, the target database is the database that needs to be backed up, a recovery directory can register multiple target databases, the command to register the target database is:$>rman Target Internal/password catalog Rman/[email protected];Rman>register database;Database regist