Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle can not change the tablespace to backup mode in non-archive mode     - Ten linux version of the system (Linux)

- MySQL database to open a remote connection method (Database)

- Java NIO2: Buffer (Programming)

- Linux maximum number of threads and limit the number of queries the current thread (Linux)

- 64 Ubuntu 15.04 Linux kernel upgrade to Linux 4.1.0 (Linux)

- 10 easy to use Linux utilities Recommended (Linux)

- Python closure and function objects (Programming)

- ORA-30926 and MERGE tables empty the temporary occupation problem (Database)

- Depth understanding of JavaScript new mechanism (Programming)

- Boost notes --Asio - (1) a simple small example of synchronous communication (Programming)

- Linux system security check method (Linux)

- How to install MySQL on Linux Dock (Database)

- CentOS 6.4 of cron scheduled task configuration (Linux)

- RedHat Linux 6.5 Enterprise Edition installation Redis 3.0.3 (Database)

- Linux Network Security Tips Share (Linux)

- ORA-27054 NFS problem solving (Database)

- How to query the role of Linux services (Linux)

- Ubuntu install Wireshark (Linux)

- Linux command -nohup & (Linux)

- Use custom backup plans for Debian backupninja (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 11.2.0.3

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
     
         
       
         
  More:      
 
- To use yum install VLC under CentOS (Linux)
- floating IP in OpenStack neutron (Server)
- Configure shared library PCRE (Linux)
- Fedora 22 how to play rmvb mp4 mkv video files (Linux)
- RabbitMQ Getting Started Tutorial (Linux)
- Virt Related Command Summary (Linux)
- How to run in support UDp Docker container JBoss data virtualization GA (Server)
- Linux System Getting Started Learning: DeVeDe installed on Linux to create a video DVD (Linux)
- Java class loading order (Programming)
- Zabbix monitoring platform to extract a single server graphical Python implementation of concurrent (Server)
- Linux (CentOS) directory file management and file system file compression packing (Linux)
- OpenSSL to generate public and private key (Linux)
- How to install Ubuntu applications Device 7 (Linux)
- Ubuntu installation under Scrapy (Linux)
- Detailed reference Oracle 11g Partition (Database)
- VMware virtual machine to install CentOS 6.2 (Linux)
- Linux fixes fatal error: x264.h: No such file or directo (Linux)
- ORA-14400: inserted partition key does not map to any partition (Database)
- Linux Telnet access Windows 7 configuration procedure (Linux)
- How to generate Linux, random password encryption or decryption (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.