Base de datos de SQL

SQL> show parameter control_file;

NAME TYPE VALUE

------------------------------------ ----------- ------------------------------

control_file_record_keep_time integer 7

control_files string C:\APP\CIBERTEC\ORADATA\CIBERT

EC\CONTROL01.CTL, C:\APP\CIBER

TEC\FLASH_RECOVERY_AREA\CIBERT

EC\CONTROL02.CTL

SQL> ALTER SYSTEM SET CONTROL_FILES=

2 'C:\APP\CIBERTEC\ORADATA\CIBERTEC\CONTROL01.CTL',

3 'C:\APP\CIBERTEC\FLASH_RECOVERY_AREA\CIBERTEC\CONTROL02.CTL',

4 'C:\ADMIN1\CONTROL1.CTL',

5 'C:\ADMIN2\CONTROL2.CTL'

6 SCOPE=SPFILE;

Sistema modificado.

SQL> SHUTDOWN IMMEDIATE;

Base de datos cerrada.

Base de datos desmontada.

Instancia ORACLE cerrada.

SQL>

SQL> STARTUP

Instancia ORACLE iniciada.

Total System Global Area 535662592 bytes

Fixed Size 1375792 bytes

Variable Size 398459344 bytes

Database Buffers 130023424 bytes

Redo Buffers 5804032 bytes

Base de datos montada.

Base de datos abierta.

SQL>

SQL>

SQL> select member from v$logfile;

MEMBER

--------------------------------------------------------------------------------

C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO03.LOG

C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO02.LOG

C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO01.LOG

SQL> SELECT GROUP#, member FROM V$LOGFILE;

GROUP#

----------

MEMBER

--------------------------------------------------------------------------------

3

C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO03.LOG

2

C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO02.LOG

1

C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO01.LOG

SQL> SHUTDOWN IMMEDIATE;

Base de datos cerrada.

Base de datos desmontada.

Instancia ORACLE cerrada.

SQL>

SQL>

SQL> STARTUP MOUNT

Instancia ORACLE iniciada.

Total System Global Area 535662592 bytes

Fixed Size 1375792 bytes

Variable Size 398459344 bytes

Database Buffers 130023424 bytes

Redo Buffers 5804032 bytes

Base de datos montada.

SQL> ALTER DATABASE RENAME FILE

2 'C:\APP\CIBERTEC\ORADATA\CIBERTEC\REDO01.LOG',

...