Today I learned about Oracle backup while performing altertablespaceusersbeginbackup; then there is: Row 1st error: ORA-01123: unable to start online backup
Today I learned about Oracle backup after executing alter tablespace users begin backup; then there is: Row 1st error: ORA-01123: unable to start online backup
I learned about Oracle backup today.
Alter tablespace users begin backup is executed;
Then:
Row 3 has an error:
ORA-01123: online backup cannot be started; media recovery not enabled
It seems that the archive is not started because: In noarchive mode, you cannot perform alter tablespace XXX begin backup. Online backup can only be performed when the database is in archivelog mode.
Then, the archive log list is executed.
Database Log mode non-archive Mode
Disable automatic archiving
Archiving end point USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Current Log sequence 7
The archive is not started, the database is closed, and the database is started in archive mode.
Then execute:
Startup mount
Alter database archivelog;
SQL> alter database archivelog;
The database has been changed.
SQL> archive log list;
Database Log mode archiving Mode
Enable automatic archiving
Archiving end point USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 5
Next archive log sequence 7
Current day
SQL> alter database open;
The database has been changed.
SQL> alter tablespace users begin backup;
The tablespace has been changed.
SQL> host cp/u01/app/oracle/oradata/JIAGULUN/datafile/o1_mf_users_7p5b157q _. dbf/u01/app/oracle/backup/users01.dbf
Now there is users01dbf in the backup directory ......
SQL> alter tablespace users end backup;
The tablespace has been changed.
OK
,