()ý
Home
Ȩ ȸҰ ý Ʈ ũ
 
 
ۼ : 06-02-21 17:05
ORA-16032: parameter LOG_ARCHIVE_DEST
 ۾ :
ȸ : 10,702  
Archive Log Mode $oraclehome/dbs/init.ora Binary(spfile) ֽϴ.⼭ ޽ Binary Ŀ LOG_ARCHIVE_DEST κ ߸ ޽ Ÿ Դϴ.

PFILE : Ŭ ⺻ ϴ Ķ INIT.ORA ƴ ڰ Ķ Ͽ Ŭ մϴ.

  ) SQL>startup pfile=D:\oracle\database\initORACLE.ora
  spfile init.ora ϰ νϽ ϴ.

SPFILE : Oracle 9i Ұ Ķ ̸ ALTER SYSTEM ͺ̽  ̶ Ķ͸ ְ ٽ ʾƵ Ķ Ǵ Binary ̹Ƿ ؼ ȵ˴ϴ.(Ŭ spfile )

Spfile spfileSID.ora ̸ $ORACLE_HOME/dbs 丮 ġմϴ. default ġ pfile ġ

pfile Ŭ ϴµ ʼ Ķ͵ ǵǾ ְ text ü ͷ ϸ pfile Ķ Ͽ ϱ ؼ ͺ̽ ϰ ٽ ؾ մϴ.

pfile spfile ġ

UNIX  :  $ORACLE_HOME/dbs
Windows NT/2000 -> %ORACLE_HOME%\database



SQL> startup mount
ORA-16032: parameter LOG_ARCHIVE_DEST destination string cannot be translated
ORA-09291: sksachk: invalid device specified for archive destination
OSD-04018: AvA$5H 5p7:Ed8. 6G4B @eD!8& >W<<=:GR <v >x=@4O4Y.
O/S-Error: (OS 2) AvA$5H FD@O@; C#@; <v >x=@4O4Y.
SQL>

------------------------------------------------------------------------------------------

pfile ̿Ͽ ͺ̽ .

  1. pfile .

 - pfile ⺻ ġ $oraclehome\database Դϴ.
 - pfile

 SQL> create pfile from spfile;

Ǿϴ.

 SQL>

 2. $oraclehome\database pfile . ( INITorcl.ORA )

*.log_archive_dest='c:\OraHome1'  -----> .
*.log_archive_format='%S.ARC'
*.log_archive_start=TRUE

 Binary κ LOG_ARCHIVE_DEST  κ pfile *.log_archive_dest='c:\OraHome1' κ Դϴ. θ ϸ ˴ϴ.

 3. startup mount

SQL> startup mount pfile=c:\orahome1\database\initorcl.ora
ORACLE νϽ ۵Ǿϴ.

Total System Global Area  135338868 bytes
Fixed Size                  453492 bytes
Variable Size            109051904 bytes
Database Buffers          25165824 bytes
Redo Buffers                667648 bytes
SQL>

ͺ̽ ORA-01991: ߻.

ORA-01991 н ų ջ Ǽ ߻ մϴ.
   
    ġ: C:\OraHome1\database\pwdorcl.ora

  ٸ ̸ .

SQL> startup mount pfile=c:\orahome1\database\initorcl.ora
ORACLE νϽ ۵Ǿϴ.

Total System Global Area  135338868 bytes
Fixed Size                  453492 bytes
Variable Size            109051904 bytes
Database Buffers          25165824 bytes
Redo Buffers                667648 bytes
ORA-01991: 'C:\OraHome1\DATABASE\PWDorcl.ORA' ?? ??? ??????


SQL>

 - ͹̳ ¿ .....

C:\OraHome1\bin>orapwd file=c:\orahome1\database\pwdorcl.ora password=test1234

C:\OraHome1\bin>

SQL> startup mount pfile=c:\orahome1\database\initorcl.ora
ORACLE νϽ ۵Ǿϴ.

Total System Global Area  135338868 bytes
Fixed Size                  453492 bytes
Variable Size            109051904 bytes
Database Buffers          25165824 bytes
Redo Buffers                667648 bytes
ͺ̽ ƮǾϴ.
SQL>

[ Խù ڴԿ 2006-02-27 18:26:39 ڷ - Solaris() ̵]

 
 

Total 136
ȣ     ۾ ¥ ȸ
16 sysstat1.5 ýۻ¸
2006/03/03 3986
15 oracle cold backup ̽
2006/03/02 6799
14 oracle cold backup - ͺ̽
2006/03/02 5777
13 ORACLE LISTENER
2006/03/02 6651
12 TAPE DEVICE ġ ̸ .
2006/03/02 4209
11 mrtg ġ  solaris 9
2005/12/21 6082
10 pfile & spfile
2006/02/21 5537
9 ORACLE Instance oratest - Can not allocate log, archival req
2005/08/24 6730
8 Raid 0 + 1 , 1+ 0
2006/01/19 6945
7 oracle 9.2.0.7.0 patch
2006/02/27 6263
6 oracle Ȯ.
2006/02/24 6627
5 ORA-16032: parameter LOG_ARCHIVE_DEST
2006/02/21 10703
4 Archive log mode
2006/02/21 4841
3 oracle archive log mode & noarchive log mode
2006/02/21 6766
2 oracle export - import
2006/02/03 10301
 1  2  3  4  5  6  7  8  9  10  
 
 
 
Administrator Login