Skip to main content

Archive logging

By Unknown
This is probably in a million places out there but just posting it here for my own reference and you might find it useful too.

Disable Archiving

SQL> archive log list;

Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u04/archive/ref4data
Oldest online log sequence     1
Next log sequence to archive   4
Current log sequence           4 SQL> shutdown immediate Database closed.
Database dismounted.
ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 8551575552 bytes
Fixed Size                  2270360 bytes
Variable Size            2634025832 bytes
Database Buffers         5804916736 bytes
Redo Buffers              110362624 bytes
Database mounted. SQL> alter database noarchivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list; Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u04/archive/ref4data
Oldest online log sequence     1
Current log sequence           4

Enable Archiving

SQL> archive log list; Database log mode              No Archive Mode
Automatic archival             Disabled
Archive destination            /u04/archive/ref4data
Oldest online log sequence     1
Current log sequence           4 SQL> shutdown immediate Database closed.
Database dismounted.
ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 8551575552 bytes
Fixed Size                  2270360 bytes
Variable Size            2634025832 bytes
Database Buffers         5804916736 bytes
Redo Buffers              110362624 bytes
Database mounted. SQL> alter database archivelog; Database altered. SQL> alter database open; Database altered. SQL> archive log list; Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /u04/archive/ref4data
Oldest online log sequence     1
Next log sequence to archive   4
Current log sequence           4
Labels:

Comments

Post a Comment

Popular posts from this blog

Cancel or abort adop session

By Unknown
ADOP is in my opinion still pretty half baked. This is a critical tool that just isn't as intuitive as the old adpatch was. However we move with the times and get the hang of the new way of doing things. Along the way you might want to abort or cancel a patching cycling. With the two file systems and db editioning this can be a bit more to manage. I have learnt the hard way so you need to use the full cleanup after aborting a session. adop phase=abort adop phase=cleanup cleanup_mode=full
Post a Comment
Read more

Creating new WLS domain ends with exit code 255

By Unknown
Cloning the instance I ran into this weird error. Was not sure what to do but after learning my lesson I dug through the error logs after seeing this in the adcfgclone log file. START: Creating new WLS domain. Running /u03/APPLYES/YES/fs2/FMW_Home/oracle_common/bin/pasteConfig.sh -javaHome /u03/APPLYES/YES/fs2/EBSapps/comn/util/jdk64 -al /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/EBSdomain.jar -tdl /u03/APPLYES/YES/fs2/FMW_Home/user_projects/domains/EBS_domain_YES -tmw /u03/APPLYES/YES/fs2/FMW_Home -mpl /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/WLS/plan/moveplan.xml -ldl /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply -silent true -debug true -domainAdminPassword /u03/APPLYES/YES/fs2/EBSapps/comn/clone/FMW/tempinfo.txt Script Executed in 1903 milliseconds, returning status 255 ERROR: Script failed, exit code 255 Dig a bit deeper into the log files cd /u03/APPLYES/YES/fs2/inst/apps/YES_erpapyes/admin/log/clone/wlsT2PApply cat CLONE2016-01-10_04-37-...
Post a Comment
Read more

Error during rapid clone on pasteBinary.sh, exit code 255

By Unknown
I needed to run a clone and was running into a really head scratcher. As is Oracle\'s way they sometimes enjoy giving us DBA's a bit of detective work to do. As usual I kept knocking my head into various brick walls instead of tracking back through the logs. Eventually I came up with the problem Start to configure the run filesystem. You can do a dualfs from AD-TXK Delta 7 but for now I just needed to get this up and running: perl adcfgclone.pl appsTier START: Creating FMW Home. Running /u03/APPLUAT/UAT/fs1/EBSapps/comn/clone/FMW/ pasteBinary.sh -javaHome /u03/APPLUAT/UAT/fs1/EBSapps/comn/util/jdk64 -al /u03/APPLUAT/UAT/fs1/EBSapps/comn/clone/FMW/FMW_Home.jar -tl /u03/APPLUAT/UAT/fs1/FMW_Home -invPtrLoc /etc/oraInst.loc -ldl /u03/APPLUAT/UAT/fs1/inst/apps/UAT_erpapp05/admin/log/clone/fmwT2PApply -silent true -debug true -executeSysPrereqs false Script Executed in 21933 milliseconds, returning status 255 ERROR: Script failed, exit code 255 Oracle has left me a cryptic ...
Post a Comment
Read more