HOT CLONING IN RAC1
===================
login as: oracle
oracle@192.168.1.45's password:
Last login: Tue Mar 12 10:39:59 2013 from 192.168.1.61
[oracle@rac1 ~]$ ps -ef |grep -i pmon
oracle 4554 4493 0 10:22 pts/1 00:00:00 grep -i pmon
[oracle@rac1 ~]$ cd /prod/
[oracle@rac1 prod]$ ls
app cold_bkp exp krish lost+found nikee nohup.out ram ramhot sbi standby madhu usa
[oracle@rac1 prod]$ cd ram
[oracle@rac1 ram]$ . ram.env
[oracle@rac1 ram]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 10:23:14 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 1219784 bytes
Variable Size 201327416 bytes
Database Buffers 213909504 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /prod/ram/admin/arch
Oldest online log sequence 27
Next log sequence to archive 29
Current log sequence 29
SQL>
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 808610 08-FEB-13
2 NOT ACTIVE 808610 08-FEB-13
3 NOT ACTIVE 808610 08-FEB-13
4 NOT ACTIVE 808610 08-FEB-13
5 NOT ACTIVE 808610 08-FEB-13
SQL> !mkdir -p /prod/ram/hot
SQL> alter database begin backup;
Database altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 ram]$ cd oradata/
[oracle@rac1 oradata]$ ls
control01.ctl control02.ctl ramdata01.dbf redo01.log redo02.log redo03.log sysaux.dbf system.dbf temp.dbf undo.db
[oracle@rac1 oradata]$ cp *.dbf *.ctl /prod/ram/hot/
[oracle@rac1 oradata]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 10:35:29 2013
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> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 887621 13-MAR-13
2 ACTIVE 887621 13-MAR-13
3 ACTIVE 887621 13-MAR-13
4 ACTIVE 887621 13-MAR-13
5 ACTIVE 887621 13-MAR-13
SQL> alter database end backup;
Database altered.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 887621 13-MAR-13
2 NOT ACTIVE 887621 13-MAR-13
3 NOT ACTIVE 887621 13-MAR-13
4 NOT ACTIVE 887621 13-MAR-13
5 NOT ACTIVE 887621 13-MAR-13
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /prod/ram/admin/arch
Oldest online log sequence 28
Next log sequence to archive 30
Current log sequence 30
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 oradata]$ cd ../admin/arch/
[oracle@rac1 arch]$ ls
1_10_806574211.dbf 1_14_806574211.dbf 1_18_806574211.dbf 1_22_806574211.dbf 1_26_806574211.dbf 1_6_806574211.dbf
1_11_806574211.dbf 1_15_806574211.dbf 1_19_806574211.dbf 1_23_806574211.dbf 1_27_806574211.dbf 1_7_806574211.dbf
1_12_806574211.dbf 1_16_806574211.dbf 1_20_806574211.dbf 1_24_806574211.dbf 1_28_806574211.dbf 1_8_806574211.dbf
1_13_806574211.dbf 1_17_806574211.dbf 1_21_806574211.dbf 1_25_806574211.dbf 1_29_806574211.dbf 1_9_806574211.dbf
[oracle@rac1 arch]$ ls -ltrh |tail
-rw-r----- 1 oracle dba 4.0M Mar 8 12:17 1_20_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 8 12:17 1_21_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 8 13:11 1_22_806574211.dbf
-rw-r----- 1 oracle dba 130K Mar 9 11:19 1_23_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 11:34 1_24_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 11:35 1_25_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 12:04 1_26_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 12:30 1_27_806574211.dbf
-rw-r----- 1 oracle dba 2.0M Mar 13 10:23 1_28_806574211.dbf
-rw-r----- 1 oracle dba 1.9M Mar 13 10:36 1_29_806574211.dbf
[oracle@rac1 arch]$ cp 1_28_806574211.dbf 1_29_806574211.dbf /prod/ram/hot/
[oracle@rac1 arch]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 10:38:48 2013
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> sho parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 arch]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$ vi initram.ora
[oracle@rac1 dbs]$ scp initram.ora rac2:/u01/app/oracle/product/10.2.0.1/dbs/
oracle@rac2's password:
Permission denied, please try again.
oracle@rac2's password:
initram.ora 100% 366 0.4KB/s 00:00
[oracle@rac1 dbs]$ cd /prod/ram/hot/
[oracle@rac1 hot]$ ls
1_28_806574211.dbf control01.ctl ramdata01.dbf redo02.log sysaux.dbf temp.dbf user.dbf
1_29_806574211.dbf control02.ctl redo01.log redo03.log system.dbf undo.dbf
[oracle@rac1 hot]$ scp * rac2:/prod/ram/oradata/
oracle@rac2's password:
1_28_806574211.dbf 100% 2036KB 2.0MB/s 00:01
1_29_806574211.dbf 100% 1935KB 1.9MB/s 00:00
control01.ctl 100% 5936KB 5.8MB/s 00:01
control02.ctl 100% 5936KB 5.8MB/s 00:00
ramdata01.dbf 100% 10MB 3.3MB/s 00:03
redo01.log 100% 4097KB 4.0MB/s 00:00
redo02.log 100% 4097KB 4.0MB/s 00:01
redo03.log 100% 4097KB 4.0MB/s 00:01
sysaux.dbf 100% 100MB 4.6MB/s 00:22
system.dbf 100% 1000MB 3.6MB/s 04:38
temp.dbf 100% 100MB 7.1MB/s 00:14
undo.dbf 100% 100MB 12.5MB/s 00:08
user.dbf 100% 100MB 12.5MB/s 00:08
[oracle@rac1 hot]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 11:22:37 2013
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> alter database backup controlfile to trace as '/prod/ram/hot/ctl.sql';
Database altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 hot]$ scp /prod/ram/hot/ctl.sql rac2:/prod/ram/oradata
oracle@rac2's password:
ctl.sql 100% 7011 6.9KB/s 00:00
[oracle@rac1 hot]$
===================
login as: oracle
oracle@192.168.1.45's password:
Last login: Tue Mar 12 10:39:59 2013 from 192.168.1.61
[oracle@rac1 ~]$ ps -ef |grep -i pmon
oracle 4554 4493 0 10:22 pts/1 00:00:00 grep -i pmon
[oracle@rac1 ~]$ cd /prod/
[oracle@rac1 prod]$ ls
app cold_bkp exp krish lost+found nikee nohup.out ram ramhot sbi standby madhu usa
[oracle@rac1 prod]$ cd ram
[oracle@rac1 ram]$ . ram.env
[oracle@rac1 ram]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 10:23:14 2013
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 419430400 bytes
Fixed Size 1219784 bytes
Variable Size 201327416 bytes
Database Buffers 213909504 bytes
Redo Buffers 2973696 bytes
Database mounted.
Database opened.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /prod/ram/admin/arch
Oldest online log sequence 27
Next log sequence to archive 29
Current log sequence 29
SQL>
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 808610 08-FEB-13
2 NOT ACTIVE 808610 08-FEB-13
3 NOT ACTIVE 808610 08-FEB-13
4 NOT ACTIVE 808610 08-FEB-13
5 NOT ACTIVE 808610 08-FEB-13
SQL> !mkdir -p /prod/ram/hot
SQL> alter database begin backup;
Database altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 ram]$ cd oradata/
[oracle@rac1 oradata]$ ls
control01.ctl control02.ctl ramdata01.dbf redo01.log redo02.log redo03.log sysaux.dbf system.dbf temp.dbf undo.db
[oracle@rac1 oradata]$ cp *.dbf *.ctl /prod/ram/hot/
[oracle@rac1 oradata]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 10:35:29 2013
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> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 ACTIVE 887621 13-MAR-13
2 ACTIVE 887621 13-MAR-13
3 ACTIVE 887621 13-MAR-13
4 ACTIVE 887621 13-MAR-13
5 ACTIVE 887621 13-MAR-13
SQL> alter database end backup;
Database altered.
SQL> select * from v$backup;
FILE# STATUS CHANGE# TIME
---------- ------------------ ---------- ---------
1 NOT ACTIVE 887621 13-MAR-13
2 NOT ACTIVE 887621 13-MAR-13
3 NOT ACTIVE 887621 13-MAR-13
4 NOT ACTIVE 887621 13-MAR-13
5 NOT ACTIVE 887621 13-MAR-13
SQL> alter system switch logfile;
System altered.
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /prod/ram/admin/arch
Oldest online log sequence 28
Next log sequence to archive 30
Current log sequence 30
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 oradata]$ cd ../admin/arch/
[oracle@rac1 arch]$ ls
1_10_806574211.dbf 1_14_806574211.dbf 1_18_806574211.dbf 1_22_806574211.dbf 1_26_806574211.dbf 1_6_806574211.dbf
1_11_806574211.dbf 1_15_806574211.dbf 1_19_806574211.dbf 1_23_806574211.dbf 1_27_806574211.dbf 1_7_806574211.dbf
1_12_806574211.dbf 1_16_806574211.dbf 1_20_806574211.dbf 1_24_806574211.dbf 1_28_806574211.dbf 1_8_806574211.dbf
1_13_806574211.dbf 1_17_806574211.dbf 1_21_806574211.dbf 1_25_806574211.dbf 1_29_806574211.dbf 1_9_806574211.dbf
[oracle@rac1 arch]$ ls -ltrh |tail
-rw-r----- 1 oracle dba 4.0M Mar 8 12:17 1_20_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 8 12:17 1_21_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 8 13:11 1_22_806574211.dbf
-rw-r----- 1 oracle dba 130K Mar 9 11:19 1_23_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 11:34 1_24_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 11:35 1_25_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 12:04 1_26_806574211.dbf
-rw-r----- 1 oracle dba 4.0M Mar 9 12:30 1_27_806574211.dbf
-rw-r----- 1 oracle dba 2.0M Mar 13 10:23 1_28_806574211.dbf
-rw-r----- 1 oracle dba 1.9M Mar 13 10:36 1_29_806574211.dbf
[oracle@rac1 arch]$ cp 1_28_806574211.dbf 1_29_806574211.dbf /prod/ram/hot/
[oracle@rac1 arch]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 10:38:48 2013
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> sho parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 arch]$ cd $ORACLE_HOME/dbs
[oracle@rac1 dbs]$ vi initram.ora
[oracle@rac1 dbs]$ scp initram.ora rac2:/u01/app/oracle/product/10.2.0.1/dbs/
oracle@rac2's password:
Permission denied, please try again.
oracle@rac2's password:
initram.ora 100% 366 0.4KB/s 00:00
[oracle@rac1 dbs]$ cd /prod/ram/hot/
[oracle@rac1 hot]$ ls
1_28_806574211.dbf control01.ctl ramdata01.dbf redo02.log sysaux.dbf temp.dbf user.dbf
1_29_806574211.dbf control02.ctl redo01.log redo03.log system.dbf undo.dbf
[oracle@rac1 hot]$ scp * rac2:/prod/ram/oradata/
oracle@rac2's password:
1_28_806574211.dbf 100% 2036KB 2.0MB/s 00:01
1_29_806574211.dbf 100% 1935KB 1.9MB/s 00:00
control01.ctl 100% 5936KB 5.8MB/s 00:01
control02.ctl 100% 5936KB 5.8MB/s 00:00
ramdata01.dbf 100% 10MB 3.3MB/s 00:03
redo01.log 100% 4097KB 4.0MB/s 00:00
redo02.log 100% 4097KB 4.0MB/s 00:01
redo03.log 100% 4097KB 4.0MB/s 00:01
sysaux.dbf 100% 100MB 4.6MB/s 00:22
system.dbf 100% 1000MB 3.6MB/s 04:38
temp.dbf 100% 100MB 7.1MB/s 00:14
undo.dbf 100% 100MB 12.5MB/s 00:08
user.dbf 100% 100MB 12.5MB/s 00:08
[oracle@rac1 hot]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.1.0 - Production on Wed Mar 13 11:22:37 2013
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> alter database backup controlfile to trace as '/prod/ram/hot/ctl.sql';
Database altered.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 hot]$ scp /prod/ram/hot/ctl.sql rac2:/prod/ram/oradata
oracle@rac2's password:
ctl.sql 100% 7011 6.9KB/s 00:00
[oracle@rac1 hot]$
No comments:
Post a Comment