Home PC Games Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ Oracle can not change the tablespace to backup mode in non-archive mode     - Findbugs installation documentation (Linux)

- Compiled version of Android Opus audio codec library method (Programming)

- Cross server / client backup command: rsync use (Server)

- Java implementation linear table - represents the order of representation and chain (Programming)

- Phoenix agents use P2P WebRTC development (Programming)

- Linux operating system must know the security command (Linux)

- How to enhance the Nagios server security (Linux)

- CentOS 7 update source - the use of domestic sources 163 yum (Linux)

- To install the Oracle process notes on Oracle Linux 4u4 (Database)

- Nginx Load Balancing (standby) + Keepalived (Server)

- Several Methods of SSH Auto - login (Linux)

- KVM usb passthrough configuration (Linux)

- Linux operating system log system (Linux)

- Linux foreground to background process switch (Linux)

- To setup CentOS LAMP environment (Server)

- in no backup ex: error: Xin Tourou ah backup child process has Singles DAT / US person / bin / in no backup ex (Database)

- awk pattern matching (Programming)

- Grep, Ack, Ag searches Efficiency Comparison (Linux)

- grep command usage (Linux)

- Manually create Oracle Database Explanations (Database)

  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
- Share Java-based multithreading file case (Programming)
- Oracle common internal event tracking number (Database)
- Linux kernel TCP / IP parameters analysis and tuning (Linux)
- Oracle 11g RAC automatically play GI PSU patch ( (Database)
- Detailed software to run UnixBench (Linux)
- Ubuntu system cp: omitting directory problem (Linux)
- How to install Git client in Ubuntu (Linux)
- Docker Private Registry Installation Guide at CentOS6.X (Linux)
- Qt signals and slots mechanism (Programming)
- pdf.js Tutorial (Linux)
- Google open source TCP team repaired the Linux kernel TCP flaw (Linux)
- Ubuntu 15.10 15.04 14.10 14.04 Install Ubuntu Tweak (Linux)
- Oracle how to maintain the consistency of read? (Database)
- Oracle RAC upgrade to problems encountered (Database)
- Linux (CentOS) SSH login without password authentication (Linux)
- Getting Started with Linux system to learn: how to install autossh (Linux)
- A key installation Gitlab 7 on RHEL6.4 and Setup Mail TX (Linux)
- Linux operating system security management skills notes (Linux)
- MySQL binary packages install for RedHat Linux Enterprise 6.4 (Database)
- ThinkPad X220 Ubuntu 14.10 installed on fingerprint recognition (Linux)
  CopyRight 2002-2020 newfreesoft.com, All Rights Reserved.