rman backup, backup after the destruction of data files, and then use the backup database to restore data files

rman backup, backup after the destruction of data files, and then use the backup database to restore data files RMAN backup, backup after the destruction of data files, and then use the backup database to restore data files. Use RMAN backup, backup after the destruction of data files, and then use the backup database to restore data files. Test as follows: 1 into the RMAN, close the database, start loading state C:Documents and target Settingspengwzh>rman / 2 perform backup scripts {run Configure channel type disk maxpiecesize = 2G FORMAT='c:\ora_bak\%U'= device; SQL'alter archive log system current'; Allocate channel disk1 type disk; Backupset full compressed format='c:\ora_bak\%d_t%t_s%s_%U.bak'tag'fullbak' (database) backup as; Release channel disk1; Allocate channel Disk2 type disk; BACKUP as backupset FORMAT ARCHIVELOG ALL delete compressed'c:\ora_bak\al_%d_t%t_s%s_%U.arcbak'input; Release channel disk2; Allocate channel Disk3 type disk; Backup current controlfile format='c:\ora_bak\ctl_%d_t%t_s%s_%U.ctlbak'; Release channel disk3; SQL'alter archive log system current'; } 3.-- uses test users to enter sqlplus C:Documents and Settingspengwzh>sqlplus test/testSQL*Plus: Release 10.2.0.1.0 - on Friday April 3 14:29:52 2009, Production Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect to: Oracle Database Enterprise Edition 10.2.0.1.0 Release - Production 10g With the Partitioning, OLAP Data Mining and options Create table and insert data SQL> create TMP (a varchar (2)) (table); Table created. SQL> insert TMP values ('1') into; 1 lines have been created. SQL> insert TMP values ('2') into; 1 lines have been created. SQL> commit; Submit complete. SQL> select * from tmp; A - One Two - connect the SYSDBA user, close the database, delete the data file 5 SQL> conn / as sysdba; Connected. SQL> shutdown immediate; Database closed. Database has been uninstalled. ORACLE routine has been closed. SQL> host del D:oracleproduct10.2.0oradataorcltest01.ora; - start the database, start failure, quit sqlplus operation as follows: SQL> startup; ORACLE routine has been started. Total System Area 289406976 bytes Global Fixed Size 1248576 bytes Variable Size 125829824 bytes Database Buffers 155189248 bytes Redo Buffers 7139328 bytes Database loaded. ORA-01157: cannot identify / lock the data file 5 - see the DBWR trace file ORA-01110: data file 5:'D:ORACLEPRODUCT10.2.0ORADATAORCLTEST01.ORA' SQL> exit; - enter the RMAN command prompt, use RMAN backup database to restore deleted data files 5 C:Documents and target Settingspengwzh>rman / Recovery Manager: Release 10.2.0.1.0 - on Friday 3 April 14:34:52 2009 Production Copyright (c) 1982, 2005, Oracle. All rights reserved. Is connected to the target database: ORCL (DBID=1210922825, not open) RMAN> shutdown immediate; Use the destination database control file instead of the recovery directory Database unloaded Oracle instance is closed RMAN> startup mount; Is connected to the target database (not started) Oracle instance has been started Database is loaded System global area totals 289406976 bytes Fixed Size 1248576 bytes Variable Size 125829824 bytes Database Buffers 155189248 bytes Redo Buffers 7139328 bytes RMAN> restore datafile 5; Start restore on 03-4 month -09 Channel assignment: ORA_DISK_1 Channel ORA_DISK_1: sid=156 devtype=DISK Channel ORA_DISK_1: is starting to recover the data file backup set Channel ORA_DISK_1: is specifying the data file to be restored from the backup set Restoring data file 00005 to D:ORACLEPRODUCT10.2.0ORADATAORCLTEST01.ORA Channel ORA_DISK_1: is reading backup segment D:BACKUP3KBI3RK_1_1 Channel ORA_DISK_1: has been restored to the backup section 1 Segment handle = D:BACKUP3KBI3RK_1_1 = TAG20090403T142556 Channel ORA_DISK_1: recovery completed, with: 00:00:08 Complete restore at 03-4 months -09 RMAN> recover datafile 5; Start recover on 03-4 month -09 Use channel ORA_DISK_1 Starting media recovery Media recovery completed, with: 00:00:03 Complete recover at 03-4 months -09 RMAN> - restore success, open database, exit RMAN RMAN> alter database open; Database open RMAN> exit; Recovery manager completed. - use test users to connect to sqlplus, just after the new table and data backup exists C:Documents and Settingspengwzh>sqlplus test/test SQL*Plus: Release 10.2.0.1.0 - on Friday April 3 15:01:47 2009, Production Copyright (c) 1982, 2005, Oracle. All rights reserved. Connect to: Oracle Database Enterprise Edition 10.2.0.1.0 Release - Production 10g With the Partitioning, OLAP Data Mining and options SQL> select * from tmp; A - One Two SQL> Tmp table exists, the data is not lost, although the data file has been deleted, but can be restored to the deleted data files when the database state. Attached: the test environment is as follows Database archiving mode SQL> conn / as sysdba; Connected. SQL> archive log list; Database log mode Automatic archiving disabled Archive endpoint USE_DB_RECOVERY_FILE_DEST The first online log sequence 1 Current log sequence 3 SQL> View database version SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database Enterprise Edition 10.2.0.1.0 Release - Prod 10g PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Windows: Version 10.2.0.1.0 - Production 32-bit NLSRTL Version