Today we will see how to take backup of Oracle Database when your database is in NOARCHIVELOG mode.

Step 1: Check your database details

In the above output, we can see that the database is in NOARCHIVELOG mode and we have checked the db_recovery_file_dest_size parameter where we can see that it has enough space available to take a new backup.

Step 2: Let’s connect to RMAM and try taking backup

RMAN threw an error that we cannot take backup of the database when the database is in NOARCHIVELOG mode. Let’s try changing open mode of the database

Step 3: Let’s try changing open_mode of database

Step 4: I have changed database state to mount state. Now let’s take a backup

Step 5: Now let’s open database in open mode

Step 6: You can check backup we took in rman using list backup command

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel: https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.