OpenForum RSS: ��

�� (lamer2k600)

Wed, 11 Jan 2012 09:32:37 GMT

>[�� ]
>> �� , ��
>> � �� .
>> �� ?
> �� , �� .
> �� , � ��
> �� .
> � ţ �� shutdown immediate � �ӣ, �� .. ��
> �� :(
> �� .
> �� .

�� . ��

1) �� : controlfiles, datafiles, redolog files, spfile

2) �� UPGRADE � ��

SQL> STARTUP UPGRADE
SQL> @?/rdbms/admin/catupgrd.sql
SQL> SHUTDOWN
SQL> STARTUP

�� STARTUP �� . �� alert.log ��
/home/oracle/app/oracle//diag/rdbms/<SID>/<SID>/trace/alert_<SID>.log ��

��

�� (S10)

Wed, 11 Jan 2012 06:37:56 GMT

> � �� . ��
> �� , ��
> � �� .
> �� ?

�� , �� .
�� , � �� .
� ţ �� shutdown immediate � �ӣ, �� .. �� :(
�� .
�� .

�� (lamer2k600)

Tue, 10 Jan 2012 11:55:56 GMT

>[�� ]
> bytes
> Redo Buffers
> 5238784 bytes
> Database mounted.
> ORA-01092: ORACLE instance terminated. Disconnection forced
> ORA-00704: bootstrap process failure
> ORA-39700: database must be opened with UPGRADE option
> Process ID: 22316
> Session ID: 191 Serial number: 3
> ---�� UPGRADE---

� �� . �� , �� .
�� ?

>[�� ]
> bytes
> Redo Buffers
> 5238784 bytes
> Database mounted.
> Database opened.
> SQL> connect SYS as SYSDBA
> Enter password:
> Connected.
> �� upgrade, ��
> �� upgrade?

�� (S10)

Tue, 10 Jan 2012 03:56:54 GMT

> �� sqlplus �� ?

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 803500032 bytes
Fixed Size 1339516 bytes
Variable Size 545263492 bytes
Database Buffers 251658240 bytes
Redo Buffers 5238784 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Process ID: 22316
Session ID: 191 Serial number: 3

---�� UPGRADE---

SQL> startup upgrade
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 803500032 bytes
Fixed Size 1339516 bytes
Variable Size 545263492 bytes
Database Buffers

�� (lamer2k600)

Fri, 30 Dec 2011 09:42:33 GMT

>[�� ]
> piece handle=/home/oracle/app/oracle/flash_recovery_area/LIO/backupset/2011_12_30/o1_mf_ncsnf_TAG20111230T140359_7hwnckcn_.bkp
> tag=TAG20111230T140359 comment=NONE
> channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/30/2011 14:03:59
> ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
> �� NOARCHIVELOG mode.
> �� , �� , �� :)

�� . �� , �� backup and recovery. �� , �� .

�� sqlplus �� ?

�� (S10)

Fri, 30 Dec 2011 04:07:17 GMT

� �� .

RMAN> backup database;

Starting backup at 30-DEC-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=63 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/30/2011 14:03:59
ORA-19602: cannot backup or copy active file in NOARCHIVELOG mode
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 30-DEC-11
channel ORA_DISK_1: finished piece 1 at 30-DEC-11
piece handle=/home/oracle/app/oracle/flash_recovery_area/LIO/backupset/2011_12_30/o1_mf_ncsnf_TAG20111230T140359_7hwnckcn_.bkp tag=TAG20111230T140359 comment=NONE
channel

�� (S10)

Fri, 30 Dec 2011 03:52:43 GMT

SQL> SELECT LOG_MODE FROM SYS.V$DATABASE;
SP2-0640: Not connected

��
� �� ţ ��, �� UPGRADE
� ��

��-�� ?

�� (lamer2k600)

Thu, 29 Dec 2011 15:24:12 GMT

>> ��
>> �� RMAN � �� sqlplus ? �� alert.log
>> �� ?

�� archivelog mode �� ? �� .
�� rman ? �� redo, control � data �� .
�� RMAN �� mounted.
�� archivelog mode �� RMAN'�� .

�� ?

>[�� ]
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of startup command at 12/29/2011 10:00:40
> ORA-01092: ORACLE instance terminated. Disconnection forced
> ORA-00704: bootstrap process failure
> ORA-39700: database must be opened with UPGRADE option
> Process ID: 7050
> Session ID: 191 Serial number: 7
> �� alert.log �� ӣ� ��
> ��-��

�� (��_��)

Thu, 29 Dec 2011 08:21:34 GMT

�� , �� -�� . ��, ��, �� - http://dbaspot.com/oracle-server/290-ora-39700-database-must-opened-upgrade-option-10g-r2-database.html �� ? �� ?

OpenForum RSS: �� ����������� ���� ������

�� ����������� ���� ������ (lamer2k600)

�� ����������� ���� ������ (S10)

�� ����������� ���� ������ (lamer2k600)

�� ����������� ���� ������ (S10)

�� ����������� ���� ������ (lamer2k600)

�� ����������� ���� ������ (S10)

�� ����������� ���� ������ (S10)

�� ����������� ���� ������ (lamer2k600)

�� ����������� ���� ������ (����_�����)

OpenForum RSS: ��

�� (lamer2k600)

�� (S10)

�� (lamer2k600)

�� (S10)

�� (lamer2k600)

�� (S10)

�� (S10)

�� (lamer2k600)

�� (��_��)