RMAN backup and recovery instance Test

Backup:

Db_fullbak_jssbook.bat

Name = "code" class = "SQL"> SET Oracle_SID = jssbook

Rman target/LOG = c: \ ORACLE \ SCRIPT \ BACKUP \ LOGS \ BAK _ % DATE :~ 0, 10%. LOG

Export File = c: \ ORACLE \ SCRIPT \ BACKUP \ DB_FULLBAK_JSSBOOK.RMAN

Db_fullbak_jssbook.rman

[Plain]

1. RUN {
2. Configure retention policy to recovery window of 14 DAYS;
3. Configure controlfile autobackup on;
4. Configure controlfile autobackup format for device type disk to 'C: \ ORACLE \ BACKUP \ % F ';
5. Allocate channel C1 device type disk format 'C: \ ORACLE \ BACKUP \ BAK _ % U ';
6. BACKUP DATABASE SKIP INACCESSIBLE
7. Plus archivelog filesperset 20
8. Delete all input;
9. Release channel C1;
10. }
11. Allocate channel for maintenance device type disk;
12. Crosscheck backupset;
13. Delete noprompt obsolete;

Construct Data:

...

Simulated loss:

...

Reboot error:

[SQL]

1. SQL> startup
2. The ORACLE routine has been started.
4. Total SystemGlobalArea 612368384 bytes
5. FixedSize1250428 bytes
6. VariableSize192940932 bytes
7. DatabaseBuffers 411041792 bytes
8. Redo Buffers 7135232 bytes
9. The database has been loaded.
10. ORA-01157: unable to identify/lock data file 4-see DBWR trace file
11. ORA-01110: data file 4:'C: \ ORACLE \ ORADATA \ JSSOOK \ JSSBOOK \ users01.dbf'

Fix:

[SQL]

1. C: \ oracle \ script>SetOracle_sid = jssbook
3. C: \ oracle \ script> rman target/
5. Recovery MANAGER: Release 10.2.0.1.0-ProductionOnWednesday, September 16, February 1 22:37:06, 2012
7. Copyright (c) 1982,200 5, Oracle.AllRights reserved.
9. Connected to the target database: JSSBOOK (DBID = 1507698744, not enabled)
11. RMAN> restore datafile 4
12. 2>;
14. Start restore from to 12
15. Use the target database control file to replace the recovery directory
16. Allocated channel: ORA_DISK_1
17. Channel ORA_DISK_1: sid = 156 devtype = DISK
19. Channel ORA_DISK_1: Recovering data file backup set
20. Channel ORA_DISK_1: Specifies the data file to be recovered from the backup set.
21. Restoring data file 00004 to C: \ ORACLE \ ORADATA \ JSSOOK \ JSSBOOK \ USERS01.DBF
22. Channel ORA_DISK_1: Reading the BACKUP section C: \ ORACLE \ BACKUP \ BAK_0FN28OQ1_1_1
23. Channel ORA_DISK_1: recovered backup segment 1
24. Segment handle = C: \ ORACLE \ BACKUP \ BAK_0FN28OQ1_1_1 mark = TAG20120201T215721
25. Channel ORA_DISK_1: Recovery completed, time: 00:00:36
26. The restore is completed from month 1 to Month 12.

Recovery:

[SQL]

1. RMAN> restore datafile 4
2. 2>;
4. Start restore from to 12
5. Use the target database control file to replace the recovery directory
6. Allocated channel: ORA_DISK_1
7. Channel ORA_DISK_1: sid = 156 devtype = DISK
9. Channel ORA_DISK_1: Recovering data file backup set
10. Channel ORA_DISK_1: Specifies the data file to be recovered from the backup set.
11. Restoring data file 00004 to C: \ ORACLE \ ORADATA \ JSSOOK \ JSSBOOK \ USERS01.DBF
12. Channel ORA_DISK_1: Reading the BACKUP section C: \ ORACLE \ BACKUP \ BAK_0FN28OQ1_1_1
13. Channel ORA_DISK_1: recovered backup segment 1
14. Segment handle = C: \ ORACLE \ BACKUP \ BAK_0FN28OQ1_1_1 mark = TAG20120201T215721
15. Channel ORA_DISK_1: Recovery completed, time: 00:00:36
16. The restore is completed from month 1 to Month 12.
18. RMAN> recover datafile 4
19. 2>;
21. Start recover from month 1 to Month 12
22. Use channel ORA_DISK_1
24. Restoring media...
25. Media Recovery completed. Time: 00:00:02
27. The recover is completed from month 1 to Month 12.

Verification:

[SQL]

1. RMAN>Alter Database Open
2. 2>;
4. Database opened
6. RMAN> host;
8. Microsoft Windows XP [version 5.1.2600]
9. (C) Copyright 1985-2001 Microsoft Corp.
11. C: \ oracle \ script> sqlplus scott/tiger
13. SQL * Plus: Release 10.2.0.1.0-ProductionOnWednesday, September 16, February 1 22:39:49, 2012
15. Copyright (c) 1982,200 5, Oracle.AllRights reserved.
18. Connect:
19. OracleDatabase10g Enterprise Edition Release 10.2.0.1.0-Production
20. WithThe Partitioning, OLAPAndData Mining options
22. SQL>Select*FromTemp1;
24. NAME
25. --------------------
26. Test1
27. Test2
28. Test3
30. SQL>