SQL> SELECT LOG_MODE FOR V$DATABASE;
SQL> SHOW PARAMATER LOG_ARCHIVE_START
SQL> SHOW PARAMATER LOG_ARCHIVE_DEST_1
SQL> ALTER SYSTEM SET LOG_ARCHIVE_START=TRUE
SCOPE=SPFILE;
SQL> SHUT IMMEDIATE;
SQL> STARTUP MOUNT
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ALTER DATABASE OPEN;
No comments:
Post a Comment