Clonacion en frio oracle 9i hp-ux
[hmapfre-oracle(oracle) en TWA]> sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Fri Apr 3 00:49:15 2009
Copyright (c) 1982, 2002, Oracle Corporation.All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
- Cambiar modo de archivos vxsf a modoS.O.
[root@hmapfre]# mount -F vxfs -o remount /dev/vg-TWA/lv-TWA01 /DBs/TWA
[root@hmapfre]# mount -F vxfs -o remount /dev/TW-A/TW-A /DBs/TW-A
- Copiar archivos de base de datos la nuevodirectorio
[hmapfre-oracle(oracle) en TWAX]> pwd
/DBs/TWA
[hmapfre-oracle(oracle) en TWAX]> l
total 275770730
-rw-rw---- 1 oracle dba 5857280 Apr 3 01:11 cntrlTWMAB02.ctl
-rw-rw----1 oracle dba 5857280 Apr 3 01:11 cntrlTWMAB03.ctl
-rw-rw---- 1 oracle dba 21474844672 Apr 3 01:11 data01.dbf
-rw-rw---- 1 oracle dba 21474844672 Apr 301:11 data02.dbf
-rw-rw---- 1 oracle dba 21474844672 Apr 3 01:11 data03.dbf
-rw-rw---- 1 oracle dba 21474844672 Apr 3 01:11 indx01.dbf
-rw-rw---- 1 oracle dba21474844672 Apr 3 01:11 indx02.dbf
-rw-rw---- 1 oracle dba 21474844672 Apr 3 01:11 indx03.dbf
drwxr-xr-x 2 root root 96 Jun 25 2008 lost+found
-rw-rw---- 1oracle dba 104858624 Apr 3 01:10 redo01.log
-rw-rw---- 1 oracle dba 104858624 Apr 3 01:10 redo02.log
-rw-rw---- 1 oracle dba 104858624 Apr 3 01:10 redo03.log-rw-rw---- 1 oracle dba 104858624 Apr 3 01:10 redo04.log
-rw-rw---- 1 oracle dba 104858624 Apr 3 01:11 redo05.log
-rw-rw---- 1 oracle dba 5368717312 Apr 301:11 roll01.dbf
-rw-rw---- 1 oracle dba 2147491840 Apr 3 01:11 syst01.dbf
-rw-rw---- 1 oracle dba 2147491840 Apr 2 19:59 temp01.dbf
-rw-rw---- 1 oracle dba...
Regístrate para leer el documento completo.