oracle@pgheo-ubuntu:/oracle/oradata/PROD$ sqlplus "/as sysdba" SQL*Plus: Release 10.2.0.1.0 - Production on Thu Nov 18 14:31:57 2009 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options SQL> col tablespace for a10 SQL> col datafile for a50 SQL> select a.ts#, a.name tablespace, b.name datafile 2 from v$tablespace a, v$datafile b 3 where a.ts#=b.ts#; TS# TABLESPACE DATAFILE ---------- ---------- -------------------------------------------------- 0 SYSTEM /oracle/oradata/PROD/system01.dbf 1 UNDOTBS1 /oracle/oradata/PROD/undotbs01.dbf 2 SYSAUX /oracle/oradata/PROD/sysaux01.dbf 4 USERS /oracle/oradata/PROD/users01.dbf 6 EXAMPLE /oracle/oradata/PROD/example01.dbf SQL> alter tablespace users offline; Tablespace altered. SQL> !cp /oracle/oradata/PROD/users01.dbf /oracle/oradata/PROD/Disk3/users01.dbf SQL> alter tablespace users 2 rename datafile '/oracle/oradata/PROD/users01.dbf' to '/oracle/oradata/PROD/Disk3/users01.dbf'; Tablespace altered. SQL> alter tablespace users online; Tablespace altered. SQL> alter tablespace example offline; Tablespace altered. SQL> !cp /oracle/oradata/PROD/example01.dbf /oracle/oradata/PROD/Disk4/example01.dbf SQL> alter tablespace example 2 rename datafile '/oracle/oradata/PROD/example01.dbf' to '/oracle/oradata/PROD/Disk4/example01.dbf'; Tablespace altered. SQL> alter tablespace example online; Tablespace altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 71305244 bytes Database Buffers 130023424 bytes Redo Buffers 2973696 bytes Database mounted. SQL> alter database rename file '/oracle/oradata/PROD/system01.dbf' to '/oracle/oradata/PROD/Disk1/system01.dbf'; alter database rename file '/oracle/oradata/PROD/system01.dbf' to '/oracle/oradata/PROD/Disk1/system01.dbf' * ERROR at line 1: ORA-01511: error in renaming log/data files ORA-01141: error renaming data file 1 - new file '/oracle/oradata/PROD/Disk1/system01.dbf' not found ORA-01110: data file 1: '/oracle/oradata/PROD/system01.dbf' ORA-27037: unable to obtain file status Linux Error: 2: No such file or directory Additional information: 3 SQL> !cp /oracle/oradata/PROD/system01.dbf /oracle/oradata/PROD/Disk1/system01.dbf SQL> alter database rename file '/oracle/oradata/PROD/system01.dbf' to '/oracle/oradata/PROD/Disk1/system01.dbf'; Database altered. SQL> alter database open; Database altered. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 71305244 bytes Database Buffers 130023424 bytes Redo Buffers 2973696 bytes Database mounted. SQL> !cp /oracle/oradata/PROD/undotbs01.dbf /oracle/oradata/PROD/Disk2/undotbs01.dbf SQL> !cp /oracle/oradata/PROD/sysaux01.dbf /oracle/oradata/PROD/Disk1/sysaux01.dbf SQL> alter database rename file '/oracle/oradata/PROD/undotbs01.dbf' to '/oracle/oradata/PROD/Disk2/undotbs01.dbf'; Database altered. SQL> alter database rename file '/oracle/oradata/PROD/sysaux01.dbf' to '/oracle/oradata/PROD/Disk1/sysaux01.dbf'; Database altered. SQL> alter database open; Database altered. SQL> col file_name for a50 SQL> col tablespace_name for a10 SQL> select file_name, tablespace_name, bytes/1024/1024 MB from dba_temp_files; FILE_NAME TABLESPACE MB -------------------------------------------------- ---------- ---------- /oracle/oradata/PROD/temp01.dbf TEMP 20 SQL> desc database_properties Name Null? Type ----------------------------------------- -------- ---------------------------- PROPERTY_NAME NOT NULL VARCHAR2(30) PROPERTY_VALUE VARCHAR2(4000) DESCRIPTION VARCHAR2(4000) SQL> col property_name for a30 SQL> col property_value for a30 SQL> col description for a40 SQL> set linesize 200 SQL> set pagesize 40 SQL> select * from database_properties; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ ------------------------------ ---------------------------------------- DICT.BASE 2 dictionary base tables version # DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace DEFAULT_PERMANENT_TABLESPACE USERS Name of default permanent tablespace DEFAULT_TBS_TYPE SMALLFILE Default tablespace type NLS_LANGUAGE AMERICAN Language NLS_TERRITORY AMERICA Territory NLS_CURRENCY $ Local currency NLS_ISO_CURRENCY AMERICA ISO currency NLS_NUMERIC_CHARACTERS ., Numeric characters NLS_CHARACTERSET KO16KSC5601 Character set NLS_CALENDAR GREGORIAN Calendar system NLS_DATE_FORMAT DD-MON-RR Date format NLS_DATE_LANGUAGE AMERICAN Date language NLS_SORT BINARY Linguistic definition NLS_TIME_FORMAT HH.MI.SSXFF AM Time format NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM Time stamp format NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR Time with timezone format NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR Timestamp with timezone format NLS_DUAL_CURRENCY $ Dual currency symbol NLS_COMP BINARY NLS comparison NLS_LENGTH_SEMANTICS BYTE NLS length semantics NLS_NCHAR_CONV_EXCP FALSE NLS conversion exception NLS_NCHAR_CHARACTERSET AL16UTF16 NCHAR Character set NLS_RDBMS_VERSION 10.2.0.1.0 RDBMS version for NLS parameters GLOBAL_DB_NAME PROD.REGRESS.RDBMS.DEV.US.ORAC Global database name LE.COM EXPORT_VIEWS_VERSION 8 Export views revision # DBTIMEZONE 00:00 DB time zone 27 rows selected. SQL> create temporary tablespace temp2 2 tempfile '/oracle/oradata/PROD/Disk2/temp01.dbf' size 20M; Tablespace created. SQL> alter tablespace temp rename to temp3; Tablespace altered. SQL> alter tablespace temp2 rename to temp; Tablespace altered. SQL> select * from database_properties where property_name like 'DEFAULT_TEMP%'; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ ------------------------------ ---------------------------------------- DEFAULT_TEMP_TABLESPACE TEMP3 Name of default temporary tablespace SQL> alter database default temporary tablespace temp; Database altered. SQL> select * from database_properties where property_name like 'DEFAULT_TEMP%'; PROPERTY_NAME PROPERTY_VALUE DESCRIPTION ------------------------------ ------------------------------ ---------------------------------------- DEFAULT_TEMP_TABLESPACE TEMP Name of default temporary tablespace SQL>select file_name, tablespace_name, bytes/1024/1024 MB from dba_temp_files; FILE_NAME TABLESPACE MB -------------------------------------------------- ---------- ---------- /oracle/oradata/PROD/temp01.dbf TEMP3 20 /oracle/oradata/PROD/Disk2/temp01.dbf TEMP 20 SQL>drop tablespace temp3; Tablespace dropped. SQL>select file_name, tablespace_name, bytes/1024/1024 MB from dba_temp_files; FILE_NAME TABLESPACE MB -------------------------------------------------- ---------- ---------- /oracle/oradata/PROD/Disk2/temp01.dbf TEMP 20 SQL> select a.group#, a.member, b.members, b.status, bytes/1024/1024 MB 2 from v$logfile a, v$log b 3 where a.group#=b.group#; GROUP# MEMBER MEMBERS STATUS MB ---------- ----------------------------------- ---------- ---------- ---------- 3 /oracle/oradata/PROD/redo03.log 1 INACTIVE 50 2 /oracle/oradata/PROD/redo02.log 1 CURRENT 50 1 /oracle/oradata/PROD/redo01.log 1 INACTIVE 50 SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 71305244 bytes Database Buffers 130023424 bytes Redo Buffers 2973696 bytes Database mounted. SQL> !cp /oracle/oradata/PROD/redo01.log /oracle/oradata/PROD/Disk3/redo01a.log SQL> !cp /oracle/oradata/PROD/redo02.log /oracle/oradata/PROD/Disk4/redo02a.log SQL> !cp /oracle/oradata/PROD/redo03.log /oracle/oradata/PROD/Disk5/redo03a.log SQL> alter database rename file 2 '/oracle/oradata/PROD/redo01.log' to '/oracle/oradata/PROD/Disk3/redo01a.log'; Database altered. SQL> alter database rename file 2 '/oracle/oradata/PROD/redo02.log' to '/oracle/oradata/PROD/Disk4/redo02a.log'; Database altered. SQL> alter database rename file 2 '/oracle/oradata/PROD/redo03.log' to '/oracle/oradata/PROD/Disk5/redo03a.log'; Database altered. SQL> alter database open; Database altered. SQL> col member for a40 SQL> select a.group#, a.member, b.members, b.status, bytes/1024/1024 MB 2 from v$logfile a, v$log b 3* where a.group#=b.group# GROUP# MEMBER MEMBERS STATUS MB ---------- ---------------------------------------- ---------- ---------- ---------- 3 /oracle/oradata/PROD/Disk5/redo03a.log 1 INACTIVE 50 2 /oracle/oradata/PROD/Disk4/redo02a.log 1 CURRENT 50 1 /oracle/oradata/PROD/Disk3/redo01a.log 1 INACTIVE 50 SQL> alter database add logfile member '/oracle/oradata/PROD/Disk5/redo01b.log' to group 1; Database altered. SQL> alter database add logfile member '/oracle/oradata/PROD/Disk3/redo02b.log' to group 2; Database altered. SQL> alter database add logfile member '/oracle/oradata/PROD/Disk4/redo03b.log' to group 3; Database altered. SQL> select a.group#, a.member, b.members, b.status, bytes/1024/1024 MB 2 from v$logfile a, v$log b 3 where a.group#=b.group# 4 order by a.group#; GROUP# MEMBER MEMBERS STATUS MB ---------- ---------------------------------------- ---------- ---------- ---------- 1 /oracle/oradata/PROD/Disk3/redo01a.log 2 INACTIVE 50 1 /oracle/oradata/PROD/Disk5/redo01b.log 2 INACTIVE 50 2 /oracle/oradata/PROD/Disk3/redo02b.log 2 CURRENT 50 2 /oracle/oradata/PROD/Disk4/redo02a.log 2 CURRENT 50 3 /oracle/oradata/PROD/Disk4/redo03b.log 2 INACTIVE 50 3 /oracle/oradata/PROD/Disk5/redo03a.log 2 INACTIVE 50 6 rows selected. SQL> show parameter pfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /oracle/10g/dbs/spfilePROD.ora SQL> create pfile = '/oracle/10g/dbs/initPROD.ora' from spfile; File created. SQL>! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd /oracle/admin/PROD/pfile oracle@pgheo-ubuntu:/oracle/admin/PROD/pfile$ ls init.ora.7162009212946 oracle@pgheo-ubuntu:/oracle/admin/PROD/pfile$ cp init.ora.7162009212946 /oracle/10g/dbs/initPROD.ora oracle@pgheo-ubuntu:/oracle/admin/PROD/pfile$ vi /oracle/10g/dbs/initPROD.ora ===pfile 내용중 controlfile, bdump,udump,adump,cdump 등등 경로명 변경=== oracle@pgheo-ubuntu:/oracle/admin/PROD/pfile$ cd /oracle/oradata/PROD oracle@pgheo-ubuntu:/oracle/oradata/PROD$ mkdir Admin oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd Admin oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ ls oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ mkdir dpdump oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ mkdir cdump oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ mkdir udump oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ mkdir adump oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ mkdir bdump oracle@pgheo-ubuntu:/oracle/oradata/PROD/Admin$ cd .. oracle@pgheo-ubuntu:/oracle/oradata/PROD$ mv Admin/ admin oracle@pgheo-ubuntu:/oracle/oradata/PROD$ mkdir flash_recovery_area oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cp control01.ctl ./Disk1/control01.ctl oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cp control02.ctl ./Disk2/control02.ctl oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cp control03.ctl ./Disk3/control03.ctl oracle@pgheo-ubuntu:/oracle/oradata/PROD$ exit exit SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- /oracle/oradata/PROD/control01.ctl /oracle/oradata/PROD/control02.ctl /oracle/oradata/PROD/control03.ctl SQL> select status from v$instance; STATUS ------------ OPEN SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup nomount pfile='/oracle/10g/dbs/initPROD.ora'; ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 67110940 bytes Database Buffers 134217728 bytes Redo Buffers 2973696 bytes SQL> alter database mount; Database altered. SQL> alter database open; Database altered. SQL> col tablespace for a10 SQL> col datafile for a50 SQL> select a.ts#, a.name tablespace, b.name datafile 2 from v$tablespace a, v$datafile b 3 where a.ts#=b.ts#; TS# TABLESPACE DATAFILE ---------- ---------- -------------------------------------------------- 0 SYSTEM /oracle/oradata/PROD/Disk1/system01.dbf 1 UNDOTBS1 /oracle/oradata/PROD/Disk2/undotbs01.dbf 2 SYSAUX /oracle/oradata/PROD/Disk1/sysaux01.dbf 4 USERS /oracle/oradata/PROD/Disk3/users01.dbf 6 EXAMPLE /oracle/oradata/PROD/Disk4/example01.dbf SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- /oracle/oradata/PROD/Disk1/control01.ctl /oracle/oradata/PROD/Disk2/control02.ctl /oracle/oradata/PROD/Disk3/control03.ctl SQL> show parameter spfile; NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string SQL> ! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd /oracle/10g/dbs oracle@pgheo-ubuntu:/oracle/10g/dbs$ ls hc_PROD.dat init.ora initPROD.ora initdw.ora lkPROD orapwPROD spfilePROD.ora oracle@pgheo-ubuntu:/oracle/10g/dbs$ rm spfilePROD.ora oracle@pgheo-ubuntu:/oracle/10g/dbs$ exit exit SQL> create spfile from pfile; File created. SQL> ! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd /oracle/10g/dbs oracle@pgheo-ubuntu:/oracle/10g/dbs$ ls hc_PROD.dat init.ora initPROD.ora initdw.ora lkPROD orapwPROD spfilePROD.ora oracle@pgheo-ubuntu:/oracle/10g/dbs$ exit exit SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 67110940 bytes Database Buffers 134217728 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /oracle/10g/dbs/spfilePROD.ora SQL>! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd /oracle/admin oracle@pgheo-ubuntu:/oracle/admin$ cp -R * /oracle/oradata/PROD/Script/. oracle@pgheo-ubuntu:/oracle/admin$ cd /oracle/oradata/PROD/Script oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ mv PROD PROD_20091119 oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ cd .. oracle@pgheo-ubuntu:/oracle/oradata/PROD$ ls control0* control01.ctl control02.ctl control03.ctl oracle@pgheo-ubuntu:/oracle/oradata/PROD$ rm -rf control0* oracle@pgheo-ubuntu:/oracle/oradata/PROD$ ls *.dbf example01.dbf sysaux01.dbf system01.dbf temp01.dbf undotbs01.dbf users01.dbf oracle@pgheo-ubuntu:/oracle/oradata/PROD$ rm -rf *.dbf oracle@pgheo-ubuntu:/oracle/oradata/PROD$ ls *.log redo01.log redo02.log redo03.log oracle@pgheo-ubuntu:/oracle/oradata/PROD$ rm -rf *.log oracle@pgheo-ubuntu:/oracle/oradata/PROD$ ls Disk1 Disk2 Disk3 Disk4 Disk5 Script admin flash_recovery_area oracle@pgheo-ubuntu:/oracle/oradata/PROD$ oracle@pgheo-ubuntu:/oracle/admin$ exit exit SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 67110940 bytes Database Buffers 134217728 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> show parameter log_archive_max_processes NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_max_processes integer 2 SQL> ! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd Disk4 oracle@pgheo-ubuntu:/oracle/oradata/PROD/Disk4$ ls example01.dbf redo02a.log redo03b.log oracle@pgheo-ubuntu:/oracle/oradata/PROD/Disk4$ mkdir archive oracle@pgheo-ubuntu:/oracle/oradata/PROD/Disk4$ cd .. oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd Disk5 oracle@pgheo-ubuntu:/oracle/oradata/PROD/Disk5$ ls redo01b.log redo03a.log oracle@pgheo-ubuntu:/oracle/oradata/PROD/Disk5$ mkdir archive oracle@pgheo-ubuntu:/oracle/oradata/PROD/Disk5$ exit exit SQL> show parameter log_archive_des NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string log_archive_dest_10 string log_archive_dest_2 string log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string log_archive_dest_8 string log_archive_dest_9 string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable log_archive_dest_state_9 string enable SQL> alter system set log_archive_dest_1 = 'location=/oracle/oradata/PROD/Disk4/archive reopen'; System altered. SQL> alter system set log_archive_dest_2 = 'location=/oracle/oradata/PROD/Disk5/archive reopen'; System altered. SQL> show parameter log_archive_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest string log_archive_dest_1 string location=/oracle/oradata/PROD/ Disk4/archive reopen log_archive_dest_10 string log_archive_dest_2 string location=/oracle/oradata/PROD/ Disk5/archive reopen log_archive_dest_3 string log_archive_dest_4 string log_archive_dest_5 string log_archive_dest_6 string log_archive_dest_7 string NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_8 string log_archive_dest_9 string log_archive_dest_state_1 string enable log_archive_dest_state_10 string enable log_archive_dest_state_2 string enable log_archive_dest_state_3 string enable log_archive_dest_state_4 string enable log_archive_dest_state_5 string enable log_archive_dest_state_6 string enable log_archive_dest_state_7 string enable log_archive_dest_state_8 string enable NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_dest_state_9 string enable SQL> show parameter log_archive_format NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_format string %t_%s_%r.dbf SQL> alter system set log_archive_format='archive_%t_%s_%r.arc' scope=spfile; System altered. SQL> show parameter log_archive_format NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_format string %t_%s_%r.dbf SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> startup mount; ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 67110940 bytes Database Buffers 134217728 bytes Redo Buffers 2973696 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 /oracle/oradata/PROD/Disk5/archive Oldest online log sequence 176 Next log sequence to archive 178 Current log sequence 178 SQL> show parameter log_archive_format NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ log_archive_format string archive_%t_%s_%r.arc SQL> alter system archive log current; System altered. SQL> alter system switch logfile; System altered. SQL> alter system checkpoint; System altered. SQL> create tablespace indx 2 datafile '/oracle/oradata/PROD/Disk5/index01.dbf' size 25M reuse 3 uniform size 64k 4 segment space management auto; Tablespace created. SQL> select name from v$datafile; NAME -------------------------------------------------------------------------------- /oracle/oradata/PROD/Disk1/system01.dbf /oracle/oradata/PROD/Disk2/undotbs01.dbf /oracle/oradata/PROD/Disk1/sysaux01.dbf /oracle/oradata/PROD/Disk3/users01.dbf /oracle/oradata/PROD/Disk4/example01.dbf /oracle/oradata/PROD/Disk5/index01.dbf 6 rows selected. SQL> select name from v$controlfile; NAME -------------------------------------------------------------------------------- /oracle/oradata/PROD/Disk1/control01.ctl /oracle/oradata/PROD/Disk2/control02.ctl /oracle/oradata/PROD/Disk3/control03.ctl SQL> select member from v$logfile; MEMBER -------------------------------------------------------------------------------- /oracle/oradata/PROD/Disk5/redo03a.log /oracle/oradata/PROD/Disk4/redo02a.log /oracle/oradata/PROD/Disk3/redo01a.log /oracle/oradata/PROD/Disk5/redo01b.log /oracle/oradata/PROD/Disk3/redo02b.log /oracle/oradata/PROD/Disk4/redo03b.log 6 rows selected. SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> ! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ ls Disk1 Disk2 Disk3 Disk4 Disk5 Script admin flash_recovery_area oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd Script oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ mkdir Cbackup_20091119 oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ vi Cbackup_20091119.sql Cbackup_20091119 Script ================================================================================== rem##datafile !cp /oracle/oradata/PROD/Disk1/system01.dbf /oracle/oradata/PROD/Script/Cbackup_20091119/system01.dbf !cp /oracle/oradata/PROD/Disk2/undotbs01.dbf /oracle/oradata/PROD/Script/Cbackup_20091119/undotbs01.dbf !cp /oracle/oradata/PROD/Disk1/sysaux01.dbf /oracle/oradata/PROD/Script/Cbackup_20091119/sysaux01.dbf !cp /oracle/oradata/PROD/Disk3/users01.dbf /oracle/oradata/PROD/Script/Cbackup_20091119/users01.dbf !cp /oracle/oradata/PROD/Disk4/example01.dbf /oracle/oradata/PROD/Script/Cbackup_20091119/example01.dbf !cp /oracle/oradata/PROD/Disk5/index01.dbf /oracle/oradata/PROD/Script/Cbackup_20091119/index01.dbf rem##controlfile !cp /oracle/oradata/PROD/Disk1/control01.ctl /oracle/oradata/PROD/Script/Cbackup_20091119/control01.ctl !cp /oracle/oradata/PROD/Disk2/control02.ctl /oracle/oradata/PROD/Script/Cbackup_20091119/control02.ctl !cp /oracle/oradata/PROD/Disk3/control03.ctl /oracle/oradata/PROD/Script/Cbackup_20091119/control03.ctl rem##logfile !cp /oracle/oradata/PROD/Disk5/redo03a.log /oracle/oradata/PROD/Script/Cbackup_20091119/redo03a.log !cp /oracle/oradata/PROD/Disk4/redo02a.log /oracle/oradata/PROD/Script/Cbackup_20091119/redo02a.log !cp /oracle/oradata/PROD/Disk3/redo01a.log /oracle/oradata/PROD/Script/Cbackup_20091119/redo01a.log !cp /oracle/oradata/PROD/Disk5/redo01b.log /oracle/oradata/PROD/Script/Cbackup_20091119/redo01b.log !cp /oracle/oradata/PROD/Disk3/redo02b.log /oracle/oradata/PROD/Script/Cbackup_20091119/redo02b.log !cp /oracle/oradata/PROD/Disk4/redo03b.log /oracle/oradata/PROD/Script/Cbackup_20091119/redo03b.log ======================================================================================================== oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ exit exit SQL> @/oracle/oradata/PROD/Script/Cbackup_20091119.sql SQL> startup ORACLE instance started. Total System Global Area 205520896 bytes Fixed Size 1218532 bytes Variable Size 67110940 bytes Database Buffers 134217728 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SQL> ! oracle@pgheo-ubuntu:/oracle/oradata/PROD$ ls Disk1 Disk2 Disk3 Disk4 Disk5 Script admin flash_recovery_area oracle@pgheo-ubuntu:/oracle/oradata/PROD$ cd Script/ oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ ls Cbackup_20091119 Cbackup_20091119.sql PROD_20091119 oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ cd Cbackup_20091119/ oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script/Cbackup_20091119$ ls control01.ctl example01.dbf redo01b.log redo03a.log system01.dbf control02.ctl index01.dbf redo02a.log redo03b.log undotbs01.dbf control03.ctl redo01a.log redo02b.log sysaux01.dbf users01.dbf oracle@pgheo-ubuntu:/oracle/oradata/PROD/Script$ exit exit SQL>