Enable ARCHIVELOG mode for database

echo "******************************************* "
 echo "  * Enable ARCHIVELOG mode for database"
 echo ""
 echo "The script may appear to hang at the SQL prompt"
 echo "when the database is shutting down and being"
 echo "opened. Wait a few minutes and it should progress."
 echo "******************************************* "
 sqlplus "/ as sysdba" << EOF
 set echo on
 ALTER SYSTEM SET db_recovery_file_dest_size = 7000M SCOPE=BOTH; 
 shutdown immediate
 startup mount
 alter database archivelog;
 alter database open;
 archive log list

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: