|
|
|
|
|
|
ۼ : 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() ̵]
|
|
|
|
|
|
|
|
|