Search

Multiplexing Redo Log and Control files

-- List redo log files

select group#, member from v$logfile order by group#, member;


-- Check redo log file status

select group#, members, status from v$log;


-- Adding redo log file to a group

alter database add logfile member '<path>/redo011.log' to group 1;


-- Drop redo log file

-- Ensure that the file is not current

alter database drop logfile member '<path>/redo011.log';


-- Adding redo log group

alter database add logfile group 2 '<path>/redo21.log' size 100M;


-- Switch redo log file

alter system switch logfile;


-- Redo log files history

select * from v$log_history;


-- Show control files

show parameter control_files;


-- Add control file

alter system set control_files ='<path>/control01.ctl', '<path>/control02.ctl' scope=spfile;

shutdown immediate

host cp <path>/control01.ctl <path>/control02.ctl

startup


-- List files that need recovery

select * from v$recover_file;


-- Check archive mode

archive log list;


-- Find archive destination

show parameter db_recovery_file_dest


-- Set archive destination

alter system set log_archive_dest_1='LOCATION=<path>' scope=spfile;


-- Enable archive mode

-- Database should be mounted

alter database archive log;

1 view0 comments

Recent Posts

See All

After logon trigger - trace user sessions

-- Activate trace for sessions using after logon database trigger -- -- Tables: -- -- SYS.XX_LOGIN_TRACE_CONDITION - add here the conditions for activating trace -- SYS.XX_LOGIN_TRACED_SESSIONS - con

INCLUDE parameter of expdp

-- Export all public database links expdp user/password full=y \ include=db_link:"in (select db_link from dba_db_links where owner = 'PUBLIC')" -- Export one table expdp user/password include=table:"i

APEX - change user's password

sqlplus / as sysdba select owner, table_name from dba_tables where table_name = upper('wwv_flow_fnd_user'); -- Change schema name to whatever you want ALTER SESSION SET CURRENT_SCHEMA = APEX_050100; s