Shulou(Shulou.com)06/01 Report--

In many books on database management of oracle, it is often talked about putting different types of files on different disks. In the process of individual self-study, it is not possible to achieve multiple disks. The following is how to construct a simulated environment by creating a directory on disk.

The directory Backup is used for database backups. Due to operational errors, the database system may crash, and sometimes the oracle system may have to be reinstalled. To prevent this from happening, make a full backup below. If the database crashes, just use backup to restore the database without reinstalling oracle. Here are the steps for backup.

SQL > connect sys/123456 as sysdba

Connected.

SQL > col name for A50

SQL > select * from v$controlfile

STATUS NAME IS_ BLOCK_SIZE

FILE_SIZE_BLKS

-

F:\ APP\ 272343\ ORADATA\ ORCL\ CONTROL01.CTL NO 16384

five hundred and ninety four

F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ CONTROL02.C NO 16384

TL

five hundred and ninety four

SQL > shutdown immediate

The database has been closed.

The database has been uninstalled.

The ORACLE routine has been closed.

SQL > host copy F:\ APP\ 272343\ ORADATA\ ORCL\ *. * E:\ Backup

F:\ APP\ 272343\ ORADATA\ ORCL\ CONTROL01.CTL

F:\ APP\ 272343\ ORADATA\ ORCL\ EXAMPLE01.DBF

F:\ APP\ 272343\ ORADATA\ ORCL\ REDO01.LOG

F:\ APP\ 272343\ ORADATA\ ORCL\ REDO02.LOG

F:\ APP\ 272343\ ORADATA\ ORCL\ REDO03.LOG

F:\ APP\ 272343\ ORADATA\ ORCL\ SYSAUX01.DBF

F:\ APP\ 272343\ ORADATA\ ORCL\ SYSTEM01.DBF

F:\ APP\ 272343\ ORADATA\ ORCL\ TEMP01.DBF

F:\ APP\ 272343\ ORADATA\ ORCL\ UNDOTBS01.DBF

F:\ APP\ 272343\ ORADATA\ ORCL\ USERS01.DBF

Ten files have been copied.

SQL > host copy F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ E:\ Backup\ database

F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ CONTROL02.CTL

1 file has been copied.

SQL > host copy F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ *. * E:\ Backup\ database

F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ CONTROL02.CTL

1 file has been copied.

SQL > host copy F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ * E:\ Backup\ database

F:\ APP\ 272343\ FLASH_RECOVERY_AREA\ ORCL\ CONTROL02.CTL

1 file has been copied.

SQL > startup

The ORACLE routine has been started.

Total System Global Area 1071333376 bytes

Fixed Size 1375792 bytes

Variable Size 754975184 bytes

Database Buffers 310378496 bytes

Redo Buffers 4603904 bytes

The database is loaded.

The database is already open.

SQL >

Results of col name for A20 and A25 effects

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.