Knowledgebase:
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..
(0 vote(s))
Helpful
Not helpful

Comments (0)
Post a new comment
 
 
Full Name:
Email:
Comments:
CAPTCHA Verification 
 
Please enter the text you see in the image into the textbox below (we use this to prevent automated submissions).