Oracle cold Backup recovery database in NOARCHIVELOG Mode

Cold backup is to copy the database-related files. It can only perform restoration operations and cannot perform restoration operations. Log on to the database, find the path for storing data files, control files, and log files, close the database, and back up the listed files.

1. SQL> showUser
2. USERIs"SYS"
3. SQL>SelectINSTANCE_NAME, STATUSFromV $ instance;
5. INSTANCE_NAME STATUS
6. ----------------------------
7. DataOPEN
9. SQL>SelectFile_nameFromDba_data_files;
11. FILE_NAME
12. --------------------------------------------------------------------------------
13. /U01/app/Oracle/oradata/data/users01.dbf
14. /U01/app/oracle/oradata/data/sysaux01.dbf
15. /U01/app/oracle/oradata/data/undotbs01.dbf
16. /U01/app/oracle/oradata/data/system01.dbf
18. SQL>Select Name FromV $ controlfile;
20. NAME
21. --------------------------------------------------
22. /U01/app/oracle/oradata/data/control01.ctl
23. /U01/app/oracle/oradata/data/control02.ctl
24. /U01/app/oracle/oradata/data/control03.ctl
26. SQL>SelectMemberFromV $ logfile;
28. MEMBER
29. --------------------------------------------------
30. /U01/app/oracle/oradata/data/redo03.log
31. /U01/app/oracle/oradata/data/redo02.log
32. /U01/app/oracle/oradata/data/redo01.log
34. SQL> shutdown immediate
35. The database has been closed.
36. The database has been detached.
37. The ORACLE routine has been disabled.

Temporary files can not be backed up. In fact, parameter files should also be backed up. Here, I copied all the above files to/u01/datafile/, and then deleted all the files before the backup to simulate disk faults.

1. [Oracle @ linux datafile] $ pwd
2. /U01/datafile
3. [Oracle @ linux datafile] $ cp/u01/app/oracle/oradata/data/*/u01/datafile/
4. [Oracle @ linux datafile] $ ll
5. Total 954144
6. -Rw-r----- 1 oracle oinstall 7061504 10-08 control01.ctl
7. -Rw-r----- 1 oracle oinstall 7061504 10-08 control02.ctl
8. -Rw-r----- 1 oracle oinstall 7061504 10-08 control03.ctl
9. -Rw-r----- 1 oracle oinstall 52429312 10-08 redo01.log
10. -Rw-r----- 1 oracle oinstall 52429312 10-08 redo02.log
11. -Rw-r----- 1 oracle oinstall 52429312 10-08 redo03.log
12. -Rw-r----- 1 oracle oinstall 262152192 10-08 sysaux01.dbf
13. -Rw-r----- 1 oracle oinstall 503324672 10-08 system01.dbf
14. -Rw-r----- 1 oracle oinstall 20979712 10-08 temp01.dbf
15. -Rw-r----- 1 oracle oinstall 26222592 10-08 undotbs01.dbf
16. -Rw-r----- 1 oracle oinstall 5251072 10-08 users01.dbf
17. [Oracle @ linux datafile] $ rm-rf temp01.dbf
18. [Oracle @ linux datafile] $ ll
19. Total 953560
20. -Rw-r----- 1 oracle oinstall 7061504 10-08 control01.ctl
21. -Rw-r----- 1 oracle oinstall 7061504 10-08 control02.ctl
22. -Rw-r----- 1 oracle oinstall 7061504 10-08 control03.ctl
23. -Rw-r----- 1 oracle oinstall 52429312 10-08 redo01.log
24. -Rw-r----- 1 oracle oinstall 52429312 10-08 redo02.log
25. -Rw-r----- 1 oracle oinstall 52429312 10-08 redo03.log
26. -Rw-r----- 1 oracle oinstall 262152192 10-08 sysaux01.dbf
27. -Rw-r----- 1 oracle oinstall 503324672 10-08 system01.dbf
28. -Rw-r----- 1 oracle oinstall 26222592 10-08 undotbs01.dbf
29. -Rw-r----- 1 oracle oinstall 5251072 10-08 users01.dbf
30. [Oracle @ linux datafile] $ rm-rf/u01/app/oracle/oradata/data/

The database cannot be started normally.

1. SQL> conn/AsSysdba
2. Already connected to the idle routine.
3. SQL> startup
4. The ORACLE routine has been started.
6. Total SystemGlobalArea 167772160 bytes
7. FixedSize1266392 bytes
8. VariableSize67112232 bytes
9. DatabaseBuffers 96468992 bytes
10. Redo Buffers 2924544 bytes
11. ORA-00205 :?????????, ??????, ???????
14. SQL>SelectStatusFromV $ instance;
16. STATUS
17. ------------------------
18. STARTED
20. SQL> shutdown immediate
21. ORA-01507 :??????
24. The ORACLE routine has been disabled.

1 2 Next Page