Use this procedure to prevent data loss.
If anything goes wrong while operating the new database without a backup, then you must repeat the database creation procedure. Back up your database now to prevent loss of data.
To back up the new database:
- Shut down the database instance and stop the service:
C:\> oradim -SHUTDOWN -SID prod -SHUTTYPE srvc,inst -SHUTMODE immediate
ORADIMreturns the prompt immediately, you must wait for the database and the service to stop completely before continuing to Step 2. Wait until the Control Panel indicates service
OracleServicePRODhas stopped. If you do not do this, then the backup is useless because it was taken while data was being written to data files.
- Back up database files using the tool of your choice.
Database files consist of the initialization parameter file, control files, online redo log files, and data files.
When the backup is complete, you can start the database again, create users and objects, if necessary, make any other changes, and use the database.
Back up the database after making any significant changes, such as switching into the archiving mode or adding a tablespace or a data file.
Do not store database files on a compressed drive. This can result in write errors and a decreased performance.