Select Menu

Ads

Random Posts

Powered By Blogger
Powered By Blogger

Blog Archive

Search This Blog

Blog Archive

Thirupal Boreddy. Powered by Blogger.

My Blog List

Followers

Lorem 1

Technology

Circle Gallery

Shooting

Racing

News

Lorem 4

» » Chang Archive log destination

ALTER SYSTEM LOG ARCHIVE START TO 'new_location';

Ex:-

Step 1 : alter system archive log start to '/ora_arch_tmp/xxxxx/archive';

Step 2 : Alter system switch logfile;
-----------------------------------------------------
ALTER SYSTEM SET log_archive_dest='location=/data/ORCL/oracle/CRL1/temp_pxc1' SCOPE=spfile;

ALTER SYSTEM SET log_archive_dest='location=/opt/ORCL/apps/best1/temparc' SCOPE=memory;

SQL> select name from v$database;

NAME
---------
orcl

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /data/ORCL/oracle/CRL1
Oldest online log sequence 496885
Next log sequence to archive 496889
Current log sequence 496889

About Oracle DBA World

WePress Theme is officially developed by Templatezy Team. We published High quality Blogger Templates with Awesome Design for blogspot lovers.The very first Blogger Templates Company where you will find Responsive Design Templates.
«
Next
Newer Post
»
Previous
Older Post

No comments

Leave a Reply

QUERY FOR CPU USAGE

select  a.target_name as HOST, to_char(a.rollup_timestamp,' dd-Mon-yy::hh24:mi') as "DAY-TIME", sum(c.cpu_count) as ...