Alibabacloud.com offers a wide variety of articles about oracle recover database using backup controlfile, easily find your oracle recover database using backup controlfile information here online.
Oracle Database Backup and upgrade, oracle Database Backup Log on to the server where the database is located as an oracle user. For example
database file system backup is not valid when the database is in an open state.Here is a complete example of a cold backup.(1) Closing the databaseSqlplus/nologSql>;connect/as SYSDBASql>;shutdown Normal;(2) use copy command to back up all time files, redo log files, control files, initialize parameter filesSQLGT;;CP (
database to the mount stage:Startup mount + 6. After the database is mounted, perform the recover process:Recover database using backup controlfile + The
First, cold backup1, cold backup occurs when the database has been shut down normally, before making a cold backup, you usually need to know the name of the backup file and the path Copy Code code as follows: Sql>select name from V$datefile; Sql>select name from V$
This forum article mainly introduces the Oracle database backup strategy related concepts and the use of attention, detailed content please refer to the following First, understand the importance of backup It can be said that from the day the computer system was born, there is the concept of
When we use a database, we always want the contents of the database to be reliable and correct, but because of the calculation Failure of the machine system (including machine failure, media failure, misoperation, etc.), the database may sometimes be destroyed, How to recover data as soon as possible is a top priority.
Oracle Database Change and backup database step tutorial, oracle backup tutorialOracle Database Change 1. Stop the Application Middleware involved/lock the
logfile; --Switch Third logSql>shutdown immediate;If the tt.dbf file is corrupted.Sql>startupOra-01157:cannot identify/lock data file 6-see DBWR trace fileOra-01110:data file 6: ' C:\ORACLE\ORADATA\TEST\TT. DBF 'Sql>select * from V$recover_file;file# ONLINE Online_error change# time---------- ------- ------------------------- ----------- -------------6 Online online FILE not FOUND 0Sql>alter Database dataf
recovery of the standby librarysql> ALTER database RECOVER MANAGED STANDBY database CANCEL;Start Standby to ReadOnly modesql> ALTER DATABASE OPEN;Set up a standby to apply log statussql> ALTER database RECOVER MANAGED STANDBY
1. Re-create initialization files, important parameters include Control_files,db_name,instance_name,Background_dump_dest,core_dump_dest,user_dump_dest,\Db_block_size=8192,db_cache_size,db_domain,Large_pool_size,pga_aggregate_target,shared_pool_size,Sort_area_size,undo_management,undo_retention,undo_tablespace You can create an initial parameter file for modification in the following ways: @ From the backup parameter file. @ from other normal-runnin
to recover）2, the implementation of the table record recoveryThe query is usually based on time, the query statement mode is SELECT * from TB as of timestampTo_timestamp (Time, ' yyyy-mm-dd hh24:mi:ss '); TB refers to the name of a table, which is a point in timesuch as SELECT * from Scott.test as of timestamp to_timestamp (' 2009-12-1120:53:57 ', ' yyyy-mm-dd hh24:mi:ss ');If you have data, recovery is extremely straightforward, with the statement F
oracle| Backup | recovery | data | database Oracle database Backup and Recovery ----When we use a database, always want the content of the databa
A Some advantages of RMAN backup 1. RMAN detects and reports corrupted blocks of data. 2. RMAN can connect to the backup database without having to put the table space into hot backup mode. Additional build redo logs are generated during hot backup. 3. RMAN automatically
As a programmer, database operation is necessary, but if the operation is wrong, generally will cause more serious consequences. Today, accidentally, did a worried thing, will be using the organization of the wrong operation of the delete, suddenly the brain a little hypoxia, feeling a circle (I believe that no data backup and rollback experience of the small par
In the process of building a logical repository based on physical standby, we run:ALTER DATABASE recover to logical standby READDB;stuck, and alert does not have an error message, extremely depressed, consulted others, chat records such as the following:Our business is a passport application that cannot be stopped or stopped very troublesome, in short, the medicine can not stop.After groping, we get an expe
Java implements Oracle database backup and oracle Database Backup Today, we will paste an Oracle database
Case 3: (Recover tablespace, database open state) --database Recover data files in open state (except system tablespace) (1) Simulation Environment: 06:10:52 sql> INSERT INTO scott.t01 values (4); 1 row created. 06:13:12 sql> INSERT INTO scott.t01 values (5); 1 row created. 06:13:13 sql> INSERT INTO scott.t01 va
Tags: transaction show development based on SQL statement Roo manual log fileWhat if the database was accidentally accidentally manipulated and not backed up in time? This is probably a kind of problem that the general coder often encounters.I accidentally deleted a database today, but the last backup was 1 weeks ago, and the only solution was to
First, recover via file descriptor (descriptor) (RM delete data file not backed up) Scene: misoperation Delete data file tp10.dbf Rm-rf/u01/app/oracle/oradata/bxdb/tp10.dbf Select Ts#,file#,name,bytes,status from V$datafile; Ps-ef |grep dBW |grep-v grep Cd/proc/12308/fd 1. Method One: Online recoveryCp/proc/13979/fd/264/u01/app/oracle/oradata/ocp/newtp12.db
;connect/as sysdbasql>shutdown normal; (2) use copy command to back up all time files, redo log files, control files, Initialize parameter file sql>cp (3) Restart Oracle database NBSP; Third, hot backupA hot backup is a method of backing up a database using the Archivelog m
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
