ITPub博客

首页 > Linux操作系统 > Linux操作系统 > recreate control

recreate control

原创 Linux操作系统 作者:singrape 时间:2013-05-02 17:10:25 0 删除 编辑
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博客 ” ,链接:https://blog.itpub.net/9482301/viewspace-759629/ ,如需转载,请注明出处,否则将追究法律责任。

下一篇: simple stream
请登录后发表评论 登录
全部评论

注册时间:2008-12-22

  • 博文量
    3
  • 访问量
    7947