Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ Oracle can not change the tablespace to backup mode in non-archive mode     - Java implementation chain store binary tree (Programming)

- How to turn Java String into Date (Programming)

- Linux system monitoring tool set cpu (Linux)

- Linux (RHEL5) general optimization system security (Linux)

- How to use Git to upload code to GitHub project (Linux)

- HttpClient4 usage upgrade from HttpClient3 (Programming)

- Ubuntu 14.04 install PostgreSQL 9.2 (Database)

- MySQL uses Federate engine mapping table to achieve operation of the local remote operation table (Database)

- Linux server network penetration testing (Linux)

- How to create a someone project on github (Linux)

- Linux Network Programming - raw socket instance: MAC header message analysis (Programming)

- Some common Linux commands Study Notes (Linux)

- MyCAT separate read and write to achieve MySQL Practice (Database)

- Linux automatic installation and implementation (Linux)

- How to make GRub instead of the default Ubuntu software center (Linux)

- Zookeeper Rights Management and Quota Management (Server)

- Windows SmartGit installation (Linux)

- How to use the ftp tool to transfer files between Windows and Linux (Linux)

- The sublime into IDE (Linux)

- Linux, security encryption to transfer files between machines (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:      
 
- Ubuntu Live CD by updating Grub resume boot the Boot Menu (Linux)
- The principle Httpclient4.4 (execution request) (Programming)
- Linux source code analysis tool (Linux)
- Linux system installation Gitlab (Server)
- Elasticsearch Kibana installation notes (Linux)
- Management DB2 logs (Database)
- Oracle delete table space prompted ORA-00604 and ORA-38301 (Database)
- Java multi-threaded in a three way (inheritance, implementation, anonymous inner classes) (Programming)
- DOM event handlers add notes (Programming)
- Linux firewall security (Linux)
- Linux file content inspection - cat, tac, no, more, less, head, tail, od (Linux)
- Install apr support for Tomcat on Linux (Server)
- Installation and configuration of Hadoop under Linux (Server)
- VMWare virtual machine without rebooting way to add virtual disk (Linux)
- Protobuf compiled and used on the Ubuntu 14.04 (Programming)
- OpenVPN offsite interconnecting room availability and load balancing solution (Server)
- FileZilla 3.10.1.1 install on Ubuntu 14.10 (Linux)
- See how --nand flash timing diagram of a read operation Comments (Programming)
- RHEL5 multipath configuration (Linux)
- Installation Experience open source car Automotive Grade Linux system (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.