ORACLE non-archive to archive

1. archive can only be changed under mount.

SQL> shutdown immediate
The database has been closed.
The database has been detached.
The ORACLE routine has been disabled.
SQL> startup mount;
The ORACLE routine has been started.

Total System Global Area 778387456 bytes
Fixed Size 1374808 bytes
Variable Size 377488808 bytes
Database Buffers 394264576 bytes
Redo Buffers 5259264 bytes
The database has been loaded.
SQL> alter database archivelog;

The database has been changed.

SQL> archivelog list;
SP2-0734: Unknown command starting with "archivelog..."-ignore the remaining lines.
SQL> archive log list;
Database Log mode archiving Mode
Enable automatic archiving
Archiving end point USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 58
Next archive log sequence 60
Current Log sequence 60

 

This article is from the "welove" blog. For more information, contact the author!