Move tablespace to another disk group in ASM with RMAN

Using RMAN:

backup as copy tablespace TBLSP1 format ‘+NEWGROUP’;
sql ‘alter tablespace TBLSP1 offline’;
switch tablespace TBLSP1 to copy;
recover tablespace TBLSP1;
sql ‘alter tablespace TBLSP1 online’;

Oracle ASM Cluster File Systems (ACFS) in Oracle Database 11g Release 2

http://www.oracle-base.com/articles/11g/ACFS_11gR2.php

Format OCFS drive (ocfsformat)

http://thelazyway.org/tiki-index.php?page=AddingOCFSDrivesWindows

Single Client Access Name (SCAN) for Oracle Database 11g RAC

Another post link I couldn’t do justice to: click here

Webutil upgrade

View this document on Scribd

Create stand alone report server in Weblogic Forms and Reports

opmnctl createcomponent -adminUsername weblogic -adminHost MyHost -adminPort 7002 -oracleHome d:\oracle\middleware\as_1 -oracleInstance d:\oracle\middleware\asinst_1 -instanceName asinst_1 -componentName MyReportServer -componentType ReportsServerComponent

Temp File Useage



SQL> select TABLESPACE_NAME, BYTES_USED, BYTES_FREE from V$TEMP_SPACE_HEADER;

TABLESPACE_NAME                BYTES_USED BYTES_FREE
------------------------------ ---------- ----------
TEMP                             52428800   52428800

Weblogic – Node Manager Setup

I couldn’t do it justice, so:

http://wlsjavatips.blogspot.com/2009/09/how-to-install-node-manager-as-windows.html

Move datafile script (unix or windows)

Remember to change the disk name.

ARCHIVE LOGGING (UNIX):

set linesize 150
column file_name format a60
set pagesize 200
set head off

select file_id, file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database datafile ‘||file_id||’ offline;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘!mv ‘||file_name||’ ‘||file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database rename file ”’||file_name||”’ to ”’||file_name||”’;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘recover datafile ‘||file_id||’;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database datafile ‘||file_id||’ online;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘select status from dba_data_files;’ from dual;

NO ARCHIVE LOGGING (UNIX):

set linesize 150
column file_name format a60
set pagesize 200
set head off

select ‘shutdown immediate’ from dual;
select file_id, file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘!mv ‘||file_name||’ ‘||file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘startup mount’ from dual;
select ‘alter database rename file ”’||file_name||”’ to ”’||file_name||”’;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database open;’ from dual;
select ‘select status from dba_data_files;’ from dual;

ARCHIVE LOGGING (WINDOWS):

set linesize 150
column file_name format a60
set pagesize 200
set head off

select file_id, file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database datafile ‘||file_id||’ offline;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘host move ‘||file_name||’ ‘||file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database rename file ”’||file_name||”’ to ”’||file_name||”’;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘recover datafile ‘||file_id||’;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database datafile ‘||file_id||’ online;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘select status from dba_data_files;’ from dual;

NO ARCHIVE LOGGING (WINDOWS):

set linesize 150
column file_name format a60
set pagesize 200
set head off

select ‘shutdown immediate’ from dual;
select file_id, file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘host move ‘||file_name||’ ‘||file_name
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘startup mount’ from dual;
select ‘alter database rename file ”’||file_name||”’ to ”’||file_name||”’;’
from dba_data_files
where file_name like ‘%disk8%’
/
select ‘alter database open;’ from dual;
select ‘select status from dba_data_files;’ from dual;

Create Tablespace

create tablespace ts_name
datafile ‘c:\ts_name_01.dbf’ size 4M autoextend off,
‘c:\ts_name_02.dbf’ size 4M autoextend off,
‘c:\ts_name_03.dbf’ size 4M autoextend off
logging
extent management local;