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

1. Back up all archive log files

RMAN > backup archivelog all delete input

Second: various options for restore archivelog

0. According to RAC thread restore archivelog from logseq 6160 thread 2

1.restore archivelog all recovers all archive log files

RMAN > restore archivelog all

two。 Restore only the four archive log files from 5 to 8

RMAN > restore archivelog from logseq 5 until logseq 8

3. Recovery starts from the fifth archive log

RMAN > restore archivelog from logseq 5

4. Restore archived logs within 7 days

RMAN > restore archivelog from time 'sysdate-7'

5. Sequence between writing method

RMAN > restore archivelog sequence between 1 and 3

6. Which log file to restore to?

RMAN > restore archivelog until logseq 3

6. Restore from the fifth log

RMAN > restore archivelog low logseq 5

7. To the fifth log.

RMAN > restore archivelog high logseq 5

If you want to change and restore to another path, you can use the following statement

Set archivelog destination to'd:\ backup'

RMAN > run

2 > {allocate channel ci type disk

3 > set archivelog destination to'd:\ backup'

4 > restore archivelog all

5 > release channel ci

6 >}

8. View the required backup sets based on time:

ERPDB1@/orabak > rman target /

RMAN > list backup of archivelog time between "to_date ('2009-06-24 08lv) 0000mm hh34:mi:ss')" and "to_date (' 2009-06-241300mm hh34:mi:ss')"

Restore a specified period of time

RMAN > run {

2 > set archivelog destination to'/ orabak/testarch'

3 > SQL 'ALTER SESSION SET NLS_DATE_FORMAT= "YYYY-MM-DD:HH24:MI:SS"'

4 > restore archivelog time between '2009-06-24 09 0010 and' 2009-06-24 1215 10

5 >}

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.