Oracle冷バックアップの完全バックアップ
1254 ワード
oracle 。
:
1. sqlplus
2. v$controlfile 。
3. v$logfile 。
4. dba_data_files , 。
5. v$datafile v$tablespace , 。
6. show parameter pfile 。
7. (shutdown immediate|transactional|nomal)
8. 。
9.
:
set line 120;
set pagesize 30;
select name from v$controlfile;
col member for a60;
select member from v$logfile;
col file_name for a60;
col tablespace_name for a15;
select file_name,tablespace_name from dba_data_files;
show parameter pfile;
sqlplus /nolog
conn sys/ticket as sysdba
shutdown immediate
host copy D:\app\Administrator\oradata\ticket\*.* D:\app\Administrator\backup\*
host copy D:\app\Administrator\product\11.1.0\db_1\database\*.* D:\app\Administrator\backup\database\*
startup
:
1.select count(1) from sales;
2.
truncate table sales;
2.conn sys/ticket as sysdba
3.shutdown immediate;
4.
5.
startup