| To test the restore of a database to new host [message #269905] |
Tue, 25 September 2007 01:49  |
ara.oracle
Messages: 142
Registered: August 2007
|
Senior Member |
|
|
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that in page(8-13 to 8-18)
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
Oracle version-10g R2 10.2.0.1.0
OS version - RHEL 4.0 (2.6.9-5 EL)
am having two oracle database
Database 1--dbsib
and i had created recovery catalog in dbsib.
Database 2--newdb
Both the database is in different nodes.
now in another new node i had installed oracle software alone.
i had already taken backups in newdb database.Backup of autobackup control file,datafile,archivelog.i had taken the backups in disk.i had also created the pfile also from spfile in newdb.
And i copied all these backups datas manually to the new node where i installed oracle software.
by using the pfile i just try to start the instance but i face the following errors.
i followed the RMAN advance user guide,
in that they had given that
rman target/ nocatalog
set DBID (2873463223) ie newdb according to my setup
RMAN> startup nomount;
startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file '/new/oracle/product/db/database/dbs/initnewdb.ora'
starting Oracle instance without parameter file for retrival of spfile
Oracle instance started
Total System Global Area 159383552 bytes
Fixed Size 1218268 bytes
Variable Size 54528292 bytes
Database Buffers 100663296 bytes
Redo Buffers 2973696 bytes
RMAN> run {
2> allocate channel t1 type disk;
3> restore spfile to pfile '/new/oracle/product/db/initnewdb.ora' from autobackup;
4> shutdown abort;
5> }
allocated channel: t1
channel t1: sid=36 devtype=DISK
Starting restore at 25-SEP-07
channel t1: looking for autobackup on day: 20070925
channel t1: looking for autobackup on day: 20070924
channel t1: looking for autobackup on day: 20070923
channel t1: looking for autobackup on day: 20070922
channel t1: looking for autobackup on day: 20070921
channel t1: looking for autobackup on day: 20070920
channel t1: looking for autobackup on day: 20070919
channel t1: no autobackup in 7 days found
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/25/2007 13:09:01
RMAN-06172: no autobackup found or specified handle is not a valid copy or piece
i had tried in catalog mode also.
please provide me a solution.
|
|
|
|
|
|
| Re: To test the restore of a database to new host [message #269929 is a reply to message #269905] |
Tue, 25 September 2007 02:47  |
ara.oracle
Messages: 142
Registered: August 2007
|
Senior Member |
|
|
how many times i say you that i had configured autobackup on.
i had configured autobackup on in newdb according to my setup.
and i had taken backup.
RMAN> startup mount;
Oracle instance started
database mounted
Total System Global Area 293601280 bytes
Fixed Size 1219040 bytes
Variable Size 83887648 bytes
Database Buffers 205520896 bytes
Redo Buffers 2973696 bytes
RMAN> show all;
RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/new/oracle/product/db/database/dbs/snapcf_newdb.f'; # default
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
