Can not allocate log, archival required

Quote:

---

Originally posted by hrishy
Is there any view through which i can check the location and the name of parameter file did my database use when it started up ?soemthing like show parameter paranmeter file

---

If under OFA, then the default directory for the parameter file is $ORACLE_HOME/admin/$ORACLE_SID/pfile.

If you have created the service manually (not through OUI) then the location depends on the 'oradim' command you used during manual database creation.

On windows, you can get the location used from the registry. (ORA_(SID)_PFILE).

HTH.

Check the alert.log. It will contain a listing of non-default System parameters that were in effect when the database was started.

Quote:

---

Originally posted by hrishy
Is there any view through which i can check the location and the name of parameter file did my database use when it started up ?

---

No, no such thing untill 9i (with spfile). Once started, there is no way to tell which initialistion parameter file was used during database startup.

Hi Jurij

Thanks for clarifing teh doubt..

regards
Hrishy

Quote:

---

Originally posted by hrishy
Is there any view through which i can check the location and the name of parameter file did my database use when it started up ?soemthing like show parameter paranmeter file

---

In 9i, we can use the following, but not in 8i or below:

Quote:

---

TST: SYS> show parameter ifile

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
ifile file D:\oracle\admin\tst\pfile\init
.ora
TST: SYS>

---

HTH.

SVRMGR> archive log list
Database log mode Archive Mode
Automatic archival Disabled
Archive destination /apps/home/ora817/dbs/arch
Oldest online log sequence 5
Next log sequence to archive 8
Current log sequence 8
but in the parameter file it is somethin like this
# Uncommenting the lines below will cause automatic archiving if archiving has
# been enabled using ALTER DATABASE ARCHIVELOG.
# log_archive_start = true
# log_archive_dest_1 = "location=/apps/home/admin/tixh/arch"
# log_archive_format = arch_%t_%s.arc



YOU HAVE STARTED THE DATABASE IN ARCHIVE LOG MOD BUT YOU FORGOT TO CHANGE THE PARAMETER IN THE INIT FILE SO IF YOU WANT TO RUN YOUR DATABASE IN ARCHIVE LOG MODE THE UNCOMMENT THE ABOVE PARAMETER OR IF YOU WANT TO RUN IN NOARCHIVELOGMODE THEN GO TO MOUNT STAGE AND EXECUTE "ALTER DATABASE NOARCHIVELOG" AND IF YOU WANT TO DO IT MANULLAY THEN DEFINE THE LOCATION IN THE PARAMETER FILE OTHERWISE IT WILL STORE IN THE LOCAL DESTINATION AS WELL AS YOU WILL HAVE TO EXECUTE THE COMMAND MANUALLY.

SHAILENDRA

Quote:

---

Originally posted by ggnanaraj
In 9i, we can use the following, but not in 8i or below:
HTH.

---

No. ifile is pointer to additional parameter file, mention in parameter file. It is available before 9i as well BUT it doesn't tell you the path of actual parameter file. As jmodic said there is no way we can see the parameter file used for startup, at least till 9.2

Quote:

---

Originally posted by shailendra
YOU HAVE STARTED THE DATABASE IN ARCHIVE LOG MOD BUT YOU FORGOT TO CHANGE THE PARAMETER IN THE INIT FILE SO IF YOU WANT TO RUN YOUR DATABASE IN ARCHIVE LOG MODE THE UNCOMMENT THE ABOVE PARAMETER OR IF YOU WANT TO RUN IN NOARCHIVELOGMODE THEN GO TO MOUNT STAGE AND EXECUTE "ALTER DATABASE NOARCHIVELOG" AND IF YOU WANT TO DO IT MANULLAY THEN DEFINE THE LOCATION IN THE PARAMETER FILE OTHERWISE IT WILL STORE IN THE LOCAL DESTINATION AS WELL AS YOU WILL HAVE TO EXECUTE THE COMMAND MANUALLY.

SHAILENDRA

---

Shailendra,
I think Hrishy already mentioned what he missed.
BTW Why all CAPS ??

ifile and pfile are quite different you know ggnanaraj :D