I have taken the hotbackup of the 2 tablespaces I have.I intend to do this once in a week and during the remaining days want to take the arch file backup.
I have enabled archiver log (in the init.ora) . However there are no arch files created in the %orahome%db%arch directory.
Does it mean that the arch files are not getting created ?
Please advice me how to take the arch file backup, alternatively.
Logs are archived only when the current log switches.
Check the Alert log to see that the logs are switching.
Or do following on sql/plus to force a switch --
alter system witch logfile;
First, you have to make sure your database is in archivelog mode:
select log_mode from v$database;
If the value is "ARCHIVE", then you are in archive log mode. If not, you have to shutdown your database and bring it up in exclusive mode. Then, issue
alter database archivelog
Shutdown, and restart your database.
Next, force a log switch.
alter system switch logfile
Then, look in v$archived_log to see if you have archived anything.
select name, to_char(completion_time, 'mm/dd/yyyy hh24:mi:ss') comptime
order by completion_time
This will give you the name of the file that was archived. Go to your OS and see if that file is there.
Also make sure that parameter LOG_ARCHIVE_START is set to TRUE in init.ora. Then archiver will automatically archive rhe file once the log switch occurs.
Apart from Archiving enabling in Init.ora, you need to issue
Alter Database Archivelog;
Then it starts creating the Archive logs
Thank You all, It's working
Click Here to Expand Forum to Full Width