Recover Noarchivelog Database
The steps in the simulation are as follows:
- To make sure you are connecting to database ORCL, you need to set Oracle SID. Enter
SET ORACLE_SID=ORCL at the prompt. When you finish, press Enter.
SVRMGR30 to access Server Manager. When you finish, press Enter.
- At the prompt, type
CONNECT INTERNAL to access the database ORCL as sysdba. The password ORACLE is entered for you. After you finish, press Enter.
- Now you start the restore process. Type
SHUTDOWN ABORT at the prompt. After you finish, press Enter.
- To access the operating system, enter
HOST at the prompt. After you finish, press Enter.
- To perform the backup, you can run the batch file you created. Suppose the batch file is stored directly in the ORANT folder. Type
DO_RESTORE at the prompt and press Enter.
- To access Server Manager, type
EXIT at the prompt. After you finish, press Enter.
- To start the database, type
STARTUP OPEN PFILEC:\ORANT\DATABASE\INITORCL.ORA at the prompt. After you finish, press Enter.
- This is the end of the Simulation.
Mount Mode first
Sometimes in test environments you may not enable archiving.
However, it is still possible to use RMAN to back up the database as long as the database is placed in mount mode first.
$ rman target /
RMAN> shutdown immediate;
RMAN> startup mount;
RMAN> backup database;
RMAN> alter database open;
You can restore a noarchivelog database only to the point at which it was backed up. There is no roll forward of transactions because there are no archived redo log files to apply. This type of restore and recovery is commonly used to reset a test environment database to a baseline point in time. Since the online redo log files are not included in the RMAN backup, you must issue alter database open resetlogs to create new online redo log files, as well as to synchronize the control files and data files in terms of their checkpoint SCNs.