热备份(hot backup)和RMAN备份共存的系统问题(国外英语资料).docVIP

热备份(hot backup)和RMAN备份共存的系统问题(国外英语资料) Lets use this example to illustrate the risk and avoidance of Hot backup and RMAN backup. Test case: First, we confirm all the data files that belong to the DB: [oracle @test1 ~] $sqlplus/as sysdba SQL * Plus: Release 10.2.0.1.0 - Production on Fri Jan 20 05:28:16 2012 Copyright (c) 1982, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL select name from v $datafile; The NAME -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- / home/oracle/app/oracle/orcl/system01. DBF / home/oracle/app/oradata/orcl/undotbs01. DBF / home/oracle/app/oradata/orcl/sysaux1.dbf / home/oracle/app/oracle/orcl/users01. DBF / home/oracle/app/oradata/orcl/test2.dbf SQL select name from v $tablespace The NAME -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- The SYSTEM UNDOTBS1 SYSAUX TEMP The USERS TEST2 6 rows selected. We used hotbackup to back up the table space test2, before we created the object: SQL create table hot_writting_t (col1 number (10)) tablespace test2 The Table is created. Start the backup table space test2: SQL alter tablespace test2 begin backup; In Tablespace altered. SQL insert into hot_writting_t values (1); 1 row created. SQL commit; Commit to complete. SQL insert into hot_writting_t select * from hot_writting_t. 1 row created. SQL / 2 rows created. SQL / 4 rows created. SQL / 8 rows created. SQL commit; Commit to complete. Check the current log sequence SQL alter system switch logfile; The System is altered. SQL archive log list; The Database log