Alter database force logging;


ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(wsjdell,wsjdelldg)';
alter system set log_archive_dest_1='LOCATION=+DATA VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wsjdell';
alter system set  log_archive_dest_2='SERVICE=wsjdelldg LGWR SYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=wsjdelldg';
ALTER SYSTEM SET FAL_CLIENT = wsjdell1 sid='wsjdell1';
ALTER SYSTEM SET FAL_CLIENT = wsjdell2 sid='wsjdell2';
ALTER SYSTEM SET FAL_CLIENT = wsjdell3 sid='wsjdell3';

ALTER SYSTEM SET FAL_SERVER = wsjdelldg;


$mkdir –-p /data/backup
$chmod 770 /data/backup




$rman target/
Rman> backup database format='/data/backup/%U_%s.bak';
Rman>sql"alter system archive log current";
Rman>backup filesperset 10 archivelog all format='/data/backup/%U_%s.bak';

alter database create standby controlfile as '/data/backup/dgcon01.ctl';



ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 111 ('/data/wsjdell/dgredo111a.log','/data/wsjdell/dgredo111b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 112 ('/data/wsjdell/dgredo112a.log','/data/wsjdell/dgredo112b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 113 ('/data/wsjdell/dgredo113a.log','/data/wsjdell/dgredo113b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 114 ('/data/wsjdell/dgredo114a.log','/data/wsjdell/dgredo114b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 115 ('/data/wsjdell/dgredo115a.log','/data/wsjdell/dgredo115b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 116 ('/data/wsjdell/dgredo116a.log','/data/wsjdell/dgredo116b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 117 ('/data/wsjdell/dgredo113a.log','/data/wsjdell/dgredo113b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 118 ('/data/wsjdell/dgredo114a.log','/data/wsjdell/dgredo114b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 119 ('/data/wsjdell/dgredo115a.log','/data/wsjdell/dgredo115b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 1 group 120 ('/data/wsjdell/dgredo116a.log','/data/wsjdell/dgredo116b.log') SIZE 100M;


 

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 221 ('/data/wsjdell/dgredo221a.log','/data/wsjdell/dgredo221b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 222 ('/data/wsjdell/dgredo222a.log','/data/wsjdell/dgredo222b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 223 ('/data/wsjdell/dgredo223a.log','/data/wsjdell/dgredo223b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 224 ('/data/wsjdell/dgredo224a.log','/data/wsjdell/dgredo224b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 225 ('/data/wsjdell/dgredo225a.log','/data/wsjdell/dgredo225b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 226 ('/data/wsjdell/dgredo226a.log','/data/wsjdell/dgredo226b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 227 ('/data/wsjdell/dgredo223a.log','/data/wsjdell/dgredo223b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 228 ('/data/wsjdell/dgredo224a.log','/data/wsjdell/dgredo224b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 229 ('/data/wsjdell/dgredo225a.log','/data/wsjdell/dgredo225b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 2 group 230 ('/data/wsjdell/dgredo226a.log','/data/wsjdell/dgredo226b.log') SIZE 100M;



ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 331 ('/data/wsjdell/dgredo221a.log','/data/wsjdell/dgredo221b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 332 ('/data/wsjdell/dgredo222a.log','/data/wsjdell/dgredo222b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 333 ('/data/wsjdell/dgredo223a.log','/data/wsjdell/dgredo223b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 334 ('/data/wsjdell/dgredo224a.log','/data/wsjdell/dgredo224b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 335 ('/data/wsjdell/dgredo225a.log','/data/wsjdell/dgredo225b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 336 ('/data/wsjdell/dgredo226a.log','/data/wsjdell/dgredo226b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 337 ('/data/wsjdell/dgredo223a.log','/data/wsjdell/dgredo223b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 338 ('/data/wsjdell/dgredo224a.log','/data/wsjdell/dgredo224b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 339 ('/data/wsjdell/dgredo225a.log','/data/wsjdell/dgredo225b.log') SIZE 100M;

ALTER DATABASE ADD STANDBY LOGFILE THREAD 3 group 340 ('/data/wsjdell/dgredo226a.log','/data/wsjdell/dgredo226b.log') SIZE 100M;



ALTER DATABASE ADD LOGFILE GROUP 2 ('+DATA/wsjdell/redo2a.log','+INDX/wsjdell/redo2b.log')  SIZE 100m;


$rman target/
Rman>restore database;
Rman>restore archvielog all;


wsjdelldg/archivelog


+data/wsjdell/archivelog



log_archive_dest_1                   string      LOCATION=+DATA/WSJDELLDG/ARCHI
                                                 VELOG VALID_FOR=(ALL_LOGFILES,
                                                 ALL_ROLES) DB_UNIQUE_NAME=wsjd
                                                 elldg


alter system set log_archive_dest_1='LOCATION=+DATA/WSJDELLDG/ARCHIVELOG VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=wsjdelldg';


alter database tempfile '+DATA/wsjdelldg/tempfile/temp.829.755775683' offline;
alter database tempfile '+DATA/wsjdelldg/tempfile/temp.829.755775683' drop;


+DATA/wsjdelldg/tempfile/temp.829.755775683
+INDX/wsjdell/tempfile/temp02.dbf

alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' offline;
alter database tempfile '+INDX/wsjdell/tempfile/temp02.dbf' drop;


alter tablespace temp add tempfile '+DATA/wsjdelldg/tempfile/temp01.dbf' size 4000m;
alter tablespace temp add tempfile '+INDX/wsjdelldg/tempfile/temp02.dbf' size 4000m;

WSJ_DELLL10_RAC_DBDG_10.109.196.160


WSJ_DELLL10_RAC_DBDG_Server_10.109.196.160