Oralce hot standby

Source: Internet
Author: User

Windows Oracle10g

-------------------------------------------------------------------------

SQL> alter database begin backup;
Alter database begin backup
*
Row 3 has an error:
ORA-01123: online backup cannot be started; media recovery not enabled

SQL> archive log list
Database Log mode non-archive Mode
Disable automatic archiving
Archiving end point use_db_recovery_file_dest
Oldest online log sequence 13
Current Log sequence 15
SQL> alter database open;
Alter database open
*
Row 3 has an error:
ORA-01531: Instance opened database

SQL> shutdown immediate
The database has been closed.
The database has been detached.
The Oracle routine has been disabled.
SQL> startup Mount
The Oracle routine has been started.

Total system global area 167772160 bytes
Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers 88080384 bytes
Redo buffers 2945024 bytes
The database has been loaded.
SQL> alter database archivelog;

The database has been changed.

SQL> alter database open;

The database has been changed.

SQL> alter database begin backup;

The database has been changed.

SQL> host xcopy C:/Oracle/product/10.2.0/oradata/ora/*. DBF C:/bak/

SQL> alter Database End backup;

The database has been changed.

SQL> shutdown immediate
The database has been closed.
The database has been detached.
The Oracle routine has been disabled.
SQL> destroys database files *. DBF
SP2-0734: Unknown command starting with "corrupt database..."-ignore the remaining lines.
SQL> startup
The Oracle routine has been started.

Total system global area 167772160 bytes
Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers 88080384 bytes
Redo buffers 2945024 bytes
The database has been loaded.
ORA-01157: unable to identify/lock data file 4-see dbwr trace file
ORA-01110: data file 4: 'C:/Oracle/product/10.2.0/oradata/ora/users01.dbf'

SQL> shutdown immediate
ORA-01109: the database is not open

The database has been detached.
The Oracle routine has been disabled.
SQL> copy Hot Standby files
SP2-0734: Unknown command starting with "Copy hot standby..."-ignore the remaining lines.
SQL> Start Mount
SP2-0310: Unable to open file "Mount. SQL"
SQL> startup Mount;
The Oracle routine has been started.

Total system global area 167772160 bytes
Fixed size 1247900 bytes
Variable Size 75498852 bytes
Database buffers 88080384 bytes
Redo buffers 2945024 bytes
The database has been loaded.
SQL> recover database;
Media recovery is completed.
-- If you want to change the database to non-archive mode, alter database noarchivelog
SQL> alter database open;

The database has been changed.

SQL> spool off;

 

---------------------------------------------------------------------------

This completes the entire operation!

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.