Environment
Source Node : dba01.charan.com
Target Node : dba02.charan.com
Source and Target OS : Oracle Linux 6.4
DB Version : 11.2.0.1
DB Name in Source : PROD
DB Name in Target : CLONE
Step 1 : Take RMAN backup of Source Database
Please find the attachment rman_backup.sh for my RMAN backup script. The script works properly provided you change the following variable values inside the script as per your environment
1. export ORACLE_HOME=/u01/PROD/Oracle/OraHome
2. export ORACLE_SID=PROD
3. export BACKUPTO=/u03/BACKUPS/rman
4. log=/u03/BACKUPS/rman/logs/${ORACLE_SID}.${DATE}.log
Step 2 : Copy the RMAN backup and OracleHome backup from Source to Target
In my environment
RMAN Backup Directory is /u03/CLONE/rman
OracleHome Directory is /u01/PROD/Oracle/OraHome
[root@dba01.charan.com rman]# scp -r *20130919* dba02.charan.com:/u03/CLONE/rman
root@dba02.charan.com's password:
ctrl_auto_c-2608846944-20130919-00 100% 41MB 41.1MB/s 00:01
ctrl_auto_c-2608846944-20130919-01 100% 41MB 41.1MB/s 00:01
PROD_9fok91i8_1_120130919 100% 1150MB 32.9MB/s 00:35
PROD_9gok91i8_1_120130919 100% 454MB 30.3MB/s 00:15
PROD_9hok91i8_1_120130919 100% 780MB 31.2MB/s 00:25
PROD_9iok91i8_1_120130919 100% 897MB 32.0MB/s 00:28
PROD_9kok91nr_1_120130919 100% 94MB 31.4MB/s 00:03
PROD_9lok91nr_1_120130919 100% 96MB 31.9MB/s 00:03
PROD_9mok91nr_1_120130919 100% 77MB 38.5MB/s 00:02
PROD_9nok91nr_1_120130919 100% 1629KB 1.6MB/s 00:00
[root@dba01.charan.com rman]#
[root@dba01.charan.com Oracle]# scp -r OraHome.tar dba02.charan.com:/u03/CLONE/Oracle
root@dba02.charan.com's password:
OraHome.tar 100% 3988MB 33.8MB/s 01:58
[root@dba01.charan.com Oracle]#
Step 3 : Get the Online redo logs and Temporary tablespace information from Source DB
SQL> select tablespace_name from dba_temp_files;
TABLESPACE_NAME
------------------------------
TEMP
TS_TEMP_HISTORY_TABLE
SQL> select member from v$Logfile;
MEMBER
--------------------------------------------------------------------------------
/u01/PROD/Oracle/OraData/log02a.dbf
/u01/PROD/Oracle/OraData/log02b.dbf
/u01/PROD/Oracle/OraData/log01a.dbf
/u01/PROD/Oracle/OraData/log01b.dbf
Step 4 : Unzip the OracleHome in Target Node
[root@dba02.charan.com Oracle]# ls -ltr
total 4088044
drwxr-xr-x 2 test dba 4096 Sep 20 09:34 OraData
-rw-r--r-- 1 root root 4182056960 Sep 20 10:11 OraHome.tar
-rw------- 1 root root 74 Sep 20 10:13 nohup.out
[root@dba02.charan.com Oracle]# nohup tar -xvf OraHome.tar -C . &
[1] 13280
[root@dba02.charan.com Oracle]# nohup: appending output to `nohup.out'
[root@dba02.charan.com Oracle]# ls
nohup.out OraData OraHome OraHome.tar
[root@dba02.charan.com Oracle]# jobs
[1]+ Running nohup tar -xvf OraHome.tar -C . &
[root@dba02.charan.com Oracle]# jobs
[1]+ Done nohup tar -xvf OraHome.tar -C .
[root@dba02.charan.com Oracle]# du -sh OraHome
4.0G OraHome
[root@dba02.charan.com Oracle]#
Step 5 : Change Ownership of backup folder and Orahome folder to Target node database OS user
[root@dba02.charan.com CLONE]# ls
app Oracle rman
[root@dba02.charan.com CLONE]# chown -R test:dba Oracle
[root@dba02.charan.com CLONE]# chown -R test:dba rman
[root@dba02.charan.com CLONE]# ls -ltr
total 12
drwxr-xr-x 3 root root 4096 Sep 18 11:27 app
drwxr-xr-x 2 test dba 4096 Sep 20 09:37 rman
drwxr-xr-x 4 test dba 4096 Sep 20 10:18 Oracle
Step 6 : Create parameter file for Target Database
Prepare the Environment file for Target Instance
[test@dba02.charan.com ~]$ cat db.env
export ORACLE_HOME=/u03/CLONE/Oracle/OraHome
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=PROD
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
Prepare the init file for Target Instance
[test@dba02.charan.com dbs]$ cat initPROD.ora
db_name='PROD'
memory_target=1G
processes = 100
sessions = 200
db_block_size=8192
diagnostic_dest=/u03/CLONE/Oracle
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files=/u03/CLONE/Oracle/OraData/cntrl01.dbf,/u03/CLONE/Oracle/OraData/cntrl02.dbf,/u03/CLONE/Oracle/OraData/cntrl03.dbf
compatible ='11.2.0'
Step 7 : Start the Oracle Instance
[test@dba02.charan.com ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 20 10:29:55 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup nomount pfile=/u03/CLONE/Oracle/OraHome/dbs/initPROD.ora
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 616566616 bytes
Database Buffers 444596224 bytes
Redo Buffers 5554176 bytes
Step 8 : Connect to RMAN and restore the control files
[test@dba02.charan.com rman]$ pwd
/u03/CLONE/rman
[test@dba02.charan.com rman]$ ls -ltr
total 3722140
-rw-r----- 1 test dba 43057152 Sep 20 09:35 ctrl_auto_c-2608846944-20130919-00
-rw-r----- 1 test dba 43057152 Sep 20 09:35 ctrl_auto_c-2608846944-20130919-01
-rw-r----- 1 test dba 1205444608 Sep 20 09:36 PROD_9fok91i8_1_120130919
-rw-r----- 1 test dba 476176384 Sep 20 09:36 PROD_9gok91i8_1_120130919
-rw-r----- 1 test dba 818126848 Sep 20 09:36 PROD_9hok91i8_1_120130919
-rw-r----- 1 test dba 940220416 Sep 20 09:37 PROD_9iok91i8_1_120130919
-rw-r----- 1 test dba 98872320 Sep 20 09:37 PROD_9kok91nr_1_120130919
-rw-r----- 1 test dba 100375040 Sep 20 09:37 PROD_9lok91nr_1_120130919
-rw-r----- 1 test dba 1667584 Sep 20 09:37 PROD_9nok91nr_1_120130919
-rw-r----- 1 test dba 80684544 Sep 20 09:37 PROD_9mok91nr_1_120130919
[test@dba02.charan.com rman]$ rman target /
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Sep 20 10:32:00 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (not mounted)
RMAN> restore controlfile from '/u03/CLONE/rman/ctrl_auto_c-2608846944-20130919-01';
Starting restore at 20-SEP-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=73 device type=DISK
channel ORA_DISK_1: restoring control file
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
output file name=/u03/CLONE/Oracle/OraData/cntrl01.dbf
output file name=/u03/CLONE/Oracle/OraData/cntrl02.dbf
output file name=/u03/CLONE/Oracle/OraData/cntrl03.dbf
Finished restore at 20-SEP-13
Step 9 : Mount the database
RMAN> sql 'alter database mount';
sql statement: alter database mount
released channel: ORA_DISK_1
Step 10 : Catalog the backup files
RMAN> catalog start with '/u03/CLONE/rman';
searching for all files that match the pattern /u03/CLONE/rman
List of Files Unknown to the Database
=====================================
File Name: /u03/CLONE/rman/PROD_9gok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9fok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9iok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9mok91nr_1_120130919
File Name: /u03/CLONE/rman/PROD_9hok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9kok91nr_1_120130919
File Name: /u03/CLONE/rman/PROD_9nok91nr_1_120130919
File Name: /u03/CLONE/rman/PROD_9lok91nr_1_120130919
File Name: /u03/CLONE/rman/ctrl_auto_c-2608846944-20130919-00
File Name: /u03/CLONE/rman/ctrl_auto_c-2608846944-20130919-01
Do you really want to catalog the above files (enter YES or NO)? YES
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name: /u03/CLONE/rman/PROD_9gok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9fok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9iok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9mok91nr_1_120130919
File Name: /u03/CLONE/rman/PROD_9hok91i8_1_120130919
File Name: /u03/CLONE/rman/PROD_9kok91nr_1_120130919
File Name: /u03/CLONE/rman/PROD_9nok91nr_1_120130919
File Name: /u03/CLONE/rman/PROD_9lok91nr_1_120130919
File Name: /u03/CLONE/rman/ctrl_auto_c-2608846944-20130919-00
File Name: /u03/CLONE/rman/ctrl_auto_c-2608846944-20130919-01
Step 11 : Prepare the RMAN recovery script
Get the datafiles list :
Set col name for a60
Set pages 300
#The below sql can be run in Target database also, as database is already mounted
select 'set newname for datafile '||file#||' to "'||name||'"' from v$datafile;
SQL> SQL>
'SETNEWNAMEFORDATAFILE'||FILE#||'TO"'||NAME||'"'
--------------------------------------------------------------------------------
set newname for datafile 1 to "/u01/PROD/Oracle/OraData/system01.dbf"
set newname for datafile 2 to "/u01/PROD/Oracle/OraData/sysaux01.dbf"
set newname for datafile 3 to "/u01/PROD/Oracle/OraData/undo01.dbf"
set newname for datafile 4 to "/u01/PROD/Oracle/OraData/users01.dbf"
set newname for datafile 5 to "/u01/PROD/Oracle/OraData/example01.dbf"
set newname for datafile 6 to "/u01/PROD/Oracle/OraData/tablehistory.dbf"
set newname for datafile 7 to "/u01/PROD/Oracle/OraData/indexhist.dbf"
set newname for datafile 8 to "/u01/PROD/Oracle/OraData/system02.dbf"
set newname for datafile 9 to "/u01/PROD/Oracle/OraData/indexhist02.dbf"
set newname for datafile 10 to "/u01/PROD/Oracle/OraData/users02.dbf"
set newname for datafile 11 to "/u01/PROD/Oracle/OraData/tablehistory02.dbf"
set newname for datafile 12 to "/u01/PROD/Oracle/OraData/sysaux02.dbf"
set newname for datafile 13 to "/u01/PROD/Oracle/OraData/EXAMPLE02.dbf"
set newname for datafile 14 to "/u01/PROD/Oracle/OraData/indexhist03.dbf"
set newname for datafile 15 to "/u01/PROD/Oracle/OraData/tablehistory03.dbf"
set newname for datafile 16 to "/u01/PROD/Oracle/OraData/tablehistory04.dbf"
set newname for datafile 17 to "/u01/PROD/Oracle/OraData/tablehistory05.dbf"
set newname for datafile 18 to "/u01/PROD/Oracle/OraData/tablehistory06.dbf"
set newname for datafile 19 to "/u01/PROD/Oracle/OraData/tablehistory07.dbf"
set newname for datafile 20 to "/u01/PROD/Oracle/OraData/tablehistory08.dbf"
set newname for datafile 21 to "/u01/PROD/Oracle/OraData/indexhist04.dbf"
set newname for datafile 22 to "/u01/PROD/Oracle/OraData/tablehistory09.dbf"
set newname for datafile 23 to "/u01/PROD/Oracle/OraData/tablehistory10.dbf"
set newname for datafile 24 to "/u01/PROD/Oracle/OraData/users03.dbf"
set newname for datafile 25 to "/u01/PROD/Oracle/OraData/sysaux03.dbf"
set newname for datafile 26 to "/u01/PROD/Oracle/OraData/tablehistory11.dbf"
Now get the latest archivelog sequence number that is backed up by RMAN
As database is already mounted in target node, connect to it using rman and issue list backup by file; command
rman target /
RMAN> list backup by file;
1 336 301247276573 19-SEP-13 303 A 1 2 YES TAG20130919T200307
1 337 301247426899 19-SEP-13 302 A 1 2 YES TAG20130919T200307
1 338 301247430477 19-SEP-13 302 A 1 2 YES TAG20130919T200307
List of Control File Backups
============================
The latest archivelog log that is backed up by rman is 338.
You have to set until sequence class to 1 number more than the latest archivelog that is backed up.
Change the folder paths to Target node paths in the script
RMAN recovery script :
run {
set until sequence 339;
set newname for datafile 1 to '/u03/CLONE/Oracle/OraData/system01.dbf';
set newname for datafile 2 to '/u03/CLONE/Oracle/OraData/sysaux01.dbf';
set newname for datafile 3 to '/u03/CLONE/Oracle/OraData/undo01.dbf';
set newname for datafile 4 to '/u03/CLONE/Oracle/OraData/users01.dbf';
set newname for datafile 5 to '/u03/CLONE/Oracle/OraData/example01.dbf';
set newname for datafile 6 to '/u03/CLONE/Oracle/OraData/tablehistory.dbf';
set newname for datafile 7 to '/u03/CLONE/Oracle/OraData/indexhist.dbf';
set newname for datafile 8 to '/u03/CLONE/Oracle/OraData/system02.dbf';
set newname for datafile 9 to '/u03/CLONE/Oracle/OraData/indexhist02.dbf';
set newname for datafile 10 to '/u03/CLONE/Oracle/OraData/users02.dbf';
set newname for datafile 11 to '/u03/CLONE/Oracle/OraData/tablehistory02.dbf';
set newname for datafile 12 to '/u03/CLONE/Oracle/OraData/sysaux02.dbf';
set newname for datafile 13 to '/u03/CLONE/Oracle/OraData/EXAMPLE02.dbf';
set newname for datafile 14 to '/u03/CLONE/Oracle/OraData/indexhist03.dbf';
set newname for datafile 15 to '/u03/CLONE/Oracle/OraData/tablehistory03.dbf';
set newname for datafile 16 to '/u03/CLONE/Oracle/OraData/tablehistory04.dbf';
set newname for datafile 17 to '/u03/CLONE/Oracle/OraData/tablehistory05.dbf';
set newname for datafile 18 to '/u03/CLONE/Oracle/OraData/tablehistory06.dbf';
set newname for datafile 19 to '/u03/CLONE/Oracle/OraData/tablehistory07.dbf';
set newname for datafile 20 to '/u03/CLONE/Oracle/OraData/tablehistory08.dbf';
set newname for datafile 21 to '/u03/CLONE/Oracle/OraData/indexhist04.dbf';
set newname for datafile 22 to '/u03/CLONE/Oracle/OraData/tablehistory09.dbf';
set newname for datafile 23 to '/u03/CLONE/Oracle/OraData/tablehistory10.dbf';
set newname for datafile 24 to '/u03/CLONE/Oracle/OraData/users03.dbf';
set newname for datafile 25 to '/u03/CLONE/Oracle/OraData/sysaux03.dbf';
set newname for datafile 26 to '/u03/CLONE/Oracle/OraData/tablehistory11.dbf';
restore database;
switch datafile all;
recover database;
}
Copy the script and paste it in RMAN prompt
Ensure that the recovery is successful
Starting recover at 20-SEP-13
using channel ORA_DISK_1
using channel ORA_DISK_2
using channel ORA_DISK_3
using channel ORA_DISK_4
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=337
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=338
channel ORA_DISK_1: reading from backup piece /u03/BACKUPS/rman/PROD_9nok91nr_1_120130919
channel ORA_DISK_1: errors found reading piece handle=/u03/BACKUPS/rman/PROD_9nok91nr_1_120130919
channel ORA_DISK_1: failover to piece handle=/u03/CLONE/rman/PROD_9nok91nr_1_120130919 tag=TAG20130919T200307
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u03/CLONE/Oracle/OraHome/dbs/arch1_337_823688123.dbf thread=1 sequence=337
archived log file name=/u03/CLONE/Oracle/OraHome/dbs/arch1_338_823688123.dbf thread=1 sequence=338
media recovery complete, elapsed time: 00:00:05
Finished recover at 20-SEP-13
Step 12 : Rename the online redolog files and open the database with resetlogs option
[test@dba02.charan.com rman]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 20 11:07:40 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database rename file '/u01/PROD/Oracle/OraData/log01a.dbf' to '/u03/CLONE/Oracle/OraData/log01a.dbf';
alter database rename file '/u01/PROD/Oracle/OraData/log01b.dbf' to '/u03/CLONE/Oracle/OraData/log01b.dbf';
alter database rename file '/u01/PROD/Oracle/OraData/log02a.dbf' to '/u03/CLONE/Oracle/OraData/log02a.dbf';
alter database rename file '/u01/PROD/Oracle/OraData/log02b.dbf' to '/u03/CLONE/Oracle/OraData/log02b.dbf';
alter database open resetlogs;
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
SQL>
Database altered.
Step 13 : Create a new temporary tablespace and make it default temporary tablespace
SQL> create temporary tablespace tempclone tempfile '/u03/CLONE/Oracle/OraData/tempclone.dbf' size 1g;
Tablespace created.
SQL> alter database default temporary tablespace tempclone;
Database altered.
SQL> drop tablespace TEMP including contents and datafiles;
Tablespace dropped.
SQL> drop tablespace TS_TEMP_HISTORY_TABLE including contents and datafiles;
Tablespace dropped.
Step 14 (Optional) : Change the Database Name
If you want to change the name of the database you can use nid utility
shut down the database and start it in mount mode
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 616566616 bytes
Database Buffers 444596224 bytes
Redo Buffers 5554176 bytes
Database mounted.
[test@dba02.charan.com rman]$ which nid
/u03/CLONE/Oracle/OraHome/bin/nid
[test@dba02.charan.com rman]$ nid target=/ DBNAME=CLONE
DBNEWID: Release 11.2.0.1.0 - Production on Fri Sep 20 11:15:14 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to database PROD (DBID=2608846944)
Connected to server version 11.2.0
Control Files in database:
/u03/CLONE/Oracle/OraData/cntrl01.dbf
/u03/CLONE/Oracle/OraData/cntrl02.dbf
/u03/CLONE/Oracle/OraData/cntrl03.dbf
Change database ID and database name PROD to CLONE? (Y/[N]) => Y
Proceeding with operation
Changing database ID from 2608846944 to 4138824066
Changing database name from PROD to CLONE
Control File /u03/CLONE/Oracle/OraData/cntrl01.dbf - modified
Control File /u03/CLONE/Oracle/OraData/cntrl02.dbf - modified
Control File /u03/CLONE/Oracle/OraData/cntrl03.dbf - modified
Datafile /u03/CLONE/Oracle/OraData/system01.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/sysaux01.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/undo01.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/users01.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/example01.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/indexhist.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/system02.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/indexhist02.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/users02.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory02.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/sysaux02.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/EXAMPLE02.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/indexhist03.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory03.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory04.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory05.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory06.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory07.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory08.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/indexhist04.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory09.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory10.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/users03.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/sysaux03.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tablehistory11.db - dbid changed, wrote new name
Datafile /u03/CLONE/Oracle/OraData/tempclone.db - dbid changed, wrote new name
Control File /u03/CLONE/Oracle/OraData/cntrl01.dbf - dbid changed, wrote new name
Control File /u03/CLONE/Oracle/OraData/cntrl02.dbf - dbid changed, wrote new name
Control File /u03/CLONE/Oracle/OraData/cntrl03.dbf - dbid changed, wrote new name
Instance shut down
Database name changed to CLONE.
Modify parameter file and generate a new password file before restarting.
Database ID for database CLONE changed to 4138824066.
All previous backups and archived redo logs for this database are unusable.
Database has been shutdown, open database with RESETLOGS option.
Succesfully changed database name and ID.
DBNEWID - Completed succesfully.
[test@dba02.charan.com rman]$
nid with shutdown the database, you have to make changes to environment file and pfile to reflect to new database name and open the database with resetlogs option.
Change the Oracle SID in environment file and database name in init file. Also create initfile name in the format init$SID.ora
[test@dba02.charan.com ~]$ cat db.env
export ORACLE_HOME=/u03/CLONE/Oracle/OraHome
export PATH=$ORACLE_HOME/bin:$PATH
export ORACLE_SID=CLONE
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
[test@dba02.charan.com ~]$ cat /u03/CLONE/Oracle/OraHome/dbs/initCLONE.ora
db_name='CLONE'
memory_target=1G
processes = 100
sessions = 200
db_block_size=8192
diagnostic_dest=/u03/CLONE/Oracle
open_cursors=300
remote_login_passwordfile='EXCLUSIVE'
undo_tablespace='UNDOTBS1'
control_files=/u03/CLONE/Oracle/OraData/cntrl01.dbf,/u03/CLONE/Oracle/OraData/cntrl02.dbf,/u03/CLONE/Oracle/OraData/cntrl03.dbf
compatible ='11.2.0'
[test@dba02.charan.com ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Fri Sep 20 11:22:30 2013
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 1068937216 bytes
Fixed Size 2220200 bytes
Variable Size 616566616 bytes
Database Buffers 444596224 bytes
Redo Buffers 5554176 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL> select name,open_mode from v$database;
NAME OPEN_MODE
--------- --------------------
CLONE READ WRITE
COMPLETED