archive log list;
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 7
Current log sequence 9
SQL> startup mount force
ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 92276788 bytes
Database Buffers 104857600 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> shutdown immediate;
startup mount;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 92276788 bytes
Database Buffers 104857600 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> recover database ;
Media recovery complete.
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> shutdown immediate
startup ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict;
SP2-0714: invalid combination of STARTUP options
SQL> startup restrict;
ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 92276788 bytes
Database Buffers 104857600 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> SQL> SQL> startup mount force;
ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 92276788 bytes
Database Buffers 104857600 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database archivelog;l
2
SQL>
SQL>
SQL> alter database archivelog;
alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode
SQL> >startup restrict;
SP2-0734: unknown command beginning ">startup r..." - rest of line ignored.
SQL> shutdown immediate;
startup ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict;
SP2-0714: invalid combination of STARTUP options
SQL> startup restrict;
ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 92276788 bytes
Database Buffers 104857600 bytes
Redo Buffers 7168000 bytes
Database mounted.
Database opened.
SQL> SQL> shutdown;
startup mount;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> ORACLE instance started.
Total System Global Area 205520896 bytes
Fixed Size 1218508 bytes
Variable Size 92276788 bytes
Database Buffers 104857600 bytes
Redo Buffers 7168000 bytes
Database mounted.
SQL> alter database archivelog;
Database altered.
SQL> alter system set log_archive_dest_1='LOCATION=/arch/prod/arch1';
System altered.
SQL> alter system set log_archive_dest_2='LOCATION=/arch/prod/arch2';
System altered.
SQL> alter system database open;
alter system database open
*
ERROR at line 1:
ORA-02065: illegal option for ALTER SYSTEM
SQL> alter database open;
Database altered.
SQL>
Restricting Access
to a Database at Startup
You can start an instance and mount and open a database in restricted mode so
that the database is available only to administrative personnel (not general
database users). Use this mode of database startup when you need to accomplish
one of the following tasks:
- Perform. an export or import of database data
- Perform. a data load (with SQL*Loader)
- Temporarily prevent typical users from using data
- During certain migration and upgrade operations
Typically, all users with the CREATE
SESSION system privilege can connect to an open database. Opening
a database in restricted mode allows database access only to users with both the
CREATE SESSION and RESTRICTED SESSION system privilege. Only database
administrators should have the RESTRICTED
SESSION system privilege.
Start an instance (and, optionally, mount and open the database) in
restricted mode by using the STARTUP command
with the RESTRICT option:
STARTUP RESTRICT
Later, use the ALTER SYSTEM statement to
disable the RESTRICTED SESSION feature:
ALTER SYSTEM DISABLE RESTRICTED SESSION;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13750068/viewspace-758484/
，如需转载，请注明出处，否则将追究法律责任。
