Monday, 11 December 2017

database hange due to archive location full

#####database hange due to archive location full


1
 if you are not able to login into sqlprompt
move the old archive file to new location using mv command

2
if you are able to login into sqlprompt
change the archive location 
ALTER SYSTEM SET log_archive_dest_1='location=/oradata/export/archive' SCOPE=BOTH;

No comments:

Post a Comment