Hej,
Jag behöver hjälp med hur man kan disablea USE_DB_RECOVERY_FILE_DEST.
Databas: Oracle 10g
OS: Windows 2003

Tacksam för all hjälp jag kan få.

/Patrik

Kolla om detta är en framkomlig väg:

database archiving mode.
rn
1.shutdown normal or shutdown immediate database closed
[Oracle @ jumper oracle] $ sqlplus "/ as sysdba"
rn
SQL> shutdown immediate;
rn
2. Start to mount the database state
SQL> startup mount;
rn
3. To enable or stop archiving mode if you want to enable archive mode, here used
alter database archivelog command.
SQL> alter database archivelog;
rn
SQL> alter database open;
rn
SQL> archive log list;
rn
If you need to stop archiving mode, used here:
alter database noarchivelog command.
SQL> shutdown immediate;
rn
SQL> startup mount;
SQL> alter database noarchivelog;
rn
SQL> alter database open;
rn
SQL> archive log list;
rn
4. Modify the initialization parameters of the corresponding
Before Oracle10g, you need to modify the initialization parameters in the database archiving mode automatically.
In the pfile / spfile to set the following parameters:
rn
log_archive_start = true
rn
Restart the database into force of this argument, this time the database is in archive mode automatically.
Can also start the process in the database, manually run:
rn
archive log start
rn
Enable automatic archiving the database, but after restarting the database archiving mode is still in hand.
rn
Starting from the Oracle10g, log_archive_start parameters have been abolished,
Oracle10g has abandoned log_archive_start parameters.
rn
In Oracle10g in, log_archive_start parameters have been abandoned, simply start the database archiving mode, Oracle will enable automatic archiving, thus avoiding 10g ago because the user a series of problems caused by negligence.
$ Sqlplus "/ as sysdba"
rn
SQL> archive log list;
rn
SQL> show parameter log_archive_start
rn
NAME TYPE VALUE
------------------------------------ ----------- --- ---------------------------
log_archive_start boolean FALSE
SQL> shutdown immediate;
rn
SQL> startup mount;
rn
SQL> alter database archivelog;
rn

SQL> alter database open;
rn
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 25
Next log sequence to archive 27
Current log sequence 27

rn

rn
- Change the storage location of archive log
rn
alter system set log_archive_dest = "d: \ tablespace \ arch"

Hej Pelle,

Vi vill inte stoppa archiving mode.
Oracle skriver till två destinationer:
LOG_ARCHIVE_DEST_1: E:\\oraarch\csdb -- denna ska vara kvar
LOG_ARCHIVE_DEST_10: USE_DB_RECOVERY_FILE_DEST -- denna vill vi disablea

Har du något förslag på hur vi kan göra?

MVH
Patrik