oracle recover database using backup controlfile

. Dbf D:\ORACLE11G\ORADATA\ORCL\STUDYDEMO_DATA01. Dbf Redo Log Files Online Sql:select * from V$logfile Result: ------------------------------ D:\ORACLE11G\ORADATA\ORCL\REDO03. LOG D:\ORACLE11G\ORADATA\ORCL\REDO02. LOG D:\ORACLE11G\ORADATA\ORCL\REDO01. LOG Back up the above files Step 2: Because the target machine only installed Oracle software, no database installed, so you need to build a

---- When we use a database, we always hope that the content of the database is reliable and correct. However, due to computer system faults (including machine faults, media faults, and misoperations ), databases may also be damaged, so it is imperative to restore data as soon as possible. If the database is backed up at ordinary times, it is easy to restore data

backup method to trace the file: 1) record the command information of the control file to the trace file: SQL> alter database backup controlfile to trace; 2) determine the location and name of the tracking file: SQL> select a. spid from v $ process a, v $ session B where a. addr = B. PADDR and B. USERNAME = 'sys' SQL>

target directory under log(3) restart the archive Process(4) back up the archived redo log file3. Use the alter database bachup controlfile command to back up control filesAdvantages of Hot Backup:1. Data can be backed up at the tablespace or database file level. The backup

Oracle databases have three standard backup methods: Export/Import (EXP/IMP), hot backup, and cold backup. Exporting spare parts is a logical backup, while cold backup and hot backup ar

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

This is the most recently written batch of an Oracle database automatic backup, which has been tested for normal operation and is recorded as follows. Includes two parts, logical backup and cold backup, if there is not complete, but also to see the master guidance of this ar

Restore databases in different locations Restore databases in different locations Machine: Select instance_name from v $ instance; Select name from v $ database; Select name from v $ datafile; Log query mode: Archive log list; Shutdown immediate; Startup mount; Change the log archive mode: Alter database archivelog; Alter database open; Alter system archive log

Machine A: Select instance_name from V$instance; Select name from V$database; Select name from V$datafile; Query log mode: Archive log list; Shutdown immediate; startup Mount; Change Log to archive mode: ALTER DATABASE Archivelog; ALTER DATABASE open; Alter system archive log current; Select name from V$archived_log; To turn on control file tracking: ALTER

recovery time requirement will be shorter and shorter. This method is backed up using EXP/EXPD tools, it cannot meet the requirements of real-time backup. In the restoration process, the environment is demanding and the restoration process is cumbersome. In addition, part of the data is definitely lost. The amount of data lost is related to the backup frequency.

Today, we encountered Oracle database sequence problems, simply to a full library of backup and recovery. As follows Imp/exp Way Table mode Backup: Oracle@sencloudserver:exp dhoffice/dhoffice rows=y indexes=n compress=n buffer=65536. DMP Log=exp_tianle_090101.log Tables=dav

/orcl/redo3a.rdo /u01/app/oracle/oradata/orcl/redo3b.rdo /u01/app/oracle/oradata/ Orcl/redo1b.rdo7) View Control filesSql> select name from V$controlfile; NAME ------------------------------------------------------------ /u01/app/oracle/oradata/orcl/ Control01.ctl /u01/app/

= 50G;Backup full database filesperset 10 include current controlfile format '/backup/fullbak _ % d _ % T _ % s _ % P'Plus archivelog format'/backup/archbak _ % d _ % T _ % s' delete all input;Release channel d1;Release channel d2;} Bac