 |
| How to set Oracle Database in Arcivelog Mode ::Oracle10g |
Here;s How to set Oracle Database in Arcivelog Mode ::Oracle10g :
1.
SHUTDOWN immediate;2.
STARTUP mount;3.
ALTER DATABASE FLASHBACK ON;4.
ALTER DATABASE ARCHIVELOG;5.
ALTER DATABASE OPEN;The startup command will use a temporary file as pfile with the following init.ora parameters:
6.
ALTER SYSTEM SET log_archive_dest_10 = "LOCATION=/media/data2/oracle_kjks_backup/archivelogs
OPTIONAL REOPEN=300" SCOPE=SPFILE;
spfile='/media/data1/oracle/product/10.2.0/dboracle/dbs/spfileorcl.ora'
