recreate control

when using script. to recreate control ,step as follow
CREATE CONTROLFILE
   SET DATABASE testorcl
   LOGFILE GROUP 1 'F:\APP\ADMINISTRATOR\ORADATA\TESTORCL\REDO03.LOG' size 50m,                    
           GROUP 2 'F:\APP\ADMINISTRATOR\ORADATA\TESTORCL\REDO02.LOG' size 50m,
           GROUP 3 'F:\APP\ADMINISTRATOR\ORADATA\TESTORCL\REDO01.LOG' size 50m                    
           datafile 'F:/app/Administrator/oradata/testorcl/system01.dbf',
            'F:/app/Administrator/oradata/testorcl/sysaux01.dbf',
--            'F:/app/Administrator/oradata/testorcl/temp01.dbf',
            'F:/app/Administrator/oradata/testorcl/undotbs01.dbf',
            'F:/app/Administrator/oradata/testorcl/users01.dbf'
            resetlogs
   MAXLOGFILES 50
   MAXLOGMEMBERS 3
   MAXLOGHISTORY 400
   MAXDATAFILES 300
   MAXINSTANCES 6
   ARCHIVELOG;

1.shutdown database
   shutdown immediate
   delete all the controlfiles

2. startup the instance to nomount
    startup nomount

3. exe the script. below

4. open the database resetlogs
alter database open resetlogs;

at this time all the configure of rman shlould reconfig
and nothing in both view V$RMAN_BACKUP_JOB_DETAILS and V$RMAN_BACKUP_SUBJOB_DETAILS
but you can catalog the backup piece using following step

catalog recovery area; when your database is using recovery area to manage all the backups

catalog "PATH of YOU backup PIECE"; when your database is using other path you define,bu recovery area.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9482301/viewspace-759629/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9482301/viewspace-759629/