C:\Documents and Settings\Administrator>sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Jun 28 10:25:39 2010
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
SQL> select * from tab;
select * from tab
*
ERROR at line 1:
ORA-01219: database not open: queries allowed on fixed tables/views only
Shutdown the database first
SQL> shutdown immediate; ORA-01109: database not open Database dismounted. ORACLE instance shut down.
Start the database
SQL> startup ORACLE instance started. Total System Global Area 599785472 bytes Fixed Size 1250356 bytes Variable Size 180358092 bytes Database Buffers 411041792 bytes Redo Buffers 7135232 bytes Database mounted. ORA-16038: log 2 sequence# 135 cannot be archived ORA-19809: limit exceeded for recovery files ORA-00312: online log 2 thread 1: 'F:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG'
Problem: The value db_recovery_file_dest_size is not enough for generate archive log
SQL> show parameter DB_RECOVERY_FILE_DEST_SIZE; NAME TYPE VALUE ------------------------------------ ----------- ------------------- db_recovery_file_dest_size big integer 2G
Solution: Increase the value of db_recovery_file_dest_size following way.
SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = 10G; System altered.
Now open the database.
SQL> alter database open; Database altered.
Nenhum comentário:
Postar um comentário