oracle常用命令大汇总(五)

29l2j42fo4

第十二章: backup and recovery

    1. v$sga,v$instance,v$process,v$bgprocess,v$database,v$datafile,v$sgastat

    2. rman need set dbwr_io_slaves or backup_tape_io_slaves and large_pool_size

    3. monitoring parallel rollback

    > v$fast_start_servers , v$fast_start_transactions

    4.perform a closed database backup (noarchivelog)

    > shutdown immediate

    > cp files /backup/

    > startup

    5.restore to a different location

    > connect system/manager as sysdba

    > startup mount

    > alter database rename file ''/disk1/../user.dbf''to ''/disk2/../user.dbf'';

    > alter database open;

    6.recover syntax

    --recover a mounted database

    >recover database;

    >recover datafile ''/disk1/data/df2.dbf'';

    >alter database recover database;

    --recover an opened database

    >recover tablespace user_data;

    >recover datafile 2;

    >alter database recover datafile 2;

    7.how to apply redo log files automatically

    >set autorecovery on

    >recover automatic datafile 4;

    8.complete recovery:

    --method 1(mounted databae)

    >copy c:\backup\user.dbf c:\oradata\user.dbf

    >startup mount

    >recover datafile ''c:\oradata\user.dbf;

    >alter database open;

    --method 2(opened database,initially opened,not system or rollback datafile)


    >copy c:\backup\user.dbf c:\oradata\user.dbf (alter tablespace offline)

    >recover datafile ''c:\oradata\user.dbf'' or

    >recover tablespace user_data;

    >alter database datafile ''c:\oradata\user.dbf'' online or

    >alter tablespace user_data online;

    --method 3(opened database,initially closed not system or rollback datafile)

    >startup mount

    >alter database datafile ''c:\oradata\user.dbf'' offline;

    >alter database open

    >copy c:\backup\user.dbf d:\oradata\user.dbf

    >alter database rename file ''c:\oradata\user.dbf''to ''d:\oradata\user.dbf''

    >recover datafile ''e:\oradata\user.dbf'' or recover tablespace user_data;

    >alter tablespace user_data online;

    --method 4(loss of data file with no backup and have all archive log)

    >alter tablespace user_data offline immediate;

    >alter database create datafile ''d:\oradata\user.dbf''as ''c:\oradata\user.dbf''''

    >recover tablespace user_data;

    >alter tablespace user_data online

    5.perform an open database backup

    > alter tablespace user_data begin backup;

    > copy files /backup/

    > alter database datafile ''/c:/../data.dbf'' end backup;

    > alter system switch logfile;

    6.backup a control file

    > alter database backup controlfile to ''control1.bkp'';

    > alter database backup controlfile to trace;

    7.recovery (noarchivelog mode)

    > shutdown abort

    > cp files

    > startup

    8.recovery of file in backup mode

    >alter database datafile 2 end backup;

    9.clearing redo log file

    >alter database clear unarchived logfile group 1;

    >alter database clear unarchived logfile group 1 unrecoverable datafile;

    10.redo log recovery

    >alter database add logfile group 3 ''c:\oradata\redo03.log''size 1000k;

    >alter database drop logfile group 1;

    >alter database open;

    or >cp c:\oradata\redo02.log'' c:\oradata\redo01.log

    >alter database clear logfile ''c:\oradata\log01.log'';