Then as root switch to this user so have to have all the oracle variables in your path,
You MUST log on as sysdba that's the only internal user allowed to access the database in such situations. eg if the owner owner/user is oradba
# su - oradba
Now you can invoke sqlplus
$sqlplus /nolog
SQL>conn / as sysdba
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 482
Next log sequence to archive 482
Current log sequence 487
Check the Archive destination and delete all the logs
SQL> shutdown immediate
Database closed.
Database dismounted.
SQL> startup mount
ORACLE instance started.
Total System Global Area 3240239104 bytes
Fixed Size 2217712 bytes
Variable Size 2835351824 bytes
Database Buffers 385875968 bytes
Redo Buffers 16793600 bytes
Database mounted.
SQL> alter database noarchivelog;
Database altered.
SQL> alter database open;
Database altered.
SQL> archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 482
Current log sequence 487
You should see Automatic archival Disabled
You MUST log on as sysdba that's the only internal user allowed to access the database in such situations. eg if the owner owner/user is oradba
# su - oradba
Now you can invoke sqlplus
$sqlplus /nolog
SQL>conn / as sysdba
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 482
Next log sequence to archive 482
Current log sequence 487
Check the Archive destination and delete all the logs
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance started.
Total System Global Area 3240239104 bytes
Fixed Size 2217712 bytes
Variable Size 2835351824 bytes
Database Buffers 385875968 bytes
Redo Buffers 16793600 bytes
Database mounted.
Database altered.
Database altered.
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 482
Current log sequence 487
Komentar
Posting Komentar