本文共 2841 字，大约阅读时间需要 9 分钟。

   
	
    
RMAN> show all;
	
    
		
    
		
    
			??ORADATA????RMAN?????		
		
    
		
    
			CONFIGURE RETENTION POLICY TO REDUNDANCY 1;		
		
    
		
    
			CONFIGURE BACKUP OPTIMIZATION OFF; # ????		
		
    
		
    
			CONFIGURE DEFAULT DEVICE TYPE TO DISK; # ????		
		
    
		
    
			CONFIGURE CONTROLFILE AUTOBACKUP ON; # ??????		
		
    
		
    
			CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # ????		
		
    
		
    
			CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # ????		
		
    
		
    
			CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # ????		
		
    
		
    
			CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # ????		
		
    
		
    
			CONFIGURE MAXSETSIZE TO UNLIMITED; # ????		
		
    
		
    
			CONFIGURE ENCRYPTION FOR DATABASE OFF; # ????		
		
    
		
    
			CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # ????		
		
    
		
    
			CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOA
    
			TRUE ; # ????		
    
		
    
		
    
			CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # ????		
		
    
		
    
			CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'D:\ORACLE\PRODUCT\11.2.0\DBHOME_1\DATABA
    
			SE\SNCFORADATA.ORA'; # ????		
    
		
    
		
    
			RMAN> backup database;		
		
    
		
    
			???????22-8-14		
		
    
		
    
			?????????		
		
    
		
    
			
     
ORA_DISK_1: SID=194
			
     
ORACLE_DISK_1: ??DISK??
			
     
???????
			
     
E:\H2DATA\H2_BUSI.DBF
			
     
D:\ORACLE\ORADATA\ORADATA\SYSTEM01.DBF
			
     
D:\ORACLE\ORADATA\ORADATA\SYSAUX01.DBF
			
     
E:\H2DATA\H2_BUSI_INDX.DBF
			
     
D:\ORACLE\ORADATA\ORADATA\UNDOTBS02.DBF
			
     
E:\H2DATA\H2DB.DBF
			
     
D:\ORACLE\ORADATA\ORADATA\EXAMPLE01.DBF
			
     
E:\H2DATA\H2DB_INDEX.DBF
			
     
E:\H2DATA\H2_TEST.DBF
			
     
E:\H2DATA\H2_TEST_INDX.DBF
			
     
E:\H2DATA\H2_LOG.DBF
			
     
E:\H2DATA\H2_LOG_INDX.DBF
			
     
D:\ORACLE\ORADATA\ORADATA\USERS01.DBF
			
     
E:\DATA\ORADATA\TEST.DBF
		
    
		
   
		
   
		
			???????22-8-14		
		
   
		
			?????SPFILE?????		
		
   
		
			?????????E:\ORADATA\FAST_RECOVERY_AREA\ORADATA\BACKUPSET\2014_08_22\		
		
   
		
			??????????O1_MF_NNNDF_TA
   
			20140822T095727_9ZF8W8W8_.BKP		
		
   
		
			?????SPFILE????????		
		
   
		
			SQL> startup mount		
		
   
		
			????????1068937216??		
		
   
		
			?????2182592??		
		
   
		
			?????746586688??		
		
   
		
			???????314572800??		
		
   
		
			??????5595136??		
		
   
		
			SQL> alter database open resetlogs;		
		
   
		
			?????ORA-01152: 1		
		
   
		
			?????ORA-01110: 1: 'D:\ORACLE\ORADATA\ORADATA\SYSTEM01.DBF'		
		
   
		
			SQL> recover database using backup controlfile until cancel;		
		
   
		
			???????22-8-14 09:57:28		
		
   
		
			????????E:\ORADATA\FAST_RECOVERY_AREA\ORADATA\ARCHIVELOG\2014_08_22\O1_MF_1_217_%U_.ARC		
		
   
		
			????????		
		
   
		
			SQL> alter database open resetlogs;