AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
![]() Full Stop! Ready to work until you are 80? IT & Tech Careers If it happens again then you may want to review your career choice. Start your database normally then configure RMAN to do controlfile Rather than a cold backup then you will have to use:Ħ. ![]() SIZE 1024M REUSE AUTOEXTEND ON NEXT 655360 MAXSIZE 32767M Ĥ. GROUP 4 '/u05/app/oradata/*DB_NAME*/redo/redo04.log' SIZE 500M BLOCKSIZE 512 GROUP 3 '/u04/app/oradata/*DB_NAME*/redo/redo03.log' SIZE 500M BLOCKSIZE GROUP 2 '/u03/app/oradata/*DB_NAME*/redo/redo02.log' SIZE 500M BLOCKSIZE GROUP 1 '/u02/app/oradata/*DB_NAME*/redo/redo01.log' SIZE 500M BLOCKSIZE STARTUP NOMOUNT pfile='/u00/app/oracle/admin/*DB_NAME*/pfile/init.ora_temp'ĬREATE CONTROLFILE REUSE DATABASE "*DB_NAME*" RESETLOGS ARCHIVELOG ![]() Gather a list of all the database datafiles and log file locations Edit your init.ora and add multiple control files in theĬontrol_files parameter - this should help you avoid this again!Ģ.
0 Comments
Read More
Leave a Reply. |