Live Chat Software by Kayako |
RMBackup : The DB does not start after the RMAN backup not working and the allocated space is used.
Posted by Syed Qutubuddin, Last modified by Syed Qutubuddin on 14 July 2019 09:51 AM
|
|
RMBackup The DB does not start after the RMAN backup not working and the allocated space is used. Archive Parameter / RMBACKUP / BACKUP / MC / ORACLE / Solution I: Enter user-name: / as sysdba SQL> startup mount SQL> alter system set db_recovery_file_dest_size=8G scope=both; SQL> shutdown immediate; SQL> startup ******************************* Solution II: SQL>STARTUP MOUNT SQL> Show parameter DB_RECOVERY_FILE_DEST_SIZE; SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 80G SCOPE=BOTH ; SQL>ALTER DATABASE OPEN; D:\OracleApp\flash_recovery_area\fmcagt\ARCHIVELOG Delete the old log file to create space. ************************************* to set the path to oracle home db ... SQL> Show parameter DB_RECOVERY_FILE_DEST_SIZE; SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 60G SCOPE=BOTH ; *************************************************** Solution III: Steps to activate the archive log To bring the database in archive mode in opera / or any other databases follow these steps. Login into sqlplus Start->Run->SqlPlus Enter user-name : sys@opera as sysdba (@opera can be vary as per the alias name of the database) password : opera10g (This is the default password of opera database this can be vary for some other products databases) SQl> Shut immediate; After the database was successfully shut down. Change the initialization parameter file and unmarked the Archive path and format lines. SQL>startup mount; SQL>alter database archivelog; SQL>alter database open; If you want to see where the archives are getting generated hit the below command. SQL > Archive log list; Here you will find the path where the archives are getting generated. Regards, Mohammad Abdul Khader.. | |
|
Comments (0)