Home » RDBMS Server » Backup & Recovery » RMAN for 8i Database
RMAN for 8i Database [message #162756] Mon, 13 March 2006 08:29 Go to next message
toshidas2000
Messages: 120
Registered: November 2005
Senior Member
All
Does anyone know how to backup the init.ora file in oracle 8i through RMAN.

Thanks
Toshi
Re: RMAN for 8i Database [message #163275 is a reply to message #162756] Wed, 15 March 2006 21:48 Go to previous message
Amosnaks
Messages: 3
Registered: March 2006
Junior Member
Try this

RMAN> run {
allocate channel t4 type 'disk or sbt';
backup
full
format 'c:\oradata\dbname\df_s%s_%t%'
(Database);
sql 'alter system archive log current';
sql 'copy c:\oracle_home\database\admin\initsid.ora d:\backup';
sql 'copy c:\oracle_home\database\network\admin\listener.ora d:\backup';
sql 'copy c:\oracle_home\database\network\admin\tnsnames.ora d:\backup';
release channel t4;
}

Hope this helps. Let us know if it worked.
Previous Topic: oracle errors...need help
Next Topic: Oracle 7.3
Goto Forum:
  


Current Time: Wed Apr 24 19:25:34 CDT 2024