SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 6341787648 bytes
Fixed Size 2093488 bytes
Variable Size 5402267216 bytes
Database Buffers 922746880 bytes
Redo Buffers 14680064 bytes
Database mounted.
SQL> ALTER SYSTEM SET sga_target = 4294967296 SCOPE=BOTH
2 ;
Fixed Size 2093488 bytes
Variable Size 5402267216 bytes
Database Buffers 922746880 bytes
Redo Buffers 14680064 bytes
Database mounted.
SQL> ALTER SYSTEM SET sga_target = 4294967296 SCOPE=BOTH
2 ;
System altered.
SQL> alter database mount
2 ;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted
2 ;
alter database mount
*
ERROR at line 1:
ORA-01100: database already mounted
SQL> alter database open;
Database altered.
SQL> show parameter db_recovery_file_dest_size;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 400G
SQL> select * from v$recovery_file_dest;
------------------------------------ ----------- ------------------------------
db_recovery_file_dest_size big integer 400G
SQL> select * from v$recovery_file_dest;
NAME
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
+ORABK
4.2950E+11 1.0887E+11 3.7276E+10 1680
--------------------------------------------------------------------------------
SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
+ORABK
4.2950E+11 1.0887E+11 3.7276E+10 1680
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/196700/viewspace-664921/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/196700/viewspace-664921/