Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle can not change the tablespace to backup mode in non-archive mode     - Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)

- CentOS RedHat YUM Source Extensions Supplement (including 32-bit, 64-bit) (Linux)

- In-depth summary of the PHP core of object-oriented (Programming)

- How to add a new hard disk without restarting the CentOS 7 / RHEL 7 virtual machine (Linux)

- DIY security of Linux platform (Linux)

- Examples of Python any parameters (Programming)

- xCAT line installation on CentOS 6.X (Linux)

- MongoDB collection data migration to MySQL database (Database)

- Export error: ORA-04063: package body dmsys dbms dm model exp has error (Database)

- Linux using RAID how to use Mdadm Tool Management Software RAID (Linux)

- Getting the Linux shell expr use (Programming)

- Oracle view object space usage show_space (Database)

- CentOS / Debian configuration Gitlab 7.1x to build self Git repository (Linux)

- Python KNN algorithm of actual realization (Programming)

- Seven Steps to Help Google Chrome Speed - (Linux)

- SQLite database commonly used sentences and visualization tools on MAC MeasSQLlite use (Database)

- Development environment to build MEAN In Ubuntu 15.10 (Server)

- Linux file permissions and access modes (Linux)

- HTTP and FTP TCP-FLOOD CC Attacks Analysis and Prevention solutions under CentOS 6.5 (Linux)

- Use nice, cpulimit and cgroups limit cpu usage (Linux)

  Oracle can not change the tablespace to backup mode in non-archive mode
  Add Date : 2017-08-31      
  Oracle table space is set to backup mode, you can online table space under the data file for the file system level copy backup operation, because during the table space changes are recorded to the database redo log file.

If you think of the database if the non-archiving mode, then the table space backup mode time must not exceed the online log is covered by the time in order to ensure that data changes will not be lost.

Oracle on this situation is how to choose?

Experiments show that: Oracle is simply not let you open the table space in non-archiving mode backup mode.

Being given as follows: ORA-01123: can not start online backup; media recovery not enabled

Experimental verification is as follows: Environment: RHEL 6.4 + Oracle

1. Archive mode can open the table space backup mode.

SQL> alter tablespace TT begin backup;

Tablespace altered.

SQL> host cp /home/oradata/JYZHAO/datafile/tt.dbf / tmp /

SQL> alter tablespace TT end backup;

Tablespace altered.

SQL>! Ls -lh / tmp | grep tt
-rw-r -----. 1 oracle oinstall 11M Sep 17 17:06 tt.dbf

SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1876
Next log sequence to archive 1879
Current log sequence 1879

2. Modify the database to non-archiving mode, the table space found in the backup mode to open will not be allowed.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.

Total System Global Area 413372416 bytes
Fixed Size 2228904 bytes
Variable Size 356519256 bytes
Database Buffers 46137344 bytes
Redo Buffers 8486912 bytes
Database mounted.

SQL> change database noarchivelog;

Database altered.

SQL> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 1876
Current log sequence 1879
SQL> alter database open;

Database altered.

SQL> alter tablespace TT begin backup;
Alter tablespace TT begin backup
ERROR at line 1:
ORA-01123: can not start online backup; media recovery not enabled
- Taught you how to install Ubuntu Linux (Linux)
- Python 3.5 will support Async / Await Asynchronous Programming (Programming)
- To install Docker under Ubuntu 15.04 (Linux)
- installation process of Matlab 2012a under Ubuntu 14.04 (Linux)
- CentOS cross compiler core Raspberry Pi 2 (Linux)
- Installation CD audio file extraction tool Flacon (Linux)
- Extended use of the swap file swap space on Linux (Linux)
- ARM runtime environment built from scratch using QEMU emulator (Linux)
- MySQL Data Types (Database)
- Oracle 11g creates virtual private directory RMAN-06004 ORA-00942 error handling (Database)
- JavaScript original values and complex values (Programming)
- JavaScript cross-browser event object library (Programming)
- Use mysqldump backup performed MariaDB (Database)
- redis main building and disaster recovery from a cluster deployment (Database)
- Difference LVS three scheduling modes (Server)
- Convert MySQL date string to a NULL value exception handling (Database)
- Oracle users to automatically increase the partition table (Database)
- How to choose the correct HTTP status code (Server)
- The difference between free command displays the buffers and cache (Linux)
- Linux tar compressed exclude a folder (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.