Clonacion en frio oracle 9i hp-ux

Solo disponible en BuenasTareas
  • Páginas : 3 (681 palabras )
  • Descarga(s) : 0
  • Publicado : 2 de junio de 2011
Leer documento completo
Vista previa del texto
- Shutdown base a clonar.

[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...
tracking img